Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.0.31-galera
-
Redhat Linux 6.7
Description
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)
|