Ad Widget

**MikansOnTap456** · 28-06-2024, 17:37

Here is the output immediately preceding the crash with debug level 4 enabled:

Code:

  5694:20240629:003600.679 query [txnlev:0] [select i.interfaceid,i.hostid,i.type,i.main,i.useip,i.ip,i.dns,i.port,i.available,i.disable_until,i.error,i.errors_from,s.version,s.bulk,s.community,s.securityname,s.securitylevel,s.authpassphrase,s.privpassphrase,s.authprotocol,s.privprotocol,s.contextname,s.max_repetitions from interface i left join interface_snmp s on i.interfaceid=s.interfaceid]
  5694:20240629:003600.683 query [txnlev:0] [select i.itemid,i.hostid,i.status,i.type,i.value_type,i.key_,i.snmp_oid,i.ipmi_sensor,i.delay,i.trapper_hosts,i.logtimefmt,i.params,ir.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,ir.lastlogsize,ir.mtime,i.history,i.trends,i.inventory_link,i.valuemapid,i.units,ir.error,i.jmx_endpoint,i.master_itemid,i.timeout,i.url,i.query_fields,i.posts,i.status_codes,i.follow_redirects,i.post_type,i.http_proxy,i.headers,i.retrieve_mode,i.request_method,i.output_format,i.ssl_cert_file,i.ssl_key_file,i.ssl_key_password,i.verify_peer,i.verify_host,i.allow_traps,i.templateid,null from items i join item_rtdata ir on i.itemid=ir.itemid]
  5694:20240629:003600.936 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i inner join hosts h on i.hostid=h.hostid where h.status=3]
  5694:20240629:003600.964 query [txnlev:0] [select i.itemid,i.hostid,i.templateid from items i where i.flags=2]
  5694:20240629:003600.989 query [txnlev:0] [select itemid,parent_itemid from item_discovery]
  5694:20240629:003601.013 query [txnlev:0] [select item_preprocid,itemid,type,params,step,error_handler,error_handler_params from item_preproc]
  5694:20240629:003601.080 query [txnlev:0] [select p.item_parameterid,p.itemid,p.name,p.value,i.hostid from item_parameter p,items i,hosts h where p.itemid=i.itemid and i.hostid=h.hostid and h.status in (0,1) and i.flags<>2 order by p.itemid]
  5694:20240629:003601.081 query [txnlev:0] [select functionid,itemid,name,parameter,triggerid from functions]
  5694:20240629:003601.132 In DCsync_interfaces()
  5694:20240629:003601.133 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
  5694:20240629:003601.133 ====== Fatal information: ======
  5694:20240629:003601.133 Program counter: 0x56054fdd7ee0
  5694:20240629:003601.133 === Registers: ===
  5694:20240629:003601.133 r8      =     7f1e05769cc0 =      139766917405888 =      139766917405888
  5694:20240629:003601.133 r9      =               40 =                   64 =                   64
  5694:20240629:003601.133 r10     =                0 =                    0 =                    0
  5694:20240629:003601.133 r11     =               20 =                   32 =                   32
  5694:20240629:003601.134 r12     =     7ffd5fd3ab09 =      140726211160841 =      140726211160841
  5694:20240629:003601.134 r13     =     7ffd5fd3aac8 =      140726211160776 =      140726211160776
  5694:20240629:003601.134 r14     =     7ffd5fd3aa58 =      140726211160664 =      140726211160664
  5694:20240629:003601.134 r15     =     7ffd5fd3aa68 =      140726211160680 =      140726211160680
  5694:20240629:003601.134 rdi     =     7ffd5fd3aac8 =      140726211160776 =      140726211160776
  5694:20240629:003601.134 rsi     =                0 =                    0 =                    0
  5694:20240629:003601.134 rbp     =     7f1dbdae5ae0 =      139765713099488 =      139765713099488
  5694:20240629:003601.134 rbx     =     7ffd5fd3aac0 =      140726211160768 =      140726211160768
  5694:20240629:003601.134 rdx     =     7ffd5fd3ab08 =      140726211160840 =      140726211160840
  5694:20240629:003601.134 rax     =               41 =                   65 =                   65
  5694:20240629:003601.134 rcx     =                0 =                    0 =                    0
  5694:20240629:003601.134 rsp     =     7ffd5fd3a9b8 =      140726211160504 =      140726211160504
  5694:20240629:003601.134 rip     =     56054fdd7ee0 =       94580814741216 =       94580814741216
  5694:20240629:003601.134 efl     =            10202 =                66050 =                66050
  5694:20240629:003601.134 csgsfs  =   2b000000000033 =    12103423998558259 =    12103423998558259
  5694:20240629:003601.134 err     =                4 =                    4 =                    4
  5694:20240629:003601.134 trapno  =                e =                   14 =                   14
  5694:20240629:003601.134 oldmask =                0 =                    0 =                    0
  5694:20240629:003601.134 cr2     =                0 =                    0 =                    0
  5694:20240629:003601.134 === Backtrace: ===
  5694:20240629:003601.137 18: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_backtrace+0x3b) [0x56054fdb051b]
  5694:20240629:003601.137 17: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_log_fatal_info+0x17d) [0x56054fdb078d]
  5694:20240629:003601.137 16: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0x3c2e46) [0x56054fdb0e46]
  5694:20240629:003601.137 15: /lib/x86_64-linux-gnu/libc.so.6(+0x3c050) [0x7f1e055d3050]
  5694:20240629:003601.137 14: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_strlcpy+0x30) [0x56054fdd7ee0]
  5694:20240629:003601.137 13: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](DCget_interface+0x38) [0x56054fc5a3f8]
  5694:20240629:003601.137 12: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_dc_config_get_interface_by_type+0x4f) [0x56054fc5cc5f]
  5694:20240629:003601.137 11: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0x26ef0b) [0x56054fc5cf0b]
  5694:20240629:003601.137 10: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0x26eff5) [0x56054fc5cff5]
  5694:20240629:003601.137 9: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0x26f623) [0x56054fc5d623]
  5694:20240629:003601.137 8: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_dc_sync_configuration+0x2a4b) [0x56054fc68e3b]
  5694:20240629:003601.137 7: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](dbconfig_thread+0xeb) [0x56054fac419b]
  5694:20240629:003601.137 6: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](zbx_thread_start+0x20) [0x56054fce5170]
  5694:20240629:003601.137 5: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](+0xcf26b) [0x56054fabd26b]
  5694:20240629:003601.137 4: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](MAIN_ZABBIX_ENTRY+0xefa) [0x56054fabe89a]
  5694:20240629:003601.137 3: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](main+0x37e) [0x56054fab2b0e]
  5694:20240629:003601.137 2: /lib/x86_64-linux-gnu/libc.so.6(+0x2724a) [0x7f1e055be24a]
  5694:20240629:003601.137 1: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0x85) [0x7f1e055be305]
  5694:20240629:003601.137 0: /usr/sbin/zabbix_server: configuration syncer [syncing configuration](_start+0x21) [0x56054fab9b61]

**millnet-maho** · 27-09-2024, 17:23

Ouch! As you can see, it says "Unsupported DB! timescaledb version 21502 is newer than 21499". When using TimescaleDB, you have to be very careful not to upgrade to a too new version, because if you do, Zabbix will refuse to start and you can't downgrade. This may require holding the timescaledb packages back to prevent automatic upgrades (with dpkg-hold or by pressing = in aptitude). I'm afraid the only options in this situation might be to wait for a newer Zabbix version that supports TimescaleDB 2.15 or to create a new database and copy the configuration tables from the old database.

However, by now, Zabbix has gained support for TimescaleDB 2.15 (since 7.0.1) and 2.16 (since 7.0.4). See https://www.zabbix.com/documentation...n/requirements

**cyber** · 30-09-2024, 11:22

You can set "AllowUnsupportedDBVersions=1" in server config, then it will ignore the slightly too new TS version... But as usual, you should know, what you are doing..

Ad Widget

Zabbix 7.0 crashing after upgrade from 6.0 LTS (Debian 12 / postgres + timescaledb)

Zabbix 7.0 crashing after upgrade from 6.0 LTS (Debian 12 / postgres + timescaledb)

Comment

Comment

Comment