Mysql stops working after a day or two

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Mysql stops working after a day or two

Postby bhosdk.durkheim » 08. August 2013 06:48

I have installed Xampp 1.8.1 on Windows 7 and my apache and mysql are apparently running fine. But after running for one or two days, mysql suddenly stops working. But at the xampp control panel, it is still showing green on the mysql item. I can fix this just by stopping and restarting mysql from the xampp control panel. Then it will again work fine and the situation will occur again in a day or two and I have to keep doing this (stopping mysql and restarting). How can I fix this problem permanently.

mysql error log is given below...

130804 12:49:09 [Note] Plugin 'FEDERATED' is disabled.
130804 12:49:09 InnoDB: The InnoDB memory heap is disabled
130804 12:49:09 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130804 12:49:09 InnoDB: Compressed tables use zlib 1.2.3
130804 12:49:09 InnoDB: Initializing buffer pool, size = 16.0M
130804 12:49:09 InnoDB: Completed initialization of buffer pool
130804 12:49:09 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130804 12:49:09 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130804 12:49:14 InnoDB: Waiting for the background threads to start
130804 12:49:15 InnoDB: 1.1.8 started; log sequence number 1595675
130804 12:49:15 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130804 12:49:15 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130804 12:49:15 [Note] Server socket created on IP: '0.0.0.0'.
130804 12:49:16 [Note] Event Scheduler: Loaded 0 events
130804 12:49:16 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)
130805 17:45:20 [Note] Plugin 'FEDERATED' is disabled.
130805 17:45:20 InnoDB: The InnoDB memory heap is disabled
130805 17:45:20 InnoDB: Mutexes and rw_locks use Windows interlocked functions
130805 17:45:20 InnoDB: Compressed tables use zlib 1.2.3
130805 17:45:20 InnoDB: Initializing buffer pool, size = 16.0M
130805 17:45:20 InnoDB: Completed initialization of buffer pool
130805 17:45:20 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
130805 17:45:20 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
130805 17:45:20 InnoDB: Waiting for the background threads to start
130805 17:45:21 InnoDB: 1.1.8 started; log sequence number 1595675
130805 17:45:21 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
130805 17:45:21 [Note] - '0.0.0.0' resolves to '0.0.0.0';
130805 17:45:21 [Note] Server socket created on IP: '0.0.0.0'.
130805 17:45:21 [Note] Event Scheduler: Loaded 0 events
130805 17:45:21 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.5.27' socket: '' port: 3306 MySQL Community Server (GPL)


The Xampp control panel log is here...

12:49:06 PM [main] Initializing Control Panel
12:49:06 PM [main] Windows Version: Windows 7 Ultimate 64-bit
12:49:06 PM [main] XAMPP Version: 1.8.1
12:49:06 PM [main] Control Panel Version: 3.1.0 3.1.0 [ Compiled: September 20th 2012 ]
12:49:06 PM [main] Running with Administrator rights - good!
12:49:06 PM [main] XAMPP Installation Directory: "c:\xampp\"
12:49:06 PM [main] Checking for prerequisites
12:49:07 PM [main] All prerequisites found
12:49:07 PM [main] Initializing Modules
12:49:07 PM [main] Enabling autostart for module "Apache"
12:49:07 PM [main] Enabling autostart for module "MySQL"
12:49:07 PM [main] Enabling autostart for module "FileZilla"
12:49:07 PM [main] Starting Check-Timer
12:49:07 PM [main] Control Panel Ready
12:49:08 PM [Apache] Autostart active: starting...
12:49:08 PM [Apache] Attempting to start Apache app...
12:49:08 PM [mysql] Autostart active: starting...
12:49:08 PM [mysql] Attempting to start MySQL app...
12:49:08 PM [filezilla] Autostart active: starting...
12:49:08 PM [filezilla] Attempting to start FileZilla app...
12:49:09 PM [Apache] Status change detected: running
12:49:09 PM [mysql] Status change detected: running
12:49:09 PM [filezilla] Status change detected: running
5:45:18 PM [mysql] Attempting to stop MySQL (PID: 3484)
5:45:18 PM [mysql] Status change detected: stopped
5:45:20 PM [mysql] Attempting to start MySQL app...
5:45:20 PM [mysql] Status change detected: running


I tried to click on the red cross beside mysql to run it as a service, the problem still remains. Thanks in advance for your help.
bhosdk.durkheim
 
Posts: 2
Joined: 08. August 2013 06:27
Operating System: Windows 7

Re: Mysql stops working after a day or two

Postby Altrea » 08. August 2013 08:58

We need information about how do you know that MySQL stops working.
What do you get? Error 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: 8294
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: Mysql stops working after a day or two

Postby bhosdk.durkheim » 08. August 2013 10:47

1. Whenever a php on that server tries to access mysql it cannot connect, and the error message is showing
"Warning: mysql_connect(): Can't create a new thread (errno -1); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug in C:\xampp\htdocs\include\common.php on line 10"
The php's in general are running fine, except whenever it is trying to connect mysql it fails. After stopping mysql and restarting, the problem goes away (but again returns in a day or two).

2. When I try to login into the phpMyAdmin, it is showing the following error.
"#1135 Cannot log in to the MySQL server"

Thank you.
bhosdk.durkheim
 
Posts: 2
Joined: 08. August 2013 06:27
Operating System: Windows 7


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 3 guests