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

[7 Feb 2006 9:59] patrice audigou
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"
[7 Feb 2006 10:00] patrice audigou
mysql schema

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

[7 Feb 2006 10:47] Valeriy Kravchuk
Thank you for a problem report. Can you, please, try to repeat with 5.1.7-beta already available and inform about the results?
[7 Feb 2006 11:03] Jonathan Miller
Are there any trace files or error logs produced during this atempt?

Thanks
JBM
[7 Feb 2006 11:20] Valeriy Kravchuk
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.
[8 Feb 2006 9:54] Jonas Oreland
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
[9 Feb 2006 8:23] patrice audigou
simple mysql schema

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

[9 Feb 2006 8:29] patrice audigou
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.
[14 Feb 2006 10:49] Bugs System
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