Re: Re[2]: Can not restore a backup - Alex Davies - com.mysql.lists.cluster

11 messages in com.mysql.lists.clusterRe: Re[2]: Can not restore a backup

From	Sent On	Attachments
Ruslan Talpa	10 Sep 2005 07:32
Alex Davies	10 Sep 2005 07:34
Gmail	10 Sep 2005 08:12
Alex Davies	10 Sep 2005 08:17
Ruslan Talpa	10 Sep 2005 08:22
Alex Davies	10 Sep 2005 08:32
Alex Davies	10 Sep 2005 08:50
Alex Davies	10 Sep 2005 09:03
Alex Davies	10 Sep 2005 09:20
Alex Davies	10 Sep 2005 09:22
Alex Davies	10 Sep 2005 09:37

Subject:	Re: Re[2]: Can not restore a backup
From:	Alex Davies (davi...@gmail.com)
Date:	09/10/2005 08:32:13 AM
List:	com.mysql.lists.cluster

only this: /usr/local/mysql/bin/ndb_restore -n 1 -m -b 3 -r /var/lib/mysql-cluster/BACKUP/BACKUP-3/ Ndb version in backup files: Version 4.1.14 Failed to connect to ndb!!

OK, so it cant connect to the cluster.

Please post the following:

the last 10 lines of the .err file in DataDir on the storage node that you run ndb_restore on the output from ndb_mgm's SHOW command

and I can try to be more helpful!

Alex

On 9/10/05, Alex Davies <davi...@gmail.com> wrote:

So what error does it give you now when you run your ndb_restore command on your storage node(s)?

Alex

On 10/09/05, Ruslan Talpa <rusl...@gmail.com> wrote:

All db nodes are up and the "No free node id found for mysqld(API).)" error was onli at first when i did not have any free nodes. There is no error in the log, it only sais this:

2005-09-10 10:09:37 [MgmSrvr] INFO -- Mgmt server state: nodeid 11 reserved for ip xx.xx.xx.16, m_reserved_nodes 0000000000000880. 2005-09-10 10:10:09 [MgmSrvr] INFO -- Mgmt server state: nodeid 11 freed, m_reserved_nodes 0000000000000080.

On 9/10/05, Alex Davies <davi...@gmail.com> wrote:

Do you still get the same error when you run ndb_restore? xx.xx.xx.xx:port 1186: No free node id found for

mysqld(API).)

Are both storage nodes connected and "started"?

What happens if you run PURGE STALE SESSIONS in ndb_mgm then try?

Alex

On 10/09/05, Gmail < rusl...@gmail.com> wrote:

Hello Alex, still the same. I have 6 free id's and the result is the same

[mysqld(API)] 9 node(s) id=8 (Version: 4.1.14) id=9 (Version: 4.1.14) id=10 (Version: 4.1.14) id=11 (not connected, accepting connect from any host) id=12 (not connected, accepting connect from any host) id=13 (not connected, accepting connect from any host) id=14 (not connected, accepting connect from any host) id=15 (not connected, accepting connect from any host) id=16 (not connected, accepting connect from any host)

ndb_mgm>

Saturday, September 10, 2005, 5:35:02 PM, you wrote:

2005-09-10 09:26:13 [MgmSrvr] INFO -- Mgmt server state: nodeid

reserved

That is your answer, I think.

You need one [mysqld] section PER storage node I seem to remember.

There is also no particular reason to define the ID - just add

[mysqld] [mysqld] [mysqld]

To the bottom of config.ini and restart.

Alex

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.