-
Incident report
-
Resolution: Duplicate
-
Trivial
-
None
-
5.2.0
After upgrading zabbix from version 5.0.4 to 5.2.1 upon server startup for the first time it detected the required database upgrade but fails on doing so.
Bellow is the Debug 5 output that repeats over time, it is failing in SQL upgrade.
15821:20201109:180001.203 Starting Zabbix Server. Zabbix 5.2.1 (revision 4d0d532fb0). 15821:20201109:180001.204 ****** Enabled features ****** 15821:20201109:180001.204 SNMP monitoring: YES 15821:20201109:180001.204 IPMI monitoring: YES 15821:20201109:180001.204 Web monitoring: YES 15821:20201109:180001.204 VMware monitoring: YES 15821:20201109:180001.204 SMTP authentication: YES 15821:20201109:180001.204 ODBC: YES 15821:20201109:180001.204 SSH support: YES 15821:20201109:180001.205 IPv6 support: YES 15821:20201109:180001.205 TLS support: YES 15821:20201109:180001.205 ****************************** 15821:20201109:180001.205 using configuration file: /etc/zabbix/zabbix_server.conf 15821:20201109:180001.205 In zbx_load_modules() 15821:20201109:180001.205 End of zbx_load_modules():SUCCEED 15821:20201109:180001.205 In init_database_cache() 15821:20201109:180001.206 In zbx_mem_create() param:'HistoryCacheSize' size:16777216 15821:20201109:180001.206 valid user addresses: [0xf371a0e0, 0xf4719ff0] total size: 16776976 15821:20201109:180001.206 End of zbx_mem_create() 15821:20201109:180001.206 In zbx_mem_create() param:'HistoryIndexCacheSize' size:4194304 15821:20201109:180001.206 valid user addresses: [0xf331a0f0, 0xf3719ff0] total size: 4194048 15821:20201109:180001.207 End of zbx_mem_create() 15821:20201109:180001.208 In init_trend_cache() 15821:20201109:180001.211 In zbx_mem_required_size() size:0 chunks_num:1 descr:'trend cache' param:'TrendCacheSize' 15821:20201109:180001.211 End of zbx_mem_required_size() size:274 15821:20201109:180001.211 In zbx_mem_create() param:'TrendCacheSize' size:4194304 15821:20201109:180001.212 valid user addresses: [0xf2f1a0e0, 0xf3319ff0] total size: 4194064 15821:20201109:180001.212 End of zbx_mem_create() 15821:20201109:180001.212 End of init_trend_cache() 15821:20201109:180001.212 End of init_database_cache() 15821:20201109:180001.212 In init_configuration_cache() size:8388608 15821:20201109:180001.212 In zbx_mem_create() param:'CacheSize' size:8388608 15821:20201109:180001.213 valid user addresses: [0xf271a0e0, 0xf2f19ff0] total size: 8388368 15821:20201109:180001.213 End of zbx_mem_create() 15821:20201109:180001.213 End of init_configuration_cache() 15821:20201109:180001.213 In init_selfmon_collector() 15821:20201109:180001.213 init_selfmon_collector() size:8432 15821:20201109:180001.214 End of init_selfmon_collector() collector:0xf7b25000 15821:20201109:180001.214 In zbx_vc_init() 15821:20201109:180001.214 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize' 15821:20201109:180001.214 End of zbx_mem_required_size() size:279 15821:20201109:180001.214 In zbx_mem_create() param:'ValueCacheSize' size:8388608 15821:20201109:180001.215 valid user addresses: [0xf1f1a0e0, 0xf2719ff0] total size: 8388368 15821:20201109:180001.215 End of zbx_mem_create() 15821:20201109:180001.215 End of zbx_vc_init() 15821:20201109:180001.216 In zbx_db_get_database_type() 15821:20201109:180001.216 In DBconnect() flag:0 15821:20201109:180001.225 End of DBconnect():0 15821:20201109:180001.226 query [txnlev:0] [select userid from users limit 1] 15821:20201109:180001.226 there is at least 1 record in "users" table 15821:20201109:180001.226 End of zbx_db_get_database_type():ZBX_DB_SERVER 15821:20201109:180001.227 In DBcheck_version() 15821:20201109:180001.227 In DBconnect() flag:0 15821:20201109:180001.231 End of DBconnect():0 15821:20201109:180001.232 query [txnlev:0] [show tables like 'dbversion'] 15821:20201109:180001.235 query [txnlev:0] [select mandatory,optional from dbversion] 15821:20201109:180001.236 current database version (mandatory/optional): 05010043/05010043 15821:20201109:180001.236 required mandatory version: 05020000 15821:20201109:180001.236 starting automatic database upgrade 15821:20201109:180001.237 query [txnlev:1] [begin;] 15821:20201109:180001.237 query [txnlev:1] [select screenid,name,templateid from screens where templateid is not null] 15821:20201109:180001.238 query [txnlev:1] [select screenitemid,screenid,resourcetype,resourceid,width,height,x,y,colspan,rowspan,elements,style,url,max_columns from screens_items where screenid=3] 15821:20201109:180001.239 screenitemid:3057 screenid:3 15821:20201109:180001.239 resourcetype: graph resourceid:903 15821:20201109:180001.239 w/h: 750x100 (x,y): (0,0) (c,rspan): (1,1) 15821:20201109:180001.240 screenitemid:3058 screenid:3 15821:20201109:180001.240 resourcetype: graph resourceid:909 15821:20201109:180001.240 w/h: 750x100 (x,y): (1,0) (c,rspan): (1,1) 15821:20201109:180001.240 screenitemid:3059 screenid:3 15821:20201109:180001.240 resourcetype: graph resourceid:918 15821:20201109:180001.240 w/h: 750x100 (x,y): (0,1) (c,rspan): (1,1) 15821:20201109:180001.240 screenitemid:3060 screenid:3 15821:20201109:180001.240 resourcetype: graph resourceid:921 15821:20201109:180001.240 w/h: 750x100 (x,y): (1,1) (c,rspan): (1,1) 15821:20201109:180001.240 screenitemid:3061 screenid:3 15821:20201109:180001.240 resourcetype: lldgraph resourceid:888 15821:20201109:180001.241 w/h: 750x100 (x,y): (0,2) (c,rspan): (2,1) 15821:20201109:180001.241 screenitemid:3062 screenid:3 15821:20201109:180001.241 resourcetype: lldgraph resourceid:891 15821:20201109:180001.241 w/h: 750x100 (x,y): (0,3) (c,rspan): (2,1) 15821:20201109:180001.241 screenitemid:3063 screenid:3 15821:20201109:180001.241 resourcetype: lldgraph resourceid:894 15821:20201109:180001.241 w/h: 750x100 (x,y): (0,4) (c,rspan): (2,1) 15821:20201109:180001.242 screenitemid:3064 screenid:3 15821:20201109:180001.242 resourcetype: lldgraph resourceid:897 15821:20201109:180001.242 w/h: 750x100 (x,y): (0,5) (c,rspan): (2,1) 15821:20201109:180001.242 screenitemid:3065 screenid:3 15821:20201109:180001.242 resourcetype: lldgraph resourceid:900 15821:20201109:180001.242 w/h: 750x100 (x,y): (0,6) (c,rspan): (2,1) 15821:20201109:180001.242 total 9 screen items 15821:20201109:180001.242 In DBpatch_get_dashboard_dimensions() 15821:20201109:180001.242 In DBpatch_get_axis_dimensions() 15821:20201109:180001.243 End of DBpatch_get_axis_dimensions(): dim:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 ] 15821:20201109:180001.243 In DBpatch_get_axis_dimensions() 15821:20201109:180001.244 End of DBpatch_get_axis_dimensions(): dim:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 ] 15821:20201109:180001.244 DBpatch_get_dashboard_dimensions: dim_x_pref:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28] 15821:20201109:180001.245 dim_x_min:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:1 30:1 31:1 32:1 33:1 34:1 ] 15821:20201109:180001.245 In DBpatch_adjust_axis_dimensions(): d:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:] 15821:20201109:180001.245 d_min:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:1 30:1 31:1 32:1 33:1 34:1 35:1] 15821:20201109:180001.245 dim_sum:100 pot_idx/val:0/1.00 15821:20201109:180001.246 End of DBpatch_adjust_axis_dimensions(): d:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1] 15821:20201109:180001.246 In DBpatch_get_axis_dimensions() 15821:20201109:180001.246 End of DBpatch_get_axis_dimensions(): dim:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 ] 15821:20201109:180001.247 In DBpatch_get_axis_dimensions() 15821:20201109:180001.247 End of DBpatch_get_axis_dimensions(): dim:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 ] 15821:20201109:180001.248 In DBpatch_adjust_axis_dimensions(): d:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:] 15821:20201109:180001.248 d_min:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:1 30:1 31:1 32:1 33:1 34:1 35:1] 15821:20201109:180001.248 dim_sum:100 pot_idx/val:0/1.00 15821:20201109:180001.248 End of DBpatch_adjust_axis_dimensions(): d:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1] 15821:20201109:180001.249 End of DBpatch_get_dashboard_dimensions(): x:[ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28] 15821:20201109:180001.249 dim_x: [ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:1 30:1 31:1 32:1 33:1 34:1 35:1 ] 15821:20201109:180001.249 dim_y: [ 0:1 1:1 2:1 3:1 4:1 5:1 6:1 7:1 8:1 9:1 10:1 11:1 12:1 13:1 14:1 15:1 16:1 17:1 18:1 19:1 20:1 21:1 22:1 23:1 24:1 25:1 26:1 27:1 28:1 29:1 30:1 31:1 32:1 33:1 34:1 35:1 ] 15821:20201109:180001.250 offsets_x: [ 0:0 1:1 2:2 3:3 4:4 5:5 6:6 7:7 8:8 9:9 10:10 11:11 12:12 13:13 14:14 15:15 16:16 17:17 18:18 19:19 20:20 21:21 22:22 23:23 24:24 25:25 26:26 27:27 28:28 29:29 30:30 ] 15821:20201109:180001.250 offsets_y: [ 0:0 1:1 2:2 3:3 4:4 5:5 6:6 7:7 8:8 9:9 10:10 11:11 12:12 13:13 14:14 15:15 16:16 17:17 18:18 19:19 20:20 21:21 22:22 23:23 24:24 25:25 26:26 27:27 28:28 29:29 30:30 ] 15821:20201109:180001.250 In DBget_nextid() tablename:'dashboard' 15821:20201109:180001.250 query [txnlev:1] [select nextid from ids where table_name='dashboard' and field_name='dashboardid'] 15821:20201109:180001.252 query [txnlev:1] [update ids set nextid=nextid+1 where table_name='dashboard' and field_name='dashboardid'] 15821:20201109:180001.254 query [txnlev:1] [select nextid from ids where table_name='dashboard' and field_name='dashboardid'] 15821:20201109:180001.255 End of DBget_nextid():4 table:'dashboard' recid:'dashboardid' corrupted size vs. prev_size
- duplicates
-
ZBX-18599 Double free or corruption (!prev) on 05010044 patch
- Closed