[MDEV-23119] ERROR 1932 Table doesn't exist in engine Created: 2020-07-08  Updated: 2020-09-06  Resolved: 2020-09-06

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.4.8
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: shindong Assignee: Unassigned
Resolution: Incomplete Votes: 0
Labels: need_feedback
Environment:

Linux 7.x


Issue Links:
Relates
relates to MDEV-17187 table doesn't exist in engine after A... Closed
relates to MDEV-21088 Table cannot be loaded after instant ... Closed

 Description   

error log

2020-07-07  9:36:25 1931387 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata
2020-07-07  9:36:32 1932374 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata
2020-07-07  9:38:54 1933520 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata
2020-07-07  9:38:54 1933520 [ERROR] Slave SQL: Error executing row event: 'Table 'fms.business' doesn't exist in engine', Gtid 0-1000-1177584, Internal MariaDB error code: 1932
2020-07-07  9:38:54 1933520 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'maria-bin.000013' position 439591739; GTID position '0-1000-1177583'
2020-07-07  9:41:33 1934785 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata
2020-07-07  9:46:33 1937184 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata
2020-07-07  9:51:33 1939583 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata
2020-07-07  9:56:33 1941982 [ERROR] InnoDB: Table `fms`.`business` contains unrecognizable instant ALTER metadata

MariaDB [fms]> show tables;
+-------------------+
| Tables_in_fms     |
+-------------------+
| business          |
+-------------------+
 
MariaDB [fms]> select * from business;
ERROR 1932 (42S02): Table 'fms.business' doesn't exist in engine

Currently, MariaDB 10.4.8 version is in use, and there is a problem that the table cannot be viewed.
I am afraid that this will happen again.

1. In what cases does the phenomenon occur?
2. Is this a bug?
3. How can I prevent it? Is it possible to fix it with a version upgrade?



 Comments   
Comment by Daniel Black [ 2020-07-08 ]

what is the master server version?
Using mysqlbinlog, what is the binary log at the point replication failed?
what is the table structure of show create table fms.business on the master?

Comment by shindong [ 2020-07-08 ]

The master server version is also 10.4.8.
Replication is not important. I wonder why the table is broken.

Comment by Alice Sherepa [ 2020-07-08 ]

Is it possible for you to try with a more recent version of the server? There were a few bugs with similar symptoms, that were fixed. (e.g. MDEV-21088).

Generated at Thu Feb 08 09:19:59 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.