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

        1. a_long_semaphore_wait.txt
          9 kB
          baek seung ho
        2. innodb_engine_status.txt
          13 kB
          baek seung ho

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.