Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.2(EOL), 10.3(EOL)
Description
10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33 |
galera.galera_ftwrl_drain 'innodb' [ fail ] |
Test ended at 2021-07-08 01:30:37 |
|
CURRENT_TEST: galera.galera_ftwrl_drain
|
mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205... |
|
The result from queries just before the failure was:
|
< snip >
|
INSERT INTO t1 VALUES (1);
|
connection node_2;
|
SET SESSION wsrep_sync_wait = 0;
|
SET SESSION wsrep_on = 0;
|
SET SESSION wsrep_on = 1;
|
SELECT COUNT(*) = 0 FROM t1;
|
COUNT(*) = 0
|
1
|
connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2;
|
connection node_2a;
|
FLUSH TABLES WITH READ LOCK;;
|
connection node_2;
|
SET GLOBAL wsrep_provider_options = 'dbug='; |
SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync'; |
connection node_2a; |
connection node_2; |
SET SESSION lock_wait_timeout = 1; |
SET SESSION innodb_lock_wait_timeout=1; |
SET SESSION wait_timeout=1; |
INSERT INTO t2 VALUES (2); |
Reproducible on 10.2/10.3 ES.
I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
{code:sql|title=10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33}
galera.galera_ftwrl_drain 'innodb' [ fail ] Test ended at 2021-07-08 01:30:37 CURRENT_TEST: galera.galera_ftwrl_drain mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205... The result from queries just before the failure was: < snip > INSERT INTO t1 VALUES (1); connection node_2; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_on = 0; SET SESSION wsrep_on = 1; SELECT COUNT(*) = 0 FROM t1; COUNT(*) = 0 1 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2; connection node_2a; FLUSH TABLES WITH READ LOCK;; connection node_2; SET GLOBAL wsrep_provider_options = 'dbug='; SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync'; connection node_2a; connection node_2; SET SESSION lock_wait_timeout = 1; SET SESSION innodb_lock_wait_timeout=1; SET SESSION wait_timeout=1; INSERT INTO t2 VALUES (2); {noformat} Reproducible on 10.2/10.3 ES. I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check. |
{code:sql|title=10.2-enterprise 0f6624fe (latest of Jul 08, 2021) + galera-enterprise-3-25.3.33}
galera.galera_ftwrl_drain 'innodb' [ fail ] Test ended at 2021-07-08 01:30:37 CURRENT_TEST: galera.galera_ftwrl_drain mysqltest: At line 58: query 'INSERT INTO t2 VALUES (2)' failed with wrong errno 1146: 'Table 'test.t2' doesn't exist', instead of 1205... The result from queries just before the failure was: < snip > INSERT INTO t1 VALUES (1); connection node_2; SET SESSION wsrep_sync_wait = 0; SET SESSION wsrep_on = 0; SET SESSION wsrep_on = 1; SELECT COUNT(*) = 0 FROM t1; COUNT(*) = 0 1 connect node_2a, 127.0.0.1, root, , test, $NODE_MYPORT_2; connection node_2a; FLUSH TABLES WITH READ LOCK;; connection node_2; SET GLOBAL wsrep_provider_options = 'dbug='; SET GLOBAL wsrep_provider_options = 'signal=apply_monitor_slave_enter_sync'; connection node_2a; connection node_2; SET SESSION lock_wait_timeout = 1; SET SESSION innodb_lock_wait_timeout=1; SET SESSION wait_timeout=1; INSERT INTO t2 VALUES (2); {code} Reproducible on 10.2/10.3 ES. I couldn't reproduce it on 10.2 CS and on 10.4 ES, but please double-check. |
Labels | affects-tests |
Priority | Major [ 3 ] | Critical [ 2 ] |
Assignee | Julius Goryavsky [ sysprg ] | Jan Lindström [ jplindst ] |
Component/s | Debug [ 14208 ] | |
Component/s | Galera [ 10124 ] | |
Component/s | Tests [ 10800 ] | |
Component/s | Debug [ 14936 ] | |
Component/s | Galera [ 14918 ] | |
Component/s | Tests [ 14999 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Fix Version/s | 10.3 [ 23605 ] | |
Fix Version/s | 10.2 [ 23606 ] | |
Key |
|
|
Affects Version/s | 10.2 [ 14601 ] | |
Affects Version/s | 10.3 [ 22126 ] | |
Affects Version/s | 10.3 [ 23605 ] | |
Affects Version/s | 10.2 [ 23606 ] | |
Project | MariaDB Enterprise [ 11500 ] | MariaDB Server [ 10000 ] |
issue.field.resolutiondate | 2021-10-13 14:09:00.0 | 2021-10-13 14:09:00.99 |
Fix Version/s | 10.2.41 [ 26032 ] | |
Fix Version/s | 10.3.32 [ 26029 ] | |
Fix Version/s | 10.4.22 [ 26031 ] | |
Fix Version/s | 10.5.13 [ 26026 ] | |
Fix Version/s | 10.6.5 [ 26034 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Fix Version/s | 10.3 [ 22126 ] | |
Resolution | Fixed [ 1 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 123330 ] | MariaDB v4 [ 159493 ] |
Link | This issue relates to MENT-1592 [ MENT-1592 ] |
It fails constantly in Jenkins.