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

Sqlite deadlock between history syncer or conf syncer.

XMLWordPrintable

    • Sprint 76 (May 2021), Sprint 77 (Jun 2021)
    • 1

      Steps to reproduce:
      start proxy with pretty big confguration
      after some time new loop configuration synced starts and all processes will hand for waiting mutex of SQLite.

       1261:20210518:152725.569 == locks diagnostic information ==
        1261:20210518:152725.578 locks:
        1261:20210518:152725.587   ZBX_MUTEX_LOG:0x7fbb6fecd000
        1261:20210518:152725.596   ZBX_MUTEX_CACHE:0x7fbb6fecd028
        1261:20210518:152725.604   ZBX_MUTEX_TRENDS:0x7fbb6fecd050
        1261:20210518:152725.617   ZBX_MUTEX_CACHE_IDS:0x7fbb6fecd078
        1261:20210518:152725.626   ZBX_MUTEX_SELFMON:0x7fbb6fecd0a0
        1261:20210518:152725.640   ZBX_MUTEX_CPUSTATS:0x7fbb6fecd0c8
        1261:20210518:152725.652   ZBX_MUTEX_DISKSTATS:0x7fbb6fecd0f0
        1261:20210518:152725.661   ZBX_MUTEX_ITSERVICES:0x7fbb6fecd118
        1261:20210518:152725.671   ZBX_MUTEX_VALUECACHE:0x7fbb6fecd140
        1261:20210518:152725.680   ZBX_MUTEX_VMWARE:0x7fbb6fecd168
        1261:20210518:152725.689   ZBX_MUTEX_SQLITE3:0x7fbb6fecd190
        1261:20210518:152725.698   ZBX_MUTEX_PROCSTAT:0x7fbb6fecd1b8
        1261:20210518:152725.707   ZBX_MUTEX_PROXY_HISTORY:0x7fbb6fecd1e0
        1261:20210518:152725.717   ZBX_MUTEX_MODBUS:0x7fbb6fecd208
        1261:20210518:152725.725   ZBX_MUTEX_TREND_FUNC:0x7fbb6fecd230
        1261:20210518:152725.735   ZBX_RWLOCK_CONFIG:0x7fbb6fecd258
        1261:20210518:152725.744   ZBX_RWLOCK_VALUECACHE:0x7fbb6fecd290
        1261:20210518:152725.753 ==
      
      root@s01:~$ ps ax | grep sync
       1263 ?        S      1:06 /usr/sbin/zabbix_proxy: configuration syncer [loading configuration]
       1332 ?        S      0:02 /usr/sbin/zabbix_proxy: history syncer #1 [processed 0 values in 0.000029 sec, syncing history]
       1333 ?        S      0:02 /usr/sbin/zabbix_proxy: history syncer #2 [processed 6090 values in 0.397928 sec, syncing history]
       1334 ?        S      0:02 /usr/sbin/zabbix_proxy: history syncer #3 [processed 0 values in 0.000036 sec, syncing history]
       1335 ?        S      0:02 /usr/sbin/zabbix_proxy: history syncer #4 [processed 7000 values in 0.397221 sec, syncing history]
      13236 pts/4    S+     0:00 grep --color=auto sync
      root@s01:~$ strace -p 1332
      strace: Process 1332 attached
      futex(0x7fbb6fecd190, FUTEX_WAIT, 2, NULL^Cstrace: Process 1332 detached
       <detached ...>
      root@s01:~$ strace -p 1263
      strace: Process 1263 attached
      futex(0x7fbb6fecd190, FUTEX_WAIT, 2, NULL^Cstrace: Process 1263 detached
       <detached ...>
      

      Result:
      No synchronisation no config update. Proxy just idle.
      Expected:
      Processing data and configuration.

            vso Vladislavs Sokurenko
            neogan Andrei Gushchin (Inactive)
            Team A
            Votes:
            17 Vote for this issue
            Watchers:
            18 Start watching this issue

              Created:
              Updated:
              Resolved: