List:Cluster« Previous MessageNext Message »
From:Wagner Bianchi Date:July 20 2011 2:55pm
Subject:Re: Mysql Cluster Backup Error (785)
View as plain text  
Do you know if the earlier backup process has finished? I had a similar
problem some times ago and just restarted ndb_mgmd to fix it.

# check actual backup status
ndb_mgm> ALL REPORT BackupStatus

# restart ndb_mgmd
ndb_mgm> node_id RESTART

# try to backup it again
ndb_mgm> START BACKUP

http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-mgm-client-commands.html

Best wishes,
--
Wagner Bianchi - +55 (31) 8654 - 9510
*LinkedIn*: http://br.linkedin.com/in/wagnerbianchi
*Twitter*: @wagnerbianchijr
*Skype*: wbianchijr



2011/7/20 hoo.smth <hoo.smth@stripped>

> Hi,all
> I can't backup my cluster for many days.
> The error is as follows:
>
> ndb_mgm> start backup
> Waiting for completed, this may take several minutes
> Backup failed
> Node 3: Backup 48 started from 1 has been aborted. Error: 785*  3001: Could
> not start backup
> *        Schema object is busy with another schema transaction: Temporary
> error: Temporary Resource error
>
>
> It's not always failed, when I'm very lucky,i can backup successfully.
> I have googled the whole day, but still haven't solve it.
> Thanks for reading.
>
> hoo.smth
> 2011-7-20
>

Thread
Mysql Cluster Backup Error (785)hoo.smth20 Jul
  • Re: Mysql Cluster Backup Error (785)Wagner Bianchi20 Jul
    • Re: Mysql Cluster Backup Error (785)hoo.smth21 Jul
  • Re: Mysql Cluster Backup Error (785)Stewart Smith20 Jul
    • Re: Mysql Cluster Backup Error (785)Wagner Bianchi20 Jul
    • Re: Mysql Cluster Backup Error (785)hoo.smth21 Jul
  • Re: Mysql Cluster Backup Error (785)hoo.smth5 Aug
    • Re: Mysql Cluster Backup Error (785)Wagner Bianchi5 Aug