Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6
-
None
Description
Streaming replication combined with innodb_snapshot_isolation
CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
|
SET SESSION wsrep_trx_fragment_size=1;
|
SET SESSION innodb_snapshot_isolation=ON;
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
INSERT INTO t1 VALUES (1);
|
COMMIT;
|
leads to the following error (and assertion in debug builds):
2024-10-29 9:45:05 12 [ERROR] WSREP: init_for_index_scan failed to read first record, error 123
|
mariadbd: /home/sciascid/Workspace/src/mariadb-server/wsrep-lib/src/transaction.cpp:382: int wsrep::transaction::before_prepare(wsrep::unique_lock<wsrep::mutex>&): Assertion `state() == s_pr
|
eparing || (is_xa() && state() == s_replaying) || (ret && (state() == s_must_abort || state() == s_must_replay || state() == s_cert_failed || state() == s_aborted))' failed.
|
241029 9:45:05 [ERROR] mysqld got signal 6 ;
|
Attachments
Issue Links
- split from
-
MDEV-35140 Support innodb-snapshot-isolation in Galera cluster
- In Progress