Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.2
-
None
-
libgalera 25.3.14
Description
10.2 e99c7c8334f842a debug build |
galera.GAL-480 'innodb' w2 [ fail ]
|
Test ended at 2017-10-26 03:58:20
|
|
CURRENT_TEST: galera.GAL-480
|
mysqltest: At line 13: query 'ALTER TABLE t1 DROP COLUMN f1' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
|
|
The result from queries just before the failure was:
|
connection node_1;
|
CREATE TABLE t1 (f1 CHAR(10), f0 integer) ENGINE=InnoDB;
|
FLUSH TABLE t1 FOR EXPORT;
|
UNLOCK TABLES;
|
ALTER TABLE t1 DROP COLUMN f1;
|
SET SESSION wsrep_osu_method='RSU';
|
ALTER TABLE t1 ADD COLUMN f1 CHAR(10);
|
ALTER TABLE t1 DROP COLUMN f1;
|
|
- saving '/home/elenst/git/10.2/mysql-test/var/2/log/galera.GAL-480-innodb/' to '/home/elenst/git/10.2/mysql-test/var/log/galera.GAL-480-innodb/'
|
worker[2] > Restart - not started
|
worker[2] > Restart - not started
|
***Warnings generated in error logs during shutdown after running tests: galera.GAL-480
|
|
2017-10-26 3:58:20 140310951712512 [ERROR] WSREP: Node desync failed.: 11 (Resource temporarily unavailable)
|
2017-10-26 3:58:20 140310951712512 [Warning] WSREP: RSU desync failed 3 for schema: test, query: ALTER TABLE t1 DROP COLUMN f1
|
2017-10-26 3:58:20 140310951712512 [Warning] WSREP: ALTER TABLE isolation failure
|
Monty also reported seeing a crash:
- galera.GAL-480
|
Fails with a core dump:
|
#5 0x00007fc37dfe4458 in abort () from /lib64/libc.so.6
|
#6 0x00007fc37940911e in galera::FSM<galera::Replicator::State,
|
galera::ReplicatorSMM::Transition, galera::EmptyGuard,
|
galera::EmptyAction>::shift_to (this=this@entry=0x41b9fb0,
|
state=state@entry=galera::Replicator::S_DONOR) at
|
galera/src/fsm.hpp:81
|
#7 0x00007fc3793fdeb2 in galera::ReplicatorSMM::desync
|
(this=0x41b9f60) at galera/src/replicator_smm.cpp:1659
|
#8 0x00007fc37940e778 in galera_desync (gh=<optimized out>) at
|
galera/src/wsrep_provider.cpp:1004
|
#9 0x00000000008cdb12 in wsrep_RSU_begin (thd=0x7fc30c000a98,
|
db_=0x0, table_=0x0) at /my/maria-10.2/sql/wsrep_mysqld.cc:1591
|
#10 0x00000000008ce60f in wsrep_to_isolation_begin
|
(thd=0x7fc30c000a98, db_=0x0, table_=0x0, table_list=0x7fc30c011380)
|
at /my/maria-10.2/sql/wsrep_mysqld.cc:1728
|
#11 0x000000000084508d in Sql_cmd_alter_table::execute
|
(this=0x7fc30c011f40, thd=0x7fc30c000a98) at /my/maria-10.2/sql/sql_al
|