View source for Mysql2::Error: Duplicate entry '2147483647' for key

= Log =

 Mysql2::Error: Duplicate entry '2147483647' for key

 --- !ruby/exception:Mysql2::Error
 message: Duplicate entry '2147483647' for key 'PRIMARY'
 error_number: 1062
 sql_state: '23000' 

<br>
= Cause =

Usually means id for some table is exhausted (somehow, probably by manually editing and messing with DB).

2147483647 is maximum value for SIGNED INT

<br>
= Fix =

Change field type to UNSIGNED BIGINT, where limit is:  18446744073709551615 (good luck reaching this one).

<br>
= Example =

Let's say we have problem with [dids] table, fix:

 ALTER TABLE `dids` CHANGE `id` `id` BIGINT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT;