-
Incident report
-
Resolution: Duplicate
-
Trivial
-
None
-
5.0.0
Steps to reproduce:
- 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?
- duplicates
-
ZBX-17722 Database Upgrade Failed
- Closed