PowerDNS MySQL INT limit reached.
Thursday, March 6th, 2008The very non-descriptive error below indicates that you have reached the maximum value for the MySQL INT Data Type.
Communicator thread died because of error: Failed to execute mysql_query, perhaps connection died? Err=-1: Duplicate entry ‘2147483647′ for key 1
What you need to do if this happens to you on your PowerDNS records table is the following:
mysql> alter table records modify id BIGINT AUTO_INCREMENT;
If it happens to your domains table, then things get a bit more complicated and you should do the following:
mysql> alter table records drop foreign key `records_ibfk_1`;
mysql> alter table records modify domain_id BIGINT ;
mysql> alter table domains modify id BIGINT AUTO_INCREMENT;
mysql> alter table records add constraint `records_ibfk_1` FOREIGN KEY (`domain
_id`) REFERENCES `domains` (`id`) ON DELETE CASCADE;
The above worked for me, your results may vary.
