Re: node crashes and doesn't restart beyond phase 4 - Alex Davies - com.mysql.lists.cluster

3 messages in com.mysql.lists.clusterRe: node crashes and doesn't restart ...

From	Sent On	Attachments
Christian Schramm	19 Jan 2006 09:27
Alex Davies	19 Jan 2006 09:28
Stewart Smith	19 Jan 2006 21:19

Subject:	Re: node crashes and doesn't restart beyond phase 4
From:	Alex Davies (davi...@gmail.com)
Date:	01/19/2006 09:28:46 AM
List:	com.mysql.lists.cluster

Try restarting it with --initial.

If it does not start within 3 mins or so kill the process and post a copy of the error log on the node so we can try to work out what is wrong!

Try restarting it with --initial.

If it does not start within 3 mins or so kill the process and post a copy of the error log on the node so we can try to work out what is wrong!

Alex

On 19/01/06, Christian Schramm <mail...@dretschler.com> wrote:

Hello!

We're having a 2 node cluster with 4 servers. I logged all the queries from our current mySQL standalone server to make a "stress test" on the cluster. So I wrote a php script which should extract some sql statements out of the log file and execute them on the cluster.

Today I executed the sql statements. The result: - Lost connection during query (many, many times) - Node crashed

After the crash we restarted the node, but it was stuck at phase 4, doing nothing for hours (no cpu/hd load). Now we restarted the complete cluster and the node won't restart anymore, but stays at phase 2. The error that occurs is 2341.

Very strange! Can anyone help? Is this a bug?

Regards

This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the sender immediately by e-mail and delete this e-mail permanently.