List:Cluster« Previous MessageNext Message »
From:Dmitry Cherkasov Date:October 28 2009 8:38pm
Subject:Re: problems when starting SQL node
View as plain text  
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
Thread
problems when starting SQL nodeDmitry Cherkasov28 Oct
  • Re: problems when starting SQL nodeMatthew Montgomery28 Oct
    • Re: problems when starting SQL nodeDmitry Cherkasov28 Oct