Details
-
Bug
-
Status: Done
-
Medium
-
Resolution: Fixed
-
8.0.21-12
-
None
Description
After loading data into sysbench tables and then killing mysqld process, I am not able to start.
MyRocks gives me the following error:
2021-01-14T17:02:05.036938Z 0 [Warning] [MY-000000] [Server] Plugin rocksdb reported: 'AUTOINC mismatch - Index number (0, 280) found in AUTOINC but does not exist as a DDL entry' 2021-01-14T17:02:05.037096Z 0 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'RocksDB: Problems validating auto increment values in data dictionary, exiting' 2021-01-14T17:02:05.037215Z 0 [ERROR] [MY-000000] [Server] Plugin rocksdb reported: 'Failed to initialize DDL manager.' 2021-01-14T17:02:05.037362Z 0 [ERROR] [MY-010202] [Server] Plugin 'ROCKSDB' init function returned error. 2021-01-14T17:02:05.037486Z 0 [ERROR] [MY-010734] [Server] Plugin 'ROCKSDB' registration as a STORAGE ENGINE failed.
There is multiple problems with this.
- why did this happen?
- What table is affected?
- How do I recovery from this? From what I see the only way forward is to remove datadir and start from scratch
