Very strange problem

2003-11-07 Thread Eric Anderson
A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14). These two machines have a private connection between them (192.168.0.1 and 192.168.0.2). The e450 is the master server, and the 1U has a copy (no replication) of some basic data, so it can run server-intensive pages.

RE: Very strange problem

2003-11-07 Thread Victor Pendleton
Is anything being logged in the error log? -Original Message- From: Eric Anderson [mailto:[EMAIL PROTECTED] Sent: Friday, November 07, 2003 11:16 AM To: [EMAIL PROTECTED] Subject: Very strange problem A little explaination: We've got two servers, e450 (3.23.47) and 1U (4.0.14

RE: Very strange problem

2003-11-07 Thread Eric Anderson
Is anything being logged in the error log? Nope. My 'wait_timeout' was set to 120 seconds, I reduced that down to 60 seconds but I don't think that will help because once it gets stuck in this blocked thread thing, it never recovers.. any subsequent connections never actually process, until the

Re: Very strange problem

2003-11-07 Thread Jeremy Zawodny
On Fri, Nov 07, 2003 at 09:16:03AM -0800, Eric Anderson wrote: A little explaination: [snip] The threads connecting from the 1U (192.168.0.2) all start to block up as expected, but when the length query on the e450 stops running, the threads from the 1U stay blocked, and all NEW threads

Very Strange problem.

2002-05-02 Thread TP R Murthy
Hi, I am new to this list. i could find solution to this problem on the net. i have a RH7.1 512Mb single intel processor. I have installed mysql-3.23.49a-max (binary). I have included the mysql.server script in the init dir and created links to it in rc6, rc5,rc3 and rc1 dir. I have

Re: Very Strange problem.

2002-05-02 Thread Jeremy Zawodny
On Fri, May 03, 2002 at 11:04:29AM +0530, TP R Murthy wrote: I have created only one database with 18 tables. Only one of these tables is MyIsam table. rest are BDB tables. When the server is up, it works fine. but when i reboot the machine, few of the tables loose all the records they

Re: Very Strange problem.

2002-05-02 Thread TP R Murthy
Hi, I do commit alright. This doesn't happen often. i insert into the tables from a java web app. The db and the data in it is fine when i stop and restart the web server(tomcat). sometimes when i restart the machine, data is all intact. I was using the mysql 4 max before. Same thing