EPrints Technical Mailing List Archive

See the EPrints wiki for instructions on how to join this mailing list and related information.

Message: #10295

< Previous (by date) | Next (by date) > | < Previous (in thread) | Next (in thread) > | Messages - Most Recent First | Threads - Most Recent First

Re: [EP-tech] Warning MYSQL_OPT_RECONNECT

Hi Mario,

Yes, this has been a fun task to deal with the last couple of days.  The issue is nothing to do with EPrints and there is no way of changing the EPrints code or configuration to fix this.  This issue is that mysql-libs was upgraded to mysql-libs-8.0.43-1.el9_6.x86_64 that introduces a warning about MYSQL_OPT_RECONNECT being deprecated.  This has not been fixed (to not use this option) in Perl's MySQL database bindings (perl-DBD-MySQL-4.053-1.el9.0.1.x86_64 on Rocky Linux 9).  However, I have observed it has been fixed in version perl-DBD-MySQL-4.053-2.  However, this is only currently available on CentOS 9 Stream:

https://centos.pkgs.org/9-stream/centos-appstream-x86_64/perl-DBD-MySQL-4.053-2.el9.x86_64.rpm.html

As a trial, I have installed this on a couple of EPrints repositories to confirm it fixes the issue and is stable.  This can be done by downloading the RPM and running DNF to install it:

wget https://mirror.stream.centos.org/9-stream/AppStream/x86_64/os/Packages/perl-DBD-MySQL-4.053-2.el9.x86_64.rpm
dnf install perl-DBD-MySQL-4.053-2.el9.x86_64.rpm

However, I am a little nervous about doing this on production servers, as it may affect future updates for this package.  The fact that there is a package in CentOS 9 Stream makes me hopeful that RHEL 9 and its derivatives will have a fixed version available shortly.

Regards

David Newman


On 04/12/2025 13:15, Beaudoin, Mario wrote:
CAUTION: This e-mail originated outside the University of Southampton.
CAUTION: This e-mail originated outside the University of Southampton.

Hello everyone,

Since the latest update of Oracle Linux 9 server, I keep seeing the following warning repeatedly in my logs:

WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.

I’m using EPrints version 3.4.5, and although everything works fine, my logs are now flooded with thousands of these messages, making it difficult to monitor other issues. I’ve tried several tricks to suppress this warning, but nothing seems to work.

Has anyone found a reliable way to remove or silence this warning? Any advice or workaround would be greatly appreciated.

Thank you in advance!

Best regards,

 

 

Mario Beaudoin| Chargé de projet informatique et technologique

Service de la bibliothèque |Université du Québec à Trois-Rivières

819 376-5011, poste 2258 | www.uqtr.ca

3351, boul. des Forges, C.P. 500, Trois-Rivières (Québec) G9A 5H7 | Local 4407, A.T.

 

 


*** Options: https://wiki.eprints.org/w/Eprints-tech_Mailing_List
*** Archive: https://www.eprints.org/tech.php/
*** EPrints community wiki: https://wiki.eprints.org/