My Sql Wont start

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

My Sql Wont start

Postby TheWackersKian » 31. December 2015 13:12

Hi i am trying to create a database for my arma server and it fails to start up mysql give me a log and this is what is in it pls help



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
TheWackersKian
 
Posts: 2
Joined: 31. December 2015 13:10
Operating System: Windows 10

Re: My Sql Wont start

Postby TheWackersKian » 31. December 2015 13:15

This is the log out of the atual log file 12:12:24 [mysql] Error: MySQL shutdown unexpectedly.
12:12:24 [mysql] This may be due to a blocked port, missing dependencies,
12:12:24 [mysql] improper privileges, a crash, or a shutdown by another method.
12:12:24 [mysql] Press the Logs button to view error logs and check
12:12:24 [mysql] the Windows Event Viewer for more clues
12:12:24 [mysql] If you need more help, copy and post this
12:12:24 [mysql] entire log window on the forums
TheWackersKian
 
Posts: 2
Joined: 31. December 2015 13:10
Operating System: Windows 10

Re: My Sql Wont start

Postby bruceaj » 04. January 2016 18:14

I'm having this same problem.

Attempting to start MySQL app...
11:54:26 AM [mysql] Status change detected: running
11:54:28 AM [mysql] Status change detected: stopped
11:54:28 AM [mysql] Error: MySQL shutdown unexpectedly.
11:54:28 AM [mysql] This may be due to a blocked port, missing dependencies,
11:54:28 AM [mysql] improper privileges, a crash, or a shutdown by another method.
11:54:28 AM [mysql] Press the Logs button to view error logs and check
11:54:28 AM [mysql] the Windows Event Viewer for more clues
11:54:28 AM [mysql] If you need more help, copy and post this
11:54:28 AM [mysql] entire log window on the forums

I'm running on Win-10. The above is the output when trying to start mysql via Xampp. Port 3306 is displayed before the start crashes.
bruceaj
 
Posts: 26
Joined: 15. December 2012 17:37
Operating System: Windows 8

Re: My Sql Wont start

Postby bruceaj » 06. January 2016 02:49

No one has replied to my query. Would like to know why no reply.

1) The answer is so obvious why bother?
or 2) Need more information. Be happy to supply if you'll give me a clue. I'm a newbie so my intelligence level i low.
3) No one knows the answer. I don't believe this because there's a lot smart people that know.

Greatly appreciate your help.

Bruce
bruceaj
 
Posts: 26
Joined: 15. December 2012 17:37
Operating System: Windows 8

Re: My Sql Wont start

Postby Altrea » 06. January 2016 03:07

it's 2) and the answer is already inside your log messages.
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: My Sql Wont start

Postby bruceaj » 12. January 2016 17:08

Okay. Sorry I'm in the learning phase but I don't see the problem using the MySql log file, mysql_error.log. But I've attached it below.
This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160112 10:44:48 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160112 10:44:48 [Note] InnoDB: The InnoDB memory heap is disabled
160112 10:44:48 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160112 10:44:48 [Note] InnoDB: Memory barrier is not used
160112 10:44:48 [Note] InnoDB: Compressed tables use zlib 1.2.3
160112 10:44:48 [Note] InnoDB: Not using CPU crc32 instructions
160112 10:44:48 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160112 10:44:48 [Note] InnoDB: Completed initialization of buffer pool
160112 10:44:48 [Note] InnoDB: Highest supported file format is Barracuda.
160112 10:44:48 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1672852
160112 10:44:48 [Note] InnoDB: Database was not shutdown normally!
160112 10:44:48 [Note] InnoDB: Starting crash recovery.
160112 10:44:48 [Note] InnoDB: Reading tablespace information from the .ibd files...
160112 10:44:49 [Note] InnoDB: Restoring possible half-written data pages
160112 10:44:49 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1672892
160112 10:44:49 [Note] InnoDB: 128 rollback segment(s) are active.
160112 10:44:49 [Note] InnoDB: Waiting for purge to start
160112 10:44:49 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1672892
160112 10:44:49 [Note] Plugin 'FEEDBACK' is disabled.
160112 10:44:49 [Note] Server socket created on IP: '::'.

Greatly appreciate your help.

Bruce
bruceaj
 
Posts: 26
Joined: 15. December 2012 17:37
Operating System: Windows 8


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 146 guests