Ad Widget

Collapse

Failed to upgrade database to 05020000

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Smoke
    Junior Member
    • Jul 2014
    • 29

    #1

    Failed to upgrade database to 05020000

    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.
    The error is corrupted size vs. prev_size

    Anyone has any idea how to get around with it?

    Code:
    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,widt h,height,x,y,colspan,rowspan,elements,style,url,ma x_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
  • Smoke
    Junior Member
    • Jul 2014
    • 29

    #2
    Update, this seems to be a problem with ARM architecture, as zabbix_server was running inside a Raspberry
    What i had to do is install zabbix_server on a Linux machine (x64) and start the server from there pointing to my database and let it upgrade, after that it looks to be running fine.

    Comment

    Working...