Error in mysql in wamp and on a wordpress website.
Posted by: unuz (109.175.108.---)
Date: November 22, 2013 06:12AM

I am working on a wordpress website locally, and mysql is going offline on visit some of posts/pages.

I have following error in mysql log:

2013-11-22 05:50:24 6404 [Note] Plugin 'FEDERATED' is disabled.
2013-11-22 05:50:24 6404 [Note] InnoDB: The InnoDB memory heap is disabled
2013-11-22 05:50:24 6404 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2013-11-22 05:50:24 6404 [Note] InnoDB: Compressed tables use zlib 1.2.3
2013-11-22 05:50:24 6404 [Note] InnoDB: Not using CPU crc32 instructions
2013-11-22 05:50:24 6404 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2013-11-22 05:50:24 6404 [Note] InnoDB: Completed initialization of buffer pool
2013-11-22 05:50:24 6404 [Note] InnoDB: Highest supported file format is Barracuda.
2013-11-22 05:50:24 6404 [Note] InnoDB: 128 rollback segment(s) are active.
2013-11-22 05:50:24 6404 [Note] InnoDB: Waiting for purge to start
2013-11-22 05:50:24 6404 [Note] InnoDB: 5.6.12 started; log sequence number 189490334
2013-11-22 05:50:25 6404 [Note] Server hostname (bind-address): '*'; port: 3306
2013-11-22 05:50:25 6404 [Note] IPv6 is available.
2013-11-22 05:50:25 6404 [Note] - '::' resolves to '::';
2013-11-22 05:50:25 6404 [Note] Server socket created on IP: '::'.
2013-11-22 05:50:25 6404 [Note] Event Scheduler: Loaded 0 events
2013-11-22 05:50:25 6404 [Note] wampmysqld: ready for connections.
Version: '5.6.12-log' socket: '' port: 3306 MySQL Community Server (GPL)
2013-11-22 05:50:26 1740 InnoDB: Assertion failure in thread 5952 in file fts0que.cc line 2993
InnoDB: Failing assertion: ret == 0
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to [bugs.mysql.com].
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: [dev.mysql.com]
InnoDB: about forcing recovery.

Options: ReplyQuote
Re: Error in mysql in wamp and on a wordpress website.
Posted by: RiggsFolly (---.ppp.as43234.net)
Date: November 22, 2013 12:40PM

More specific information please.

Version of Operating system?
Version of Wamp Server installed?
Version of Apache you are running?
Version of MySQL you are running?
Version of PHP you are running?

What colour is your WampManager icon? ( in the system tray )


Have you done as suggested in the message InnoDB: [dev.mysql.com]

---------------------------------------------------------------------------------------------
(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.