2 messages in com.mysql.lists.clusterResolved: Stuck in phase 3?
FromSent OnAttachments
Wilersh15 Nov 2007 10:51 
Wilersh15 Nov 2007 21:17 
Subject:Resolved: Stuck in phase 3?
From:Wilersh (wile@mac.com)
Date:11/15/2007 09:17:24 PM
List:com.mysql.lists.cluster

I solve this by bringing down my whole cluster. Luckily I was able to carve out some down time tonight. Completely restarting the cluster, NOT initializing the node that had been up and running, then starting the second node with --initial, worked this time. After the second node was up I then restarted the first node with --initial so it picked up the parameter changes.

Seems to have worked. Maybe this info will help another confused admin down the line.

Eric

Sorry to be so noisy on this list this week. It's my week for issues I guess.

I am running a rolling restart of my cluster, due to changes in parameter settings. I actually deleted some settings I had in place during a restore. At the start of the restart I actually had one data node, out of two, down. I restarted the management node. The started the down node with --initial. This node has been stuck on phase 3 for hours. I always seen the start of ndbd blow by phase 3 so I concerned. I've found that phase 3 is where the internal variables are initialized. Not 100% sure what that is referring to but since I've changed eliminated some parameter settings in my config.ini I'm wondering if there is a connection.

Any suggestions on where I should be going from here. I'll continue to sift through docs and be patient but I'm getting nervous.

Thanks for all the help here.