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

After database service stop and start, problem occured time and recovery time reversed

    XMLWordPrintable

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 4.0.19, 4.0.20
    • Fix Version/s: 4.0.28rc1, 5.0.7rc1, 5.4 (plan)
    • Component/s: Server (S)
    • Labels:
      None
    • Team:
      Team C
    • Sprint:
      Sprint 64 (May 2020), Sprint 65 (Jun 2020), Sprint 66 (Jul 2020), Sprint 67 (Aug 2020), Sprint 68 (Sep 2020), Sprint 69 (Oct 2020), Sprint 70 (Nov 2020), Sprint 71 (Dec 2020)
    • Story Points:
      0.25

      Description

      Steps to reproduce:

      1. Create agent.ping item and trigger
        Key:agent.ping
        Update interval:60s
        
        Trigger Expression:{hostname:agent.ping.nodata(300)}=1
        
      1. Stop database service
      2. After 5 minutes start database service
      3. Trigger happened

      Result:
      See screenshot...

      See log file...

       18145:20200512:120805.012 [Z3005] query failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) [begin;]
       18145:20200512:120805.012 [Z3001] connection to database 'zabbix' failed: [2002] Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
       18145:20200512:120805.012 database is down: reconnecting in 10 seconds
      
       18145:20200512:121335.024 database connection re-established
       18150:20200512:121335.739 database connection re-established
       18146:20200512:121336.385 database connection re-established
       18163:20200512:121336.503 database connection re-established
       18142:20200512:121337.022 database connection re-established
       18157:20200512:121337.920 database connection re-established
       18143:20200512:121338.023 database connection re-established
       18140:20200512:121338.460 database connection re-established
       18141:20200512:121338.896 database connection re-established
       18144:20200512:121339.022 database connection re-established
       18153:20200512:121339.502 database connection re-established
       18139:20200512:121340.342 database connection re-established
       18159:20200512:121340.619 database connection re-established
       18158:20200512:121340.936 database connection re-established
       18161:20200512:121343.460 database connection re-established
       18160:20200512:121343.618 database connection re-established
       18135:20200512:121343.808 database connection re-established
      

      Expected:
      Duration should not be minus

        Attachments

          Activity

            People

            Assignee:
            asestakovs Aleksejs Sestakovs
            Reporter:
            yIn Syusei YIn
            Votes:
            0 Vote for this issue
            Watchers:
            9 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: