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

Database lock crash in Zabbix agent2 using SQLite.

    XMLWordPrintable

Details

    • Team C
    • Sprint 84 (Jan 2022), Sprint 85 (Feb 2022)
    • 1

    Description

      Crashes can occur in a matter of minutes, or they may not occur for a month or more.

      zabbix_agent2.log
      2022/01/14 10:18:18.163731 [102] cannot execute SQL statement : database is locked
      2022/01/14 10:18:18.165740 Critical failure: database is locked
      2022/01/14 10:18:18.165740 goroutine 12 [running]:
      2022/01/14 10:18:18.165740 runtime/debug.Stack(0xc0002adab0, 0xd7e940, 0xc000144ba0)
      2022/01/14 10:18:18.165740 	c:/go/src/runtime/debug/stack.go:24 +0xa4
      2022/01/14 10:18:18.165740 zabbix.com/pkg/log.PanicHook()
      2022/01/14 10:18:18.165740 	C:/Users/ZABBIX/build-agents-web/zabbix-5.0.14/src/go/pkg/log/log.go:243 +0x77
      2022/01/14 10:18:18.165740 panic(0xd7e940, 0xc000144ba0)
      2022/01/14 10:18:18.165740 	c:/go/src/runtime/panic.go:969 +0x174
      2022/01/14 10:18:18.165740 zabbix.com/internal/agent/resultcache.(*DiskCache).write(0xc0001b8200, 0xc0001f8000)
      2022/01/14 10:18:18.165740 	C:/Users/ZABBIX/build-agents-web/zabbix-5.0.14/src/go/internal/agent/resultcache/diskcache.go:382 +0x1259
      2022/01/14 10:18:18.165740 zabbix.com/internal/agent/resultcache.(*DiskCache).run(0xc0001b8200)
      2022/01/14 10:18:18.165740 	C:/Users/ZABBIX/build-agents-web/zabbix-5.0.14/src/go/internal/agent/resultcache/diskcache.go:399 +0x141
      2022/01/14 10:18:18.165740 created by zabbix.com/internal/agent/resultcache.(*DiskCache).Start
      2022/01/14 10:18:18.165740 	C:/Users/ZABBIX/build-agents-web/zabbix-5.0.14/src/go/internal/agent/resultcache/diskcache.go:460 +0x5f
      

      The agent we are using is Archive package, downloaded from zabbix.com.
      https://www.zabbix.com/jp/download_agents?version=5.0+LTS&release=5.0.14&os=Windows&os_version=Any&hardware=amd64&encryption=OpenSSL&packaging=Archive&show_legacy=0

      SQLite Configuration

      zabbix_agentd.conf
      EnablePersistentBuffer=1
      PersistentBufferPeriod=1d
      PersistentBufferFile=C:\zabbix\ActiveCheckBuffer.sqlite
      

      Attachments

        Activity

          People

            ak Andrejs Kozlovs
            hayato.watanabe Hayato Watanabe
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: