Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
10.3.10
-
None
Description
A DROP TABLE that fails on a node due to missing table is replicated to other nodes.
In this example I remove the table locally on node 10310, and then again with replication on.
It fails on 10310 since the table is missing, but it's replicated to other nodes.
A similar bug was fixed long ago but that was failing due to missing permissions:
https://jira.mariadb.org/browse/MDEV-8598
Not sure how important is this specific bug since the case shows an inconsistent state of the nodes but on the other hand, that a failing command is replicated is weird too and it could be the tip of an iceberg.
# mh cli 10310
|
|
|
MariaDB [(none)]> create database db99;
|
Query OK, 1 row affected (0.019 sec)
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> create table t1 (id int);
|
Query OK, 0 rows affected (0.037 sec)
|
|
|
MariaDB [db99]> show tables;
|
+----------------+
|
| Tables_in_db99 |
|
+----------------+
|
| t1 |
|
+----------------+
|
1 row in set (0.001 sec)
|
|
|
# mh cli 20310
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
+----------------+
|
| Tables_in_db99 |
|
+----------------+
|
| t1 |
|
+----------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [db99]> Bye
|
|
|
# mh cli 30310
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
+----------------+
|
| Tables_in_db99 |
|
+----------------+
|
| t1 |
|
+----------------+
|
1 row in set (0.000 sec)
|
|
|
MariaDB [db99]> Bye
|
|
|
# mh cli 10310
|
|
|
MariaDB [(none)]> use db99;
|
|
|
MariaDB [db99]> set wsrep_on=off;
|
|
|
MariaDB [db99]> drop table t1;
|
Query OK, 0 rows affected (0.015 sec)
|
|
|
MariaDB [db99]> show tables;
|
Empty set (0.001 sec)
|
|
|
MariaDB [db99]> Bye
|
|
|
# mh cli 20310
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
+----------------+
|
| Tables_in_db99 |
|
+----------------+
|
| t1 |
|
+----------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [db99]> Bye
|
|
|
# mh cli 30310
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
+----------------+
|
| Tables_in_db99 |
|
+----------------+
|
| t1 |
|
+----------------+
|
1 row in set (0.001 sec)
|
|
|
MariaDB [db99]> Bye
|
|
|
# mh cli 10310
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
Empty set (0.000 sec)
|
|
|
MariaDB [db99]> drop table t1;
|
ERROR 1051 (42S02): Unknown table 'db99.t1'
|
|
|
MariaDB [db99]> Bye
|
|
|
# mh cli 20310
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
Empty set (0.000 sec)
|
|
|
MariaDB [db99]> Bye
|
# mh cli 30310
|
|
|
MariaDB [(none)]> use db99;
|
Database changed
|
|
|
MariaDB [db99]> show tables;
|
Empty set (0.001 sec)
|
|
|
MariaDB [db99]>
|
|