Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
10.2.12
Description
I'm using three mariadb 10.2.12 in galera cluster mode in the same network. I've got regulary this error in galera's logs:
2018-02-07 17:56:59 139856357209856 [Warning] WSREP: SQL statement was ineffective thd: 6327 buf: 190
schema: mybdd
QUERY: commit
=> Skipping replication
2018-02-07 17:56:59 139856357209856 [Note] WSREP: cluster conflict due to certification failure for threads:
2018-02-07 17:56:59 139856357209856 [Note] WSREP: Victim thread:
THD: 6327, mode: local, state: executing, conflict: cert failure, seqno: -1
SQL: commit
my config:
wsrep_on=ON
#wsrep_debug=ON
wsrep_log_conflicts = 1
wsrep_provider=/usr/lib/galera/libgalera_smm.so
wsrep_cluster_address="gcomm://172.25.252.1,172.25.252.2,172.25.252.3"
binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2
wsrep_retry_autocommit=4
#wsrep_sst_method=mariabackup
#
- Allow server to accept connections on all interfaces.
bind-address=0.0.0.0
- Optional setting
wsrep_slave_threads=1
innodb_flush_log_at_trx_commit=0
wsrep_node_address="172.25.252.2"
wsrep_node_name="cluster1"
I found a simple example to redo the problem.
create table test2 (c1 INT) engine innodb;
insert into test2 VALUES(1);
in a new SQL session
use mybdd;
SET autocommit=0;
– dostuff...
DROP TEMPORARY TABLE IF EXISTS test;
CREATE TEMPORARY TABLE test SELECT * FROM test2 WHERE c1=1;
– dostuff...
COMMIT;
ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Description |
I'm using three mariadb 10.2.12 in galera cluster mode in the same network. I've got regulary this error in galera's logs:
2018-02-07 17:56:59 139856357209856 [Warning] WSREP: SQL statement was ineffective thd: 6327 buf: 190 schema: mybdd QUERY: commit => Skipping replication 2018-02-07 17:56:59 139856357209856 [Note] WSREP: cluster conflict due to certification failure for threads: 2018-02-07 17:56:59 139856357209856 [Note] WSREP: Victim thread: THD: 6327, mode: local, state: executing, conflict: cert failure, seqno: -1 SQL: commit my config: wsrep_on=ON #wsrep_debug=ON wsrep_log_conflicts = 1 wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://172.25.252.1,172.25.252.2,172.25.252.3" binlog_format=row default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 wsrep_retry_autocommit=4 #wsrep_sst_method=mariabackup # # Allow server to accept connections on all interfaces. bind-address=0.0.0.0 # Optional setting wsrep_slave_threads=1 innodb_flush_log_at_trx_commit=0 wsrep_node_address="172.25.252.2" wsrep_node_name="cluster1" |
I'm using three mariadb 10.2.12 in galera cluster mode in the same network. I've got regulary this error in galera's logs:
2018-02-07 17:56:59 139856357209856 [Warning] WSREP: SQL statement was ineffective thd: 6327 buf: 190 schema: mybdd QUERY: commit => Skipping replication 2018-02-07 17:56:59 139856357209856 [Note] WSREP: cluster conflict due to certification failure for threads: 2018-02-07 17:56:59 139856357209856 [Note] WSREP: Victim thread: THD: 6327, mode: local, state: executing, conflict: cert failure, seqno: -1 SQL: commit my config: wsrep_on=ON #wsrep_debug=ON wsrep_log_conflicts = 1 wsrep_provider=/usr/lib/galera/libgalera_smm.so wsrep_cluster_address="gcomm://172.25.252.1,172.25.252.2,172.25.252.3" binlog_format=row default_storage_engine=InnoDB innodb_autoinc_lock_mode=2 wsrep_retry_autocommit=4 #wsrep_sst_method=mariabackup # # Allow server to accept connections on all interfaces. bind-address=0.0.0.0 # Optional setting wsrep_slave_threads=1 innodb_flush_log_at_trx_commit=0 wsrep_node_address="172.25.252.2" wsrep_node_name="cluster1" I found a simple example to redo the problem. create table test2 (c1 INT) engine innodb; insert into test2 VALUES(1); in a new SQL session use mybdd; SET autocommit=0; -- dostuff... DROP TEMPORARY TABLE IF EXISTS test; CREATE TEMPORARY TABLE test SELECT * FROM test2 WHERE c1=1; -- dostuff... COMMIT; ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction |
Component/s | Galera [ 10124 ] | |
Assignee | Sachin Setiya [ sachin.setiya.007 ] |
Fix Version/s | 10.2 [ 14601 ] |
Assignee | Sachin Setiya [ sachin.setiya.007 ] | Jan Lindström [ jplindst ] |
Assignee | Jan Lindström [ jplindst ] | Stepan Patryshev [ stepan.patryshev ] |
Labels | galera | galera need_feedback |
Labels | galera need_feedback | need_verification |
Assignee | Stepan Patryshev [ stepan.patryshev ] | Ramesh Sivaraman [ JIRAUSER48189 ] |
Workflow | MariaDB v3 [ 85480 ] | MariaDB v4 [ 140634 ] |
Fix Version/s | N/A [ 14700 ] | |
Fix Version/s | 10.2 [ 14601 ] | |
Resolution | Won't Fix [ 2 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
With these requests i don't have any problems
SET autocommit=0;
– dostuff...
DROP TEMPORARY TABLE IF EXISTS test;
CREATE TEMPORARY TABLE test LIKE test2;
INSERT INTO test SELECT * FROM test2 WHERE c1=1;
– dostuff...
COMMIT;