MySQL Forums
Forum List  »  Quality Assurance

MySQL Shutdown unexpectedly
Posted by: Giovanni Marchesi
Date: May 09, 2024 05:15PM

Hello to all, i'm completely new to MySQL, and so i kindly ask you if you can help me with a problem. One moment it works fine, but the second time i open it doesn't open! I'm having trouble identifying the problem, so i thought maybe in the forums someone could help me out.

2024-05-09 18:00:32 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-05-09 18:00:32 0 [Note] InnoDB: Waiting for purge to start
2024-05-09 18:00:32 0 [Note] InnoDB: 10.4.32 started; log sequence number 8697900; transaction id 4526
2024-05-09 18:00:32 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-05-09 18:00:32 0 [Note] InnoDB: Buffer pool(s) load completed at 240509 18:00:32
2024-05-09 18:00:32 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-09 18:00:32 0 [Note] Server socket created on IP: '::'.
2024-05-09 23:20:52 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 18592
Cannot find checkpoint record at LSN (1,0x5556)
2024-05-09 23:20:52 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-05-09 23:20:52 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-05-09 23:20:52 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-09 23:20:52 0 [Note] InnoDB: Uses event mutexes
2024-05-09 23:20:52 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-05-09 23:20:52 0 [Note] InnoDB: Number of pools: 1
2024-05-09 23:20:52 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-09 23:20:52 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-05-09 23:20:52 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-09 23:20:52 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=13338595
2024-05-09 23:20:53 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-09 23:20:53 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2024-05-09 23:20:53 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-09 23:20:53 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-09 23:20:53 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-05-09 23:20:53 0 [Note] InnoDB: Waiting for purge to start
2024-05-09 23:20:53 0 [Note] InnoDB: 10.4.32 started; log sequence number 13338604; transaction id 6870
2024-05-09 23:20:53 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-05-09 23:20:53 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-09 23:20:53 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-05-09 23:20:53 0 [ERROR] Failed to initialize plugins.
2024-05-09 23:20:53 0 [ERROR] Aborting
2024-05-09 23:21:22 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 29728
Cannot find checkpoint record at LSN (1,0x5556)
2024-05-09 23:21:22 0 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2024-05-09 23:21:22 0 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2024-05-09 23:21:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-09 23:21:22 0 [Note] InnoDB: Uses event mutexes
2024-05-09 23:21:22 0 [Note] InnoDB: Compressed tables use zlib 1.3
2024-05-09 23:21:22 0 [Note] InnoDB: Number of pools: 1
2024-05-09 23:21:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2024-05-09 23:21:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2024-05-09 23:21:22 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-09 23:21:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2024-05-09 23:21:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2024-05-09 23:21:22 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2024-05-09 23:21:22 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2024-05-09 23:21:22 0 [Note] InnoDB: Waiting for purge to start
2024-05-09 23:21:22 0 [Note] InnoDB: 10.4.32 started; log sequence number 13338613; transaction id 6870
2024-05-09 23:21:22 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2024-05-09 23:21:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2024-05-09 23:21:22 0 [Note] InnoDB: Buffer pool(s) load completed at 240509 23:21:22
2024-05-09 23:21:22 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2024-05-09 23:21:22 0 [ERROR] Failed to initialize plugins.
2024-05-09 23:21:22 0 [ERROR] Aborting
2024-05-09 23:21:28 0 [Note] Starting MariaDB 10.4.32-MariaDB source revision c4143f909528e3fab0677a28631d10389354c491 as process 36036
Cannot find checkpoint record at LSN (1,0x5556)

I will appreciate any help you can provide, thank you all.

Options: ReplyQuote


Subject
Views
Written By
Posted
MySQL Shutdown unexpectedly
516
May 09, 2024 05:15PM


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.