MySQL shutdown

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

MySQL shutdown

Postby ur_mom » 13. February 2017 21:57

So I'm a total noob and I got this error:

Error: MySQL shutdown unexpectedly.
3:58:26 PM [mysql] This may be due to a blocked port, missing dependencies,
3:58:26 PM [mysql] improper privileges, a crash, or a shutdown by another method.

No idea what to do so plz help
ur_mom
 
Posts: 2
Joined: 13. February 2017 21:55
XAMPP version: 3.2.2
Operating System: Windows

Re: MySQL shutdown

Postby Altrea » 14. February 2017 00:14

read further. The control panel gave you some hints where to look.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11935
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64

Re: MySQL shutdown

Postby ur_mom » 16. February 2017 15:29

Okay so I did that. Here is the error log for mysql, which repeats until it's aborted:

2015-11-10 15:26:56 10fc 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.
2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835027
2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2017-02-13 15:57:57 188c 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-02-13 15:57:57 6284 [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.


Here is a list of things I have tried:
Deleting ibdata1. Reappears during next install attempt.
Skype is not even logged in.
Navigating to the file that needs to open port in directory, but .exe file is not there…?
Changing the port from 3306 to 3307 in xampp\mysql\bin\my
Changing everything from xampp to xampp_new
Cmd prompt netstat -an to check if 3306 was listening, and it is. Damn it shit goddamn
Analyzed error:
Problem detected!
3:38:40 PM [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.7\bin\mysqld.exe" --defaults-file="C:\ProgramData\MySQL\MySQL Server 5.7\my.ini" MySQL57"!
3:38:40 PM [mysql] MySQL WILL NOT start without the configured ports free!
3:38:40 PM [mysql] You need to uninstall/disable/reconfigure the blocking application
3:38:40 PM [mysql] or reconfigure MySQL and the Control Panel to listen on a different port

Then tried to changed my.ini so that it was listening to a different port but I’m not allowed to edit the file… :(
Then went into services to stop the previously-installed separate mysql and got the error posted above.
ur_mom
 
Posts: 2
Joined: 13. February 2017 21:55
XAMPP version: 3.2.2
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 60 guests