[MDEV-24062] Galera test failure on galera_var_replicate_myisam_on Created: 2020-10-30  Updated: 2023-09-04  Resolved: 2023-09-04

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests, wsrep
Affects Version/s: 10.4, 10.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Jan Lindström (Inactive) Assignee: Jan Lindström
Resolution: Cannot Reproduce Votes: 0
Labels: None


 Description    

2020-10-30  8:39:30 53 [ERROR] Slave SQL: Error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Internal MariaDB error code: 1062
 
2020-10-30  8:39:30 53 [Warning] WSREP: Ignoring error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Error_code: 1062
 
mysqld: /home/jan/mysql/10.4-bugs/wsrep-lib/src/client_state.cpp:227: int wsrep::client_state::after_statement(): Assertion `mode() == m_local' failed.



 Comments   
Comment by Julien Fritsch [ 2020-12-03 ]

Found in disabled.def that it was disabled, also I'm adding the missing label.

Comment by Julien Fritsch [ 2020-12-03 ]

Found in disabled.def for ES that it was disabled, also I'm adding the missing label.

Comment by Ramesh Sivaraman [ 2021-03-18 ]

Reduced testcase

CREATE TABLE t1 (a INT, b INT, UNIQUE(a)) ENGINE=MyISAM;
 
CREATE TRIGGER tr1 BEFORE INSERT ON t1 FOR EACH ROW SET NEW.a=1;
 
SET GLOBAL wsrep_replicate_myisam=ON;
 
INSERT INTO t1  (a,b) VALUES (10,20);

Comment by Marko Mäkelä [ 2021-10-13 ]

On merge to 10.5, the test galera.galera_var_replicate_myisam_on would trigger an assertion failure:

10.5 99bb3fb656f4a2a06c808b7c5d50e18e4c44b73b

 
CURRENT_TEST: galera.galera_var_replicate_myisam_on
 
mysqltest: At line 214: query 'SELECT * FROM t1 ORDER BY id' failed: 2013: Lost connection to MySQL server during query
 
…
 
2021-10-13 12:42:16 31 [Warning] WSREP: Ignoring error 'Duplicate entry '1' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'INSERT INTO t1 VALUES (1)', Error_code: 1062
 
2021-10-13 12:42:16 2 [ERROR] Slave SQL: Error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Internal MariaDB error code: 1062
 
2021-10-13 12:42:16 2 [Warning] WSREP: Ignoring error 'Duplicate entry '11' for key 'PRIMARY'' on query. Default database: 'test'. Query: 'insert into t1 values (11,11)', Error_code: 1062
 
mariadbd: /mariadb/10.5m/wsrep-lib/src/client_state.cpp:253: int wsrep::client_state::after_statement(): Assertion `mode() == m_local' failed.

Also, in 10.6, the change to the test conflicts with an earlier change, which apparently replaced wsrep_replicate_myisam=TRUE with wsrep_mode=REPLICATE_MYISAM. (How can you tell Galera to replicate both MyISAM and Aria?)

Comment by Jan Lindström [ 2023-09-04 ]

Test case not anymore disabled and I could not reproduce with given test case. wsrep_mode=REPLICATE_ARIA could be used for Aria tables in 10.6+.

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