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.

        1. ps_bt.zip
          5 kB

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

              Created:
              Updated:
              Resolved: