MySQL Bugs: #29674: restore of backup from different endian core dump

Bug #29674	restore of backup from different endian core dump
Submitted:	10 Jul 2007 5:44	Modified:	15 Sep 2007 13:37
Reporter:	li zhou
Status:	Closed
Category:	Server: Cluster	Severity:	S2 (Serious)
Version:	5.0.44	OS:	Sun Solaris (linux <-> solaris)
Assigned to:	Bugs System	Target Version:

Description:
Do backup on a little-endian machine, and copy backuped data to a big-endian machine(e.g.
solaris), then restore it. Restore program will core dump. 

How to repeat:
1. start a 2 data nodes cluster on a linux(little endian) machine.
2. create a table , and insert values into it.
   mysql> use test;
   mysql> create table t1 (a int , b int) engine ndb;
   mysql> insert into t1 values (1, 1);
3. start backup
   ./bin/ndb_mgm -e "start backup"
4. copy the backuped data to a solaris machine.
5. start a same cluster as linux machine on solaris machine.
6. restore database.
   ./bin/ndb_restore -n 1 -b 1 -m -r /PATH/TO/BACKUP/BACKUP-1

restore program will core dump

Suggested fix:
Ndb backup/restore should be endian compatible in 5.0.

backup data of the new test case for endian problem

Attachment: ndb_backup50_data.tar.gz (application/x-gzip, text), 101.26 KiB.

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/32195

ChangeSet@1.2477, 2007-08-07 18:07:57+00:00, lzhou@dev3-63.(none) +17 -0
  BUG#29674 Restore/backup are endian compatible in 5.0

looks ok.

pushed into ndb-bj tree 5.0.44

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/32724

ChangeSet@1.2474, 2007-08-20 10:47:09+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#29674 add install data of the new test case in makefile.am

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/32727

ChangeSet@1.2475, 2007-08-20 14:57:04+00:00, lzhou@dev3-63.(none) +1 -0
  BUG#29674 Remove warning in pushbuild in 5.0

Pushed into 5.0.44 ndb-bj tree

Pushed into 5.0.50

Pushed into 5.1.23-beta

Thank you for your bug report. This issue has been committed to our source repository of
that product and will be incorporated into the next release.

If necessary, you can access the source repository and build the latest available
version, including the bug fix. More information about accessing the source trees is
available at

    http://dev.mysql.com/doc/en/installing-source.html

Documented in 5.0.50 and 5.1.23 changelogs as follows:

It was not possible to restore
          a backup made on a cluster host using one endian to a machine
          using the other endian.

Also documented in mysql-5.1.22-ndb-6.2.6 changelog.