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.
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
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.
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.