If you use mythtv-status, optimize_mythdb, mythexport or anything else
that is written in Perl and uses the database, then you may be getting
this warning message now:
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a
future version.
It will happen every time the Perl DBD::mysql call is used, as the
Perl implementation of that call sets the MYSQL_OPT_RECONNECT option
to false, and any setting of the MYSQL_OPT_RECONNECT option triggers
the deprecation warning. The real problem is if you have
mythtv-status installed - it gets run regularly to update the motd
message, and each time it now gets this deprecation warning, it emails
you on your root@<hostname> email address. So you get hundreds of
these unwanted emails. If you do not have your root email address
enabled, you will not have this problem, but sensible people do have
their root email working so they can receive the reports from
optimize_mythdb each day to see if they have database problems.
The warning is caused by the installation of the latest
libmysqlclient21 version. On Ubuntu 22.04, the version that causes
this is package version 8.0.34:
root@mypvr:~# apt list -a libmysqlclient21
Listing... Done
libmysqlclient21/jammy-updates,jammy-security 8.0.34-0ubuntu0.22.04.1
amd64 [upgradable from: 8.0.28-0ubuntu4]
libmysqlclient21/jammy,now 8.0.28-0ubuntu4 amd64 [installed,upgradable
to: 8.0.34-0ubuntu0.22.04.1]
libmysqlclient21/jammy-updates,jammy-security 8.0.34-0ubuntu0.22.04.1
i386
libmysqlclient21/jammy 8.0.28-0ubuntu4 i386
If you have already been updated to this version, the workaround is to
downgrade to the latest previous version that is still available,
which is 8.0.28 in the Ubuntu 22.04 packages.
sudo apt install libmysqlclient21=8.0.28-0ubuntu4
Then you need to mark that version to be held instead of being
updated:
sudo apt-mark hold libmysqlclient21
If you have not yet been updated to the 8.0.34 version, you can just
do the hold command before that happens and you should be left on the
prior 8.0.33 version. The timing of the update to 8.0.34 varies due
to the new apt system where packages get rolled out to only a few
systems first, to see if they cause problems. So you may be lucky and
not have 8.0.34 yet. Two of my Ubuntu 22.04 systems had not been
updated, but my main MythTV box had, and had 60+ unwanted emails
waiting.
Reverting to a slightly older libmysqlclient21 version should not
cause any problems for now, but as other things get updated it may
cause problems later. Hopefully the Perl maintainers will fix the
DBD:mysql code before then, or some other fix will happen.
See:
https://stackoverflow.com/questions/76875569/warning-mysql-opt-reconnect-is-deprecated-and-will-be-removed-in-a-future-versi
https://github.com/perl5-dbi/DBD-mysql/issues/354
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org
that is written in Perl and uses the database, then you may be getting
this warning message now:
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a
future version.
It will happen every time the Perl DBD::mysql call is used, as the
Perl implementation of that call sets the MYSQL_OPT_RECONNECT option
to false, and any setting of the MYSQL_OPT_RECONNECT option triggers
the deprecation warning. The real problem is if you have
mythtv-status installed - it gets run regularly to update the motd
message, and each time it now gets this deprecation warning, it emails
you on your root@<hostname> email address. So you get hundreds of
these unwanted emails. If you do not have your root email address
enabled, you will not have this problem, but sensible people do have
their root email working so they can receive the reports from
optimize_mythdb each day to see if they have database problems.
The warning is caused by the installation of the latest
libmysqlclient21 version. On Ubuntu 22.04, the version that causes
this is package version 8.0.34:
root@mypvr:~# apt list -a libmysqlclient21
Listing... Done
libmysqlclient21/jammy-updates,jammy-security 8.0.34-0ubuntu0.22.04.1
amd64 [upgradable from: 8.0.28-0ubuntu4]
libmysqlclient21/jammy,now 8.0.28-0ubuntu4 amd64 [installed,upgradable
to: 8.0.34-0ubuntu0.22.04.1]
libmysqlclient21/jammy-updates,jammy-security 8.0.34-0ubuntu0.22.04.1
i386
libmysqlclient21/jammy 8.0.28-0ubuntu4 i386
If you have already been updated to this version, the workaround is to
downgrade to the latest previous version that is still available,
which is 8.0.28 in the Ubuntu 22.04 packages.
sudo apt install libmysqlclient21=8.0.28-0ubuntu4
Then you need to mark that version to be held instead of being
updated:
sudo apt-mark hold libmysqlclient21
If you have not yet been updated to the 8.0.34 version, you can just
do the hold command before that happens and you should be left on the
prior 8.0.33 version. The timing of the update to 8.0.34 varies due
to the new apt system where packages get rolled out to only a few
systems first, to see if they cause problems. So you may be lucky and
not have 8.0.34 yet. Two of my Ubuntu 22.04 systems had not been
updated, but my main MythTV box had, and had 60+ unwanted emails
waiting.
Reverting to a slightly older libmysqlclient21 version should not
cause any problems for now, but as other things get updated it may
cause problems later. Hopefully the Perl maintainers will fix the
DBD:mysql code before then, or some other fix will happen.
See:
https://stackoverflow.com/questions/76875569/warning-mysql-opt-reconnect-is-deprecated-and-will-be-removed-in-a-future-versi
https://github.com/perl5-dbi/DBD-mysql/issues/354
_______________________________________________
mythtv-users mailing list
mythtv-users@mythtv.org
http://lists.mythtv.org/mailman/listinfo/mythtv-users
http://wiki.mythtv.org/Mailing_List_etiquette
MythTV Forums: https://forum.mythtv.org