3 messages in com.mysql.lists.win32Re: MySQL on Windows2003 crashes| From | Sent On | Attachments |
|---|---|---|
| Andrej Kudriavcev (CITRUS) | 29 Oct 2004 00:08 | |
| Andrej Kudriavcev (CITRUS) | 29 Oct 2004 08:23 | |
| Nurse, Robert (Cont, ARL/CISD) | 29 Oct 2004 08:41 |
| Subject: | Re: MySQL on Windows2003 crashes |
|---|---|
| From: | Andrej Kudriavcev (CITRUS) (and...@citrus.lt) |
| Date: | 10/29/2004 08:23:36 AM |
| List: | com.mysql.lists.win32 |
I feel, you got me wrong. The box itself don't crashes. But, evaluating W2003 messages log I found a coulpe of messages, about MySQL service, PHP executable and ColdFusion service crashes. The box continue running, MySQL service is set to restart aftrer crach, and it do. But last time MySQL service crash in the middle of insert/update query, so I got to unlock one table manualy with "repare table". That's is not good.
Solution could be if I configure MySQL to automaticly repair all tables after crash. Any idea on how to do that? I was unable find anything about that in the docs :(
But I still searching for a solution, on how to prevent MySQL from crashing at all on this server.
-- Best Regards, Andrej Kudriavcev CITRUSR programmer
----- Original Message ----- From: "Nurse, Robert (Cont, ARL/CISD)" <rnu...@arl.army.mil> To: "Andrej Kudriavcev (CITRUS)" <and...@citrus.lt> Sent: Friday, October 29, 2004 5:33 PM Subject: RE: MySQL on Windows2003 crashes
A couple of things. First, are you limited to running all those app servers on one box? Two, are you sure it's MySQL? Did the box only crash after MySQL was added. Since it's Window 2KX, you're probably getting a blue screen after the crash. What does the message say? You can search for the message in Microsoft's knowledge base. Try starting the server in safe mode. Then load each service one at a time and see what happens.
Robert Nurse STG Contractor - Applications Development Enterprise Management Center Computational & Information Sciences Directorate
-----Original Message----- From: Andrej Kudriavcev (CITRUS) [mailto:and...@citrus.lt] Sent: Friday, October 29, 2004 3:09 AM To: win...@lists.mysql.com Subject: MySQL on Windows2003 crashes
Hello, all
I got a problem with one of our clients running MySQL 3.23.58. The platform is IBM server, running Win2003 Server, IPlanet web server, PHP4.3.whatever and MySQL. Also they run ColdFusion server for another project. ColdFusion project use Oracle DB from dedicated DB Oracle server, so it should not affect MySQL installation.
The problem is, that MySQL, PHP and ColdFusion ir crashing from time to time (at least one time in month each). I could not catch any rule in that - it just crashes, and W2003 bring service back. In MySQL case this crash could (and in fact does) bring data loses.
Before they own new IBM server, they used to run projects on oldest HP server with Win2000Server on it. Other configuration was the same (IPlanet+PHP+MySQL+ColdFusion). And MySQL was not stabile on that server too. So it sould not be Win2003 Server problem. Maybe it is some sort of IPlanet or ColdFusion problem (but I can not imagine, how those programs could affect MySQL stability - PHP working with MySQL throw TCP/IP and ColdFusion don't work with this DB at all).
Could any one please direct me to the solution in this case? Would it help, if I try to upgrade MySQL to version 4.1?