One after another – This was a strange exception I received today. I am not sure if this is a bug of JPA or underlying MySQL.
[code language=”java”]
SQL Error: 1467, SQLState: HY000
Failed to read auto-increment value from storage engine
Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: could not execute statement; nested exception is org.hibernate.exception.GenericJDBCException: could not execute statement] with root cause
java.sql.SQLException: Failed to read auto-increment value from storage engine
[/code]
I was pretty much surprised, what else!
Server version: 10.1.36-MariaDB
Spring Boot :: (v2.1.7.RELEASE)
I tried this.
ALTER TABLE `feed_item_info` AUTO_INCREMENT =1
It does not help me.
Later –
ALTER TABLE `feed_item_info` ORDER BY `index`
It throws the following warning.
Warning: #1105 ORDER BY ignored as there is a user-defined clustered index in the table ‘feed_item_info’
But it was working.
Ref:https://stackoverflow.com/questions/17690926/failed-to-read-auto-increment-value-from-storage-engine-error-number-1467
