Mysqli connection error

Discussion in 'ISPConfig 3 Priority Support' started by francoisPE, Jul 29, 2022.

  1. francoisPE

    francoisPE Active Member HowtoForge Supporter

    Hello,
    I have a multiple servers config running ispconfig 3.2.8p1
    2 servers had mysqli server error
    Here extract of /var/log/ispconfig/*log on first server
    Code:
    Thu 28 Jul 2022 01:41:01 AM CEST 28.07.2022-01:41 - WARNING - There is already an instance of server.php running with pid 1263146.
    Thu 28 Jul 2022 01:41:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:42:01 AM CEST 28.07.2022-01:42 - WARNING - There is already an instance of server.php running with pid 1263146.
    Thu 28 Jul 2022 01:42:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:42:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:43:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:43:02 AM CEST 28.07.2022-01:43 - WARNING - There is already an instance of server.php running with pid 1263146.
    Thu 28 Jul 2022 01:43:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:43:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:44:01 AM CEST 28.07.2022-01:44 - WARNING - There is already an instance of server.php running with pid 1263146.
    Thu 28 Jul 2022 01:44:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:44:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:44:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:44:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:01 AM CEST 28.07.2022-01:45 - WARNING - There is already an instance of server.php running with pid 1263146.
    Thu 28 Jul 2022 01:45:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:45:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:01 AM CEST 28.07.2022-01:46 - WARNING - There is already an instance of server.php running with pid 1263146.
    Thu 28 Jul 2022 01:46:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:46:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:08 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:11 AM CEST #0 {main}
    Thu 28 Jul 2022 01:46:11 AM CEST #0 /usr/local/ispconfig/server/lib/classes/cronjob.inc.php(90): cronjob_monitor_backup->onRunJob()
    Thu 28 Jul 2022 01:46:11 AM CEST #1 /usr/local/ispconfig/server/cron.php(116): cronjob->run()
    Thu 28 Jul 2022 01:46:11 AM CEST #2 {main}
    Thu 28 Jul 2022 01:46:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:11 AM CEST Database connection failed Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! PHP Fatal error:  Uncaught Error: Call to a member function query() on bool in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_backup.inc.php:98
    Thu 28 Jul 2022 01:46:11 AM CEST Database connection failed Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! PHP Fatal error:  Uncaught Error: Call to a member function testConnection() on bool in /usr/local/ispconfig/server/server.php:64
    Thu 28 Jul 2022 01:46:11 AM CEST Stack trace:
    Thu 28 Jul 2022 01:46:11 AM CEST thrown in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_backup.inc.php on line 98
    Thu 28 Jul 2022 01:46:11 AM CEST thrown in /usr/local/ispconfig/server/server.php on line 64
    Thu 28 Jul 2022 01:47:01 AM CEST 28.07.2022-01:47 - WARNING - There is already a lockfile set, but no process running with this pid (1263146). Continuing.
    Thu 28 Jul 2022 01:47:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:47:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:08 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:11 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:47:12 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:01 AM CEST 28.07.2022-01:48 - WARNING - There is already an instance of server.php running with pid 1264384.
    Thu 28 Jul 2022 01:48:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:48:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:08 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:11 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:12 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:01 AM CEST 28.07.2022-01:49 - WARNING - There is already an instance of server.php running with pid 1264384.
    Thu 28 Jul 2022 01:49:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:49:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:12 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:01 AM CEST 28.07.2022-01:50 - WARNING - There is already an instance of server.php running with pid 1264384.
    Thu 28 Jul 2022 01:50:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:50:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:14 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:01 AM CEST 28.07.2022-01:51 - WARNING - There is already an instance of server.php running with pid 1264384.
    Thu 28 Jul 2022 01:51:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:51:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:08 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:17 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 02:07:01 AM CEST 28.07.2022-02:07 - WARNING - There is already an instance of server.php running with pid 1269270.
    Thu 28 Jul 2022 02:07:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    
     
  2. francoisPE

    francoisPE Active Member HowtoForge Supporter

    Here same files on second server
    Code:
    Thu 28 Jul 2022 01:41:02 AM CEST 28.07.2022-01:41 - WARNING - There is already an instance of server.php running with pid 175961.
    Thu 28 Jul 2022 01:41:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:42:01 AM CEST 28.07.2022-01:42 - WARNING - There is already an instance of server.php running with pid 175961.
    Thu 28 Jul 2022 01:42:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:42:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:43:01 AM CEST 28.07.2022-01:43 - WARNING - There is already an instance of server.php running with pid 175961.
    Thu 28 Jul 2022 01:43:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:43:02 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:43:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:44:01 AM CEST 28.07.2022-01:44 - WARNING - There is already an instance of server.php running with pid 175961.
    Thu 28 Jul 2022 01:44:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:44:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:44:03 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:44:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:01 AM CEST 28.07.2022-01:45 - WARNING - There is already an instance of server.php running with pid 175961.
    Thu 28 Jul 2022 01:45:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:45:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:05 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:45:08 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:01 AM CEST 28.07.2022-01:46 - WARNING - There is already an instance of server.php running with pid 175961.
    Thu 28 Jul 2022 01:46:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:46:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:08 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:12 AM CEST #0 {main}
    Thu 28 Jul 2022 01:46:12 AM CEST #0 /usr/local/ispconfig/server/lib/classes/cronjob.inc.php(90): cronjob_monitor_backup->onRunJob()
    Thu 28 Jul 2022 01:46:12 AM CEST #1 /usr/local/ispconfig/server/cron.php(116): cronjob->run()
    Thu 28 Jul 2022 01:46:12 AM CEST #2 {main}
    Thu 28 Jul 2022 01:46:12 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:46:12 AM CEST Database connection failed Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! PHP Fatal error:  Uncaught Error: Call to a member function query() on bool in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_backup.inc.php:98
    Thu 28 Jul 2022 01:46:12 AM CEST Database connection failed Zugriff auf Datenbankserver fehlgeschlagen! / Database server not accessible! PHP Fatal error:  Uncaught Error: Call to a member function testConnection() on bool in /usr/local/ispconfig/server/server.php:64
    Thu 28 Jul 2022 01:46:12 AM CEST Stack trace:
    Thu 28 Jul 2022 01:46:12 AM CEST thrown in /usr/local/ispconfig/server/lib/classes/cron.d/100-monitor_backup.inc.php on line 98
    Thu 28 Jul 2022 01:46:12 AM CEST thrown in /usr/local/ispconfig/server/server.php on line 64
    Thu 28 Jul 2022 01:47:01 AM CEST 28.07.2022-01:47 - WARNING - There is already a lockfile set, but no process running with this pid (175961). Continuing.
    Thu 28 Jul 2022 01:47:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:47:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:12 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:47:12 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:48:01 AM CEST 28.07.2022-01:48 - WARNING - There is already an instance of server.php running with pid 177630.
    Thu 28 Jul 2022 01:48:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:48:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:48:12 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:01 AM CEST 28.07.2022-01:49 - WARNING - There is already an instance of server.php running with pid 177630.
    Thu 28 Jul 2022 01:49:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:49:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:49:13 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:01 AM CEST 28.07.2022-01:50 - WARNING - There is already an instance of server.php running with pid 177630.
    Thu 28 Jul 2022 01:50:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:50:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:50:15 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:01 AM CEST 28.07.2022-01:51 - WARNING - There is already an instance of server.php running with pid 177630.
    Thu 28 Jul 2022 01:51:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    Thu 28 Jul 2022 01:51:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:02 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:04 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:07 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:11 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 01:51:18 AM CEST Database connection failed PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 91
    Thu 28 Jul 2022 02:07:01 AM CEST 28.07.2022-02:07 - WARNING - There is already an instance of server.php running with pid 183722.
    Thu 28 Jul 2022 02:07:01 AM CEST PHP Warning:  mysqli_real_connect(): (HY000/2002): Connection timed out in /usr/local/ispconfig/server/lib/classes/db_mysql.inc.php on line 85
    
     
  3. francoisPE

    francoisPE Active Member HowtoForge Supporter

    I check
    Code:
    service mysql status
    but nothing strange. Both are running.
    Anyway I did (to do something !)
    Code:
    service mysql restart
    What do you thing ?
    Should I run php -q udapte.php ?
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

    This means your MySQL server was unreachable at that time.
     
  5. till

    till Super Moderator Staff Member ISPConfig Developer

    No, your issue is not ISPConfig related, so there is nothing that an ISPConfig update could fix.
     
  6. francoisPE

    francoisPE Active Member HowtoForge Supporter

    Checkin munin I see on both servers
    upload_2022-7-29_9-55-15.png

    Everything seems ok now.
    Thank for your help to confirm that's not severe.
     
  7. francoisPE

    francoisPE Active Member HowtoForge Supporter

    I wonder why this service stop...
    mysql logs and syslog show nothing yesterday !
     
    Last edited: Jul 29, 2022
  8. till

    till Super Moderator Staff Member ISPConfig Developer

    That's not easy to diagnose without errors, and no errors in log. Maybe some kind of backup software that you might be using that runs at that time?
     
  9. francoisPE

    francoisPE Active Member HowtoForge Supporter

    That same "white band" is visible in munin for apache, tcp, mysql -> all graphs.
    I am more in favor of an issue at my provider level !
     
    Last edited: Jul 29, 2022
  10. francoisPE

    francoisPE Active Member HowtoForge Supporter

    Running "service mysql restart", I kill my dovecot... (and amavis ; not fully sure for that last one)
    So, on mail server, run
    Code:
    service mysql restart && service dovecot restart && service amavis restart
     
  11. till

    till Super Moderator Staff Member ISPConfig Developer

    Amavis is connected to postfix and not dovecot, so probably you don't have to restart it.
     
  12. francoisPE

    francoisPE Active Member HowtoForge Supporter

    syslog said
    Code:
    Jul 29 10:41:34 mail1 amavis[1165067]: (1165067-10) (!)lookup_sql: sql exec: err=1927, 70100, DBD::mysql::st execute failed: Connection was killed at (eval 110) line 173., ,
    Jul 29 10:41:34 mail1 amavis[1165067]: (1165067-10) (!!)TROUBLE in process_request: sql exec: err=1927, 70100, DBD::mysql::st execute failed: Connection was killed at (eval 110) line 173. at (eval 112) line 333.
    Jul 29 10:41:34 mail1 amavis[1165067]: (1165067-10) (!)Requesting process rundown after fatal error
    Jul 29 10:42:36 mail1 systemd[1]: Stopping LSB: Starts amavisd-new mailfilter...
    Jul 29 10:42:37 mail1 amavis[1193700]: Stopping amavisd: amavisd-new.
    Jul 29 10:42:37 mail1 systemd[1]: amavis.service: Succeeded.
    
    Anyway I will tun to rspamd in coming days.
     
  13. till

    till Super Moderator Staff Member ISPConfig Developer

    I guess these messages should go aware without an amavis restart, same with dovecot. The basically just indicate just that amavis was not able to connect to MySQL while MySQL was restarted.
     
  14. francoisPE

    francoisPE Active Member HowtoForge Supporter

    I agree for amavis, but, for dovecot, there was ckearly an issue because no more connection to dovecot was possible.
    Code:
    Jul 29 10:40:15 mail1 dovecot: auth-worker(1169674): Error: sql([email protected],hiddenIP,<A7gxxxxxxxtDTsT>): Password query failed: Connection was killed
     

Share This Page