MySQL Bugs: #17183: restore operation from a backup of release -x aborts

Bug #17183	restore operation from a backup of release -x aborts
Submitted:	7 Feb 2006 9:59	Modified:	20 Feb 2006 22:33
Reporter:	patrice audigou	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Cluster: Cluster (NDB) storage engine	Severity:	S2 (Serious)
Version:	5.1.6-alpha	OS:	Linux (redhat9)
Assigned to:	Jonas Oreland	CPU Architecture:	Any

Description:
On a cluster at release 5.1.6-alpha , the restore operation aborts if i try to restore
a backup that has been done on a cluster at release 5.1.2-a_drop5p8.
-Clusters are identical (config.ini,my.cnf)

on 5.1.2-a_drop5p8 station
==================
-The backup operation is done with ndb_mgm using the "start backup" command
-The backup is transfered via ftp on the 5.1.6-alpha machine.

on 5.1.6-alpha machine
===============
-The ndb node is started with the --initial option
-The following restore operation is launched

 "/usr/mysql/bin/ndb_restore --ndb-connectstring=host=xxxx:2200 --backupid=1 --nodeid=2 --restore_meta --restore_data --print_log /.../BACKUP/BACKUP-1" 

the restore operation aborts with the following error message

  "Processing data in table: hlr/def/CFiBSG(67) fragment 0"
  "Aborted"

How to repeat:
"/usr/mysql/bin/ndb_restore --ndb-connectstring=host=xxxx:2200 --backupid=1 --nodeid=2 --restore_meta --restore_data --print_log /.../BACKUP/BACKUP-1"

mysql schema

Attachment: createtable.sql (text/x-sql), 45.79 KiB.

Thank you for a problem report. Can you, please, try to repeat with 5.1.7-beta already available and inform about the results?

Are there any trace files or error logs produced during this atempt?

Thanks
JBM

Patrice,

Sorry, 5.1.7 is not realeased yet - it is available only from our source repository. My fault. Please, ignore my question if you are not building from sources.

1) --restore-meta is currently not support between 5.1.2 and 5.16
You have to restore your schema using e.g mysqldump
2) Can you upload the backup files

simple mysql schema

Attachment: createtableNew.sql (text/x-sql), 200 bytes.

it does not work if i restore without the --meta_data option :

 /usr/mysql/bin/ndb_restore --ndb-connectstring=host=xxx:2200 --backupid=1 --nodeid=2 --restore_data /../BACKUP-1

i join a more simple schema that can be used to reproduce the pb.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/2583