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

Database upgrade fail

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Duplicate
    • Icon: Trivial Trivial
    • None
    • 5.0.0
    • Server (S)

      Steps to reproduce:

      1. Upgrade 4.4 to 5.0

       

      i have a problem after upgrade to version 5.0LTS

      according log bellow occur an error when try DB update

      [root@zbx-server ~]# tail -30 /var/log/zabbix/zabbix_server.log
      10489:20200515:022432.079 init_selfmon_collector() size:19128
      10489:20200515:022432.079 End of init_selfmon_collector() collector:0x7f0b0943a000
      10489:20200515:022432.079 In zbx_vc_init()
      10489:20200515:022432.079 In zbx_mem_required_size() size:0 chunks_num:1 descr:'value cache size' param:'ValueCacheSize'
      10489:20200515:022432.079 End of zbx_mem_required_size() size:419
      10489:20200515:022432.079 In zbx_mem_create() param:'ValueCacheSize' size:67108864
      10489:20200515:022432.079 valid user addresses: [0x7f0ac1c8c168, 0x7f0ac5c8bff0] total size: 67108488
      10489:20200515:022432.079 End of zbx_mem_create()
      10489:20200515:022432.079 End of zbx_vc_init()
      10489:20200515:022432.079 In zbx_db_get_database_type()
      10489:20200515:022432.079 In DBconnect() flag:0
      10489:20200515:022432.085 End of DBconnect():0
      10489:20200515:022432.085 query [txnlev:0] [select userid from users limit 1]
      10489:20200515:022432.086 there is at least 1 record in "users" table
      10489:20200515:022432.086 End of zbx_db_get_database_type():ZBX_DB_SERVER
      10489:20200515:022432.086 In DBcheck_version()
      10489:20200515:022432.086 In DBconnect() flag:0
      10489:20200515:022432.088 End of DBconnect():0
      10489:20200515:022432.088 query [txnlev:0] [show tables like 'dbversion']
      10489:20200515:022432.089 query [txnlev:0] [select mandatory,optional from dbversion]
      10489:20200515:022432.090 current database version (mandatory/optional): 04050003/04050003
      10489:20200515:022432.090 required mandatory version: 05000000
      10489:20200515:022432.090 starting automatic database upgrade
      10489:20200515:022432.090 query [txnlev:1] [begin;]
      10489:20200515:022432.090 query [txnlev:1] [create index items_1 on items (hostid,key_(1021))]
      10489:20200515:022432.091 [Z3005] query failed: [1071] Specified key was too long; max key length is 767 bytes [create index items_1 on items (hostid,key_(1021))]
      10489:20200515:022432.091 query [create index items_1 on items (hostid,key_(1021))] failed, setting transaction as failed
      10489:20200515:022432.091 query [txnlev:1] [rollback;]
      10489:20200515:022432.091 database upgrade failed
      10489:20200515:022432.092 End of DBcheck_version():FAIL

      Could you help me?

            zabbix.support Zabbix Support Team
            marcioasc Marcio Campos
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: