[ZBX-24852] 7.0.1rc1 crashes on PgSQL 14.12/TSDB 2.15.3 Created: 2024 Jul 15  Updated: 2024 Jul 25  Resolved: 2024 Jul 23

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 7.0.1rc1
Fix Version/s: 7.0.1rc2, 7.2.0alpha1

Type: Problem report Priority: Blocker
Reporter: Alexander Vladishev Assignee: Armands Arseniuss Skolmeisters
Resolution: Fixed Votes: 0
Labels: TimescaleDB, auditlog, crash
Remaining Estimate: Not Specified
Time Spent: 28h 10m
Original Estimate: Not Specified

Attachments: Text File ZBX-24643.crash.log    
Issue Links:
Duplicate
Sub-task
depends on ZBX-24886 7.0.0 -> 7.0.1 stuck at database upgr... Closed
Team: Team C
Sprint: S24-W28/29, S24-W30/31
Story Points: 1

 Description   
3731821:20240713:185924.442 In hk_check_table_segmentation(): table: auditlog
3731821:20240713:185924.442 query [txnlev:0] [select attname from timescaledb_information.compression_settings where hypertable_schema='public' and hypertable_name='auditlog' and segmentby_column_index is not null]
3731821:20240713:185924.443 End of hk_check_table_segmentation()
3731821:20240713:185924.443 In hk_set_table_compression_age(): table: auditlog age 612000
3731821:20240713:185924.443 In hk_get_compression_age(): table: auditlog
3731821:20240713:185924.443 query [txnlev:0] [select extract(epoch from (config::json->>'compress_created_before')::interval) from timescaledb_information.jobs where application_name like 'Compression%' and hypertable_schema='public' and hypertable_name='auditlog']
3731821:20240713:185924.444 Got signal [signal:11(SIGSEGV),reason:1,refaddr:(nil)]. Crashing ...
3731821:20240713:185924.444 ====== Fatal information: ======
3731821:20240713:185924.444 Program counter: 0x7f912aff5558


...


731821:20240713:185924.444 === Backtrace: ===
3731821:20240713:185924.446 14: /usr/local/sbin/zabbix_server: housekeeper [startup idle for 30 minutes](zbx_backtrace+0x3b) [0x558daac8894b]
3731821:20240713:185924.446 13: /usr/local/sbin/zabbix_server: housekeeper [startup idle for 30 minutes](zbx_log_fatal_info+0x17d) [0x558daac88bbd]
3731821:20240713:185924.446 12: /usr/local/sbin/zabbix_server: housekeeper [startup idle for 30 minutes](+0x370256) [0x558daac89256]
3731821:20240713:185924.446 11: /lib/x86_64-linux-gnu/libpthread.so.0(+0x13140) [0x7f912b478140]
3731821:20240713:185924.446 10: /lib/x86_64-linux-gnu/libc.so.6(+0x3d558) [0x7f912aff5558]
3731821:20240713:185924.446 9: /usr/local/sbin/zabbix_server: housekeeper [startup idle for 30 minutes](+0xec166) [0x558daaa05166]
3731821:20240713:185924.446 8: /usr/local/sbin/zabbix_server: housekeeper [start

7.0.0 keeps working with same database.



 Comments   
Comment by Armands Arseniuss Skolmeisters [ 2024 Jul 17 ]

Available in versions:

Comment by Martins Valkovskis [ 2024 Jul 23 ]

Updated documentation:

Generated at Tue Jan 21 12:53:40 EET 2025 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.