Bug #31284 rpl_ndb_blob fails on powermacg5: incorrect BLOB contents

Submitted: 28 Sep 2007 16:44 Modified: 10 Jul 2008 11:01
Reporter: Timothy Smith Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Cluster: Replication Severity:S3 (Non-critical)
Version:5.1, 5.2 OS:MacOS (powermacg5)
Assigned to: Frazer Clement CPU Architecture:Any
Tags: pbfail

[28 Sep 2007 16:44] Timothy Smith 
Description:
This failure has been around for a while on the powermacg5 platform.

The first place it shows up is in mysql-5.2 tree here:

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=mysql-5.2&order=74

It may be that pushbuild wasn't running this test earlier.

The symptom is that the sha1() of a BLOB field is incorrect:

rpl_ndb.rpl_ndb_blob           [ fail ]

Errors are (from /Users/henry/pb/mysql-5.2-opt/49/mysql-5.2.6-alpha-pb49/mysql-test/var-n_mix-5/log/mysqltest-time) :
mysqltest: Result content mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** /Users/henry/pb/mysql-5.2-opt/49/mysql-5.2.6-alpha-pb49/mysql-test/suite/rpl_ndb/r/rpl_ndb_blob.result	Thu Aug 30 20:16:36 2007
--- /Users/henry/pb/mysql-5.2-opt/49/mysql-5.2.6-alpha-pb49/mysql-test/suite/rpl_ndb/r/rpl_ndb_blob.reject	Fri Aug 31 05:51:34 2007
***************
*** 67,93 ****
  select 'M', a, sha1(b), c, sha1(d), sha1(e)
  from t1 order by a;
  M	a	sha1(b)	c	sha1(d)	sha1(e)
! M	0	9538f61e649383c0d1054de2a2f0171188129f33	100	2b6515f29c20b8e9e17cc597527e516c0de8d612	NULL
! M	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	f23e7439d9a73c3954979b85a7ef6ef35faf4e9d	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  M	2	da39a3ee5e6b4b0d3255bfef95601890afd80709	102	da39a3ee5e6b4b0d3255bfef95601890afd80709	33deebe47470a40e960834bffa4cdc66790845a6
! M	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	278629ad080c3c4377978c006c2e54d0992e43cc	700915801f853603510aeb67b331866d996fdbda
! M	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	5084b602c7203e0e9590a163415ac605da17ac32	700915801f853603510aeb67b331866d996fdbda
  M	5	0f9653f0c7a69cd1c617792d546582e974a7a24d	105	566588a04ff26d05160d61c83435292bfda2978e	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  M	6	a37e8b0ff4fc13a42be02cdecb36186436959bae	106	NULL	abfe8ae5212b22d023aa6de84beeb1344ac5668a
! M	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8	da39a3ee5e6b4b0d3255bfef95601890afd80709
  M	8	e139adcb7b2974ee7ff227fd405709e5cb7c896c	108	ba8073b0e1a281d4111bd2d82c7722b01574c00b	NULL
  M	9	1fc5168fe4be566b17b658d94e7813f0b5032cdb	NULL	NULL	NULL
  select 'S', a, sha1(b), c, sha1(d), sha1(e)
  from t1 order by a;
  S	a	sha1(b)	c	sha1(d)	sha1(e)
! S	0	9538f61e649383c0d1054de2a2f0171188129f33	100	2b6515f29c20b8e9e17cc597527e516c0de8d612	NULL
! S	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	f23e7439d9a73c3954979b85a7ef6ef35faf4e9d	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  S	2	da39a3ee5e6b4b0d3255bfef95601890afd80709	102	da39a3ee5e6b4b0d3255bfef95601890afd80709	33deebe47470a40e960834bffa4cdc66790845a6
! S	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	278629ad080c3c4377978c006c2e54d0992e43cc	700915801f853603510aeb67b331866d996fdbda
! S	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	5084b602c7203e0e9590a163415ac605da17ac32	700915801f853603510aeb67b331866d996fdbda
  S	5	0f9653f0c7a69cd1c617792d546582e974a7a24d	105	566588a04ff26d05160d61c83435292bfda2978e	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  S	6	a37e8b0ff4fc13a42be02cdecb36186436959bae	106	NULL	abfe8ae5212b22d023aa6de84beeb1344ac5668a
! S	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8	da39a3ee5e6b4b0d3255bfef95601890afd80709
  S	8	e139adcb7b2974ee7ff227fd405709e5cb7c896c	108	ba8073b0e1a281d4111bd2d82c7722b01574c00b	NULL
  S	9	1fc5168fe4be566b17b658d94e7813f0b5032cdb	NULL	NULL	NULL
  drop table t1;
--- 67,93 ----
  select 'M', a, sha1(b), c, sha1(d), sha1(e)
  from t1 order by a;
  M	a	sha1(b)	c	sha1(d)	sha1(e)
! M	0	9538f61e649383c0d1054de2a2f0171188129f33	100	66dfdcd02cd32bc4d82b49bf84258bb78eef0f32	NULL
! M	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	a1852aab4f317d5bb4d8e553f7bec6c895fb9eb8	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  M	2	da39a3ee5e6b4b0d3255bfef95601890afd80709	102	da39a3ee5e6b4b0d3255bfef95601890afd80709	33deebe47470a40e960834bffa4cdc66790845a6
! M	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	a69bcebf0e0942cb54b3d792d81dfd0065c15842	700915801f853603510aeb67b331866d996fdbda
! M	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	0ee8f61857e7b113fd93e5c55c9fef1a2586c11d	700915801f853603510aeb67b331866d996fdbda
  M	5	0f9653f0c7a69cd1c617792d546582e974a7a24d	105	566588a04ff26d05160d61c83435292bfda2978e	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  M	6	a37e8b0ff4fc13a42be02cdecb36186436959bae	106	NULL	abfe8ae5212b22d023aa6de84beeb1344ac5668a
! M	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	b8ec0980d6e87999d8f8ed87710e62ef907b9d9c	da39a3ee5e6b4b0d3255bfef95601890afd80709
  M	8	e139adcb7b2974ee7ff227fd405709e5cb7c896c	108	ba8073b0e1a281d4111bd2d82c7722b01574c00b	NULL
  M	9	1fc5168fe4be566b17b658d94e7813f0b5032cdb	NULL	NULL	NULL
  select 'S', a, sha1(b), c, sha1(d), sha1(e)
  from t1 order by a;
  S	a	sha1(b)	c	sha1(d)	sha1(e)
! S	0	9538f61e649383c0d1054de2a2f0171188129f33	100	66dfdcd02cd32bc4d82b49bf84258bb78eef0f32	NULL
! S	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	a1852aab4f317d5bb4d8e553f7bec6c895fb9eb8	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  S	2	da39a3ee5e6b4b0d3255bfef95601890afd80709	102	da39a3ee5e6b4b0d3255bfef95601890afd80709	33deebe47470a40e960834bffa4cdc66790845a6
! S	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	a69bcebf0e0942cb54b3d792d81dfd0065c15842	700915801f853603510aeb67b331866d996fdbda
! S	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	0ee8f61857e7b113fd93e5c55c9fef1a2586c11d	700915801f853603510aeb67b331866d996fdbda
  S	5	0f9653f0c7a69cd1c617792d546582e974a7a24d	105	566588a04ff26d05160d61c83435292bfda2978e	abfe8ae5212b22d023aa6de84beeb1344ac5668a
  S	6	a37e8b0ff4fc13a42be02cdecb36186436959bae	106	NULL	abfe8ae5212b22d023aa6de84beeb1344ac5668a
! S	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	b8ec0980d6e87999d8f8ed87710e62ef907b9d9c	da39a3ee5e6b4b0d3255bfef95601890afd80709
  S	8	e139adcb7b2974ee7ff227fd405709e5cb7c896c	108	ba8073b0e1a281d4111bd2d82c7722b01574c00b	NULL
  S	9	1fc5168fe4be566b17b658d94e7813f0b5032cdb	NULL	NULL	NULL
  drop table t1;
-------------------------------------------------------

How to repeat:
Verified by pushbuild, see xref for rpl_ndb_blob test:

https://intranet.mysql.com/secure/pushbuild/xref.pl?startdate=&enddate=&dir=&plat=&testtyp...
[20 Nov 2007 18:05] Jonas Oreland 
this was most likely fixed by blob/commit fixes that we did
(related to simple-read)

and error has not been seen in pb since september (when we did fix)
[25 Nov 2007 12:49] Ingo Strüwing 
Disagree. This is from the latest mysql-6.0:

rpl_ndb.rpl_ndb_blob           [ fail ]

--- /Users/henry/pb/mysql-6.0/32/mysql-6.0.4-alpha-pb32/mysql-test/suite/rpl_ndb/r/rpl_ndb_blob.result	Thu Nov 22 20:36:45 2007
+++ /Users/henry/pb/mysql-6.0/32/mysql-6.0.4-alpha-pb32/mysql-test/suite/rpl_ndb/r/rpl_ndb_blob.reject	Fri Nov 23 11:16:38 2007
@@ -67,27 +67,27 @@
 select 'M', a, sha1(b), c, sha1(d), sha1(e)
 from t1 order by a;
 M	a	sha1(b)	c	sha1(d)	sha1(e)
-M	0	9538f61e649383c0d1054de2a2f0171188129f33	100	2b6515f29c20b8e9e17cc597527e516c0de8d612	NULL
-M	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	f23e7439d9a73c3954979b85a7ef6ef35faf4e9d	abfe8ae5212b22d023aa6de84beeb1344ac5668a
+M	0	9538f61e649383c0d1054de2a2f0171188129f33	100	66dfdcd02cd32bc4d82b49bf84258bb78eef0f32	NULL
+M	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	a1852aab4f317d5bb4d8e553f7bec6c895fb9eb8	abfe8ae5212b22d023aa6de84beeb1344ac5668a
 M	2	da39a3ee5e6b4b0d3255bfef95601890afd80709	102	da39a3ee5e6b4b0d3255bfef95601890afd80709	33deebe47470a40e960834bffa4cdc66790845a6
-M	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	278629ad080c3c4377978c006c2e54d0992e43cc	700915801f853603510aeb67b331866d996fdbda
-M	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	5084b602c7203e0e9590a163415ac605da17ac32	700915801f853603510aeb67b331866d996fdbda
+M	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	a69bcebf0e0942cb54b3d792d81dfd0065c15842	700915801f853603510aeb67b331866d996fdbda
+M	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	0ee8f61857e7b113fd93e5c55c9fef1a2586c11d	700915801f853603510aeb67b331866d996fdbda
 M	5	0f9653f0c7a69cd1c617792d546582e974a7a24d	105	566588a04ff26d05160d61c83435292bfda2978e	abfe8ae5212b22d023aa6de84beeb1344ac5668a
 M	6	a37e8b0ff4fc13a42be02cdecb36186436959bae	106	NULL	abfe8ae5212b22d023aa6de84beeb1344ac5668a
-M	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8	da39a3ee5e6b4b0d3255bfef95601890afd80709
+M	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	b8ec0980d6e87999d8f8ed87710e62ef907b9d9c	da39a3ee5e6b4b0d3255bfef95601890afd80709
 M	8	e139adcb7b2974ee7ff227fd405709e5cb7c896c	108	ba8073b0e1a281d4111bd2d82c7722b01574c00b	NULL
 M	9	1fc5168fe4be566b17b658d94e7813f0b5032cdb	NULL	NULL	NULL
 select 'S', a, sha1(b), c, sha1(d), sha1(e)
 from t1 order by a;
 S	a	sha1(b)	c	sha1(d)	sha1(e)
-S	0	9538f61e649383c0d1054de2a2f0171188129f33	100	2b6515f29c20b8e9e17cc597527e516c0de8d612	NULL
-S	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	f23e7439d9a73c3954979b85a7ef6ef35faf4e9d	abfe8ae5212b22d023aa6de84beeb1344ac5668a
+S	0	9538f61e649383c0d1054de2a2f0171188129f33	100	66dfdcd02cd32bc4d82b49bf84258bb78eef0f32	NULL
+S	1	dcb9a12ca86e718ff2564be041b7c1b3ff5ea559	NULL	a1852aab4f317d5bb4d8e553f7bec6c895fb9eb8	abfe8ae5212b22d023aa6de84beeb1344ac5668a
 S	2	da39a3ee5e6b4b0d3255bfef95601890afd80709	102	da39a3ee5e6b4b0d3255bfef95601890afd80709	33deebe47470a40e960834bffa4cdc66790845a6
-S	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	278629ad080c3c4377978c006c2e54d0992e43cc	700915801f853603510aeb67b331866d996fdbda
-S	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	5084b602c7203e0e9590a163415ac605da17ac32	700915801f853603510aeb67b331866d996fdbda
+S	3	ec8e06d9ac4695d6a898b519ba840590263a9bff	103	a69bcebf0e0942cb54b3d792d81dfd0065c15842	700915801f853603510aeb67b331866d996fdbda
+S	4	0392fa8c425d293c79291f0f34779d1101d13fcb	104	0ee8f61857e7b113fd93e5c55c9fef1a2586c11d	700915801f853603510aeb67b331866d996fdbda
 S	5	0f9653f0c7a69cd1c617792d546582e974a7a24d	105	566588a04ff26d05160d61c83435292bfda2978e	abfe8ae5212b22d023aa6de84beeb1344ac5668a
 S	6	a37e8b0ff4fc13a42be02cdecb36186436959bae	106	NULL	abfe8ae5212b22d023aa6de84beeb1344ac5668a
-S	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	39ee712b4b9e47f2cf3ba7c9790b2bf0d8f378e8	da39a3ee5e6b4b0d3255bfef95601890afd80709
+S	7	a6bae0cfe6b45ff8c3c12d2ce577a1cd3931190f	107	b8ec0980d6e87999d8f8ed87710e62ef907b9d9c	da39a3ee5e6b4b0d3255bfef95601890afd80709
 S	8	e139adcb7b2974ee7ff227fd405709e5cb7c896c	108	ba8073b0e1a281d4111bd2d82c7722b01574c00b	NULL
 S	9	1fc5168fe4be566b17b658d94e7813f0b5032cdb	NULL	NULL	NULL
 drop table t1;

mysqltest: Result content mismatch

The log file is: https://intranet.mysql.com/secure/pushbuild/getlog.pl?dir=mysql-6.0&entry=dfischer@pippilo...

Disabling the test case. Please re-enable after fix.
[28 Nov 2007 10:24] Bugs System 
Pushed into 6.0.4-alpha
[30 May 2008 19:49] Frazer Clement 
Long Blob v2 exposed a buffer overrun in old-Api setValue() call.
Fix is to ensure stack buffers allocated in setValue() are large enough.
[30 May 2008 19:57] Jonas Oreland 
patch as such is brilliant,
can you also check if there are similar occurrences
for key (max_keysize_in_words or similar)
[3 Jun 2008 10:01] 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/47344
[3 Jun 2008 10:35] 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/47349
[3 Jun 2008 10:59] 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/47350
[3 Jun 2008 15:03] 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/47377
[3 Jun 2008 15:45] 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/47379
[9 Jul 2008 8:51] Jon Stephens 
Need versions in which the fix was applied. Thanks.
[9 Jul 2008 9:50] Frazer Clement 
Pushed to 6.2.16, 6.3.16, 6.4.0
[10 Jul 2008 11:01] Jon Stephens 
Documented in the 5.1.24-ndb-6.2.16, 5.1.24-ndb-6.3.16, and 6.0.4 changelogs as follows:

        A buffer overrun in NdbBlob::setValue() caused 
        erroneous results on Mac OS X.

Closed.
[13 Jul 2008 15:41] Andrei Elkin 
Maybe bugteam tree has not got the fixes, but still here is the most recent show of the failure on that tree:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-bugteam&order=51
[12 Dec 2008 23:29] Bugs System 
Pushed into 6.0.6-alpha  (revid:frazer@mysql.com-20080603100031-ks1hpd0bj2zcj4r9) (version source revid:jonas@mysql.com-20080808094047-4e1yiarqa2t3opg3) (pib:5)

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.071 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.