2009/10/28 Matthew Montgomery <Matt.Montgomery@stripped>:
> On Wed, 2009-10-28 at 16:21 +0200, Dmitry Cherkasov wrote:
>> Hello everybody,
>>
>> I got a strange problem with starting SQL node, probably it has some
>> relation to the platform I'm working on: CentOS5 x86_64.
>>
>> When starting mysql with system script like 'service mysql start' it
>> starts successfully yet fails to connect to the cluster:
>>
>> (on the management node)
>> Node-A ~ ndb_mgm -e show
>> [...]
>> [mysqld(API)] 2 node(s)
>> id=4 (not connected, accepting connect from any host)
>> id=5 (not connected, accepting connect from any host)
>>
>> (in the log of mysql)
>> [...]
>> 091028 9:00:21 [Note] NDB[0]: NodeID: 4, no storage nodes connected (timed
> out)
>> [...]
>
> Can you send the full SHOW output?
Sure:
Node-A ~ ndb_mgm -e show
Connected to Management Server at: 127.0.0.1:1186
Cluster Configuration
---------------------
[ndbd(NDB)] 2 node(s)
id=2 @10.50.7.33 (mysql-5.1.37 ndb-7.0.8, Nodegroup: 0, Master)
id=3 @10.50.7.34 (mysql-5.1.37 ndb-7.0.8, Nodegroup: 0)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.50.7.31 (mysql-5.1.37 ndb-7.0.8)
[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)
> --
> Matthew Montgomery
> MySQL Senior Support Engineer
> Sun Microsystems Inc., Database Group
> San Antonio, Texas, USA
>
>
--
Dmitry Cherkasov