List:Cluster« Previous MessageNext Message »
From:Tomas Ulin Date:September 2 2004 1:31pm
Subject:Re: Can't Init Database
View as plain text  
You cannot use localhost and other host names mixed in a config file.  
You have two choices:

1. remove localhost
2. move mgm to be node 3 and db nodes to be nodes 1 and 2, then you 
don't need to specidy the host for mgm.

BTW, you should be able to leave out node id's.  Then the nodes will get 
numbers 1, 2, 3 etc in the order that they are specified in the config file.

BR,

Tomas

Sharad Maloo wrote:

> Hi Olivier,
>
> In my case the management and the API node is the same machine.
> So can you guide me how should I go ahead with it ?
> Or should I change my API machine to be the same as my DB machines ?
>
> -
> Sharad
>
>
> On Thu, 2 Sep 2004, Olivier Kaloudoff wrote:
>
>> Hi Sharad,
>>
>>
>>     the mysqld process is started at the last stage when you
>> first run your cluster, as explained in the following quickstart paper:
>>
>> http://dev.mysql.com/doc/mysql/en/MySQL_Cluster_quick.html
>>
>>     Did you start the Management Server, then the DB Nodes,
>> then activate NDB support in your my.cnf file before starting your API
>> node with "mysqld_safe" ?
>>
>>
>> Olivier
>>
>>
>> On Thu, 2 Sep 2004, Sharad Maloo wrote:
>>
>>>
>>> Hello,
>>>
>>> I am quite new to the cluster list, excuse me if this has been posted
>>> earlier.
>>>
>>> I get this error when I run the mysqld_safe process.
>>> ----
>>> frm the .err file.
>>>
>>> 40903 01:00:50  mysqld started
>>> 040903  1:00:50  InnoDB: Started; log sequence number 0 43866
>>> 040903  1:01:51  Can't init databases
>>> 040903  1:01:51  Aborting
>>>
>>> 040903  1:01:51  InnoDB: Starting shutdown...
>>> 040903  1:01:54  InnoDB: Shutdown completed; log sequence number 0 
>>> 43866
>>> 040903  1:01:54  /usr/local/mysql/libexec/mysqld: Shutdown complete
>>>
>>> 040903 01:01:56  mysqld ended
>>>
>>> -------
>>>
>>> Following is the config.ini file I have been using
>>>
>>> [COMPUTER DEFAULT]
>>>
>>> [DB DEFAULT]
>>> NoOfReplicas: 2
>>>
>>> [API DEFAULT]
>>>
>>> [MGM DEFAULT]
>>> ArbitrationRank: 2
>>>
>>> [TCP DEFAULT]
>>> PortNumber: 28002
>>>
>>> [COMPUTER]
>>> Id:1
>>> HostName: localhost
>>>
>>> [COMPUTER]
>>> Id:2
>>> HostName: ASL-81
>>>
>>> [COMPUTER]
>>> Id:3
>>> HostName: cluster
>>>
>>> [MGM]
>>> Id:1
>>> ExecuteOnComputer: 1
>>> PortNumber: 2200
>>>
>>> [DB]
>>> Id: 2
>>> ExecuteOnComputer: 2
>>> FileSystemPath: /var/lib/mysql-cluster/node2/
>>>
>>> [DB]
>>> Id: 3
>>> ExecuteOnComputer: 3
>>> FileSystemPath: /var/lib/mysql-cluster/node3/
>>>
>>> [API]
>>> Id: 4
>>> ExecuteOnComputer: 1
>>>
>>>
>>> ------------
>>>
>>> Any inputs will be appreciated.
>>>
>>> Thanks aprior,
>>> Sharad Maloo
>>>
>>> -- 
>>> MySQL Cluster Mailing List
>>> For list archives: http://lists.mysql.com/cluster
>>> To unsubscribe:    http://lists.mysql.com/cluster?unsub=1
>>>
>>>
>>
>

Thread
Re: nightly crashingJim Hoadley1 Sep
  • Re: nightly crashingJim Hoadley1 Sep
    • Can't Init DatabaseSharad Maloo2 Sep
      • Re: Can't Init DatabaseOlivier Kaloudoff2 Sep
        • Re: Can't Init DatabaseSharad Maloo2 Sep
          • Re: Can't Init DatabaseTomas Ulin2 Sep
      • Re: Can't Init DatabaseWouter de Jong2 Sep
        • Re: Can't Init DatabaseChad Martin2 Sep
          • Re: Can't Init DatabaseSharad Maloo2 Sep
          • Re: Can't Init DatabaseWouter de Jong3 Sep
  • Re: nightly crashingPh.D. Joseph E. Sacco1 Sep
  • Re: nightly crashingMikael Ronström2 Sep
    • Re: nightly crashingJim Hoadley22 Sep
      • Re: nightly crashingMikael Ronström23 Sep
      • Re: nightly crashingTomas Ulin23 Sep
        • Re: nightly crashingJim Hoadley23 Sep
RE: Can't Init DatabaseLuke H. Crouch2 Sep
  • Re: Can't Init DatabaseWouter de Jong3 Sep
    • Re: Can't Init DatabaseTomas Ulin3 Sep
      • Re: Can't Init Database <- solvedWouter de Jong3 Sep
        • Re: Can't Init Database <- solvedMagnus Svensson6 Sep
Re: nightly crashingJim Hoadley23 Sep
  • Re: nightly crashingTomas Ulin25 Sep
    • Re: nightly crashingJim Hoadley27 Sep
      • Re: nightly crashingTomas Ulin28 Sep