MySQL keeps shutting down unexpectedly

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL keeps shutting down unexpectedly

Postby pierluroma » 18. March 2020 10:00

Hi everybody,
I keep getting this problem whenever i try to turn MySQL on. I don't get any problem with Apache or Tomcat, just with MySQL. Also checked that there are no mysql.exe running in the background.
This is the log i keep getting.

InnoDB: using atomic writes.
2020-03-18 9:55:41 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-18 9:55:41 0 [Note] InnoDB: Uses event mutexes
2020-03-18 9:55:41 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-18 9:55:41 0 [Note] InnoDB: Number of pools: 1
2020-03-18 9:55:41 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-18 9:55:41 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-18 9:55:41 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-18 9:55:42 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-18 9:55:42 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-18 9:55:42 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-18 9:55:42 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-18 9:55:42 0 [Note] InnoDB: 10.4.8 started; log sequence number 1706711; transaction id 3247
2020-03-18 9:55:42 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-18 9:55:42 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-18 9:55:42 0 [Note] Server socket created on IP: '::'.


Thanks in advance to anyone who can help me!
pierluroma
 
Posts: 1
Joined: 18. March 2020 09:57
XAMPP version: 3.2.4
Operating System: Windows

Re: MySQL keeps shutting down unexpectedly

Postby Koushirou » 19. March 2020 11:52

I'm getting the same problem since yesterday. I changed nothing as far as I know.
Using XAMPP 3.2.4 on Windows 10

InnoDB: using atomic writes.
2020-03-19 11:36:22 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-03-19 11:36:22 0 [Note] InnoDB: Uses event mutexes
2020-03-19 11:36:22 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-03-19 11:36:22 0 [Note] InnoDB: Number of pools: 1
2020-03-19 11:36:22 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-03-19 11:36:22 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-03-19 11:36:22 0 [Note] InnoDB: Completed initialization of buffer pool
2020-03-19 11:36:22 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-03-19 11:36:22 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-03-19 11:36:22 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-03-19 11:36:22 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-03-19 11:36:22 0 [Note] InnoDB: Waiting for purge to start
2020-03-19 11:36:22 0 [Note] InnoDB: 10.4.11 started; log sequence number 139481496; transaction id 274075
2020-03-19 11:36:22 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2020-03-19 11:36:22 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-03-19 11:36:22 0 [Note] Server socket created on IP: '::'.
Koushirou
 
Posts: 3
Joined: 19. March 2020 11:49
XAMPP version: 3.2.4
Operating System: Windows 10

Re: MySQL keeps shutting down unexpectedly

Postby Koushirou » 20. March 2020 18:34

Windows Event Viewer
Code: Select all
Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
c:\xampp\mysql\bin\mysqld.exe (mysqld 10.4.11-MariaDB) starting as process 2124 ...


Code: Select all
InnoDB: Mutexes and rw_locks use Windows interlocked functions
InnoDB: Uses event mutexes
InnoDB: Compressed tables use zlib 1.2.11
InnoDB: Number of pools: 1
InnoDB: Using SSE2 crc32 instructions
InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
InnoDB: Completed initialization of buffer pool
InnoDB: 128 out of 128 rollback segments are active.
InnoDB: Creating shared tablespace for temporary tables
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
InnoDB: Waiting for purge to start
InnoDB: 10.4.11 started; log sequence number 139481586; transaction id 274075
InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
Plugin 'FEEDBACK' is disabled.
Server socket created on IP: '::'.


I'm guessing ths last part might actually help ... anyone any idea what is happening here?

Code: Select all
mysqld.exe: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
Fatal error: Can't open and lock privilege tables: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
Aborting
Koushirou
 
Posts: 3
Joined: 19. March 2020 11:49
XAMPP version: 3.2.4
Operating System: Windows 10

Re: MySQL keeps shutting down unexpectedly

Postby Koushirou » 20. March 2020 18:54

Running mysql_upgrade resulted in

Code: Select all
Phase 4/7: Running 'mysql_fix_privilege_tables'
ERROR 1030 (HY000) at line 110: Got error 176 "Read page with wrong checksum" from storage engine Aria
ERROR 144 (HY000) at line 454: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 455: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 456: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
ERROR 1030 (HY000) at line 464: Got error 176 "Read page with wrong checksum" from storage engine Aria
ERROR 144 (HY000) at line 479: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 729: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
ERROR 144 (HY000) at line 731: Table '.\mysql\proxies_priv' is marked as crashed and last (automatic?) repair failed
FATAL ERROR: Upgrade failed

Deleting the 3 files ...

Code: Select all
proxies_priv.MAI
proxies_priv.MAD
proxies_priv.frm


...in C:\xampp\mysql\data\mysql\.. at least let me start the mysql server now.
Everything seems to work. I'm not entirely sure what those tables are used for, since I never used any proxy with my local mysql server.
Koushirou
 
Posts: 3
Joined: 19. March 2020 11:49
XAMPP version: 3.2.4
Operating System: Windows 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 112 guests