-
Type:
Incident report
-
Resolution: Duplicate
-
Priority:
Trivial
-
None
-
Affects Version/s: 5.2.0
-
Component/s: Server (S)
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
-