Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-23456

Zabbix-Server service was hanging unlimited because database service was down at first to perform the reboot

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Commercial support required
    • Icon: Trivial Trivial
    • None
    • 6.4.6
    • None

      Steps to reproduce:

      1. sudo apt update
      2. sudo apt upgrade
      3. sudo reboot

      Result:
      See screenshot...

      See log file...

      See memory dump...
      Expected:

      service from zabbix-server is running unlimited if this condition came up.

      WARNING: MYSQL_OPT_RECONNECT is deprecated and will be removed in a future version.
        1408:20230921:163926.345 Got signal [signal:15(SIGTERM),sender_pid:2480380,sender_uid:0,reason:0]. Exiting ...
        1420:20230921:163927.004 [Z3005] query failed: [1053] Server shutdown in progress [select changelogid,object,objectid,operation,clock from changelog]
        1420:20230921:163927.191 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1420:20230921:163927.192 database is down: reconnecting in 10 seconds
        1452:20230921:163927.316 [Z3005] query failed: [2013] Lost connection to MySQL server during query [insert into history (itemid,clock,ns,value) values (8174>
      ]
        1455:20230921:163927.347 [Z3005] query failed: [2013] Lost connection to MySQL server during query [commit;]
        1455:20230921:163927.347 [Z3005] query failed: [2013] Lost connection to MySQL server during query [rollback;]
        1455:20230921:163927.347 cannot perform transaction rollback, connection will be reset
        1452:20230921:163927.348 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1452:20230921:163927.348 database is down: reconnecting in 10 seconds
        1455:20230921:163927.379 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1455:20230921:163927.379 database is down: reconnecting in 10 seconds
        1438:20230921:163927.660 [Z3005] query failed: [1053] Server shutdown in progress [select h.hostid,h.host,h.name,t.httptestid,t.name,t.agent,t.authenticatio>
        1442:20230921:163927.660 [Z3005] query failed: [1053] Server shutdown in progress [select h.hostid,h.host,h.name,t.httptestid,t.name,t.agent,t.authenticatio>
        1438:20230921:163927.660 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1438:20230921:163927.660 database is down: reconnecting in 10 seconds
        1442:20230921:163927.660 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1442:20230921:163927.660 database is down: reconnecting in 10 seconds
        1516:20230921:163927.817 [Z3005] query failed: [2013] Lost connection to MySQL server during query [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.mess>
        1516:20230921:163927.910 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1516:20230921:163927.910 database is down: reconnecting in 10 seconds
        1420:20230921:163928.037 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1420:20230921:163928.037 database is down: reconnecting in 10 seconds
        1451:20230921:163928.037 syncing history data in progress...
        1442:20230921:163928.037 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s>
        1442:20230921:163928.037 database is down: reconnecting in 10 seconds
       

      Workaround
      Connect to console to VM/server and manually reboot the server. In managed environments this issue have a big impact because one ticket must be opened or the technician must be contact first to solve the corruption.

            Unassigned Unassigned
            jerome.bose Jerome Bose
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: