The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

MySQL shutdown unexpectedly.

I have HyperW virtual Win10 machine with Xampp.

Host machine restarted and now virtual Win10 is working OK, as wel as Apachee server, but MySql refuse to start.

Log mention that file 'C:\xampp\mysql\data\ibtmp1' is full, but there is no such file on my disk

Any idea what to do?

Here is MySql log:

2021-06-28 15:11:13 0 [Note] mysqld.exe: Aria engine: recovery done InnoDB: using atomic writes. 2021-06-28 15:11:13 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-06-28 15:11:13 0 [Note] InnoDB: Uses event mutexes 2021-06-28 15:11:13 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-28 15:11:13 0 [Note] InnoDB: Number of pools: 1 2021-06-28 15:11:13 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-28 15:11:13 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-06-28 15:11:13 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-28 15:11:13 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=116556689 2021-06-28 15:11:13 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-06-28 15:11:13 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1" 2021-06-28 15:11:13 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-28 15:11:13 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-28 15:11:13 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-06-28 15:11:13 0 [Note] InnoDB: Waiting for purge to start 2021-06-28 15:11:13 0 [Note] InnoDB: 10.4.17 started; log sequence number 116556698; transaction id 191653 2021-06-28 15:11:13 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-06-28 15:11:13 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-06-28 15:11:13 0 [Note] InnoDB: Buffer pool(s) load completed at 210628 15:11:13 2021-06-28 15:11:13 0 [Note] Server socket created on IP: '::'. InnoDB: using atomic writes. 2021-06-28 15:11:35 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions 2021-06-28 15:11:35 0 [Note] InnoDB: Uses event mutexes 2021-06-28 15:11:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.11 2021-06-28 15:11:35 0 [Note] InnoDB: Number of pools: 1 2021-06-28 15:11:35 0 [Note] InnoDB: Using SSE2 crc32 instructions 2021-06-28 15:11:35 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M 2021-06-28 15:11:36 0 [Note] InnoDB: Completed initialization of buffer pool 2021-06-28 15:11:36 0 [Note] InnoDB: 128 out of 128 rollback segments are active. 2021-06-28 15:11:36 0 [Note] InnoDB: Creating shared tablespace for temporary tables 2021-06-28 15:11:36 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2021-06-28 15:11:36 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB. 2021-06-28 15:11:36 0 [Note] InnoDB: Waiting for purge to start 2021-06-28 15:11:36 0 [Note] InnoDB: 10.4.17 started; log sequence number 116556707; transaction id 191653 2021-06-28 15:11:36 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool 2021-06-28 15:11:36 0 [Note] Plugin 'FEEDBACK' is disabled. 2021-06-28 15:11:36 0 [Note] Server socket created on IP: '::'. InnoDB: using atomic writes.

Answer Answered by Daniel Black in this comment.

I can't see any sign of refusing to start. What does that look like? Are you starting MySQL and MariaDB is already started?

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.