MySQL and Apache won't start

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

MySQL and Apache won't start

Postby milaz357 » 04. December 2016 19:46

1:42:09 PM [main] Checking for prerequisites
1:42:09 PM [main] All prerequisites found
1:42:09 PM [main] Initializing Modules
1:42:09 PM [main] Starting Check-Timer
1:42:09 PM [main] Control Panel Ready
1:42:18 PM [Apache] Attempting to start Apache service...
1:42:26 PM [mysql] Attempting to start MySQL service...
1:42:26 PM [mysql] Status change detected: running
1:42:31 PM [mysql] Status change detected: stopped
1:42:31 PM [mysql] Error: MySQL shutdown unexpectedly.
1:42:31 PM [mysql] This may be due to a blocked port, missing dependencies,
1:42:31 PM [mysql] improper privileges, a crash, or a shutdown by another method.
1:42:31 PM [mysql] Press the Logs button to view error logs and check
1:42:31 PM [mysql] the Windows Event Viewer for more clues
1:42:31 PM [mysql] If you need more help, copy and post this
1:42:31 PM [mysql] entire log window on the forums

APACHE Error LOG
[Mon May 16 18:35:08.945194 2016] [ssl:warn] [pid 3812:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon May 16 18:35:09.101332 2016] [ssl:warn] [pid 3812:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning: Module 'openssl' already loaded in Unknown on line 0
[Mon May 16 18:35:10.382945 2016] [mpm_winnt:notice] [pid 3812:tid 384] AH00455: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.20 configured -- resuming normal operations
[Mon May 16 18:35:10.382945 2016] [mpm_winnt:notice] [pid 3812:tid 384] AH00456: Apache Lounge VC11 Server built: Oct 13 2015 10:54:13
[Mon May 16 18:35:10.382945 2016] [core:notice] [pid 3812:tid 384] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Mon May 16 18:35:10.382945 2016] [mpm_winnt:notice] [pid 3812:tid 384] AH00418: Parent: Created child process 172
[Mon May 16 18:35:10.679457 2016] [ssl:warn] [pid 172:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Mon May 16 18:35:10.757582 2016] [ssl:warn] [pid 172:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning: Module 'openssl' already loaded in Unknown on line 0
[Mon May 16 18:35:10.898210 2016] [mpm_winnt:notice] [pid 172:tid 384] AH00354: Child: Starting 150 worker threads.
[Tue May 17 00:08:51.986021 2016] [ssl:warn] [pid 2920:tid 376] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue May 17 00:08:52.017276 2016] [core:warn] [pid 2920:tid 376] AH00098: pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Tue May 17 00:08:52.080273 2016] [ssl:warn] [pid 2920:tid 376] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning: Module 'openssl' already loaded in Unknown on line 0
[Tue May 17 00:08:52.908290 2016] [mpm_winnt:notice] [pid 2920:tid 376] AH00455: Apache/2.4.17 (Win32) OpenSSL/1.0.2d PHP/5.6.20 configured -- resuming normal operations
[Tue May 17 00:08:52.908290 2016] [mpm_winnt:notice] [pid 2920:tid 376] AH00456: Apache Lounge VC11 Server built: Oct 13 2015 10:54:13
[Tue May 17 00:08:52.908290 2016] [core:notice] [pid 2920:tid 376] AH00094: Command line: 'c:\\xampp\\apache\\bin\\httpd.exe -d C:/xampp/apache'
[Tue May 17 00:08:52.908290 2016] [mpm_winnt:notice] [pid 2920:tid 376] AH00418: Parent: Created child process 2872
[Tue May 17 00:08:53.236287 2016] [ssl:warn] [pid 2872:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
[Tue May 17 00:08:53.314149 2016] [ssl:warn] [pid 2872:tid 384] AH01909: www.example.com:443:0 server certificate does NOT include an ID which matches the server name
PHP Warning: Module 'openssl' already loaded in Unknown on line 0
[Tue May 17 00:08:53.501677 2016] [mpm_winnt:notice] [pid 2872:tid 384] AH00354: Child: Starting 150 worker threads.

MySQL error LOG

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

2016-05-16 18:35:16 80c 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.
2016-05-16 18:35:16 2060 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-16 18:35:16 2060 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-16 18:35:16 2060 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-16 18:35:16 2060 [Note] InnoDB: Memory barrier is not used
2016-05-16 18:35:16 2060 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-16 18:35:16 2060 [Note] InnoDB: Using generic crc32 instructions
2016-05-16 18:35:16 2060 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-16 18:35:16 2060 [Note] InnoDB: Completed initialization of buffer pool
2016-05-16 18:35:16 2060 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-16 18:35:17 2060 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-16 18:35:17 2060 [Note] InnoDB: Waiting for purge to start
2016-05-16 18:35:17 2060 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835037
2016-05-16 18:35:17 2476 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-05-16 18:35:17 2060 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-16 18:35:17 2060 [Note] Server socket created on IP: '::'.
2016-05-16 18:35:18 2060 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-05-16 18:35:52 3404 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2016-05-16 18:35:52 3404 [Note] Event Scheduler: Purging the queue. 0 events
2016-05-16 18:35:52 4004 [Note] InnoDB: FTS optimize thread exiting.
2016-05-16 18:35:52 3404 [Note] InnoDB: Starting shutdown...
2016-05-16 18:35:54 3404 [Note] InnoDB: Shutdown completed; log sequence number 1835047
2016-05-16 18:35:54 3404 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-05-17 00:08:58 c74 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.
2016-05-17 0:08:58 3188 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-05-17 0:08:58 3188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-05-17 0:08:58 3188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-05-17 0:08:58 3188 [Note] InnoDB: Memory barrier is not used
2016-05-17 0:08:58 3188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-05-17 0:08:58 3188 [Note] InnoDB: Using generic crc32 instructions
2016-05-17 0:08:58 3188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-05-17 0:08:58 3188 [Note] InnoDB: Completed initialization of buffer pool
2016-05-17 0:08:59 3188 [Note] InnoDB: Highest supported file format is Barracuda.
2016-05-17 0:09:00 3188 [Note] InnoDB: 128 rollback segment(s) are active.
2016-05-17 0:09:00 3188 [Note] InnoDB: Waiting for purge to start
2016-05-17 0:09:00 3188 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1835047
2016-05-17 0:09:00 3288 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-05-17 0:09:00 3188 [Note] Plugin 'FEEDBACK' is disabled.
2016-05-17 0:09:00 3188 [Note] Server socket created on IP: '::'.
2016-05-17 0:09:00 3188 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '10.1.13-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Start
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Start applying row log
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : End of applying row log
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Completed
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Start
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Start applying row log
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : End of applying row log
2016-05-17 0:11:12 3308 [Note] InnoDB: Online DDL : Completed

2016-05-17 0:13:12 3312 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown

2016-05-17 0:13:12 3312 [Note] Event Scheduler: Purging the queue. 0 events
2016-05-17 0:13:12 3296 [Note] InnoDB: FTS optimize thread exiting.
2016-05-17 0:13:12 3312 [Note] InnoDB: Starting shutdown...
2016-05-17 0:13:14 3312 [Note] InnoDB: Shutdown completed; log sequence number 2467619
2016-05-17 0:13:14 3312 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete


Please help. I tried changing the ports and turning off IIS but still getting this problem.
milaz357
 
Posts: 2
Joined: 04. December 2016 19:22
XAMPP version: v3.2.2
Operating System: Windows

Re: MySQL and Apache won't start

Postby Altrea » 04. December 2016 20:17

You did not provide the full control panel log contents. The first lines are missing.
The first lines contain important base information like precise XAMPP version number, Windows version, installation path, ...
Your profile info does not give any correct base information too.

So, let's start here: [Q&A] Insufficient debug information - base information
and here: [Q&A] Insufficient debug information - Apache starting issue
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: 8730
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: MySQL and Apache won't start

Postby milaz357 » 10. December 2016 17:00

10:53:22 AM [main] Initializing Control Panel
10:53:22 AM [main] Windows Version: Pro 64-bit
10:53:22 AM [main] XAMPP Version: 5.6.20
10:53:22 AM [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
10:53:22 AM [main] Running with Administrator rights - good!
10:53:22 AM [main] XAMPP Installation Directory: "c:\openemr\xampp\"
10:53:22 AM [main] Checking for prerequisites
10:53:24 AM [main] All prerequisites found
10:53:24 AM [main] Initializing Modules
10:53:24 AM [main] Starting Check-Timer
10:53:24 AM [main] Control Panel Ready
10:53:37 AM [Apache] Installing service...
10:53:49 AM [Apache] Successful!
10:53:53 AM [mysql] Installing service...
10:53:55 AM [mysql] Successful!
10:54:16 AM [Apache] Attempting to start Apache service...
10:55:22 AM [mysql] Attempting to start MySQL service...
10:55:22 AM [mysql] Status change detected: running
10:55:27 AM [mysql] Status change detected: stopped
10:55:27 AM [mysql] Error: MySQL shutdown unexpectedly.
10:55:27 AM [mysql] This may be due to a blocked port, missing dependencies,
10:55:27 AM [mysql] improper privileges, a crash, or a shutdown by another method.
10:55:27 AM [mysql] Press the Logs button to view error logs and check
10:55:27 AM [mysql] the Windows Event Viewer for more clues
10:55:27 AM [mysql] If you need more help, copy and post this
10:55:27 AM [mysql] entire log window on the forums
milaz357
 
Posts: 2
Joined: 04. December 2016 19:22
XAMPP version: v3.2.2
Operating System: Windows


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests