Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21324

ALTER TABLE RENAME TABLENAME Failed

    XMLWordPrintable

    Details

      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)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            supbaek baek seung ho
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: