Windows Server 2003/MySQL help needed - Nottingham
Discussion
Ok - a plea for some help here!
Need some urgent help with server problems we're having with Windows Server 2003, in particular IIS 6 and MySQL 4.1
We've had an intermittent problem with MySQL stopping responding and causing all websites that use it to fail. I really need someone to come in and take a look at our setup and get some diagnostic stuff going so we can trace the cause of the failure. I'm really out of my depth with this and just don't have the time to get up to speed.
If anyone here can help, or knows someone who can - they *really* need to know their stuff - then get in touch with me at pete[at]metafocus.co.uk and give me an idea of costs.
Need some urgent help with server problems we're having with Windows Server 2003, in particular IIS 6 and MySQL 4.1
We've had an intermittent problem with MySQL stopping responding and causing all websites that use it to fail. I really need someone to come in and take a look at our setup and get some diagnostic stuff going so we can trace the cause of the failure. I'm really out of my depth with this and just don't have the time to get up to speed.
If anyone here can help, or knows someone who can - they *really* need to know their stuff - then get in touch with me at pete[at]metafocus.co.uk and give me an idea of costs.
Have you looked in the MySQL error logs? Or the Event logs on the server?
On the server there will be a file in the MySQL data directory called *.err (where * is the mysql instance name). Have a look in the file and see if there is any useful info. Post it up (or pm it to me) if you like and I'll have a look. I run a couple of servers with the same setup so I might be able to offer some advice at least.
On the server there will be a file in the MySQL data directory called *.err (where * is the mysql instance name). Have a look in the file and see if there is any useful info. Post it up (or pm it to me) if you like and I'll have a look. I run a couple of servers with the same setup so I might be able to offer some advice at least.
Thanks for the offer 
Unfortunately the logs don't seem to be much help in this. Yes there are error entries in both the MySQL and Windows logs, but nothing specific enough to track down the cause of the problem. This is why I'm looking to get someone in who can get on the server and have a good look at the setup and get some diagnostic/debug stuff set up.
I noticed in the Windows system error logs one of the application pools sometimes wasn't shutting down properly when it recycled, so I've moved each site in that application pool into a new app pool. When the server went down this morning I found the following error in the windows log:
A process serving application pool 'Test2' exceeded time limits during shut down. The process id was '4020'.
No idea whether that's a red herring or not, but that's about all I've got. The MySQL err.log has lots of aborted connection warnings but from what I've been able to find this *is* a red herring and refers to connections timing out normally.
Just had the D/B lock up again and there's nothing it either logs for the past hour except the start-up messages.
Unfortunately the logs don't seem to be much help in this. Yes there are error entries in both the MySQL and Windows logs, but nothing specific enough to track down the cause of the problem. This is why I'm looking to get someone in who can get on the server and have a good look at the setup and get some diagnostic/debug stuff set up. I noticed in the Windows system error logs one of the application pools sometimes wasn't shutting down properly when it recycled, so I've moved each site in that application pool into a new app pool. When the server went down this morning I found the following error in the windows log:
Windows error log said:
A process serving application pool 'Test2' exceeded time limits during shut down. The process id was '4020'.
No idea whether that's a red herring or not, but that's about all I've got. The MySQL err.log has lots of aborted connection warnings but from what I've been able to find this *is* a red herring and refers to connections timing out normally.
Just had the D/B lock up again and there's nothing it either logs for the past hour except the start-up messages.
Probably not a red herring....
http://support.microsoft.com/kb/82126
How to find out why it is hanging...
http://support.microsoft.com/kb/91979
http://support.microsoft.com/kb/82126
How to find out why it is hanging...
http://support.microsoft.com/kb/91979
BliarOut.
Todays top tip, always keep a spare profile hanging around in case of a posting emergency.
Todays top tip, always keep a spare profile hanging around in case of a posting emergency.
It sounds as though it's more to do with the IIS side of things than the MySQL database. I'd guess the first thing to check is the website code that's running is correctly closing the database connections as it's running and not leaving them hanging open, that's the most obvious thing.
As an outside chance what version of MySQL are you running? I do remember when we were running v3.23 (I think!) the database was leaving connections open even after they were specifically closed in the code, this then caused problems down the line when it ran out of fresh connections to use. If it's version older than 4 it might be worth upgrading to 4 at least.
Hope that helps at least!
As an outside chance what version of MySQL are you running? I do remember when we were running v3.23 (I think!) the database was leaving connections open even after they were specifically closed in the code, this then caused problems down the line when it ran out of fresh connections to use. If it's version older than 4 it might be worth upgrading to 4 at least.
Hope that helps at least!
TonyOut said:
Probably not a red herring....
http://support.microsoft.com/kb/82126
How to find out why it is hanging...
http://support.microsoft.com/kb/91979
http://support.microsoft.com/kb/82126
How to find out why it is hanging...
http://support.microsoft.com/kb/91979
BliarOut.
Todays top tip, always keep a spare profile hanging around in case of a posting emergency.
Todays top tip, always keep a spare profile hanging around in case of a posting emergency.
Yep - that's exactly the kind of thing I need. Now all I need is someone who has the time to do it and make sense of the results...
Rob - pop over and sort it for me and I promise to stop ribbing you about the time Tracy trashed you on the drift day 
Edited by judas on Monday 5th February 17:05
silent k said:
It sounds as though it's more to do with the IIS side of things than the MySQL database. I'd guess the first thing to check is the website code that's running is correctly closing the database connections as it's running and not leaving them hanging open, that's the most obvious thing.
As an outside chance what version of MySQL are you running? I do remember when we were running v3.23 (I think!) the database was leaving connections open even after they were specifically closed in the code, this then caused problems down the line when it ran out of fresh connections to use. If it's version older than 4 it might be worth upgrading to 4 at least.
Hope that helps at least!
As an outside chance what version of MySQL are you running? I do remember when we were running v3.23 (I think!) the database was leaving connections open even after they were specifically closed in the code, this then caused problems down the line when it ran out of fresh connections to use. If it's version older than 4 it might be worth upgrading to 4 at least.
Hope that helps at least!
MySQL is version 4.1.7
There are rather a lot of websites running on the server, so trawling though the source code of all of them to track down which is causing the problem is not an option
Also, anyone know any decent (free!) log viewers that will open a 4gb+ sized file? Just found the MySQL query log and it's a bit too big for notepad!
judas said:
TonyOut said:
Probably not a red herring....
http://support.microsoft.com/kb/82126
How to find out why it is hanging...
http://support.microsoft.com/kb/91979
http://support.microsoft.com/kb/82126
How to find out why it is hanging...
http://support.microsoft.com/kb/91979
BliarOut.
Todays top tip, always keep a spare profile hanging around in case of a posting emergency.
Todays top tip, always keep a spare profile hanging around in case of a posting emergency.
Yep - that's exactly the kind of thing I need. Now all I need is someone who has the time to do it and make sense of the results...
Rob - pop over and sort it for me and I promise to stop ribbing you about the time Tracy trashed you on the drift day
Edited by judas on Monday 5th February 17:05
I've lost three stone since then
I can have a look at it tomorrow remotely from here if you can't get it sorted before then. I'll be free from late AM onwards.
www.networkingsupportservices.co.u is my new baby if you're interested. We normally work on monthly maintenance but I'm sure I can work out a no-fix no-fee way of doing things...
judas said:
Also, anyone know any decent (free!) log viewers that will open a 4gb+ sized file? Just found the MySQL query log and it's a bit too big for notepad!
There's a prog called V-Edit (or just V) that should be able to open a file 4gb in size, very fast. Takes a while to save though if you edit a file that big.
tigger1 said:
judas said:
Also, anyone know any decent (free!) log viewers that will open a 4gb+ sized file? Just found the MySQL query log and it's a bit too big for notepad!
There's a prog called V-Edit (or just V) that should be able to open a file 4gb in size, very fast. Takes a while to save though if you edit a file that big.
Er, just looked at the price of the version that will open files over 2 gig - $239! That's a lot of money for a glorified text editor!
judas said:
tigger1 said:
judas said:
Also, anyone know any decent (free!) log viewers that will open a 4gb+ sized file? Just found the MySQL query log and it's a bit too big for notepad!
There's a prog called V-Edit (or just V) that should be able to open a file 4gb in size, very fast. Takes a while to save though if you edit a file that big.
Er, just looked at the price of the version that will open files over 2 gig - $239! That's a lot of money for a glorified text editor!
Sorry, I urrmmmm..."the company" must have bought a license before I joined...
Possibly worth looking for just "V"...doesn't edit though.
www.fileviewer.com/
Think it's only $20 by the look of it. If you need to view files that big then it's worth it.
Failing that, if it's plain text, you could write something (? .net) that splits a file into chunks?
Gassing Station | Computers, Gadgets & Stuff | Top of Page | What's New | My Stuff