mariadb/galera_lock_tables_in_transaction.result at main - mariadb - GitFox

database/mariadb

mirror of https://github.com/MariaDB/server.git synced 2025-08-01 03:47:19 +03:00

Files

mkaruza 2b8b7394a1 MDEV-22222: Assertion `state() == s_executing || state() == s_preparing || state() == s_prepared || state() == s_must_abort || state() == s_aborting || state() == s_cert_failed || state() == s_must_replay' failed in wsrep::transaction::before_rollback

LOCK TABLE will do implicit commit, we need to properly handle transaction after commit.

2020-06-28 23:07:41 +02:00

13 lines

284 B

Plaintext

Raw Permalink Blame History

 connection node_2;
 connection node_1;
 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
 START TRANSACTION;
 INSERT INTO t1 VALUES (1);
 LOCK TABLES t2 READ;
 ERROR 42S02: Table 'test.t2' doesn't exist
 START TRANSACTION;
 INSERT INTO t1 VALUES (1);
 LOCK TABLES t1 READ;
 UNLOCK TABLES;
 DROP TABLE t1;