mysql won't start win10

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

mysql won't start win10

Postby SWood » 07. March 2018 22:45

Today out of the blue mysql just stops running for some reason. Here is the LOG any ideas? Sorry if it's obvious i'm new to this. Thanks

2018-03-07 13:40:01 ae4 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.
2018-03-07 13:40:01 2788 [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.

2018-03-07 13:40:01 2788 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2018-03-07 13:40:01 2788 [Note] InnoDB: The InnoDB memory heap is disabled
2018-03-07 13:40:01 2788 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2018-03-07 13:40:01 2788 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2018-03-07 13:40:01 2788 [Note] InnoDB: Compressed tables use zlib 1.2.3
2018-03-07 13:40:01 2788 [Note] InnoDB: Using generic crc32 instructions
2018-03-07 13:40:01 2788 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2018-03-07 13:40:01 2788 [Note] InnoDB: Completed initialization of buffer pool
2018-03-07 13:40:01 2788 [Note] InnoDB: Highest supported file format is Barracuda.
2018-03-07 13:40:01 2788 [Note] InnoDB: The log sequence number 47050378 in ibdata file do not match the log sequence number 47050904 in the ib_logfiles!
2018-03-07 13:40:01 2788 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2018-03-07 13:40:02 2788 [Note] InnoDB: 128 rollback segment(s) are active.
2018-03-07 13:40:02 2788 [Note] InnoDB: Waiting for purge to start
2018-03-07 13:40:02 2788 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.2 started; log sequence number 47050904
2018-03-07 13:40:02 2788 [Note] Plugin 'FEEDBACK' is disabled.
2018-03-07 13:40:02 2788 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
2018-03-07 13:40:02 2788 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
2018-03-07 13:40:02 2788 [Note] Server socket created on IP: '::'.
2018-03-07 13:40:02 2788 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
SWood
 
Posts: 1
Joined: 07. March 2018 22:32
XAMPP version: 7.2.2.
Operating System: win10

Re: mysql won't start win10

Postby JJ_Tagy » 08. March 2018 11:04

Have a backup of your database? Looks like some of the data may have corrupted. I recommend not stopping MySQL with the control panel, rather use mysqladmin command line to do a clean shutdown. Can also happen if your computer is shut down while server is running.
JJ_Tagy
 
Posts: 788
Joined: 30. January 2012 13:44
XAMPP version: 5.5.15
Operating System: Windows 10 Pro x64

Re: mysql won't start win10

Postby faospark » 14. March 2018 13:21

comment out or delete innodb_additional_mem_pool_size on your my.ini configuration for mysql. a missing mysql user table can easily be solved though phpmyadmin if you have one installed.
User avatar
faospark
 
Posts: 15
Joined: 07. March 2017 11:40
XAMPP version: 7.1.1
Operating System: windows 11


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 127 guests