List:Cluster« Previous MessageNext Message »
From:hoo.smth Date:July 21 2011 6:22am
Subject:Re: Mysql Cluster Backup Error (785)
View as plain text  
My backup status is as follows :
ndb_mgm> ALL REPORT BackupStatus
Connected to Management Server at: localhost:1186
Node 3: Backup not started
Node 4: Backup not started
Node 5: Backup not started

I have restarted all the management node, I still get failure.

On Wed, Jul 20, 2011 at 10:55 PM, Wagner Bianchi
<wagnerbianchijr@stripped>wrote:

> 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