DevHeads.net

Mysql Cluster Backup Error (785)

By hoo.smth at 07/20/2011 - 05:16

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

Comments

Re: Mysql Cluster Backup Error (785)

By hoo.smth at 08/04/2011 - 22:24

I have solve it~hahaha
My solution is adding the following lines to config.ini:

MaxNoOfConcurrentIndexOperations=25000
MaxNoOfFiredTriggers=12500

Thank all.

Re: Mysql Cluster Backup Error (785)

By Wagner Bianchi at 08/05/2011 - 10:50

Hey! Good hearing it from you, one more hint to the MySQL usability.

Best wishes,

Re: Mysql Cluster Backup Error (785)

By Stewart Smith at 07/20/2011 - 12:18

On Wed, 20 Jul 2011 17:16:31 +0800, "hoo.smth" <hoo. ... at gmail dot com> wrote:
A backup cannot proceed while DDL is being executed, and this is what
the error above is about. You may have DDL operations happenning often
and this is why you're getting this error. You can simply retry or wait
until DDL is done.

Re: Mysql Cluster Backup Error (785)

By hoo.smth at 07/21/2011 - 02:14

Thank you for replying.
In my application,there's no DDL.But the DML(insert and update) operations
are very heavy.
When I stop all the DML operations,I can backup successfully , so I guess
the reason is the DML
operations,which cause the transaction problem.

This is my cluster config:

[ndbd default]
noofreplicas=3
DataMemory=8192M
IndexMemory=2048M
TransactionDeadLockDetectionTimeOut=5000
MaxNoOfConcurrentOperations=100000
MaxNoOfTables=4096
MaxNoOfOrderedIndexes=2048
MaxNoOfUniqueHashIndexes=1250
MaxNoOfAttributes=24576
datadir=/data/mysqlc/ndb_data
BackupDataDir=/data/mysqlc_backup/BACKUP

Would you please give me some advice about the transaction so solve the
problem?
Thank you again.

hoo.smth
2011-7-21

On Thu, Jul 21, 2011 at 12:18 AM, Stewart Smith < ... at flamingspork dot com>wrote:

Re: Mysql Cluster Backup Error (785)

By Wagner Bianchi at 07/20/2011 - 12:40

That is a good touch, Smith.

Best wishes,

Re: Mysql Cluster Backup Error (785)

By Wagner Bianchi at 07/20/2011 - 10:55

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

<a href="http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-mgm-client-commands.html" title="http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-mgm-client-commands.html">http://dev.mysql.com/doc/refman/5.1/en/mysql-cluster-mgm-client-commands...</a>

Best wishes,

Re: Mysql Cluster Backup Error (785)

By hoo.smth at 07/21/2011 - 02:22

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
< ... at gmail dot com>wrote: