Bug #29940 ndb_dd_restore_compat.test fails
Submitted: 20 Jul 2007 18:17 Modified: 23 Apr 2008 10:20
Reporter: Ingo Strüwing Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Disk Data Severity:S2 (Serious)
Version:5.2.5 OS:Solaris (Also OSX)
Assigned to: CPU Architecture:Any
Tags: pbfail

[20 Jul 2007 18:17] Ingo Strüwing
Description:
ndb_dd_restore_compat.test fails in 5.2 on Sparc and G5.

ndb_dd_restore_compat          [ fail ]

Errors are (from /tmp/var-n_mix-120/log/mysqltest-time) :
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/ndb_dd_restore_compat.result	Tue Jul 17 13:29:48 2007
--- r/ndb_dd_restore_compat.reject	Tue Jul 17 16:26:53 2007
***************
*** 38,48 ****
  a10 Blob(256,2000,16) NULL AT=FIXED ST=DISK BV=1
  select * from t1 order by a1;
  a1	a2	a3	a4	a5	a6	a7	a8	a9	a10
! 1	2	2000000001	aaa1	34.2	04:03:02	2006-01-01	1971-05-28 16:55:03	bbbbbbbbbbbbb1	binary data
! 2	3	2000000002	aaa2	34.2	04:03:02	2006-01-01	1971-05-28 16:55:03	bbbbbbbbbbbbb2	binary data
! 3	4	2000000003	aaa3	34.2	04:03:02	2006-01-01	1971-05-28 16:55:03	bbbbbbbbbbbbb3	binary data
! 4	5	2000000004	aaa4	34.2	04:03:02	2006-01-01	1971-05-28 16:55:03	bbbbbbbbbbbbb4	binary data
! 5	6	2000000005	aaa5	34.2	04:03:02	2006-01-01	1971-05-28 16:55:03	bbbbbbbbbbbbb5	binary data
  drop table t1;
  ALTER TABLESPACE ts
  DROP DATAFILE 'datafile.dat'
--- 38,54 ----
  a10 Blob(256,2000,16) NULL AT=FIXED ST=DISK BV=1
  select * from t1 order by a1;
  a1	a2	a3	a4	a5	a6	a7	a8	a9	a10
! 1	2	2000000001	aaa1	34.2	04:03:02	2006-01-01	j/-+-,*--/ 35:62:88	bbbbbbbbbbbbb1	NULL
! 2	3	2000000002	aaa2	34.2	04:03:02	2006-01-01	j/-+-,*--/ 35:62:88	bbbbbbbbbbbbb2	NULL
! 3	4	2000000003	aaa3	34.2	04:03:02	2006-01-01	j/-+-,*--/ 35:62:88	bbbbbbbbbbbbb3	NULL
! 4	5	2000000004	aaa4	34.2	04:03:02	2006-01-01	j/-+-,*--/ 35:62:88	bbbbbbbbbbbbb4	NULL
! 5	6	2000000005	aaa5	34.2	04:03:02	2006-01-01	j/-+-,*--/ 35:62:88	bbbbbbbbbbbbb5	NULL
! Warnings:
! Error	1296	Got error 0 'No error' from NDB
! Error	1296	Got error 0 'No error' from NDB
! Error	1296	Got error 0 'No error' from NDB
! Error	1296	Got error 0 'No error' from NDB
! Error	1296	Got error 0 'No error' from NDB
  drop table t1;
  ALTER TABLESPACE ts
  DROP DATAFILE 'datafile.dat'
-------------------------------------------------------
Please follow the instructions outlined at

How to repeat:
Please check pushbuild pages for 5.2.
[21 Apr 2008 8:27] li zhou
Please check with the lastest version of mysql.
[23 Apr 2008 10:20] Ingo Strüwing
Looks like it has been fixed meanwhile.