Mysql Error 1467
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack
Failed To Read Auto-increment Value From Storage Engine Innodb
Overflow the company Business Learn more about hiring developers or posting ads with us failed to read auto-increment value from storage engine codeigniter Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community error 1030 (hy000): got error -1 from storage engine of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up mysql Failed to read auto-increment value from storage engine up vote 9 down vote favorite 2
Mysql Reset Auto Increment
i am having mysql table with one id field as auto-increment . When i insert values to the table am getting error as 1467 - Failed to read auto-increment value from storage engine Also the show table status shows me that the field with auto increment has 18446744073709551615 as Auto_increment value. What would be the issue can any one help me ....? mysql database table auto-increment share|improve this question asked Sep 8
Mysql Bigint
'11 at 10:56 ashu 44441535 Post your table definition and let's see which data type is taht field assigned –Marco Sep 8 '11 at 11:00 add a comment| 8 Answers 8 active oldest votes up vote 9 down vote accepted Problem could absolutely be that: convert 18446744073709551615 to hex and you'll find $FFFF-FFFF-FFFF-FFFF. If your field is an unsigned 64bit you reach its limit. share|improve this answer answered Sep 8 '11 at 11:01 Marco 36.8k970103 This is the field ID int(11) NOT NULL AUTO_INCREMENT and am having only 200 rows in that table that is field ID has the maximum value of 200 –ashu Sep 8 '11 at 11:05 @ash: export your db (or simply the table), DROP existing table and create a new one; then import data back being careful not to touch auto-increment value... –Marco Sep 8 '11 at 11:08 @ash: did you solve your problem? –Marco Sep 8 '11 at 11:19 Actually now am having problem in dropping the table as the field ID used as foreign key i cant drop table. –ashu Sep 8 '11 at 11:40 @ash: if you want, export your db and sent it to me by email... I'll take a look... &nd
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings mysql auto increment and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it http://stackoverflow.com/questions/7346934/mysql-failed-to-read-auto-increment-value-from-storage-engine only takes a minute: Sign up Error: Failed to read auto-increment value from storage engine up vote 1 down vote favorite This question might be a duplicate to these questions: Failed to read auto-increment value from the storage engine in MySQL mysql Failed to read auto-increment value from storage engine Failed to read auto-increment value from storage engine, Error Number: http://stackoverflow.com/questions/21257379/error-failed-to-read-auto-increment-value-from-storage-engine 1467 Failed to read auto-increment value from storage engine. Cause? Anyhow, the solutions did not work for me, so it seems to be the same error but different cause. Situation: In MySQL i have a table with one "id"-column (the primary key) which has the AUTO_INCREMENT property set. Each time i try to insert a new row into that table i get the following error: Failed to read auto-increment value from storage engine. In the questions mentioned above the solution was to reset the auto-increment value with: ALTER TABLE `table_name` AUTO_INCREMENT = 1 In my case this works fine as long as i don't reboot my computer. When i do, i'm getting the error again. Additional Information: Here is my CREATE TABLE: CREATE TABLE `producer` ( `id` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(30) NOT NULL, `setup_cost` double NOT NULL, `delivery_time` int(5) NOT NULL, `stock_delivery_time` int(5) NOT NULL, `country` varchar(20) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 When executing SHOW TABLE STATUS i have recognized something weird: Auto_increment is set to 0 and Create_time is set to "
2010 12:59 Reporter: Shane Bester (Platinum Quality Contributor) Email Updates: Status: Closed Impact on me: None Category:MySQL Server: InnoDB storage engine Severity:S3 (Non-critical) https://bugs.mysql.com/bug.php?id=36411 Version:5.1.24, 5.1.25 OS:Any Assigned to: Sunny Bains Tags: auto_increment, autoinc, error 1467 Triage: Triaged: D4 (Minor) View Add Comment Files Developer Edit Submission View Progress Log Contributions [29 Apr 2008 19:46] Shane Bester Description: This may or may not be a bug, but I'll open the bug report anyway, since 5.1.23 didn't have this problem. 5.1.23 and 5.0.58 behaviour from storage differs to 5.1.24. Using the statements in "How to repeat", we have the output in 5.1.24: mysql> insert into `qa05` set `id` = 2; Query OK, 1 row affected (0.00 sec) mysql> insert into `qa05` set `id` = -1; Query OK, 1 row affected (0.00 sec) mysql> insert into `qa05` set `id` = -1; ERROR 1062 (23000): Duplicate from storage engine entry '-1' for key 'PRIMARY' mysql> insert into `qa05` set `id` = -1; ERROR 1062 (23000): Duplicate entry '-1' for key 'PRIMARY' mysql> insert into `qa05` values (); ERROR 1467 (HY000): Failed to read auto-increment value from storage engine The auto_increment value in show table status says "18446744073709551615". And this output in 5.0.58 and 5.1.23: mysql> insert into `qa05` set `id` = -1; ERROR 1062 (23000): Duplicate entry '-1' for key 1 mysql> insert into `qa05` set `id` = -1; ERROR 1062 (23000): Duplicate entry '-1' for key 1 mysql> insert into `qa05` values (); Query OK, 1 row affected (0.00 sec) For what reason does the 1st and 2nd insert give error 1062, and the third insert return error 1467 on 5.1.24? Then, if you comment out the 1st show table status, the results are different. Why does the show table status have any effect on this - given the fact the auto-inc should be initialized by the first insert. I read: http://dev.mysql.com/doc/refman/5.1/en/innodb-auto-increment-handling.html "The behavior of the auto-increment mechanism is not defined