[Bug 2031548] Re: 8.0.34 client lib change in behavior/output - new warning - breaking apps
David Hillman
2031548 at bugs.launchpad.net
Mon Sep 25 02:01:10 UTC 2023
I appreciate Toby and William commenting that they are still seeing this
warming. All of my physical Ubuntu boxes are as well, despite having
all of the specified upgrades performed. I thought perhaps I was losing
my mind, but not quite yet.
I even removed all of the mysql and mariadb related packages, reset, and
re-installed just the current revisions -- and still the warning
persists.
However, I spun up a fresh Ubuntu 22 virtual machine and installed the
mysql client packages, and that virtual system produces no warnings.
All of the package versions are identical to those on the machines on
which the warnings are still produced -- which doesn't make any sense,
but there you go.
Machine A:
user at machineA:~/Code/db$ ./connect.pl
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
$VAR1 = bless( {}, 'DBI::db' );
user at machineA:~/Code/db$ ./versions.sh
ii libdbd-mysql-perl:amd64 4.050-5ubuntu0.22.04.1 amd64 Perl5 database interface to the MariaDB/MySQL database
ii libmysqlclient21:amd64 8.0.34-0ubuntu0.22.04.1 amd64 MySQL database client library
ii mysql-common 5.8+1.0.8 all MySQL database common files, e.g. /etc/mysql/my.cnf
ii libdbd-mysql-perl:amd64 4.050-5ubuntu0.22.04.1 amd64 Perl5 database interface to the MariaDB/MySQL database
ii libmariadb-dev 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database development files
ii libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database client library
ii mariadb-client-10.6 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database client binaries
ii mariadb-client-core-10.6 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database core client binaries
ii mariadb-common 1:10.6.12-0ubuntu0.22.04.1 all MariaDB common configuration files
Machine B:
user at machineB:~/Code/db$ ./connect.pl
$VAR1 = bless( {}, 'DBI::db' );
user at machineB:~/Code/db$ ./versions.sh
ii libdbd-mysql-perl:amd64 4.050-5ubuntu0.22.04.1 amd64 Perl5 database interface to the MariaDB/MySQL database
ii libmysqlclient21:amd64 8.0.34-0ubuntu0.22.04.1 amd64 MySQL database client library
ii mysql-common 5.8+1.0.8 all MySQL database common files, e.g. /etc/mysql/my.cnf
ii libdbd-mysql-perl:amd64 4.050-5ubuntu0.22.04.1 amd64 Perl5 database interface to the MariaDB/MySQL database
ii libmariadb-dev 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database development files
ii libmariadb3:amd64 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database client library
ii mariadb-client-10.6 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database client binaries
ii mariadb-client-core-10.6 1:10.6.12-0ubuntu0.22.04.1 amd64 MariaDB database core client binaries
ii mariadb-common 1:10.6.12-0ubuntu0.22.04.1 all MariaDB common configuration files
There's something else effecting this database connection, but I don't know what it is either.
--
You received this bug notification because you are a member of Ubuntu
Foundations Bugs, which is subscribed to apr-util in Ubuntu.
https://bugs.launchpad.net/bugs/2031548
Title:
8.0.34 client lib change in behavior/output - new warning - breaking
apps
Status in MySQL Server:
Unknown
Status in apr-util package in Ubuntu:
Confirmed
Status in libdbd-mysql-perl package in Ubuntu:
Fix Released
Status in mysql-8.0 package in Ubuntu:
Confirmed
Status in apr-util source package in Focal:
Fix Released
Status in libdbd-mysql-perl source package in Focal:
Fix Released
Status in mysql-8.0 source package in Focal:
Confirmed
Status in apr-util source package in Jammy:
Fix Released
Status in libdbd-mysql-perl source package in Jammy:
Fix Released
Status in mysql-8.0 source package in Jammy:
Confirmed
Status in apr-util source package in Lunar:
Fix Released
Status in libdbd-mysql-perl source package in Lunar:
Fix Released
Status in mysql-8.0 source package in Lunar:
Confirmed
Status in apr-util source package in Mantic:
Confirmed
Status in libdbd-mysql-perl source package in Mantic:
Fix Released
Status in mysql-8.0 source package in Mantic:
Confirmed
Bug description:
The introduction of this warning output in a MINOR version/security
update is completely inappropriate, regardless of it's validity. A
minor version update of a package should NEVER change fundamental
behavior
WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in
a future version.
Any application (particularly web applications) that depended on mysql
client library are now broken due to this additional warning being
just dumped into the output of the app, such a API endpoints producing
JSON.
Please produce a newer build that does output the warning.
I am not arguing for or against the change in functionality/defaults
on the MYSQL_OPT_RECONNECT -- only about the zero-warning introduction
of new warning level output in a dependent library.
If this were a "hey we just found a major security problem, and we see
you are using the function in a way that triggers it, so we are going
to spew out an _ERROR_ level warning", that might be justifiable.
Spewing out a new warning to say "Your app MIGHT break in the future."
when the new effect is "We're going to break it NOW!" is not.
8.0.33-0ubuntu0.20.04.4 is last working
8.0.34-0ubuntu0.20.04.1 is when the BUG was introduced.
To manage notifications about this bug go to:
https://bugs.launchpad.net/mysql-server/+bug/2031548/+subscriptions
More information about the foundations-bugs
mailing list