|
Renaming table after bulk insert to large data, it is failed.
running query in node 3, and failed in node 2.
LOAD DATA LOCAL INFILE 'A.TXT' INTO TABLE A_NEW;
|
ALTER TABLE A_NEW RENAME A;
|
2019-12-08 01:51:59 7f07e72d9700 InnoDB: Warning: problems renaming 'MTPUSHDB/ICAS_CUSTOMER_NEW' to 'MTPUSHDB/ICAS_CUSTOMER', 25000 iterations
|
191208 1:51:59 [ERROR] Slave SQL: Error 'Error on rename of './MTPUSHDB/ICAS_CUSTOMER_NEW' to './MTPUSHDB/ICAS_CUSTOMER' (errno: -1 "Internal error < 0 (Not system error)")
|
' on query. Default database: 'MTPUSHDB'. Query: 'ALTER TABLE ICAS_CUSTOMER_NEW RENAME ICAS_CUSTOMER', Internal MariaDB error code: 1025
|
191208 1:51:59 [Warning] WSREP: RBR event 1 Query apply warning: 1, 258025777
|
191208 1:51:59 [Warning] WSREP: Ignoring error for TO isolated action: source: 44bb55a7-3a96-11e9-82c4-cb5c380a389f version: 3 local: 0 state: APPLYING flags: 65 conn_id: 2
|
671735 trx_id: -1 seqnos (l: 41949069, g: 258025777, s: 258025776, d: 258025776, ts: 24461914127490636)
|
|
a_long_semaphore_wait.txt