Problem with MySql
Posted by: incredible.100rav (101.57.148.---)
Date: March 28, 2016 08:22PM

When I run wampserver.exe , icon turns to orange but mysql doesn't run.
And give the following error:\
#2002 - No connection could be made because the target machine actively refused it.

The server is not responding (or the local server's socket is not correctly configured).

Options: ReplyQuote
Re: Problem with MySql
Posted by: RiggsFolly (Moderator)
Date: March 29, 2016 12:09AM

Hi,

please start by reding the Trouble shooting tips

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Problem with MySql
Posted by: incredible.100rav (101.56.40.---)
Date: March 29, 2016 09:16AM

I've tried everything but can't figure out. Can you help me with teamviewer ?

Options: ReplyQuote
Re: Problem with MySql
Posted by: RiggsFolly (Moderator)
Date: March 29, 2016 09:51AM

Hi,

Look at the MYSQL Error log (wampmanager -> MySQL -> Error log)

If that is empty, then look at the Windows Event Viewer (WindowsKey+R -> keyin eventvwr -> Press OK button)
Then looks for messages from MySQL

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Problem with MySql
Posted by: Otomatic (Moderator)
Date: March 29, 2016 10:15AM

Hi,

@RiggsFolly : You are really too kind!
All this is already stated in points 04, 12 and 13 of "Troubleshooting Tips" that "incredible.100rav" states have already followed.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Options: ReplyQuote
Re: Problem with MySql
Posted by: RiggsFolly (Moderator)
Date: March 29, 2016 10:45AM

Hi Oto,

Well I do try !?!?!?!?!


Oh incredible,

There are normally 2 reasons why MySQL does not start, they are :-

1. You already have a MYSQL instance running on your PC.
2. One of your INNODB datbases is corrupted.

Both are difficult to diagnose remotely, so only you can tell if point 1 is your problem

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Problem with MySql
Posted by: incredible.100rav (59.90.169.---)
Date: March 29, 2016 08:33PM

This is my sql log
2016-03-29 00:16:14 2116 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 00:16:14 2116 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 00:16:14 2116 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 00:16:14 2116 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 00:16:14 2116 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 00:16:14 2116 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 00:16:14 2116 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 00:16:14 2116 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 00:16:14 2116 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 00:16:14 2116 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 00:16:14 2116 [Note] InnoDB: Waiting for purge to start
2016-03-29 00:16:14 2116 [Note] InnoDB: 5.6.17 started; log sequence number 1625977
2016-03-29 00:16:14 2116 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 5954f573-f515-11e5-8bac-5c260a74f649.
2016-03-29 00:16:14 2116 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 00:16:14 2116 [Note] IPv6 is available.
2016-03-29 00:16:14 2116 [Note] - '::' resolves to '::';
2016-03-29 00:16:14 2116 [Note] Server socket created on IP: '::'.
2016-03-29 00:16:14 2116 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 00:16:14 2116 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 00:16:35 5436 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 00:16:35 5436 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 00:16:35 5436 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 00:16:35 5436 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 00:16:35 5436 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 00:16:35 5436 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 00:16:35 5436 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 00:16:35 5436 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 00:16:35 5436 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 00:16:35 5436 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 00:16:35 5436 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 00:16:35 5436 [Note] InnoDB: Starting crash recovery.
2016-03-29 00:16:35 5436 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 00:16:35 5436 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 00:16:35 5436 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1625987
2016-03-29 00:16:36 5436 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 00:16:36 5436 [Note] InnoDB: Waiting for purge to start
2016-03-29 00:16:36 5436 [Note] InnoDB: 5.6.17 started; log sequence number 1625987
2016-03-29 00:16:36 5436 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 00:16:36 5436 [Note] IPv6 is available.
2016-03-29 00:16:36 5436 [Note] - '::' resolves to '::';
2016-03-29 00:16:36 5436 [Note] Server socket created on IP: '::'.
2016-03-29 00:16:36 5436 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 00:16:36 5436 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 00:17:03 3640 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 00:17:03 3640 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 00:17:03 3640 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 00:17:03 3640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 00:17:03 3640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 00:17:03 3640 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 00:17:03 3640 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 00:17:03 3640 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 00:17:03 3640 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 00:17:03 3640 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 00:17:03 3640 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 00:17:03 3640 [Note] InnoDB: Starting crash recovery.
2016-03-29 00:17:03 3640 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 00:17:03 3640 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 00:17:03 3640 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1625997
2016-03-29 00:17:04 3640 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 00:17:04 3640 [Note] InnoDB: Waiting for purge to start
2016-03-29 00:17:04 3640 [Note] InnoDB: 5.6.17 started; log sequence number 1625997
2016-03-29 00:17:04 3640 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 00:17:04 3640 [Note] IPv6 is available.
2016-03-29 00:17:04 3640 [Note] - '::' resolves to '::';
2016-03-29 00:17:04 3640 [Note] Server socket created on IP: '::'.
2016-03-29 00:17:04 3640 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 00:17:04 3640 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 00:22:24 5196 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 00:22:24 5196 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 00:22:24 5196 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 00:22:24 5196 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 00:22:24 5196 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 00:22:24 5196 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 00:22:24 5196 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 00:22:24 5196 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 00:22:24 5196 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 00:22:24 5196 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 00:22:24 5196 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 00:22:24 5196 [Note] InnoDB: Starting crash recovery.
2016-03-29 00:22:24 5196 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 00:22:24 5196 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 00:22:24 5196 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626007
2016-03-29 00:22:25 5196 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 00:22:25 5196 [Note] InnoDB: Waiting for purge to start
2016-03-29 00:22:25 5196 [Note] InnoDB: 5.6.17 started; log sequence number 1626007
2016-03-29 00:22:25 5196 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 00:22:25 5196 [Note] IPv6 is available.
2016-03-29 00:22:25 5196 [Note] - '::' resolves to '::';
2016-03-29 00:22:25 5196 [Note] Server socket created on IP: '::'.
2016-03-29 00:22:25 5196 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 00:22:25 5196 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:04:02 5628 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:04:02 5628 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:04:02 5628 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:04:02 5628 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:04:02 5628 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:04:02 5628 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:04:02 5628 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:04:02 5628 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:04:02 5628 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:04:02 5628 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:04:02 5628 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:04:02 5628 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:04:02 5628 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:04:02 5628 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:04:02 5628 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626017
2016-03-29 01:04:03 5628 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:04:03 5628 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:04:03 5628 [Note] InnoDB: 5.6.17 started; log sequence number 1626017
2016-03-29 01:04:03 5628 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:04:03 5628 [Note] IPv6 is available.
2016-03-29 01:04:03 5628 [Note] - '::' resolves to '::';
2016-03-29 01:04:03 5628 [Note] Server socket created on IP: '::'.
2016-03-29 01:04:03 5628 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:04:03 5628 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:07:33 4256 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:07:33 4256 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:07:33 4256 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:07:33 4256 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:07:33 4256 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:07:33 4256 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:07:33 4256 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:07:33 4256 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:07:33 4256 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:07:33 4256 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:07:33 4256 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:07:33 4256 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:07:33 4256 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:07:33 4256 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:07:33 4256 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626027
2016-03-29 01:07:34 4256 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:07:34 4256 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:07:34 4256 [Note] InnoDB: 5.6.17 started; log sequence number 1626027
2016-03-29 01:07:34 4256 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:07:34 4256 [Note] IPv6 is available.
2016-03-29 01:07:34 4256 [Note] - '::' resolves to '::';
2016-03-29 01:07:34 4256 [Note] Server socket created on IP: '::'.
2016-03-29 01:07:34 4256 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:07:34 4256 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:08:38 5976 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:08:38 5976 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:08:38 5976 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:08:38 5976 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:08:38 5976 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:08:38 5976 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:08:38 5976 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:08:38 5976 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:08:38 5976 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:08:38 5976 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:08:38 5976 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:08:38 5976 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:08:38 5976 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:08:38 5976 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:08:38 5976 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626037
2016-03-29 01:08:38 5976 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:08:38 5976 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:08:38 5976 [Note] InnoDB: 5.6.17 started; log sequence number 1626037
2016-03-29 01:08:38 5976 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:08:38 5976 [Note] IPv6 is available.
2016-03-29 01:08:38 5976 [Note] - '::' resolves to '::';
2016-03-29 01:08:38 5976 [Note] Server socket created on IP: '::'.
2016-03-29 01:08:38 5976 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:08:38 5976 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:21:23 2484 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:21:23 2484 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:21:23 2484 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:21:23 2484 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:21:23 2484 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:21:23 2484 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:21:23 2484 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:21:23 2484 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:21:23 2484 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:21:23 2484 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:21:23 2484 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:21:23 2484 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:21:23 2484 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:21:23 2484 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:21:23 2484 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626047
2016-03-29 01:21:23 2484 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:21:23 2484 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:21:23 2484 [Note] InnoDB: 5.6.17 started; log sequence number 1626047
2016-03-29 01:21:23 2484 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:21:23 2484 [Note] IPv6 is available.
2016-03-29 01:21:23 2484 [Note] - '::' resolves to '::';
2016-03-29 01:21:23 2484 [Note] Server socket created on IP: '::'.
2016-03-29 01:21:24 2484 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:21:24 2484 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:23:29 1248 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:23:29 1248 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:23:29 1248 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:23:29 1248 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:23:29 1248 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:23:29 1248 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:23:29 1248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:23:29 1248 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:23:29 1248 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:23:29 1248 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:23:29 1248 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:23:29 1248 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:23:29 1248 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:23:29 1248 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:23:29 1248 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626057
2016-03-29 01:23:30 1248 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:23:30 1248 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:23:30 1248 [Note] InnoDB: 5.6.17 started; log sequence number 1626057
2016-03-29 01:23:30 1248 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:23:30 1248 [Note] IPv6 is available.
2016-03-29 01:23:30 1248 [Note] - '::' resolves to '::';
2016-03-29 01:23:30 1248 [Note] Server socket created on IP: '::'.
2016-03-29 01:23:30 1248 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:23:30 1248 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:23:39 6080 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:23:39 6080 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:23:39 6080 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:23:39 6080 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:23:39 6080 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:23:39 6080 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:23:39 6080 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:23:39 6080 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:23:39 6080 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:23:39 6080 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:23:39 6080 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:23:39 6080 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:23:39 6080 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:23:39 6080 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:23:39 6080 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626067
2016-03-29 01:23:39 6080 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:23:40 6080 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:23:40 6080 [Note] InnoDB: 5.6.17 started; log sequence number 1626067
2016-03-29 01:23:40 6080 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:23:40 6080 [Note] IPv6 is available.
2016-03-29 01:23:40 6080 [Note] - '::' resolves to '::';
2016-03-29 01:23:40 6080 [Note] Server socket created on IP: '::'.
2016-03-29 01:23:40 6080 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:23:40 6080 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-29 01:24:55 4708 [Note] Plugin 'FEDERATED' is disabled.
2016-03-29 01:24:55 4708 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-29 01:24:55 4708 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-29 01:24:55 4708 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-29 01:24:55 4708 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-29 01:24:55 4708 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-29 01:24:55 4708 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-29 01:24:55 4708 [Note] InnoDB: Completed initialization of buffer pool
2016-03-29 01:24:55 4708 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-29 01:24:55 4708 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-29 01:24:55 4708 [Note] InnoDB: Database was not shutdown normally!
2016-03-29 01:24:55 4708 [Note] InnoDB: Starting crash recovery.
2016-03-29 01:24:55 4708 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-29 01:24:55 4708 [Note] InnoDB: Restoring possible half-written data pages
2016-03-29 01:24:55 4708 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626077
2016-03-29 01:24:55 4708 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-29 01:24:56 4708 [Note] InnoDB: Waiting for purge to start
2016-03-29 01:24:56 4708 [Note] InnoDB: 5.6.17 started; log sequence number 1626077
2016-03-29 01:24:56 4708 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-29 01:24:56 4708 [Note] IPv6 is available.
2016-03-29 01:24:56 4708 [Note] - '::' resolves to '::';
2016-03-29 01:24:56 4708 [Note] Server socket created on IP: '::'.
2016-03-29 01:24:56 4708 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-29 01:24:56 4708 [ERROR] Can't start server: can't create PID file: Invalid argument
2016-03-30 00:00:26 7908 [Note] Plugin 'FEDERATED' is disabled.
2016-03-30 00:00:26 7908 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-03-30 00:00:26 7908 [Note] InnoDB: The InnoDB memory heap is disabled
2016-03-30 00:00:26 7908 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-03-30 00:00:26 7908 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-03-30 00:00:26 7908 [Note] InnoDB: Not using CPU crc32 instructions
2016-03-30 00:00:26 7908 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2016-03-30 00:00:26 7908 [Note] InnoDB: Completed initialization of buffer pool
2016-03-30 00:00:26 7908 [Note] InnoDB: Highest supported file format is Barracuda.
2016-03-30 00:00:26 7908 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1625977
2016-03-30 00:00:26 7908 [Note] InnoDB: Database was not shutdown normally!
2016-03-30 00:00:26 7908 [Note] InnoDB: Starting crash recovery.
2016-03-30 00:00:26 7908 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-03-30 00:00:26 7908 [Note] InnoDB: Restoring possible half-written data pages
2016-03-30 00:00:26 7908 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1626087
2016-03-30 00:00:27 7908 [Note] InnoDB: 128 rollback segment(s) are active.
2016-03-30 00:00:27 7908 [Note] InnoDB: Waiting for purge to start
2016-03-30 00:00:27 7908 [Note] InnoDB: 5.6.17 started; log sequence number 1626087
2016-03-30 00:00:27 7908 [Note] Server hostname (bind-address): '*'; port: 3306
2016-03-30 00:00:27 7908 [Note] IPv6 is available.
2016-03-30 00:00:27 7908 [Note] - '::' resolves to '::';
2016-03-30 00:00:27 7908 [Note] Server socket created on IP: '::'.
2016-03-30 00:00:27 7908 [ERROR] wampmysqld: Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid' (Errcode: 22 - Invalid argument)
2016-03-30 00:00:27 7908 [ERROR] Can't start server: can't create PID file: Invalid argument

Options: ReplyQuote
Re: Problem with MySql
Posted by: RiggsFolly (Moderator)
Date: March 30, 2016 12:32AM

This is yor problem

Can't create/write to file 'c:\wamp\bin\mysql\mysql5.6.17\data\s?u??v.pid'

The pid file uses your machine name as the file name (s?u??v) so if you give your PC a name that contains just simple ascii characters it should work.

I am assuming you are either using an odd character set or have set your machine name to something very odd.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote


Sorry, only registered users may post in this forum.