query failed: [167] Out of range value for column 'pkid' at row 1

[domadmin]

Running Zabbix 5.0.18 MySQL server. Getting the following errors and unable to see recent history.

 13718:20211130:102124.274 [Z3005] query failed: [167] Out of range value for column 'pkid' at row 1 [insert into history_uint (itemid,clock,ns,value) values (40544,1638285681,671675243,0);]

I assume there is a change needed to the fields in the database. What would be the recommended change?

[domadmin]

I think I had found the problem. We recently changed database engines and this was done in-place without a dump and restore. Dropped the database and rebuilt. Though we can now get data, LDAP authentication no longer works. That will be another post for another time.

[domadmin]

I think I had found the problem. We recently changed database engines and this was done in-place without a dump and restore. Dropped the database and rebuilt. Though we can now get data, LDAP authentication no longer works. That will be another post for another time.