Can't start mysql in XAMPP

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

Can't start mysql in XAMPP

Postby biblioteka » 14. May 2017 05:35

Hi all,

I'm a newbie that may be in over my head. I am trying to use XAMPP to run open biblio for a small church library. all was going well until I tried to start this morning. All worked well last night which makes the log message worrisome:

"Error: MySQL shutdown unexpectedly.
This may be due to a blocked port, missing dependencies,
improper privileges, a crash, or a shutdown by another method.
Press the Logs button to view error logs and check
the Windows Event Viewer for more clues
If you need more help, copy and post this
entire log window on the forums"

on the log:
[color=#0000FF]2017-05-12 18:01:01 1db0 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.
2017-05-12 18:01:01 7600 [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.

2017-05-12 18:01:01 7600 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-12 18:01:01 7600 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-12 18:01:01 7600 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-05-12 18:01:01 7600 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-05-12 18:01:01 7600 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-12 18:01:01 7600 [Note] InnoDB: Using generic crc32 instructions
2017-05-12 18:01:01 7600 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-05-12 18:01:01 7600 [Note] InnoDB: Completed initialization of buffer pool
2017-05-12 18:01:02 7600 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-12 18:01:02 7600 [Note] InnoDB: The log sequence numbers 1835037 and 1835037 in ibdata files do not match the log sequence number 1835087 in the ib_logfiles!
2017-05-12 18:01:02 7600 [Note] InnoDB: Database was not shutdown normally!
2017-05-12 18:01:02 7600 [Note] InnoDB: Starting crash recovery.
2017-05-12 18:01:02 7600 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-05-12 18:01:03 7600 [Note] InnoDB: Restoring possible half-written data pages
2017-05-12 18:01:03 7600 [Note] InnoDB: from the doublewrite buffer...
2017-05-12 18:01:05 7600 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-12 18:01:05 7600 [Note] InnoDB: Waiting for purge to start
2017-05-12 18:01:05 7600 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835087
2017-05-12 18:01:05 8044 [Note] InnoDB: Dumping buffer pool(s) not yet started
2017-05-12 18:01:05 7600 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-12 18:01:05 7600 [Note] Server socket created on IP: '::'.
2017-05-12 18:01:07 7600 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.21-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2017-05-12 18:01:38 2752 [ERROR] mysqld.exe: Table '.\openbiblio\settings' is marked as crashed and should be repaired
2017-05-12 18:01:38 2752 [Warning] Checking table: '.\openbiblio\settings'
2017-05-12 18:06:36 8632 [ERROR] mysqld.exe: Table '.\openbiblio\session' is marked as crashed and should be repaired
2017-05-12 18:06:36 8632 [Warning] Checking table: '.\openbiblio\session'
2017-05-12 18:10:34 2752 [ERROR] mysqld.exe: Table '.\openbiblio\member' is marked as crashed and should be repaired
2017-05-12 18:10:34 2752 [Warning] Checking table: '.\openbiblio\member'
2017-05-12 18:10:34 2752 [ERROR] mysqld.exe: Table '.\openbiblio\member_fields' is marked as crashed and should be repaired
2017-05-12 18:10:34 2752 [Warning] Checking table: '.\openbiblio\member_fields'
2017-05-12 18:20:43 8632 [ERROR] mysqld.exe: Table '.\openbiblio\usmarc_tag_dm' is marked as crashed and should be repaired
2017-05-12 18:20:43 8632 [Warning] Checking table: '.\openbiblio\usmarc_tag_dm'
2017-05-12 18:20:43 8632 [ERROR] mysqld.exe: Table '.\openbiblio\usmarc_subfield_dm' is marked as crashed and should be repaired
2017-05-12 18:20:43 8632 [Warning] Checking table: '.\openbiblio\usmarc_subfield_dm'
[/color]
What is weird is I thought I may have shutdown while forgetting to quit XAMPP, but log erro shows time of 18h00 when I actually started the program.
Any help or advise would be welcome. We are desperate.
Thanks!!
biblioteka
 
Posts: 4
Joined: 14. May 2017 05:26
XAMPP version: 3.2.2
Operating System: Windoes 10

Re: Can't start mysql in XAMPP

Postby biblioteka » 14. May 2017 14:04

If it helps, this is log when I started up yesterday:
2017-05-13 12:33:58 264c 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.
2017-05-13 12:33:58 9804 [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.

2017-05-13 12:33:58 92800147 -[Note0]5 -I1n3n o1D2B::3 3Using mutexes to ref count buffer pool pages
:58 9488 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-05-13 12:33:58 9804 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-13 12:33:58 9488 [Note] InnoDB: The InnoDB memory heap is disabl2e017d-
05-13 12:33:58 9804 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-05-13 12:33:58 9488 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-05-13 12:33:58 9804 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2017-05-13 12:33:58 9804 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-13 12:33:58 9488 [Note] InnoDB: _mm2_l0f1e7n-c0e5(-)1 3a n1d2 :_3m3m:_5s8f e9n8c0e4( )[ Naortee ]u sIendn ofDoBr: mUesmionrgy gbeanrerriiecr
crc32 instructions
2017-05-13 12:33:58 9488 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-05-13 12:33:58 9488 [Note] InnoDB: Using generic crc32 instructions
2017-05-13 12:33:58 9804 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-05-13 12:33:58 9488 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-05-13 12:33:58 9804 [Note] InnoDB: Completed initialization of buffer pool
2017-05-13 12:33:58 9488 [Note] InnoDB: Completed initialization of buffer pool
2017-05-13 12:33:58 9488 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2017-05-13 12:33:58 9488 [ERROR] InnoDB: The system tablespace must be writable!
2017-05-13 12:33:58 9488 [ERROR] Plugin 'InnoDB' init function returned error.
2017-05-13 12:33:58 9488 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-05-13 12:33:58 9488 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-13 12:33:58 9488 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-05-13 12:33:58 9488 [ERROR] Aborting

2017-05-13 12:33:58 9804 [Note] InnoDB: Highest supported file format is Barracuda.
2017-05-13 12:33:58 21a8 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, toge2t017-h0er5 -w1i3t h1 2t:h3e3 :o5p8t i2o7nd 8inn oIdnbn_ouDsBe:_ sWyasr_nmianlgl:o cU sainndg wiintnho dtbh_ea dIdnintoiDoBn'asl _imnetme_rpnoaoll _mseimzoer yi sa lDlEoPcRaEtCoArT.E
D.2 Thi0s1 7o-p0t5i-o1n may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's3 i1n2t:e3r3n:a5l8 m8e6m1o6r y[ Naoltleo]c aItnonro.D
B: 2i0n1n7o-d0b5_-e1m3p t1y2_:f3r3e:e5_8l i1s0t2_0a0l g[oNroitteh]m Ihnanso DbBe:e ni ncnhoadnbg_eedm pttoy _lfergeaec_yl ibsetc_aaulsgeo roift hsmm ahlals bbuefefne rc hpaonogle ds itzoe .l eIgna coyr dbeercause oft os muaslel bbaucfkfoefrf ,p oionlc rseiazsee. bIunf foerr dpeoro lt oa tu slee absatc kuopf ft,o i2n0cMrBe.a
se
buffer pool at least up to 20MB.

2017-05-13 12:332:5081 78-60156- 1[3N o1t2e:]3 3I:n5n8o D1B0:2 0U0s i[nNgo tmuete]x eIsn ntooD Br:e fU scoiunngt mbuutfefxeers ptooo lr epfa gceosu
nt buffer pool pages
2017-05-13 12:33:58 8616 [Note] InnoDB: The InnoDB memory heap is disabl2e0d1
7-05-13 12:33:58 10200 [Note] InnoDB: The InnoDB memory heap is disabled
2017-05-13 12:33:58 8616 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked2 f0u1n7c-t0i5o-n1s3
12:33:58 10200 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2017-05-1230 1172-:3035:-5183 11022:0303 :[5N8o t9e8]0 4I n[nNooDtBe:] _Imnmn_olDfBe:n cTeh(e) laongd s_emqmu_esnfceen cneu(m)b earrse 1u8s3e5d0 37 and 1835037 in ibdata files do not match the log sequence number 1835097 in the ib_logfiles!
2017-05-13 12:33:58 9804 [Note] InnoDB: Database was not shutdown normally!
2017-05-13 12:33:58 9804 [Note] InnoDB: Starting crash recovery.
2017-05-13 12:33:58 9804 [Note] InnoDB: Reading tablespace information from the .ibd files...
2017-05-13 12:33:58 8616 [Note] InnoDB: _mm_lfence() anfd o_rm mm_esmfoernyc eb(a)r riaerre
used for memory barrier
2017-05-13 12:33:58 8616 [Note]2 0I1n7n-oDB: Compress05e-d1 3t a1b2l:e3s3 :u5s8e 1z0l2i0b0 1[.N2o.t3e
] InnoDB: Compressed tables use zlib 1.2.3
2017-05-13 12:33:58 8616 [Note] Inno2017-05-13 12:33:58 10200 [Note] InnoDB: Using generic crc32 instructions
DB: Using generic crc32 instructions
2017-05-13 12:33:58 10200 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-05-13 12:33:58 10200 [Note] InnoDB: Completed initialization of buffer pool
2017-05-13 12:33:58 8616 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2017-05-13 12:33:59 8616 [Note] InnoDB: Completed initialization of buffer pool
2017-05-13 12:33:59 10200 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2017-05-13 12:33:59 10200 [ERROR] InnoDB: The system tablespace must be writable!
2017-05-13 12:33:59 10200 [ERROR] Plugin 'InnoDB' init function returned error.
2017-05-13 12:33:59 10200 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-05-13 12:33:59 8616 [ERROR] InnoDB: C:\xampp\mysql\data\ibdata1 can't be opened in read-write mode
2017-05-13 12:33:59 8616 [ERROR] InnoDB: The system tablespace must be writable!
2017-05-13 12:33:59 8616 [ERROR] Plugin 'InnoDB' init function returned error.
2017-05-13 12:33:59 8616 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-05-13 12:33:59 10200 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-13 12:33:59 10200 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-05-13 12:33:59 10200 [ERROR] Aborting

2017-05-13 12:33:59 8616 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-13 12:33:59 8616 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-05-13 12:33:59 8616 [ERROR] Aborting

2017-05-13 12:33:59 9804 [Note] InnoDB: Restoring possible half-written data pages
2017-05-13 12:33:59 9804 [Note] InnoDB: from the doublewrite buffer...
2017-05-13 12:34:07 9804 [Note] InnoDB: 128 rollback segment(s) are active.
2017-05-13 12:34:07 9804 [Note] InnoDB: Waiting for purge to start
2017-05-13 12:34:07 9804 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.34-79.1 started; log sequence number 1835097
2017-05-13 12:34:07 8608 [Note] InnoDB: Dumping buffer pool(s) not yet started
Cannot find checkpoint record at LSN (1,0x20e3)

2017-05-13 12:34:07 9804 [ERROR] mysqld.exe: Aria recovery failed. Please run aria_chk -r on all Aria tables and delete all aria_log.######## files
2017-05-13 12:34:07 9804 [ERROR] Plugin 'Aria' init function returned error.
2017-05-13 12:34:07 9804 [ERROR] Plugin 'Aria' registration as a STORAGE ENGINE failed.
2017-05-13 12:34:07 9804 [Note] Plugin 'FEEDBACK' is disabled.
2017-05-13 12:34:07 9804 [ERROR] Aria engine is not enabled or did not start. The Aria engine must be enabled to continue as mysqld was configured with --with-aria-tmp-tables

2017-05-13 12:34:07 9804 [ERROR] Aborting
biblioteka
 
Posts: 4
Joined: 14. May 2017 05:26
XAMPP version: 3.2.2
Operating System: Windoes 10

Re: Can't start mysql in XAMPP

Postby biblioteka » 20. May 2017 00:44

Nevermind, I re-installed the everything back, and it works, i even copied over my back-up catalog files...but now I have a new error message...see my next posts
biblioteka
 
Posts: 4
Joined: 14. May 2017 05:26
XAMPP version: 3.2.2
Operating System: Windoes 10


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 63 guests