Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-18632

Failed to upgrade database to 05020000

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 5.2.0
    • 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

            zabbix.dev Zabbix Development Team
            creizlein Christian Reizlein
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: