[MDEV-14148] galera.MW-259 fails with "Operation 'desync' failed for SET GLOBAL wsrep_desync=1" Created: 2017-10-26  Updated: 2017-10-30  Resolved: 2017-10-30

Status: Closed
Project: MariaDB Server
Component/s: Galera, Tests
Affects Version/s: 10.2
Fix Version/s: 10.2.10

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Seppo Jaakola
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

libgalera 25.3.14



 Description   

10.2 e99c7c8334f842a debug build

galera.MW-259 'innodb'                   w2 [ fail ]
        Test ended at 2017-10-26 03:59:17
 
CURRENT_TEST: galera.MW-259
mysqltest: At line 38: query 'reap' failed: 1396: Operation 'desync' failed for SET GLOBAL wsrep_desync=1
 
The result from queries just before the failure was:
< snip >
Timeout in wait_condition.inc for SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE INFO = 'SET GLOBAL wsrep_desync=1'
Id      User    Host    db      Command Time    State   Info    Progress
1       system user             NULL    Sleep   39      wsrep aborter idle      NULL    0.000
2       system user             NULL    Sleep   39      NULL    NULL    0.000
5       system user             NULL    Daemon  NULL    InnoDB purge coordinator        NULL    0.000
6       system user             NULL    Daemon  NULL    InnoDB purge worker     NULL    0.000
4       system user             NULL    Daemon  NULL    InnoDB purge worker     NULL    0.000
3       system user             NULL    Daemon  NULL    InnoDB purge worker     NULL    0.000
7       system user             NULL    Daemon  NULL    InnoDB shutdown handler NULL    0.000
11      root    localhost       test    Sleep   34              NULL    0.000
12      root    localhost:59480 test    Query   32      debug sync point: alter_table_before_open_tables        ALTER TABLE t1 ADD COLUMN f2 INTEGER    0.000
13      root    localhost:59482 test    Sleep   32              NULL    0.000
14      root    localhost:59484 test    Query   0       init    show full processlist   0.000
SET DEBUG_SYNC= 'now SIGNAL continue';
DROP TABLE t1;
SET GLOBAL wsrep_desync=0;
Warnings:
Warning 1231    'wsrep_desync' is already OFF.
connection node_1;
connection node_1a;



 Comments   
Comment by Seppo Jaakola [ 2017-10-30 ]

Cannot reproduce with Galera library 25.3.20 and later

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