Hi Krunal, thanks for reply.
I didn’t execute option 2 in my import. As I noticed in question that I have 3 node cluster with 2 of them shutdown. And just test from 1st node.
For now I forget all about import and just test simple case: INSERTION.
I login to Node1 with root user and just create simple table in shems database to test if insert can be done successfully.
mysql> create table test (id integer);
Query OK, 0 rows affected (0.01 sec)
mysql> insert into test values (4);
ERROR 1213 (40001): WSREP detected deadlock/conflict and aborted the transaction. Try restarting the transaction
Again the log output is:
[I]2017-12-04T11:18:04.550046Z 48 [Note] WSREP: Cleaning up wsrep-transaction for local query: insert into test values (4)
2017-12-04T11:18:04.550065Z 48 [Note] WSREP: Retrying auto-commit query (on abort): insert into test values (4)
2017-12-04T11:18:04.550095Z 48 [Note] WSREP: Assigned new trx id to retry auto-commit query: 108
2017-12-04T11:18:04.550187Z 48 [Note] WSREP: wsrep: replicating commit (-1)
2017-12-04T11:18:04.550205Z 48 [Warning] WSREP: SQL statement (insert into test values (4)) was not replicated (thd: 48)
2017-12-04T11:18:04.550211Z 48 [Note] WSREP: commit action failed for reason: WSREP_TRX_FAIL THD: 48 Query: insert into test values (4)
2017-12-04T11:18:04.550216Z 48 [Note] WSREP: conflict state: NO_CONFLICT
2017-12-04T11:18:04.550221Z 48 [Note] WSREP: --------- CONFLICT DETECTED --------
2017-12-04T11:18:04.550240Z 48 [Note] WSREP: cluster conflict due to certification failure for threads:
2017-12-04T11:18:04.550246Z 48 [Note] WSREP: Victim thread:
THD: 48, mode: local, state: executing, conflict: cert failure, seqno: -1
SQL: insert into test values (4)[/I]
WHAT DOES IT MEANS???
Thanks.