Failed to read auto-increment value from storage engine

sponsored links
The project has encountered a problem, that is, data stored on a table when an error, "Failed to read auto-increment value from storage engine". In the structure of the table after a careful examination of the table auto_increment values are found in a very large value (18446744073709551615, is in the mysql bigint unsign value). So I manually set a value of 1 (ALTER TABLE target_table AUTO_INCREMENT = 1). But still does not work, the value has not changed.

Search for a lot of information online, a more consistent argument is that a mysql bug, need to upgrade the database. I have to trouble, do not upgrade my mysql. So would like to find other ways. I use the mysql console is phpmyadmin, accidentally discovered several operating options, such as optimization of the data table and on the table flush operation. Really played a role.
Concrete action is:
1. Select the destination table, click Operations, find the following Table maintenance list. Here are a few data sheet repair option.
2. Click Optimize Table, will implement the following sql statement: OPTIMIZE TABLE target_table.
3. After the return to Operations. Find Flush the table ("FLUSH"). Will implement the following sql statement:
FLUSH TABLE target_table.
At this point you can not AUTO_INCREMENT set to a large value can be received.

Project to use JPA, the database is automatically created, as to why, after you create the table AUTO_INCREMENT values will be set to a maximum value, which has still not clear. I do not know their own problems or database program, an error occurred.

Just make a record to facilitate future inquiries. If someone have similar problems, hope to exchange the next.

================================================== ==============
After the release of this article, I still did not find out the specific reasons, simply to test the database upgrade, the original version is 5.1.28, after upgrading the database version is 5.1.43. Once again rebuilt the database and found no problems. Really is a bug ah mysql database.
  • StumbleUpon
  • Digg
  • TwitThis
  • Mixx
  • Technorati
  • Facebook
  • NewsVine
  • Reddit
  • Google
  • LinkedIn
  • YahooMyWeb

Related Posts of Failed to read auto-increment value from storage engine

  • Hibernate's FetchSize and MaxReslut

    Previously EJB to do paging, EJBQL only provide FirstResult and MaxReslut, recently discovered by Hibernate its HQL also provides FetchSize, checked under the API found almost mean, and then found the next line so someone said: setFetchSize is an opt ...

  • js examples of common events

    <html> <head> <script type="text/javascript"> / / Which mouse button is clicked function whichButton1 (event) ( if (event.button == 2) ( alert ( "You clicked the right mouse button!") ) else ( alert ( "You c ...

  • SUI-JavaScript rich UI library integration solution

    Introduction: SUI is not a class implementation of the UI, nor is it a standard set of UI markup language, it is just to help the existing UI frameworks (such as Ext, YUI like) to mark the way to the statement and the creation of UI. The names of these ta

  • hibernate Technical Study Notes (first)

    Introduction: Model does not match (impedance mismatch) java object-oriented language, object model, its key concepts are: inheritance, association, polymorphism, etc.; database is the relational model, its key concepts are: tables, primary keys, for ...

  • Unable to load bean: type: struts-derfault.xml abnormal

    Struts2 in the use of a lot of friends from time to time we encountered this anomaly, leading to its main reason is because the wrong package, we have to be xwork-2.1.1.jar and struts2-core-2.1.2.jar, replaced xwork-2.0. 4.jar and struts2-core-2.0.14.jar

  • Hibernate II Study Notes

    11. Many-to-many Of many that can be converted to two one-to-many <set name="students" table="teacher_student"> <key column="techer_id"/> <many-to-many column="student_id"/> </set> many-to-many data only from one end of the mainten

  • Hibernate primary key strategy-sequence

    Today, the use of hibernate in the company encountered a troublesome problem, the use of hibernate when the primary key generation strategy set sequence, but always reported in the implementation could not get next sequence value of the error, then o ...

  • JDBC example of a long time do not have JDBC forgot

    A back-up here to stay. The first: The second:

  • Hibernate pessimistic locking mechanism for locking and optimistic locking

    hibernate lock mechanism 1. Pessimistic lock It refers to the modification of data by outsiders hold a conservative attitude. The assumption that at any time access to data, may also have another client to access the same data, in order to maintain t ...

  • Based on JDBC, JPA Annotation achieve simple CRUD Generic Dao

    The origin of ideas are pretty long history of reasons: [Use iBATIS history] The use of iBATIS has been a long time, the system is to use the CRUD template tool to generate the code, although there are tools to generate, but looked at a lot of CRUD the Sq

blog comments powered by Disqus
Recent Entries
Tag Cloud
Random Entries