mySQL randomly shutting down. Reason unknown.

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

mySQL randomly shutting down. Reason unknown.

Postby oppdelta » 08. March 2012 01:43

Hello, been having this problem for a few days now.

As of late, I started up the SQL service. Could connect to DB's fine and dandy. Then (here's the random part), within a 5 minutes - 3 hours time-frame. It will suddenly, stop. No reason...I've tried it on a different port. (3336) to see if it was a port collision error. It still randomly shut down on the new port.

I then got to thinking it could be just overflowing...it is being sent around

I would of checked in the mySQL logs...but I haven't a clue where that is...

Also is there a way to increase the amount of queries an such a second? I checked in the many config files and it mentions "These are the standard settings for a small server".
What I require is something a little more demanding than 1 query a second...

I've come to the conclusion the SQL must be overflowing. Since I've left it on, with nothing connected to it, over night and it didn't randomly shut down, until I started up the program that needs the SQL database, in which the SQL shutdown 30 minutes later.

Never had this problem until last week. But I have put a greater strain on the SQL since then...

Xampp: 1.7.7
oppdelta
 
Posts: 4
Joined: 08. March 2012 01:33
Operating System: Windows Server 2008 R2 Standar

Re: mySQL randomly shutting down. Reason unknown.

Postby Sharley » 08. March 2012 01:52

Would you be so kind as to add your Windows version to your profile please as just Windows tells us nothing:
viewtopic.php?f=16&t=48626
Thanks. :)

The log files are in \xampp\mysql\data folder and some template type ini files are in \xampp\mysql which you can read with a view to adjusting the my.ini file in the \xampp\mysql\bin folder - do not use those sample ini files but rather use them to give you some ideas that may help your problem and always make a back up of any configuration files you may edit so you have a point you can revert to.

Also another place to look that may have a clue is in the Windows Event viewer under Applications.

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: mySQL randomly shutting down. Reason unknown.

Postby oppdelta » 08. March 2012 02:11

OS: Windows Server 2008 R2 Standard

Just tried the "large" ini config.

Just this second stopped again.

Log: (Using the default me.ini)

www.pastebin.com/6WusderF


EDIT: It's not being overtaxed. Just found out. It randomly crashed 15 minutes after using the large template. And it was only receiving 3 queries a second.
oppdelta
 
Posts: 4
Joined: 08. March 2012 01:33
Operating System: Windows Server 2008 R2 Standar

Re: mySQL randomly shutting down. Reason unknown.

Postby Sharley » 08. March 2012 02:33

Open \xampp\php\php.ini file in your text editor and find this line and change from 60 to this
Code: Select all
max_input_time = 300
and this line change it also to read
Code: Select all
max_execution_time = 300
Save the file and restart Apache and MySQL and try again.

Let me know if it helps. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: mySQL randomly shutting down. Reason unknown.

Postby oppdelta » 08. March 2012 02:41

I shall do that. But wont be able to get a result until tomorrow.

I left the forum support a little to late in the day. It's 2am and I don't want to wait around 5mins - 3 hours to see if it shuts down. I shall test it out tomorrow.

Thank you for the support.
oppdelta
 
Posts: 4
Joined: 08. March 2012 01:33
Operating System: Windows Server 2008 R2 Standar

Re: mySQL randomly shutting down. Reason unknown.

Postby Sharley » 08. March 2012 02:47

Also these may be worth a read:
Google Search Results
as it seems you are not alone with this tussle between MySQL and Server 2k8 but the solutions seem yet to be positively found.

If the above fails to help then perhaps save your own data and remove this XAMPP installation and try again using a different method - zip or 7zip for example as per these instructions:
viewtopic.php?p=179699#p179699

Don't forget to add your correct Operating System to your profile as it is important.

Sleep well and my best wishes. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: mySQL randomly shutting down. Reason unknown.

Postby oppdelta » 08. March 2012 16:54

Still having the problems.

Even ramped it up to 600 on both of them.

Then tried -1. Still getting error code 6.

Tried WAMP...getting the same errors on that program to...I'm guessing it's a OS problem.
oppdelta
 
Posts: 4
Joined: 08. March 2012 01:33
Operating System: Windows Server 2008 R2 Standar

Re: mySQL randomly shutting down. Reason unknown.

Postby Sharley » 08. March 2012 23:23

There was a possible fix in this thread for a similar stopping issue with Apache that may help:
viewtopic.php?f=16&t=50090#p193124

Good luck. :)
User avatar
Sharley
AF Moderator
 
Posts: 3316
Joined: 03. October 2008 05:10
Location: Yeppoon, Australia Time Zone: GMT/UTC+10
Operating System: Win 7 Pro 32bit/XP Pro SP3

Re: mySQL randomly shutting down. Reason unknown.

Postby hackattack142 » 09. March 2012 00:20

Error code 6 in this case (from looking at your log file) is related to invalid file handles which is quite strange. Is this an isolated issue (just mysql) or have you noticed similar problems with other programs? Are there any similar errors in your Windows Event viewer (Start > Run > eventvwr > Windows Logs > Application)?
XAMPP Control Panel Developer
Latest CP: viewtopic.php?f=16&t=48932
hackattack142
 
Posts: 701
Joined: 20. May 2011 23:29
Operating System: Windows 7 Ultimate SP1 64-Bit


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 139 guests