Error: MySQL shutdown unexpectedly.

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

Error: MySQL shutdown unexpectedly.

Postby Titakuro » 21. February 2020 17:49

Hello,

I’ve had this error since today and i don't know why..
Can someone help me ?

logs
Code: Select all
2020-02-21 17:41:28 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2020-02-21 17:41:28 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2020-02-21 17:41:28 0 [Note] InnoDB: Uses event mutexes
2020-02-21 17:41:28 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2020-02-21 17:41:28 0 [Note] InnoDB: Number of pools: 1
2020-02-21 17:41:28 0 [Note] InnoDB: Using SSE2 crc32 instructions
2020-02-21 17:41:28 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2020-02-21 17:41:28 0 [Note] InnoDB: Completed initialization of buffer pool
2020-02-21 17:41:28 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibdata1' size to 10 MB. Physically writing the file full; Please wait ...
2020-02-21 17:41:28 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibdata1' size is now 10 MB.
2020-02-21 17:41:28 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5242880 bytes
2020-02-21 17:41:28 0 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile1 size to 5242880 bytes
2020-02-21 17:41:28 0 [Note] InnoDB: Renaming log file C:\xampp\mysql\data\ib_logfile101 to C:\xampp\mysql\data\ib_logfile0
2020-02-21 17:41:28 0 [Note] InnoDB: New log files created, LSN=11452
2020-02-21 17:41:28 0 [Note] InnoDB: Doublewrite buffer not found: creating new
2020-02-21 17:41:28 0 [Note] InnoDB: Doublewrite buffer created
2020-02-21 17:41:28 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2020-02-21 17:41:28 0 [Note] InnoDB: Creating foreign key constraint system tables.
2020-02-21 17:41:28 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2020-02-21 17:41:28 0 [Note] InnoDB: Creating sys_virtual system tables.
2020-02-21 17:41:29 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2020-02-21 17:41:29 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2020-02-21 17:41:29 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2020-02-21 17:41:29 0 [Note] InnoDB: Waiting for purge to start
2020-02-21 17:41:29 0 [Note] InnoDB: 10.4.11 started; log sequence number 0; transaction id 7
2020-02-21 17:41:29 0 [Note] Plugin 'FEEDBACK' is disabled.
2020-02-21 17:41:29 0 [Note] Server socket created on IP: '::'.
Titakuro
 
Posts: 1
Joined: 21. February 2020 17:44
XAMPP version: 3.2.4
Operating System: Windows

Re: Error: MySQL shutdown unexpectedly.

Postby NormB » 24. February 2020 15:05

Yes I have suddenly got this, anyone any ideas?
NormB
 
Posts: 7
Joined: 07. January 2013 22:29
XAMPP version: 7.4.2
Operating System: Windows 10

Re: Error: MySQL shutdown unexpectedly.

Postby NormB » 24. February 2020 15:22

I was on the latest 7.4.2 , I have gone back to 7.4.1 and it is ok.
NormB
 
Posts: 7
Joined: 07. January 2013 22:29
XAMPP version: 7.4.2
Operating System: Windows 10

Re: Error: MySQL shutdown unexpectedly.

Postby Drachsi » 25. February 2020 15:39

I have the same problem. This morning it worked, I shut down the pc, and 4 hours later restarted and the MYsql fails to load.
Is 7.4.2 really stable, maybe after a few days it will also stop.

Really appreciate this problem being treated as a matter of urgency.

Regards
Drachsi
Drachsi
 
Posts: 38
Joined: 09. August 2010 07:18

Re: Error: MySQL shutdown unexpectedly.

Postby Nobbie » 25. February 2020 16:08

Drachsi wrote:Really appreciate this problem being treated as a matter of urgency.


Then you really *should* provide that info to the MariaDB development, not to Bitnami. You must not forget, Bitnami does not do any software development, they "only" build packages of programs. The development and bug fixes are done by the development teams (i.e. https://mariadb.org/).
Nobbie
 
Posts: 11620
Joined: 09. March 2008 13:04

Re: Error: MySQL shutdown unexpectedly.

Postby Drachsi » 25. February 2020 16:47

Hi, really appreciate the info. Did not know. Hopefully they also see these posts?

Regards
Northampton
Drachsi
 
Posts: 38
Joined: 09. August 2010 07:18

Re: Error: MySQL shutdown unexpectedly.

Postby Nobbie » 25. February 2020 19:22

Drachsi wrote: Hopefully they also see these posts?


No, definately NOT! This is only one of many many many distributions which distributes MariaDB. Therefore i told you, its ON YOU to provide your problems directly to MariaDB team. Only "hoping" is by far not enough.
Nobbie
 
Posts: 11620
Joined: 09. March 2008 13:04

Re: Error: MySQL shutdown unexpectedly.

Postby Drachsi » 27. February 2020 07:01

Maybe as a number of the latest versions of Xampp all use MariaDB 10.4.11, it is not the DB at all? only the result.

Drachsi
Drachsi
 
Posts: 38
Joined: 09. August 2010 07:18

Re: Error: MySQL shutdown unexpectedly.

Postby storman » 10. March 2020 16:31

I am facing the same error. seems it is not my case only
Image
storman
 
Posts: 5
Joined: 06. March 2020 18:58
XAMPP version: 3.2.4
Operating System: Windows 10 64 bit

Re: Error: MySQL shutdown unexpectedly.

Postby Alexar89 » 18. March 2020 21:52

Hi, I test with the following steps and this work for me:

1. Installing a second Xampp and rename the folder of installation to: xampp2, them you can installing all.

2. copy and paste to the new installation folder of xampp2 the following folders: mysql, htdocs from the other xampp folder that is fail, and close all Xampp folder. After you can start the xampp again but you need go to the new folder xampp2 and execute the xamp-control-panel of new xampp2 folder and the mysql work again.

3. take a backup of your databases for the future.
Alexar89
 
Posts: 1
Joined: 18. March 2020 21:45
XAMPP version: 3.2.4
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 75 guests