I am running 1.6.2 and I just ran the command ./zabbix_server_mysql -n 1 -c /etc/zabbix/zabbix_server.conf to convert my tables. After this ran for 14 hours I got the following error message.
Converting tables ................./zabbix_server_mysql [3728]: Error: [Z3005] Query failed: [1206] The total number of locks exceeds the lock table size [update history set itemid=itemid+100000000000000 where itemid>0
]
......./zabbix_server_mysql [3728]: Error: [Z3005] Query failed: [1206] The total number of locks exceeds the lock table size [update history_log set id=id+100000000000000 where id>0
]
.................................................. . done.
Conversion completed.
What do I need to do to fix this?
Converting tables ................./zabbix_server_mysql [3728]: Error: [Z3005] Query failed: [1206] The total number of locks exceeds the lock table size [update history set itemid=itemid+100000000000000 where itemid>0
]
......./zabbix_server_mysql [3728]: Error: [Z3005] Query failed: [1206] The total number of locks exceeds the lock table size [update history_log set id=id+100000000000000 where id>0
]
.................................................. . done.
Conversion completed.
What do I need to do to fix this?