Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5605

MySql doesn't start in Xampp on Windows - InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6154

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • None
    • None
    • PrimProc
    • None
    • Windows 11 Xampp control panel v3.3.0

    Description

      2023-11-08 14:26:38 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 10268
      2023-11-08 14:26:38 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
      2023-11-08 14:26:38 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2023-11-08 14:26:38 0 [Note] InnoDB: Uses event mutexes
      2023-11-08 14:26:38 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
      2023-11-08 14:26:38 0 [Note] InnoDB: Number of pools: 1
      2023-11-08 14:26:38 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2023-11-08 14:26:38 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
      2023-11-08 14:26:38 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-11-08 14:26:38 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
      2023-11-08 14:26:38 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
      2023-11-08 14:26:38 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
      2023-11-08 14:26:38 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
      2023-11-08 14:26:38 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
      2023-11-08 14:26:38 0 [Note] InnoDB: New log files created, LSN=11451
      2023-11-08 14:26:38 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2023-11-08 14:26:38 0 [Note] InnoDB: Doublewrite buffer created
      2023-11-08 14:26:38 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2023-11-08 14:26:38 0 [Note] InnoDB: Creating foreign key constraint system tables.
      2023-11-08 14:26:38 0 [Note] InnoDB: Creating tablespace and datafile system tables.
      2023-11-08 14:26:38 0 [Note] InnoDB: Creating sys_virtual system tables.
      2023-11-08 14:26:38 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2023-11-08 14:26:38 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2023-11-08 14:26:38 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
      2023-11-08 14:26:38 0 [Note] InnoDB: Waiting for purge to start
      2023-11-08 14:26:38 0 [Note] InnoDB: 10.4.28 started; log sequence number 0; transaction id 7
      2023-11-08 14:26:38 0 [Note] Plugin 'FEEDBACK' is disabled.
      2023-11-08 14:26:38 0 [Note] Zerofilling moved table: '.\mysql\plugin'
      2023-11-08 14:26:38 0 [Note] Zerofilling moved table: '.\mysql\servers'
      2023-11-08 14:26:38 0 [Note] Server socket created on IP: '::'.
      2023-11-08 14:26:38 0x2798 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6154
      InnoDB: Failing assertion: slot
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      2023-11-08 14:26:38 0x1278 InnoDB: Assertion failure in file D:\winx64-packages\build\src\storage\innobase\os\os0file.cc line 6154
      231108 14:26:38 InnoDB: Failing assertion: slot
      [ERROR] mysqld got exception 0x80000003 ;
      InnoDB: We intentionally generate a memory trap.
      InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
      InnoDB: If you get repeated assertion failures or crashes, even
      InnoDB: immediately after the mysqld startup, there may be
      InnoDB: corruption in the InnoDB tablespace. Please refer to
      InnoDB: https://mariadb.com/kb/en/library/innodb-recovery-modes/
      InnoDB: about forcing recovery.
      This could be because you hit a bug. It is also possible that this binary
      or one of the libraries it was linked against is corrupt, improperly built,
      or misconfigured. This error can also be caused by malfunctioning hardware.

      To report this bug, see https://mariadb.com/kb/en/reporting-bugs

      2022023-11-08 14:27:17 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 2588
      2023-11-08 14:27:17 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2023-11-08 14:27:17 0 [Note] InnoDB: Uses event mutexes
      2023-11-08 14:27:17 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
      2023-11-08 14:27:17 0 [Note] InnoDB: Number of pools: 1
      2023-11-08 14:27:17 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2023-11-08 14:27:17 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
      2023-11-08 14:27:17 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-11-08 14:27:17 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=14601
      2023-11-08 14:27:17 0 [Note] InnoDB: Starting final batch to recover 13 pages from redo log.
      2023-11-08 14:27:18 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2023-11-08 14:27:18 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
      2023-11-08 14:27:18 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2023-11-08 14:27:18 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2023-11-08 14:27:18 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
      2023-11-08 14:27:18 0 [Note] InnoDB: Waiting for purge to start
      2023-11-08 14:27:18 0 [Note] InnoDB: 10.4.28 started; log sequence number 46271; transaction id 8
      2023-11-08 14:27:18 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
      2023-11-08 14:27:18 0 [Note] Plugin 'FEEDBACK' is disabled.
      2023-11-08 14:27:18 0 [Note] InnoDB: Cannot open 'C:\xampp\mysql\data\ib_buffer_pool' for reading: No such file or directory
      2023-11-08 14:27:18 0 [Note] Server socket created on IP: '::'.
      2023-11-08 14:27:31 0 [Note] Starting MariaDB 10.4.28-MariaDB source revision c8f2e9a5c0ac5905f28b050b7df5a9ffd914b7e7 as process 5312
      2023-11-08 14:27:31 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
      2023-11-08 14:27:31 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2023-11-08 14:27:31 0 [Note] InnoDB: Uses event mutexes
      2023-11-08 14:27:31 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
      2023-11-08 14:27:31 0 [Note] InnoDB: Number of pools: 1
      2023-11-08 14:27:31 0 [Note] InnoDB: Using SSE2 crc32 instructions
      2023-11-08 14:27:31 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
      2023-11-08 14:27:31 0 [Note] InnoDB: Completed initialization of buffer pool
      2023-11-08 14:27:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
      2023-11-08 14:27:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
      2023-11-08 14:27:31 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
      2023-11-08 14:27:31 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
      2023-11-08 14:27:31 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
      2023-11-08 14:27:31 0 [Note] InnoDB: New log files created, LSN=11451
      2023-11-08 14:27:31 0 [Note] InnoDB: Doublewrite buffer not found: creating new
      2023-11-08 14:27:31 0 [Note] InnoDB: Doublewrite buffer created
      2023-11-08 14:27:31 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
      2023-11-08 14:27:31 0 [Note] InnoDB: Creating foreign key constraint system tables.
      2023-11-08 14:27:31 0 [Note] InnoDB: Creating tablespace and datafile system tables.
      2023-11-08 14:27:31 0 [Note] InnoDB: Creating sys_virtual system tables.
      2023-11-08 14:27:31 0 [Note] InnoDB: Creating shared tablespace for temporary tables
      2023-11-08 14:27:31 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
      2023-11-08 14:27:31 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
      2023-11-08 14:27:31 0 [Note] InnoDB: 10.4.28 started; log sequence number 0; transaction id 7
      2023-11-08 14:27:31 0 [Note] Plugin 'FEEDBACK' is disabled.
      2023-11-08 14:27:31 0 [Note] Server socket created on IP: '::'.

      Attachments

        Activity

          People

            Unassigned Unassigned
            bilo35x Bilal Özcan
            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.