MySQL shutdown unexpectedly

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

MySQL shutdown unexpectedly

Postby bhaskarbhagowati » 25. September 2019 13:40

I am unable to start the MySQL database from XAMPP control panel. I need to shutdown the server on 15/09/2019 due to some power issue, and turning it ON on today; i.e. on 25/09/2019. some of the snapshots of the mysql_error.log are as follows:
2019-09-15 10:33:32 d3c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3388 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3388 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3388 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3388 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3388 [Note] InnoDB: _mm_lfence() and _mm_sfence() are u2s019e-d0 9f-o1r5 m1e0m:o3r3y: 3b2a rer0icer
InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and wit2h 0t1h9e- 0I9n-n1o5D B1'0s: 3i3n:t3e2r n3a3l8 8m e[mNoortye ]a lIlnnoocDaBt:o rC.o
mpr2e01s9s-e0d9 -t1a5b l1e0s: 3u3s:e3 2z l3i5b9 61 .[2N.o3t
e] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3388 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3388 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3388 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 3596 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3596 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3596 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3596 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3596 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3596 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3596 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3596 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 ea4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3748 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 d3c InnoDB: Operating system error number 32 in a file operation.
InnoDB: The error means that another program is using InnoDB's files.
InnoDB: This might be a backup or antivirus software or another instance
InnoDB: of MySQL. Please close it to get rid of this error.
2019-09-15 10:33:32 3748 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3748 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3748 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3748 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3748 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3748 [Note] InnoDB: Using generic crc32 instructi2o0n1s9
-09-15 10:33:32 3596 [Note] InnoDB: Highest supported file format is Barracuda.
2019-09-15 10:33:32 3748 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3748 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 684 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 1668 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3748 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3748 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 3748 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 3748 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3596 [Note] InnoDB: The log sequence number 1835037 in ibdata file do not match the log sequence number 89329480 in the ib_logfiles!
2019-09-15 10:33:32 3748 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3748 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 3748 [ERROR] Aborting

2019-09-15 10:33:32 1668 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 1668 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 1668 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 1668 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 1668 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 1668 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 1668 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 1668 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 ff0 InnoDB: Warning: Using innodb_additional_mem_p2o0o1l9_-si0z9e- 1i5s 1D0E:P3R3E:C3A2T E1D6.6 8T h[iEsR RoOpRt]i oInn nmoaDyB :b eD :r\exmaomvpepd\ miyns qflu\tduartea \riebldeaatsae1s ,c atno'gte tbhee ro pweintehd tihne roepatdi-ownr iitnen omdobd_eu
se_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 4080 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use ba2ck0o1f9f-,0 9i-n1c5r e1a0s:e3 3b:u3f2f e1r6 6p8o o[lE RaRtO Rl]e aIsntn ouDpB :t oT h2e0 MsBy.s
t
em tablespace must be writable!
2019-09-15 10:33:32 1668 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 1668 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 1668 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 1668 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 1668 [ERROR] Aborting

2019-09-15 10:33:32 4080 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 4080 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 4080 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 4080 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 4080 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 4080 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 4080 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 4080 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 2e8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 744 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to2 02109M-B0.9
-
15 10:33:32 4080 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 4080 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 4080 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 4080 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 744 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 744 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 744 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 744 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 744 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 744 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 744 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 744 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 744 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-writCeanno tm ofdien
d checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 4080 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 744 [ERROR] InnoDB: The system tablespace must be writab2l0e1!9
-09-15 10:33:32 4080 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 744 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 4080 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 744 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 4080 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 674 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 1652 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 4080 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 4080 [ERROR] Aborting

Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 744 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 744 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 744 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 744 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 744 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 744 [ERROR] Aborting

2019-09-15 10:33:32 1652 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 1652 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 1652 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 f94 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the 2I0n1n9o-D0B9'-s1 5i n1t0e:rn3a3l: 3m2e m1o6r5y2 a[llNooctaet]o rI.n
noDB2:0 1_9m-m0_9l-f1e5n c1e0(:)3 3a:n3d2 _3m9m8_8s f[eNnoctee]( )I nanroDeB : iunsneodd bf_oerm pmteym_ofrrye eb_alrirsite_ra
lgorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 1652 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 1652 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 1652 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 1652 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 1652 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3988 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 1652 [ERROR] InnoDB: The system tablespace must be writ2a0b1l9-e0!9
-15 10:33:32 3988 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 1652 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 1652 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3988 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3988 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3988 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3988 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3988 [Note] InnoDB: Initializing buffer pool, size = 16.0M
Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 1652 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 1652 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 1652 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 1652 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3988 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 1652 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 1652 [ERROR] Aborting

2019-09-15 10:33:32 cb4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3252 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

2019-09-15 10:33:32 3988 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3988 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 3988 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 3988 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 3988 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 3988 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 3988 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3988 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3988 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 3988 [ERROR] Aborting

2019-09-15 10:33:32 3252 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2019-09-15 10:33:32 3252 [Note] InnoDB: The InnoDB memory heap is disabled
2019-09-15 10:33:32 3252 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-09-15 10:33:32 3252 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2019-09-15 10:33:32 3252 [Note] InnoDB: Compressed tables use zlib 1.2.3
2019-09-15 10:33:32 3252 [Note] InnoDB: Using generic crc32 instructions
2019-09-15 10:33:32 3252 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2019-09-15 10:33:32 3252 [Note] InnoDB: Completed initialization of buffer pool
2019-09-15 10:33:32 3252 [ERROR] InnoDB: D:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2019-09-15 10:33:32 3252 [ERROR] InnoDB: The system tablespace must be writable!
2019-09-15 10:33:32 3252 [ERROR] Plugin 'InnoDB' init function returned error.
2019-09-15 10:33:32 3252 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 f58 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2019-09-15 10:33:32 3928 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

Cannot find checkpoint record at LSN (1,0x208b)

2019-09-15 10:33:32 3252 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2019-09-15 10:33:32 3252 [ERROR] Plugin 'Aria' init function returned error.
2019-09-15 10:33:32 3252 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2019-09-15 10:33:32 3252 [Note] Plugin 'FEEDBACK' is disabled.
2019-09-15 10:33:32 3252 [ERROR] Unknown/unsupported storage engine: InnoDB
2019-09-15 10:33:32 3252 [ERROR] Aborting
bhaskarbhagowati
 
Posts: 3
Joined: 25. September 2019 12:46
XAMPP version: 3.2.2
Operating System: Windows Server 2008 R2 Std

Re: MySQL shutdown unexpectedly

Postby bhaskarbhagowati » 28. September 2019 12:55

I got the solution by deleting aria_log.00000001 under C:\xampp\mysql\data. But don't delete the ibdata1 file under the same directory.
bhaskarbhagowati
 
Posts: 3
Joined: 25. September 2019 12:46
XAMPP version: 3.2.2
Operating System: Windows Server 2008 R2 Std


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 79 guests