Bogus MySQL connection error at event log

Moderator: crythias

Post Reply
djcaetano
Znuny newbie
Posts: 17
Joined: 31 May 2016, 16:19
Znuny Version: 5.0.19
Real Name: Daniel Caetano
Company: Universidade de São Paulo

Bogus MySQL connection error at event log

Post by djcaetano »

Hi there,

I have just noticed that after the latest OTRS patches (I updated from 5.0.19 to 5.021 and then to 5.0.22) the system event log started to display lots and lots of "Can't connect to MySQL server on '172.31.0.64' (111)". The system, however, is working ok and is accessing the database.
I got the full message on SysLog and found out the following error:

Code: Select all

Aug 14 11:48:54 atendimento OTRS-otrs.Daemon.pl - Daemon Kernel::System::Daemon::DaemonModules::SchedulerGenericAgentTaskManager-31[18192]: [Error][Kernel::System::DB::Ping][Line:1634]: Can't connect to MySQL server on 'xxx.yyy.zzz.kkk' (111)
This error is reported error every 2 or 3 seconds (each time from a different Deamon Module).
I ping'ed the server address both from otrs and root users and that went fine. I've also connected to the mysql server using the otrs user to login and everything went fine too.

Any clues on how to obtain more information on the reported error and how to fix it?

Regards,
Daniel Caetano
djcaetano
Znuny newbie
Posts: 17
Joined: 31 May 2016, 16:19
Znuny Version: 5.0.19
Real Name: Daniel Caetano
Company: Universidade de São Paulo

Re: Bogus MySQL connection error at event log

Post by djcaetano »

It is worse than I thought.
In fact, timed generic agents are not running correctly because of this problem. The time generic agents stopped to work is exactly the time I updated the system from 5.0.19 to 5.0.21. Weird. Still no clues on how to deal with this problem.
jojo
Znuny guru
Posts: 15019
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Bogus MySQL connection error at event log

Post by jojo »

did you restart the Daemon?
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
djcaetano
Znuny newbie
Posts: 17
Joined: 31 May 2016, 16:19
Znuny Version: 5.0.19
Real Name: Daniel Caetano
Company: Universidade de São Paulo

Re: Bogus MySQL connection error at event log

Post by djcaetano »

I restarted the daemon and this problem has gone way. Probably the old daemon was running against the new version of the systems.
Post Reply