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

After the drop table, only the ibd file remains, and the frm file has been deleted

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 10.5.17
    • N/A
    • None
    • windows

    Description

      After the drop table, only the ibd file remains, and the frm file has been deleted

      err log info:

      2023-08-07 4:33:32 0 [Note] InnoDB: Uses event mutexes
      2023-08-07 4:33:32 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
      2023-08-07 4:33:32 0 [Note] InnoDB: Number of pools: 1
      2023-08-07 4:33:32 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2023-08-07 4:33:32 0 [Note] InnoDB: Initializing buffer pool, total size = 3221225472, chunk size = 134217728
      2023-08-07 4:33:32 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-08-07 4:33:33 0 [Note] InnoDB: 128 rollback segments are active.
      2023-08-07 4:37:05 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2023-08-07 4:37:05 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2023-08-07 4:37:05 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2023-08-07 4:37:05 0 [Note] InnoDB: 10.5.17 started; log sequence number 1294478171862; transaction id 1677378100
      2023-08-07 4:37:05 0 [Note] InnoDB: Loading buffer pool(s) from D:\DSS\DSS Server\mysql\data\ib_buffer_pool
      2023-08-07 4:37:09 0 [Note] Server socket created on IP: '::'.
      2023-08-07 4:37:09 2 [Note] Event Scheduler: scheduler thread started with id 2
      2023-08-07 4:37:09 0 [Note] D:\DSS\DSS Server\mysql\bin\mysqld.exe: ready for connections.
      Version: '10.5.17-MariaDB-log' socket: '' port: 3306 mariadb.org binary distribution
      2023-08-07 4:37:18 77 [Note] Detected table cache mutex contention at instance 1: 45% waits. Additional table cache instance activated. Number of instances after activation: 2.
      2023-08-07 4:38:05 0 [Note] InnoDB: Buffer pool(s) load completed at 230807 4:38:05
      2023-08-07 5:03:00 548 [ERROR] InnoDB: Table `shop`.`adm_face_device_record_20230714_0` does not exist in the InnoDB internal data dictionary though MariaDB is trying to drop it. Have you copied the .frm file of the table to the MariaDB database directory from another database? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.
      2023-08-07 5:03:00 548 [ERROR] InnoDB: Table `shop`.`adm_face_device_record_20230714_1` does not exist in the InnoDB internal data dictionary though MariaDB is trying to drop it. Have you copied the .frm file of the table to the MariaDB database directory from another database? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.
      2023-08-07 5:03:00 548 [ERROR] InnoDB: Table `shop`.`adm_face_device_record_20230714_2` does not exist in the InnoDB internal data dictionary though MariaDB is trying to drop it. Have you copied the .frm file of the table to the MariaDB database directory from another database? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.
      2023-08-07 5:03:00 548 [ERROR] InnoDB: Table `shop`.`adm_face_device_record_20230714_3` does not exist in the InnoDB internal data dictionary though MariaDB is trying to drop it. Have you copied the .frm file of the table to the MariaDB database directory from another database? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.
      2023-08-07 5:03:00 548 [ERROR] InnoDB: Table `shop`.`adm_face_device_record_20230714_4` does not exist in the InnoDB internal data dictionary though MariaDB is trying to drop it. Have you copied the .frm file of the table to the MariaDB database directory from another database? Please refer to https://mariadb.com/kb/en/innodb-troubleshooting/ for how to resolve the issue.

      Attachments

        Activity

          People

            Unassigned Unassigned
            kennyliao kennyliao
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.