Getting duplicate primary key for auto increment column
I reached the max possible value of an int column. Problem resolved by altering table and setting big int than int.

The signed range of MIDINT is –8388608 to 8388607. The unsigned range is 0 to 16777215 

Reference: 
http://help.scibit.com/mascon/masconMySQL_Field_Types.html