MySQL Forums
Forum List  »  Newbie

MySQL shutdown unexpectedly.
Posted by: Ivo Tišljar
Date: June 28, 2021 07:34AM

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.

Options: ReplyQuote


Subject
Written By
Posted
MySQL shutdown unexpectedly.
June 28, 2021 07:34AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.