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

After mysqld shuts down normally, restart mysqld and the partition table cannot be found.

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Incomplete
    • 10.5.22
    • N/A
    • Platform Windows
    • None
    • windows

    Description

      2023-08-30 16:52:57 0 [Note] .\bin\mysqld (initiated by: sys[sys] @  [127.0.0.1]): Normal shutdown
      2023-08-30 16:52:57 0 [Note] Event Scheduler: Killing the scheduler thread, thread id 2
      2023-08-30 16:52:57 0 [Note] Event Scheduler: Waiting for the scheduler thread to reply
      2023-08-30 16:52:57 0 [Note] Event Scheduler: Stopped
      2023-08-30 16:52:57 0 [Note] Event Scheduler: Purging the queue. 50 events
      2023-08-30 16:52:57 0 [Note] InnoDB: FTS optimize thread exiting.
      2023-08-30 16:52:57 0 [Note] InnoDB: Starting shutdown...
      2023-08-30 16:53:19 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2023-08-30 16:53:19 0 [Note] InnoDB: Shutdown completed; log sequence number 63880810; transaction id 69971
      2023-08-30 16:53:19 0 [Note] .\bin\mysqld: Shutdown complete
       
      2023-08-30 17:00:20 0 [Note] Starting MariaDB 10.5.22-MariaDB-log source revision 7e650253dc488debcb0898ebe6d385bf6dfa3656 as process 49816
      2023-08-30 17:00:20 0 [Warning] The parameter innodb_buffer_pool_instances is deprecated and has no effect.
      2023-08-30 17:00:20 0 [Warning] The parameter innodb_page_cleaners is deprecated and has no effect.
      2023-08-30 17:00:20 0 [Note] InnoDB: Uses event mutexes
      2023-08-30 17:00:20 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
      2023-08-30 17:00:20 0 [Note] InnoDB: Number of pools: 1
      2023-08-30 17:00:20 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
      2023-08-30 17:00:20 0 [Note] InnoDB: Initializing buffer pool, total size = 2147483648, chunk size = 134217728
      2023-08-30 17:00:20 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-08-30 17:00:21 0 [Note] InnoDB: 128 rollback segments are active.
      2023-08-30 17:00:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2023-08-30 17:00:22 0 [Note] InnoDB: Setting file '.\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2023-08-30 17:00:22 0 [Note] InnoDB: File '.\ibtmp1' size is now 12 MB.
      2023-08-30 17:00:22 0 [Note] InnoDB: 10.5.22 started; log sequence number 64595296; transaction id 72181
      2023-08-30 17:00:22 0 [Note] Plugin 'FEEDBACK' is disabled.
      2023-08-30 17:00:22 0 [Note] Server socket created on IP: '::'.
      2023-08-30 17:00:22 2 [Note] Event Scheduler: scheduler thread started with id 2
      2023-08-30 17:00:22 0 [Note] Reading of all Master_info entries succeeded
      2023-08-30 17:00:22 0 [Note] Added new Master_info '' to hash table
      2023-08-30 17:00:22 0 [Note] .\bin\mysqld: ready for connections.
      Version: '10.5.22-MariaDB-log'  socket: ''  port: 3306  mariadb.org binary distribution
       
      2023-08-30 17:00:57 55 [ERROR] Failed to open table dsdb/attendance_record_202310#p#p20231001.
       
      2023-08-30 17:00:57 55 [ERROR] Failed to open table dsdb/attendance_record_202311#p#p20231101.
       
      2023-08-30 17:00:57 55 [ERROR] Failed to open table dsdb/attendance_record_202312#p#p20231201.
       
      2023-08-30 17:00:57 55 [ERROR] Failed to open table dsdb/attendance_record_202401#p#p20240101.
       
      2023-08-30 17:00:57 55 [ERROR] Failed to open table dsdb/attendance_record_202402#p#p20240201.
       
      2023-08-30 17:00:58 55 [ERROR] Failed to open table dsdb/attendance_record_202403#p#p20240301.
       
      2023-08-30 17:00:58 55 [ERROR] Failed to open table dsdb/attendance_record_202404#p#p20240401.
       
      2023-08-30 17:00:58 55 [ERROR] Failed to open table dsdb/attendance_record_202405#p#p20240501.
       
      2023-08-30 17:00:58 55 [ERROR] Failed to open table dsdb/attendance_record_202406#p#p20240601.
       
      2023-08-30 17:00:58 55 [ERROR] Failed to open table dsdb/attendance_record_202407#p#p20240701.
      

      Attachments

        Activity

          People

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