ERROR 1467 (HY000) at line 1: Failed to read auto-increment value from storage engine

[노한성]

I faced MySQL problem.

My sample has very big genome size. This is plant.
This error occurs when manage huge data.

I found the reason.

The type of 'id' column of 'snps' table is int(10).
And I sent a command to modify the type to int(12) now.

I have no idea about other columns also have to be changed. Such as 'tag_id'.

[노한성]

This command will solve the problem.

alter table snps modify id bigint unsigned;


2014년 11월 1일 토요일 오후 5시 24분 10초 UTC+9, 노한성 님의 말: