[MDEV-21557] galera_bf_abort_at_after_statement MTR failed: query 'reap' succeeded - should have failed with errno 1213 Created: 2020-01-23  Updated: 2022-05-16  Resolved: 2022-05-03

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.4.12, 10.5.2
Fix Version/s: 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3

Type: Bug Priority: Major
Reporter: Stepan Patryshev (Inactive) Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

kvm-rpm-centos74-amd64-debug



 Description   

galera_bf_abort_at_after_statement failed on bb: "query 'reap' succeeded - should have failed with errno 1213".

stdio.log:

10.4.12 8a931e4d16303b76e4744428faaab7b200f408ec

galera.galera_bf_abort_at_after_statement 'innodb' w2 [ fail ]
        Test ended at 2020-01-22 18:17:49
 
CURRENT_TEST: galera.galera_bf_abort_at_after_statement
mysqltest: At line 32: query 'reap' succeeded - should have failed with errno 1213...
 
The result from queries just before the failure was:
< snip >
INSERT INTO t1 VALUES (1, 1);
connection node_2;
START TRANSACTION;
SET DEBUG_SYNC = 'wsrep_after_statement_enter SIGNAL blocked WAIT_FOR continue';
UPDATE t1 SET val=2 WHERE id=1;
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
SET DEBUG_SYNC = 'now WAIT_FOR blocked';
connection node_1;
UPDATE t1 SET val=3 WHERE id=1;
connection node_2a;
SET DEBUG_SYNC = 'now SIGNAL continue';
connection node_2;
 
More results from queries before failure can be found in /dev/shm/var/2/log/galera_bf_abort_at_after_statement.log
 
 - saving '/dev/shm/var/2/log/galera.galera_bf_abort_at_after_statement-innodb/' to '/dev/shm/var/log/galera.galera_bf_abort_at_after_statement-innodb/'
 
Retrying test galera.galera_bf_abort_at_after_statement, attempt(2/3)...
 
worker[2] > Restart  - not started
worker[2] > Restart  - not started
galera.galera_var_auto_inc_control_off 'innodb' w1 [ pass ]   4041
galera.galera_var_certify_nonPK_off 'innodb' w1 [ pass ]   2037
galera.galera_bf_abort_at_after_statement 'innodb' w2 [ retry-pass ]   2096
 
Retrying test galera.galera_bf_abort_at_after_statement, attempt(3/3)...
 
galera.galera_bf_abort_at_after_statement 'innodb' w2 [ retry-pass ]   2039



 Comments   
Comment by Stepan Patryshev (Inactive) [ 2020-03-23 ]

It failed also on bb, 10.5.

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