Ad Widget

**tim.mooney** · 11-09-2020, 17:47

Zabbix version 5.0.3 is out, perhaps update to that and see if you still get the same crash

The fixes and changes from 5.0.2 to 5.0.3: https://www.zabbix.com/rn/rn5.0.3
The fixes and changes from 5.0.1 to 5.0.2: https://www.zabbix.com/rn/rn5.0.2

**dimir** · 11-09-2020, 17:54

Can you show the command you used to create the database?

**zhujian** · 14-09-2020, 12:16

@tim.mooney Upgrade to the latest version（5.0.3）, but the crash remains

**zhujian** · 14-09-2020, 12:19

@dimir
create database zabbix character set utf8 collate utf8_bin;
zcat /usr/share/doc/zabbix-server-mysql*/create.sql.gz | mysql -uzabbix -p zabbix

**dimir** · 14-09-2020, 14:23

Can you attach full log where we can see the messages from start to crash?

**zhujian** · 14-09-2020, 15:02

50053:20200914:172851.187 item "bigdata-nmgv3-hdp947.nmg02:netstat.portuse_num" became supported
49951:20200914:172855.104 slow query: 11.577191 sec, "select distinct t.triggerid,t.description,t.expression,t.error,t.p riority,t.type,t.value,t.state,t.lastchange,t.stat
us,t.recovery_mode,t.recovery_expression,t.correla tion_mode,t.correlation_tag,opdata from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.ite
mid and f.triggerid=t.triggerid and h.status in (0,1) and t.flags<>2"
49951:20200914:172856.966 Got signal [signal:11(SIGSEGV),reason:1,refaddr

nil)]. Crashing ...
49951:20200914:172856.966 ====== Fatal information: ======
49951:20200914:172856.966 Program counter: 0x7f75ba724901
49951:20200914:172856.966 === Registers: ===
49951:20200914:172856.966 r8 = 7f75ba97d060 = 140143618412640 = 140143618412640
49951:20200914:172856.966 r9 = 7f75d1ef7915 = 140144010033429 = 140144010033429
49951:20200914:172856.966 r10 = 0 = 0 = 0
49951:20200914:172856.966 r11 = 0 = 0 = 0
49951:20200914:172856.966 r12 = 7f75be0f34d7 = 140143676568791 = 140143676568791
49951:20200914:172856.966 r13 = 1 = 1 = 1
49951:20200914:172856.966 r14 = 0 = 0 = 0
49951:20200914:172856.966 r15 = 0 = 0 = 0
49951:20200914:172856.966 rdi = 0 = 0 = 0
49951:20200914:172856.966 rsi = fffffffffffffffc = 18446744073709551612 = -4
49951:20200914:172856.966 rbp = 7ffcb208ea20 = 140723295414816 = 140723295414816
49951:20200914:172856.966 rbx = 7f72b6c06168 = 140130669060456 = 140130669060456
49951:20200914:172856.966 rdx = fffffffffffffffc = 18446744073709551612 = -4
49951:20200914:172856.966 rax = 0 = 0 = 0
49951:20200914:172856.966 rcx = 0 = 0 = 0
49951:20200914:172856.966 rsp = 7ffcb208ea08 = 140723295414792 = 140723295414792
49951:20200914:172856.966 rip = 7f75ba724901 = 140143615953153 = 140143615953153
49951:20200914:172856.966 efl = 10283 = 66179 = 66179
49951:20200914:172856.966 csgsfs = 33 = 51 = 51
49951:20200914:172856.966 err = 4 = 4 = 4
49951:20200914:172856.967 trapno = e = 14 = 14
49951:20200914:172856.967 oldmask = 0 = 0 = 0
49951:20200914:172856.967 cr2 = 0 = 0 = 0
49951:20200914:172856.967 === Backtrace: ===
49951:20200914:172856.968 18: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](zbx_backtrace+0x42) [0x7f75be01ae23]
49951:20200914:172856.968 17: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](zbx_log_fatal_info+0x151) [0x7f75be01b0a1
]
49951:20200914:172856.968 16: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](+0x1c1816) [0x7f75be01b816]
49951:20200914:172856.968 15: /lib64/libpthread.so.0(+0xf5d0) [0x7f75bd5295d0]
49951:20200914:172856.968 14: /lib64/libc.so.6(+0x16e901) [0x7f75ba724901]
49951:20200914:172856.968 13: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](zbx_default_string_hash_func+0x18) [0x7f7
5be01c594]
49951:20200914:172856.968 12: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](+0x183b24) [0x7f75bdfddb24]
49951:20200914:172856.968 11: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](zbx_hashset_search+0x36) [0x7f75be020cf3]
49951:20200914:172856.968 10: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](+0x183b7f) [0x7f75bdfddb7f]
49951:20200914:172856.968 9: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](DCstrpool_replace+0x55) [0x7f75bdfddcbc]
49951:20200914:172856.968 8: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](+0x18c315) [0x7f75bdfe6315]
49951:20200914:172856.968 7: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](DCsync_configuration+0x110c) [0x7f75bdfe9b
b0]
49951:20200914:172856.968 6: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](dbconfig_thread+0x202) [0x7f75bdeaee6b]
49951:20200914:172856.968 5: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](zbx_thread_start+0x37) [0x7f75be02992c]
49951:20200914:172856.968 4: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](MAIN_ZABBIX_ENTRY+0xa02) [0x7f75bdea13dc]
49951:20200914:172856.968 3: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](daemon_start+0x305) [0x7f75be01aa6f]
49951:20200914:172856.968 2: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](main+0x312) [0x7f75bdea09d8]
49951:20200914:172856.968 1: /lib64/libc.so.6(__libc_start_main+0xf5) [0x7f75ba5d83d5]
49951:20200914:172856.968 0: zabbix_server: configuration syncer [synced configuration in 28.578507 sec, syncing configuration](+0x45a59) [0x7f75bde9fa59]
49951:20200914:172856.968 === Memory map: ===
49951:20200914:172856.968 7f7030000000-7f7030021000 rw-p 00000000 00:00 0
49951:20200914:172856.968 7f7030021000-7f7034000000 ---p 00000000 00:00 0
49951:20200914:172856.968 7f7036405000-7f7036406000 ---p 00000000 00:00 0
49951:20200914:172856.969 7f7036406000-7f7036c06000 rw-p 00000000 00:00 0
49951:20200914:172856.969 7f7036c06000-7f72b6c06000 rw-s 00000000 00:04 720902 /SYSV00000000 (deleted)
49951:20200914:172856.969 7f72b6c06000-7f7436c06000 rw-s 00000000 00:04 655364 /SYSV00000000 (deleted)
49951:20200914:172856.969 7f7436c06000-7f74b6c06000 rw-s 00000000 00:04 622595 /SYSV00000000 (deleted)
49951:20200914:172856.969 7f74b6c06000-7f7536c06000 rw-s 00000000 00:04 589826 /SYSV00000000 (deleted)
49951:20200914:172856.969 7f7536c06000-7f75b6c06000 rw-s 00000000 00:04 557057 /SYSV00000000 (deleted)
49951:20200914:172856.969 7f75b6c06000-7f75b6c12000 r-xp 00000000 08:02 7866284 /usr/lib64/libnss_files-2.17.so
49951:20200914:172856.969 7f75b6c12000-7f75b6e11000 ---p 0000c000 08:02 7866284 /usr/lib64/libnss_files-2.17.so
49951:20200914:172856.969 7f75b6e11000-7f75b6e12000 r--p 0000b000 08:02 7866284 /usr/lib64/libnss_files-2.17.so
49951:20200914:172856.969 7f75b6e12000-7f75b6e13000 rw-p 0000c000 08:02 7866284 /usr/lib64/libnss_files-2.17.so
49951:20200914:172856.969 7f75b6e13000-7f75b6e19000 rw-p 00000000 00:00 0
49951:20200914:172856.969 7f75b6e19000-7f75b6e1b000 r-xp 00000000 08:02 7866145 /usr/lib64/libfreebl3.so
49951:20200914:172856.969 7f75b6e1b000-7f75b701a000 ---p 00002000 08:02 7866145 /usr/lib64/libfreebl3.so
49951:20200914:172856.969 7f75b701a000-7f75b701b000 r--p 00001000 08:02 7866145 /usr/lib64/libfreebl3.so
49951:20200914:172856.969 7f75b701b000-7f75b701c000 rw-p 00002000 08:02 7866145 /usr/lib64/libfreebl3.so
49951:20200914:172856.969 7f75b701c000-7f75b7040000 r-xp 00000000 08:02 7866407 /usr/lib64/libselinux.so.1
49951:20200914:172856.969 7f75b7040000-7f75b723f000 ---p 00024000 08:02 7866407 /usr/lib64/libselinux.so.1
49951:20200914:172856.969 7f75b723f000-7f75b7240000 r--p 00023000 08:02 7866407 /usr/lib64/libselinux.so.1
49951:20200914:172856.969 7f75b7240000-7f75b7241000 rw-p 00024000 08:02 7866407 /usr/lib64/libselinux.so.1
49951:20200914:172856.969 7f75b7241000-7f75b7243000 rw-p 00000000 00:00 0
49951:20200914:172856.969 7f75b7243000-7f75b724a000 r-xp 00000000 08:02 7866397 /usr/lib64/librt-2.17.so
49951:20200914:172856.969 7f75b724a000-7f75b7449000 ---p 00007000 08:02 7866397 /usr/lib64/librt-2.17.so
49951:20200914:172856.969 7f75b7449000-7f75b744a000 r--p 00006000 08:02 7866397 /usr/lib64/librt-2.17.so
49951:20200914:172856.969 7f75b744a000-7f75b744b000 rw-p 00007000 08:02 7866397 /usr/lib64/librt-2.17.so
49951:20200914:172856.969 7f75b744b000-7f75b7453000 r-xp 00000000 08:02 7866070 /usr/lib64/libcrypt-2.17.so
49951:20200914:172856.969 7f75b7453000-7f75b7652000 ---p 00008000 08:02 7866070 /usr/lib64/libcrypt-2.17.so
49951:20200914:172856.969 7f75b7652000-7f75b7653000 r--p 00007000 08:02 7866070 /usr/lib64/libcrypt-2.17.so
49951:20200914:172856.969 7f75b7653000-7f75b7654000 rw-p 00008000 08:02 7866070 /usr/lib64/libcrypt-2.17.so
49951:20200914:172856.969 7f75b7654000-7f75b7682000 rw-p 00000000 00:00 0
49951:20200914:172856.969 7f75b7682000-7f75b7685000 r-xp 00000000 08:02 7866225 /usr/lib64/libkeyutils.so.1.5
49951:20200914:172856.969 7f75b7685000-7f75b7884000 ---p 00003000 08:02 7866225 /usr/lib64/libkeyutils.so.1.5
49951:20200914:172856.969 7f75b7884000-7f75b7885000 r--p 00002000 08:02 7866225 /usr/lib64/libkeyutils.so.1.5
49951:20200914:172856.969 7f75b7885000-7f75b7886000 rw-p 00003000 08:02 7866225 /usr/lib64/libkeyutils.so.1.5
49951:20200914:172856.969 7f75b7886000-7f75b7893000 r-xp 00000000 08:02 7866235 /usr/lib64/libkrb5support.so.0.1
49951:20200914:172856.969 7f75b7893000-7f75b7a93000 ---p 0000d000 08:02 7866235 /usr/lib64/libkrb5support.so.0.1
49951:20200914:172856.969 7f75b7a93000-7f75b7a94000 r--p 0000d000 08:02 7866235 /usr/lib64/libkrb5support.so.0.1
49951:20200914:172856.969 7f75b7a94000-7f75b7a95000 rw-p 0000e000 08:02 7866235 /usr/lib64/libkrb5support.so.0.1
49951:20200914:172856.969 7f75b7a95000-7f75b7aaa000 r-xp 00000000 08:02 7866156 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
49951:20200914:172856.969 7f75b7aaa000-7f75b7ca9000 ---p 00015000 08:02 7866156 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
49951:20200914:172856.969 7f75b7ca9000-7f75b7caa000 r--p 00014000 08:02 7866156 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
49951:20200914:172856.970 7f75b7caa000-7f75b7cab000 rw-p 00015000 08:02 7866156 /usr/lib64/libgcc_s-4.8.5-20150702.so.1
49951:20200914:172856.970 7f75b7cab000-7f75b7cdd000 r-xp 00000000 08:02 7866209 /usr/lib64/libidn.so.11.6.11
49951:20200914:172856.970 7f75b7cdd000-7f75b7edc000 ---p 00032000 08:02 7866209 /usr/lib64/libidn.so.11.6.11
49951:20200914:172856.970 7f75b7edc000-7f75b7edd000 r--p 00031000 08:02 7866209 /usr/lib64/libidn.so.11.6.11
49951:20200914:172856.970 7f75b7edd000-7f75b7ede000 rw-p 00032000 08:02 7866209 /usr/lib64/libidn.so.11.6.11
49951:20200914:172856.970 7f75b7ede000-7f75b7f18000 r-xp 00000000 08:02 7866276 /usr/lib64/libnspr4.so
49951:20200914:172856.970 7f75b7f18000-7f75b8117000 ---p 0003a000 08:02 7866276 /usr/lib64/libnspr4.so
49951:20200914:172856.970 7f75b8117000-7f75b8118000 r--p 00039000 08:02 7866276 /usr/lib64/libnspr4.so
49951:20200914:172856.970 7f75b8118000-7f75b811a000 rw-p 0003a000 08:02 7866276 /usr/lib64/libnspr4.so
49951:20200914:172856.970 7f75b811a000-7f75b811c000 rw-p 00000000 00:00 0
49951:20200914:172856.970 7f75b811c000-7f75b8120000 r-xp 00000000 08:02 7866364 /usr/lib64/libplc4.so
49951:20200914:172856.970 7f75b8120000-7f75b831f000 ---p 00004000 08:02 7866364 /usr/lib64/libplc4.so
49951:20200914:172856.970 7f75b831f000-7f75b8320000 r--p 00003000 08:02 7866364 /usr/lib64/libplc4.so
49951:20200914:172856.970 7f75b8320000-7f75b8321000 rw-p 00004000 08:02 7866364 /usr/lib64/libplc4.so
49951:20200914:172856.970 7f75b8321000-7f75b8324000 r-xp 00000000 08:02 7866365 /usr/lib64/libplds4.so
49951:20200914:172856.970 7f75b8324000-7f75b8523000 ---p 00003000 08:02 7866365 /usr/lib64/libplds4.so
49951:20200914:172856.970 7f75b8523000-7f75b8524000 r--p 00002000 08:02 7866365 /usr/lib64/libplds4.so
49951:20200914:172856.970 7f75b8524000-7f75b8525000 rw-p 00003000 08:02 7866365 /usr/lib64/libplds4.so
49951:20200914:172856.970 7f75b8525000-7f75b854d000 r-xp 00000000 08:02 7866299 /usr/lib64/libnssutil3.so
49951:20200914:172856.970 7f75b854d000-7f75b874c000 ---p 00028000 08:02 7866299 /usr/lib64/libnssutil3.so
49951:20200914:172856.970 7f75b874c000-7f75b8753000 r--p 00027000 08:02 7866299 /usr/lib64/libnssutil3.so
49951:20200914:172856.970 7f75b8753000-7f75b8754000 rw-p 0002e000 08:02 7866299 /usr/lib64/libnssutil3.so
49951:20200914:172856.970 7f75b8754000-7f75b8878000 r-xp 00000000 08:02 7866277 /usr/lib64/libnss3.so
49951:20200914:172856.970 7f75b8878000-7f75b8a78000 ---p 00124000 08:02 7866277 /usr/lib64/libnss3.so
49951:20200914:172856.970 7f75b8a78000-7f75b8a7d000 r--p 00124000 08:02 7866277 /usr/lib64/libnss3.so
49951:20200914:172856.970 7f75b8a7d000-7f75b8a7f000 rw-p 00129000 08:02 7866277 /usr/lib64/libnss3.so
49951:20200914:172856.970 7f75b8a7f000-7f75b8a81000 rw-p 00000000 00:00 0
49951:20200914:172856.970 7f75b8a81000-7f75b8aa5000 r-xp 00000000 08:02 7866416 /usr/lib64/libsmime3.so
49951:20200914:172856.970 7f75b8aa5000-7f75b8ca4000 ---p 00024000 08:02 7866416 /usr/lib64/libsmime3.so
49951:20200914:172856.970 7f75b8ca4000-7f75b8ca7000 r--p 00023000 08:02 7866416 /usr/lib64/libsmime3.so
49951:20200914:172856.970 7f75b8ca7000-7f75b8ca8000 rw-p 00026000 08:02 7866416 /usr/lib64/libsmime3.so
49951:20200914:172856.970 7f75b8ca8000-7f75b8cf5000 r-xp 00000000 08:02 7866427 /usr/lib64/libssl3.so
49951:20200914:172856.970 7f75b8cf5000-7f75b8ef4000 ---p 0004d000 08:02 7866427 /usr/lib64/libssl3.so
49951:20200914:172856.970 7f75b8ef4000-7f75b8ef8000 r--p 0004c000 08:02 7866427 /usr/lib64/libssl3.so
49951:20200914:172856.970 7f75b8ef8000-7f75b8ef9000 rw-p 00050000 08:02 7866427 /usr/lib64/libssl3.so
49951:20200914:172856.970 7f75b8ef9000-7f75b8efa000 rw-p 00000000 00:00 0
49951:20200914:172856.970 7f75b8efa000-7f75b8f16000 r-xp 00000000 08:02 7866402 /usr/lib64/libsasl2.so.3.0.0
49951:20200914:172856.970 7f75b8f16000-7f75b9115000 ---p 0001c000 08:02 7866402 /usr/lib64/libsasl2.so.3.0.0
49951:20200914:172856.970 7f75b9115000-7f75b9116000 r--p 0001b000 08:02 7866402 /usr/lib64/libsasl2.so.3.0.0
49951:20200914:172856.970 7f75b9116000-7f75b9117000 rw-p 0001c000 08:02 7866402 /usr/lib64/libsasl2.so.3.0.0
49951:20200914:172856.970 7f75b9117000-7f75b911e000 r-xp 00000000 08:02 7866163 /usr/lib64/libgdbm.so.4.0.0
49951:20200914:172856.970 7f75b911e000-7f75b931e000 ---p 00007000 08:02 7866163 /usr/lib64/libgdbm.so.4.0.0
49951:20200914:172856.970 7f75b931e000-7f75b931f000 r--p 00007000 08:02 7866163 /usr/lib64/libgdbm.so.4.0.0
49951:20200914:172856.970 7f75b931f000-7f75b9320000 rw-p 00008000 08:02 7866163 /usr/lib64/libgdbm.so.4.0.0
49951:20200914:172856.970 7f75b9320000-7f75b9328000 r-xp 00000000 08:02 7865993 /usr/lib64/libOpenIPMIutils.so.0.0.1
49951:20200914:172856.971 7f75b9328000-7f75b9528000 ---p 00008000 08:02 7865993 /usr/lib64/libOpenIPMIutils.so.0.0.1
49951:20200914:172856.971 7f75b9528000-7f75b9529000 r--p 00008000 08:02 7865993 /usr/lib64/libOpenIPMIutils.so.0.0.1
49951:20200914:172856.971 7f75b9529000-7f75b952a000 rw-p 00009000 08:02 7865993 /usr/lib64/libOpenIPMIutils.so.0.0.1
49951:20200914:172856.971 7f75b952a000-7f75b9533000 r-xp 00000000 08:02 7866243 /usr/lib64/libltdl.so.7.3.0
49951:20200914:172856.971 7f75b9533000-7f75b9732000 ---p 00009000 08:02 7866243 /usr/lib64/libltdl.so.7.3.0
49951:20200914:172856.971 7f75b9732000-7f75b9733000 r--p 00008000 08:02 7866243 /usr/lib64/libltdl.so.7.3.0
49951:20200914:172856.971 7f75b9733000-7f75b9734000 rw-p 00009000 08:02 7866243 /usr/lib64/libltdl.so.7.3.0
49951:20200914:172856.971 7f75b9734000-7f75b9759000 r-xp 00000000 08:02 7866248 /usr/lib64/liblzma.so.5.2.2
49951:20200914:172856.971 7f75b9759000-7f75b9958000 ---p 00025000 08:02 7866248 /usr/lib64/liblzma.so.5.2.2
49951:20200914:172856.971 7f75b9958000-7f75b9959000 r--p 00024000 08:02 7866248 /usr/lib64/liblzma.so.5.2.2
49951:20200914:172856.971 7f75b9959000-7f75b995a000 rw-p 00025000 08:02 7866248 /usr/lib64/liblzma.so.5.2.2
49951:20200914:172856.971 7f75b995a000-7f75b9973000 r-xp 00000000 08:02 7866221 /usr/lib64/libk5crypto.so.3.1
49951:20200914:172856.971 7f75b9973000-7f75b9b72000 ---p 00019000 08:02 7866221 /usr/lib64/libk5crypto.so.3.1
49951:20200914:172856.971 7f75b9b72000-7f75b9b74000 r--p 00018000 08:02 7866221 /usr/lib64/libk5crypto.so.3.1
49951:20200914:172856.971 7f75b9b74000-7f75b9b75000 rw-p 0001a000 08:02 7866221 /usr/lib64/libk5crypto.so.3.1
49951:20200914:172856.971 7f75b9b75000-7f75b9b78000 r-xp 00000000 08:02 7866067 /usr/lib64/libcom_err.so.2.1
49951:20200914:172856.971 7f75b9b78000-7f75b9d77000 ---p 00003000 08:02 7866067 /usr/lib64/libcom_err.so.2.1
49951:20200914:172856.971 7f75b9d77000-7f75b9d78000 r--p 00002000 08:02 7866067 /usr/lib64/libcom_err.so.2.1
49951:20200914:172856.971 7f75b9d78000-7f75b9d79000 rw-p 00003000 08:02 7866067 /usr/lib64/libcom_err.so.2.1
49951:20200914:172856.971 7f75b9d79000-7f75b9e52000 r-xp 00000000 08:02 7866233 /usr/lib64/libkrb5.so.3.3
49951:20200914:172856.971 7f75b9e52000-7f75ba051000 ---p 000d9000 08:02 7866233 /usr/lib64/libkrb5.so.3.3
49951:20200914:172856.971 7f75ba051000-7f75ba05f000 r--p 000d8000 08:02 7866233 /usr/lib64/libkrb5.so.3.3
49951:20200914:172856.971 7f75ba05f000-7f75ba062000 rw-p 000e6000 08:02 7866233 /usr/lib64/libkrb5.so.3.3
49951:20200914:172856.971 7f75ba062000-7f75ba0ac000 r-xp 00000000 08:02 7866197 /usr/lib64/libgssapi_krb5.so.2.2
49951:20200914:172856.971 7f75ba0ac000-7f75ba2ac000 ---p 0004a000 08:02 7866197 /usr/lib64/libgssapi_krb5.so.2.2
49951:20200914:172856.971 7f75ba2ac000-7f75ba2ad000 r--p 0004a000 08:02 7866197 /usr/lib64/libgssapi_krb5.so.2.2
49951:20200914:172856.971 7f75ba2ad000-7f75ba2af000 rw-p 0004b000 08:02 7866197 /usr/lib64/libgssapi_krb5.so.2.2
49951:20200914:172856.971 7f75ba2af000-7f75ba398000 r-xp 00000000 08:02 7866429 /usr/lib64/libstdc++.so.6.0.19
49951:20200914:172856.971 7f75ba398000-7f75ba597000 ---p 000e9000 08:02 7866429 /usr/lib64/libstdc++.so.6.0.19
49951:20200914:172856.971 7f75ba597000-7f75ba59f000 r--p 000e8000 08:02 7866429 /usr/lib64/libstdc++.so.6.0.19
49951:20200914:172856.971 7f75ba59f000-7f75ba5a1000 rw-p 000f0000 08:02 7866429 /usr/lib64/libstdc++.so.6.0.19
49951:20200914:172856.971 7f75ba5a1000-7f75ba5b6000 rw-p 00000000 00:00 0
49951:20200914:172856.971 7f75ba5b6000-7f75ba778000 r-xp 00000000 08:02 7866052 /usr/lib64/libc-2.17.so
49951:20200914:172856.971 7f75ba778000-7f75ba978000 ---p 001c2000 08:02 7866052 /usr/lib64/libc-2.17.so
49951:20200914:172856.971 7f75ba978000-7f75ba97c000 r--p 001c2000 08:02 7866052 /usr/lib64/libc-2.17.so
49951:20200914:172856.971 7f75ba97c000-7f75ba97e000 rw-p 001c6000 08:02 7866052 /usr/lib64/libc-2.17.so
49951:20200914:172856.971 7f75ba97e000-7f75ba983000 rw-p 00000000 00:00 0
49951:20200914:172856.971 7f75ba983000-7f75ba9e3000 r-xp 00000000 08:02 7866353 /usr/lib64/libpcre.so.1.2.0
49951:20200914:172856.971 7f75ba9e3000-7f75babe3000 ---p 00060000 08:02 7866353 /usr/lib64/libpcre.so.1.2.0
49951:20200914:172856.971 7f75babe3000-7f75babe4000 r--p 00060000 08:02 7866353 /usr/lib64/libpcre.so.1.2.0
49951:20200914:172856.971 7f75babe4000-7f75babe5000 rw-p 00061000 08:02 7866353 /usr/lib64/libpcre.so.1.2.0
49951:20200914:172856.971 7f75babe5000-7f75babfb000 r-xp 00000000 08:02 7866387 /usr/lib64/libresolv-2.17.so
49951:20200914:172856.971 7f75babfb000-7f75badfa000 ---p 00016000 08:02 7866387 /usr/lib64/libresolv-2.17.so
49951:20200914:172856.971 7f75badfa000-7f75badfb000 r--p 00015000 08:02 7866387 /usr/lib64/libresolv-2.17.so
49951:20200914:172856.971 7f75badfb000-7f75badfc000 rw-p 00016000 08:02 7866387 /usr/lib64/libresolv-2.17.so
49951:20200914:172856.971 7f75badfc000-7f75badfe000 rw-p 00000000 00:00 0
49951:20200914:172856.971 7f75badfe000-7f75bae64000 r-xp 00000000 08:02 7866084 /usr/lib64/libcurl.so.4.3.0
49951:20200914:172856.971 7f75bae64000-7f75bb063000 ---p 00066000 08:02 7866084 /usr/lib64/libcurl.so.4.3.0
49951:20200914:172856.971 7f75bb063000-7f75bb065000 r--p 00065000 08:02 7866084 /usr/lib64/libcurl.so.4.3.0
49951:20200914:172856.971 7f75bb065000-7f75bb066000 rw-p 00067000 08:02 7866084 /usr/lib64/libcurl.so.4.3.0
49951:20200914:172856.971 7f75bb066000-7f75bb067000 rw-p 00000000 00:00 0
49951:20200914:172856.971 7f75bb067000-7f75bb075000 r-xp 00000000 08:02 7866237 /usr/lib64/liblber-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb075000-7f75bb274000 ---p 0000e000 08:02 7866237 /usr/lib64/liblber-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb274000-7f75bb275000 r--p 0000d000 08:02 7866237 /usr/lib64/liblber-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb275000-7f75bb276000 rw-p 0000e000 08:02 7866237 /usr/lib64/liblber-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb276000-7f75bb2c8000 r-xp 00000000 08:02 7866239 /usr/lib64/libldap-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb2c8000-7f75bb4c8000 ---p 00052000 08:02 7866239 /usr/lib64/libldap-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb4c8000-7f75bb4ca000 r--p 00052000 08:02 7866239 /usr/lib64/libldap-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb4ca000-7f75bb4cb000 rw-p 00054000 08:02 7866239 /usr/lib64/libldap-2.4.so.2.10.7
49951:20200914:172856.971 7f75bb4cb000-7f75bb511000 r-xp 00000000 08:02 7866117 /usr/lib64/libevent-2.0.so.5.1.9
49951:20200914:172856.971 7f75bb511000-7f75bb710000 ---p 00046000 08:02 7866117 /usr/lib64/libevent-2.0.so.5.1.9
49951:20200914:172856.971 7f75bb710000-7f75bb711000 r--p 00045000 08:02 7866117 /usr/lib64/libevent-2.0.so.5.1.9
49951:20200914:172856.971 7f75bb711000-7f75bb712000 rw-p 00046000 08:02 7866117 /usr/lib64/libevent-2.0.so.5.1.9
49951:20200914:172856.972 7f75bb712000-7f75bb713000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bb713000-7f75bb71a000 r-xp 00000000 08:02 7865987 /usr/lib64/libOpenIPMIposix.so.0.0.1
49951:20200914:172856.972 7f75bb71a000-7f75bb919000 ---p 00007000 08:02 7865987 /usr/lib64/libOpenIPMIposix.so.0.0.1
49951:20200914:172856.972 7f75bb919000-7f75bb91a000 r--p 00006000 08:02 7865987 /usr/lib64/libOpenIPMIposix.so.0.0.1
49951:20200914:172856.972 7f75bb91a000-7f75bb91b000 rw-p 00007000 08:02 7865987 /usr/lib64/libOpenIPMIposix.so.0.0.1
49951:20200914:172856.972 7f75bb91b000-7f75bba09000 r-xp 00000000 08:02 7865981 /usr/lib64/libOpenIPMI.so.0.0.5
49951:20200914:172856.972 7f75bba09000-7f75bbc09000 ---p 000ee000 08:02 7865981 /usr/lib64/libOpenIPMI.so.0.0.5
49951:20200914:172856.972 7f75bbc09000-7f75bbc21000 r--p 000ee000 08:02 7865981 /usr/lib64/libOpenIPMI.so.0.0.5
49951:20200914:172856.972 7f75bbc21000-7f75bbc26000 rw-p 00106000 08:02 7865981 /usr/lib64/libOpenIPMI.so.0.0.5
49951:20200914:172856.972 7f75bbc26000-7f75bbc2a000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bbc2a000-7f75bbc52000 r-xp 00000000 08:02 7866424 /usr/lib64/libssh2.so.1.0.1
49951:20200914:172856.972 7f75bbc52000-7f75bbe52000 ---p 00028000 08:02 7866424 /usr/lib64/libssh2.so.1.0.1
49951:20200914:172856.972 7f75bbe52000-7f75bbe53000 r--p 00028000 08:02 7866424 /usr/lib64/libssh2.so.1.0.1
49951:20200914:172856.972 7f75bbe53000-7f75bbe54000 rw-p 00029000 08:02 7866424 /usr/lib64/libssh2.so.1.0.1
49951:20200914:172856.972 7f75bbe54000-7f75bbf1c000 r-xp 00000000 08:02 7866271 /usr/lib64/libnetsnmp.so.31.0.2
49951:20200914:172856.972 7f75bbf1c000-7f75bc11c000 ---p 000c8000 08:02 7866271 /usr/lib64/libnetsnmp.so.31.0.2
49951:20200914:172856.972 7f75bc11c000-7f75bc11f000 r--p 000c8000 08:02 7866271 /usr/lib64/libnetsnmp.so.31.0.2
49951:20200914:172856.972 7f75bc11f000-7f75bc121000 rw-p 000cb000 08:02 7866271 /usr/lib64/libnetsnmp.so.31.0.2
49951:20200914:172856.972 7f75bc121000-7f75bc157000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bc157000-7f75bc1b7000 r-xp 00000000 08:02 7866302 /usr/lib64/libodbc.so.2.0.0
49951:20200914:172856.972 7f75bc1b7000-7f75bc3b6000 ---p 00060000 08:02 7866302 /usr/lib64/libodbc.so.2.0.0
49951:20200914:172856.972 7f75bc3b6000-7f75bc3b7000 r--p 0005f000 08:02 7866302 /usr/lib64/libodbc.so.2.0.0
49951:20200914:172856.972 7f75bc3b7000-7f75bc3be000 rw-p 00060000 08:02 7866302 /usr/lib64/libodbc.so.2.0.0
49951:20200914:172856.972 7f75bc3be000-7f75bc3bf000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bc3bf000-7f75bc51e000 r-xp 00000000 08:02 7866539 /usr/lib64/libxml2.so.2.9.1
49951:20200914:172856.972 7f75bc51e000-7f75bc71d000 ---p 0015f000 08:02 7866539 /usr/lib64/libxml2.so.2.9.1
49951:20200914:172856.972 7f75bc71d000-7f75bc725000 r--p 0015e000 08:02 7866539 /usr/lib64/libxml2.so.2.9.1
49951:20200914:172856.972 7f75bc725000-7f75bc727000 rw-p 00166000 08:02 7866539 /usr/lib64/libxml2.so.2.9.1
49951:20200914:172856.972 7f75bc727000-7f75bc729000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bc729000-7f75bc95f000 r-xp 00000000 08:02 7866072 /usr/lib64/libcrypto.so.1.0.2k
49951:20200914:172856.972 7f75bc95f000-7f75bcb5f000 ---p 00236000 08:02 7866072 /usr/lib64/libcrypto.so.1.0.2k
49951:20200914:172856.972 7f75bcb5f000-7f75bcb7b000 r--p 00236000 08:02 7866072 /usr/lib64/libcrypto.so.1.0.2k
49951:20200914:172856.972 7f75bcb7b000-7f75bcb88000 rw-p 00252000 08:02 7866072 /usr/lib64/libcrypto.so.1.0.2k
49951:20200914:172856.972 7f75bcb88000-7f75bcb8c000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bcb8c000-7f75bcbf3000 r-xp 00000000 08:02 7866425 /usr/lib64/libssl.so.1.0.2k
49951:20200914:172856.972 7f75bcbf3000-7f75bcdf3000 ---p 00067000 08:02 7866425 /usr/lib64/libssl.so.1.0.2k
49951:20200914:172856.972 7f75bcdf3000-7f75bcdf7000 r--p 00067000 08:02 7866425 /usr/lib64/libssl.so.1.0.2k
49951:20200914:172856.972 7f75bcdf7000-7f75bcdfe000 rw-p 0006b000 08:02 7866425 /usr/lib64/libssl.so.1.0.2k
49951:20200914:172856.972 7f75bcdfe000-7f75bce00000 r-xp 00000000 08:02 7866092 /usr/lib64/libdl-2.17.so
49951:20200914:172856.972 7f75bce00000-7f75bd000000 ---p 00002000 08:02 7866092 /usr/lib64/libdl-2.17.so
49951:20200914:172856.972 7f75bd000000-7f75bd001000 r--p 00002000 08:02 7866092 /usr/lib64/libdl-2.17.so
49951:20200914:172856.972 7f75bd001000-7f75bd002000 rw-p 00003000 08:02 7866092 /usr/lib64/libdl-2.17.so
49951:20200914:172856.972 7f75bd002000-7f75bd103000 r-xp 00000000 08:02 7866249 /usr/lib64/libm-2.17.so
49951:20200914:172856.972 7f75bd103000-7f75bd302000 ---p 00101000 08:02 7866249 /usr/lib64/libm-2.17.so
49951:20200914:172856.972 7f75bd302000-7f75bd303000 r--p 00100000 08:02 7866249 /usr/lib64/libm-2.17.so
49951:20200914:172856.972 7f75bd303000-7f75bd304000 rw-p 00101000 08:02 7866249 /usr/lib64/libm-2.17.so
49951:20200914:172856.972 7f75bd304000-7f75bd319000 r-xp 00000000 08:02 7866546 /usr/lib64/libz.so.1.2.7
49951:20200914:172856.972 7f75bd319000-7f75bd518000 ---p 00015000 08:02 7866546 /usr/lib64/libz.so.1.2.7
49951:20200914:172856.972 7f75bd518000-7f75bd519000 r--p 00014000 08:02 7866546 /usr/lib64/libz.so.1.2.7
49951:20200914:172856.972 7f75bd519000-7f75bd51a000 rw-p 00015000 08:02 7866546 /usr/lib64/libz.so.1.2.7
49951:20200914:172856.972 7f75bd51a000-7f75bd531000 r-xp 00000000 08:02 7866376 /usr/lib64/libpthread-2.17.so
49951:20200914:172856.972 7f75bd531000-7f75bd730000 ---p 00017000 08:02 7866376 /usr/lib64/libpthread-2.17.so
49951:20200914:172856.972 7f75bd730000-7f75bd731000 r--p 00016000 08:02 7866376 /usr/lib64/libpthread-2.17.so
49951:20200914:172856.972 7f75bd731000-7f75bd732000 rw-p 00017000 08:02 7866376 /usr/lib64/libpthread-2.17.so
49951:20200914:172856.972 7f75bd732000-7f75bd736000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bd736000-7f75bda14000 r-xp 00000000 08:02 7866551 /usr/lib64/mysql/libmysqlclient.so.18.0.0
49951:20200914:172856.972 7f75bda14000-7f75bdc13000 ---p 002de000 08:02 7866551 /usr/lib64/mysql/libmysqlclient.so.18.0.0
49951:20200914:172856.972 7f75bdc13000-7f75bdc1c000 r--p 002dd000 08:02 7866551 /usr/lib64/mysql/libmysqlclient.so.18.0.0
49951:20200914:172856.972 7f75bdc1c000-7f75bdc30000 rw-p 002e6000 08:02 7866551 /usr/lib64/mysql/libmysqlclient.so.18.0.0
49951:20200914:172856.972 7f75bdc30000-7f75bdc36000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bdc36000-7f75bdc58000 r-xp 00000000 08:02 7865961 /usr/lib64/ld-2.17.so
49951:20200914:172856.972 7f75bde1a000-7f75bde37000 rw-s 00000000 00:04 688133 /SYSV00000000 (deleted)
49951:20200914:172856.972 7f75bde37000-7f75bde50000 rw-p 00000000 00:00 0
49951:20200914:172856.972 7f75bde53000-7f75bde54000 rw-p 00000000 00:00 0
49951:20200914:172856.973 7f75bde54000-7f75bde55000 rw-s 00000000 00:04 524288 /SYSV00000000 (deleted)
49951:20200914:172856.973 7f75bde55000-7f75bde56000 rw-p 00000000 00:00 0
49951:20200914:172856.973 7f75bde56000-7f75bde57000 rw-p 00000000 00:00 0
49951:20200914:172856.973 7f75bde57000-7f75bde58000 r--p 00021000 08:02 7865961 /usr/lib64/ld-2.17.so
49951:20200914:172856.973 7f75bde58000-7f75bde59000 rw-p 00022000 08:02 7865961 /usr/lib64/ld-2.17.so
49951:20200914:172856.973 7f75bde59000-7f75bde5a000 rw-p 00000000 00:00 0
49951:20200914:172856.973 7f75bde5a000-7f75be17f000 r-xp 00000000 08:02 8258507 /usr/sbin/zabbix_server_mysql
49951:20200914:172856.973 7f75be37e000-7f75be40e000 r--p 00324000 08:02 8258507 /usr/sbin/zabbix_server_mysql
49951:20200914:172856.973 7f75be40e000-7f75be41b000 rw-p 003b4000 08:02 8258507 /usr/sbin/zabbix_server_mysql
49951:20200914:172856.973 7f75be41b000-7f75be424000 rw-p 00000000 00:00 0
49951:20200914:172856.973 7f75bffb3000-7f75bffd4000 rw-p 00000000 00:00 0 [heap]
49951:20200914:172856.973 7f75bffd4000-7f75bfff5000 rw-p 00000000 00:00 0 [heap]
49951:20200914:172856.973 7f75bfff5000-7f75d2a9c000 rw-p 00000000 00:00 0 [heap]
49951:20200914:172856.973 7ffcb2072000-7ffcb2093000 rw-p 00000000 00:00 0 [stack]
49951:20200914:172856.973 7ffcb21f9000-7ffcb21fb000 r-xp 00000000 00:00 0 [vdso]
49951:20200914:172856.973 ffffffffff600000-ffffffffff601000 r-xp 00000000 00:00 0 [vsyscall]
49951:20200914:172856.973 ================================
49951:20200914:172856.973 Please consider attaching a disassembly listing to your bug report.
49951:20200914:172856.973 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
49951:20200914:172856.973 ================================
49949:20200914:172857.020 One child process died (PID:49951,exitcode/signal:1). Exiting ...
zabbix_server [49949]: Error waiting for process with PID 49951: [10] No child processes
49949:20200914:172857.603 syncing history data...
49949:20200914:172857.625 [Z3005] query failed: [1062] Duplicate entry '2846094-1600075729-654568459' for key 'PRIMARY' [insert into history (itemid,clock,ns,value) value
s (2846094,1600075729,654568459,49.969999999999999), (2846095,1600075729,654589061,52.100000000000001), (2846096,1600075729,654605745,51.609999999999999), (2846097,1600075729
,654613995,33.282871),(2846098,1600075729,65461948 8,0.003176),(2846099,1600075729,654622876,4.958359 9999999999),(2846100,1600075729,654626530,0.184558 ),(2844584,1600075729
--More--

49949:20200914:172858.015 syncing history data... 100.000000%
49949:20200914:172858.015 syncing history data done
49949:20200914:172858.015 syncing trend data...
49949:20200914:172903.107 syncing trend data done
49949:20200914:172903.244 Zabbix Server stopped. Zabbix 5.0.3 (revision 146855bff3).

**dimir** · 14-09-2020, 15:49

Could you show the output of the following SQL statements:

Code:

show create table hosts;
show create table items;
show create table functions;
show create table triggers;

**zhujian** · 15-09-2020, 07:10

| hosts | CREATE TABLE `hosts` (
`hostid` bigint(20) unsigned NOT NULL,
`proxy_hostid` bigint(20) unsigned DEFAULT NULL,
`host` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
`status` int(11) NOT NULL DEFAULT '0',
`disable_until` int(11) NOT NULL DEFAULT '0',
`error` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`available` int(11) NOT NULL DEFAULT '0',
`errors_from` int(11) NOT NULL DEFAULT '0',
`lastaccess` int(11) NOT NULL DEFAULT '0',
`ipmi_authtype` int(11) NOT NULL DEFAULT '-1',
`ipmi_privilege` int(11) NOT NULL DEFAULT '2',
`ipmi_username` varchar(16) COLLATE utf8_bin NOT NULL DEFAULT '',
`ipmi_password` varchar(20) COLLATE utf8_bin NOT NULL DEFAULT '',
`ipmi_disable_until` int(11) NOT NULL DEFAULT '0',
`ipmi_available` int(11) NOT NULL DEFAULT '0',
`snmp_disable_until` int(11) NOT NULL DEFAULT '0',
`snmp_available` int(11) NOT NULL DEFAULT '0',
`maintenanceid` bigint(20) unsigned DEFAULT NULL,
`maintenance_status` int(11) NOT NULL DEFAULT '0',
`maintenance_type` int(11) NOT NULL DEFAULT '0',
`maintenance_from` int(11) NOT NULL DEFAULT '0',
`ipmi_errors_from` int(11) NOT NULL DEFAULT '0',
`snmp_errors_from` int(11) NOT NULL DEFAULT '0',
`ipmi_error` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`snmp_error` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`jmx_disable_until` int(11) NOT NULL DEFAULT '0',
`jmx_available` int(11) NOT NULL DEFAULT '0',
`jmx_errors_from` int(11) NOT NULL DEFAULT '0',
`jmx_error` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`name` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
`flags` int(11) NOT NULL DEFAULT '0',
`templateid` bigint(20) unsigned DEFAULT NULL,
`description` text COLLATE utf8_bin NOT NULL,
`tls_connect` int(11) NOT NULL DEFAULT '1',
`tls_accept` int(11) NOT NULL DEFAULT '1',
`tls_issuer` varchar(1024) COLLATE utf8_bin NOT NULL DEFAULT '',
`tls_subject` varchar(1024) COLLATE utf8_bin NOT NULL DEFAULT '',
`tls_psk_identity` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
`tls_psk` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
`proxy_address` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`auto_compress` int(11) NOT NULL DEFAULT '1',
`discover` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`hostid`),
KEY `hosts_1` (`host`),
KEY `hosts_2` (`status`),
KEY `hosts_3` (`proxy_hostid`),
KEY `hosts_4` (`name`),
KEY `hosts_5` (`maintenanceid`),
KEY `c_hosts_3` (`templateid`),
CONSTRAINT `c_hosts_1` FOREIGN KEY (`proxy_hostid`) REFERENCES `hosts` (`hostid`),
CONSTRAINT `c_hosts_2` FOREIGN KEY (`maintenanceid`) REFERENCES `maintenances` (`maintenanceid`),
CONSTRAINT `c_hosts_3` FOREIGN KEY (`templateid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |

| items | CREATE TABLE `items` (
`itemid` bigint(20) unsigned NOT NULL,
`type` int(11) NOT NULL DEFAULT '0',
`snmp_oid` varchar(512) COLLATE utf8_bin NOT NULL DEFAULT '',
`hostid` bigint(20) unsigned NOT NULL,
`name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`key_` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`delay` varchar(1024) COLLATE utf8_bin NOT NULL DEFAULT '0',
`history` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '90d',
`trends` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '365d',
`status` int(11) NOT NULL DEFAULT '0',
`value_type` int(11) NOT NULL DEFAULT '0',
`trapper_hosts` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`units` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`formula` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`logtimefmt` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`templateid` bigint(20) unsigned DEFAULT NULL,
`valuemapid` bigint(20) unsigned DEFAULT NULL,
`params` text COLLATE utf8_bin NOT NULL,
`ipmi_sensor` varchar(128) COLLATE utf8_bin NOT NULL DEFAULT '',
`authtype` int(11) NOT NULL DEFAULT '0',
`username` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`password` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`publickey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`privatekey` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`flags` int(11) NOT NULL DEFAULT '0',
`interfaceid` bigint(20) unsigned DEFAULT NULL,
`description` text COLLATE utf8_bin NOT NULL,
`inventory_link` int(11) NOT NULL DEFAULT '0',
`lifetime` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '30d',
`evaltype` int(11) NOT NULL DEFAULT '0',
`jmx_endpoint` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`master_itemid` bigint(20) unsigned DEFAULT NULL,
`timeout` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '3s',
`url` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`query_fields` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`posts` text COLLATE utf8_bin NOT NULL,
`status_codes` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '200',
`follow_redirects` int(11) NOT NULL DEFAULT '1',
`post_type` int(11) NOT NULL DEFAULT '0',
`http_proxy` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`headers` text COLLATE utf8_bin NOT NULL,
`retrieve_mode` int(11) NOT NULL DEFAULT '0',
`request_method` int(11) NOT NULL DEFAULT '0',
`output_format` int(11) NOT NULL DEFAULT '0',
`ssl_cert_file` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`ssl_key_file` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`ssl_key_password` varchar(64) COLLATE utf8_bin NOT NULL DEFAULT '',
`verify_peer` int(11) NOT NULL DEFAULT '0',
`verify_host` int(11) NOT NULL DEFAULT '0',
`allow_traps` int(11) NOT NULL DEFAULT '0',
`discover` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`itemid`),
KEY `items_3` (`status`),
KEY `items_4` (`templateid`),
KEY `items_5` (`valuemapid`),
KEY `items_6` (`interfaceid`),
KEY `items_7` (`master_itemid`),
KEY `items_1` (`hostid`,`key_`(1021)),
CONSTRAINT `c_items_1` FOREIGN KEY (`hostid`) REFERENCES `hosts` (`hostid`) ON DELETE CASCADE,
CONSTRAINT `c_items_2` FOREIGN KEY (`templateid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE,
CONSTRAINT `c_items_3` FOREIGN KEY (`valuemapid`) REFERENCES `valuemaps` (`valuemapid`),
CONSTRAINT `c_items_4` FOREIGN KEY (`interfaceid`) REFERENCES `interface` (`interfaceid`),
CONSTRAINT `c_items_5` FOREIGN KEY (`master_itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |

| functions | CREATE TABLE `functions` (
`functionid` bigint(20) unsigned NOT NULL,
`itemid` bigint(20) unsigned NOT NULL,
`triggerid` bigint(20) unsigned NOT NULL,
`name` varchar(12) COLLATE utf8_bin NOT NULL DEFAULT '',
`parameter` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '0',
PRIMARY KEY (`functionid`),
KEY `functions_1` (`triggerid`),
KEY `functions_2` (`itemid`,`name`,`parameter`),
CONSTRAINT `c_functions_1` FOREIGN KEY (`itemid`) REFERENCES `items` (`itemid`) ON DELETE CASCADE,
CONSTRAINT `c_functions_2` FOREIGN KEY (`triggerid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |

| triggers | CREATE TABLE `triggers` (
`triggerid` bigint(20) unsigned NOT NULL,
`expression` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`description` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`url` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`status` int(11) NOT NULL DEFAULT '0',
`value` int(11) NOT NULL DEFAULT '0',
`priority` int(11) NOT NULL DEFAULT '0',
`lastchange` int(11) NOT NULL DEFAULT '0',
`comments` text COLLATE utf8_bin NOT NULL,
`error` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`templateid` bigint(20) unsigned DEFAULT NULL,
`type` int(11) NOT NULL DEFAULT '0',
`state` int(11) NOT NULL DEFAULT '0',
`flags` int(11) NOT NULL DEFAULT '0',
`recovery_mode` int(11) NOT NULL DEFAULT '0',
`recovery_expression` varchar(2048) COLLATE utf8_bin NOT NULL DEFAULT '',
`correlation_mode` int(11) NOT NULL DEFAULT '0',
`correlation_tag` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`manual_close` int(11) NOT NULL DEFAULT '0',
`opdata` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`discover` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`triggerid`),
KEY `triggers_1` (`status`),
KEY `triggers_2` (`value`,`lastchange`),
KEY `triggers_3` (`templateid`),
KEY `triggers_4` (`flags`),
CONSTRAINT `c_triggers_1` FOREIGN KEY (`templateid`) REFERENCES `triggers` (`triggerid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin |

**dimir** · 15-09-2020, 18:19

I don't see any issues. How long is server working before it crashes? Could you do the following:
1. rm /var/log/zabbix/zabbix_server.log
2. start zabbix server
3. after it crashes attach full log file /var/log/zabbix/zabbix_server.log here (not copy-past but attach the file itself)

**zhujian** · 16-09-2020, 10:16

Add an action, it will crash immediately, attached is zabbix_server log,thanks

zabbix_server.log.gz

**vso** · 16-09-2020, 13:17

It is better to increase log level to debug (DebugLevel=4) and then attach patch, please also check 5.0.3 version.

**dimir** · 16-09-2020, 13:40

Originally posted by vso

It is better to increase log level to debug (DebugLevel=4) and then attach patch, please also check 5.0.3 version.

Indeed. But I guess you meant "attach the log".

**zhujian** · 16-09-2020, 15:25

the log very big,i can't upload. so Click link: https://cowtransfer.com/s/3f8691279d384c use code:7ym7hc

**dimir** · 16-09-2020, 16:28

Related snippet from the attached log file:

Code:

98:20200916:203022.281 End of DCsync_expressions()
98:20200916:203022.281 In DCsync_actions()
98:20200916:203022.290 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
[...]
98:20200916:203022.293 === Backtrace: ===
98:20200916:203022.307 18: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](zbx_backtrace+0x42) [0x7ff1e104fe23]
98:20200916:203022.307 17: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](zbx_log_fatal_info+0x151) [0x7ff1e10500a1]
98:20200916:203022.307 16: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](+0x1c1816) [0x7ff1e1050816]
98:20200916:203022.307 15: /lib64/libpthread.so.0(+0xf5d0) [0x7ff1e055e5d0]
98:20200916:203022.307 14: /lib64/libc.so.6(+0x16e901) [0x7ff1dd759901]
98:20200916:203022.307 13: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](zbx_default_string_hash_func+0x18) [0x7ff1e1051594]
98:20200916:203022.307 12: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](+0x183b24) [0x7ff1e1012b24]
98:20200916:203022.307 11: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](zbx_hashset_search+0x36) [0x7ff1e1055cf3]
98:20200916:203022.307 10: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](+0x183b7f) [0x7ff1e1012b7f]
98:20200916:203022.307 9: /usr/sbin/zabbix_server: configuration syncer [synced configuration in 30.816227 sec, syncing configuration](DCstrpool_replace+0x55) [0x7ff1e1012cbc]
[...]

Looks like something to do with the formula.Could you show the output of the following SQL statement:

Code:

show create table actions;

Ad Widget

zabbix5.0.1 crash

zabbix5.0.1 crash

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment

Comment