Sample Header Ad - 728x90

How do I correct InnoDB Multiple files found for the same tablespace ID?

1 vote
2 answers
9846 views
Some time ago after an update of Ubuntu 20.10, I discovered that MySQL was not running. When I tried to restart it, the error message suggested that it had started, failed and stopped. A check of the error log contained "InnoDB Multiple files found for the same tablespace ID" and listed 25 such instances, for example Tablespace ID: 92 = ['mercury/pickupcity.ibd', 'mycity/wp_mycity_eventlog.ibd'] How do I correct InnoDB Multiple files found for the same tablespace ID?
Asked by Mark Lee (141 rep)
Jun 14, 2021, 05:55 PM
Last activity: Nov 13, 2024, 12:55 AM