Bug #45500 falcon_chill_thaw_compare: mismatch in number of rows returned between servers
Submitted: 15 Jun 2009 12:20 Modified: 26 May 2010 17:45
Reporter: Olav Sandstå Email Updates:
Status: Unsupported Impact on me:
None 
Category:MySQL Server: Falcon storage engine Severity:S2 (Serious)
Version:6.0.12-alpha OS:Any
Assigned to: Kevin Lewis CPU Architecture:Any
Tags: F_ISOLATION

[15 Jun 2009 12:20] Olav Sandstå 
Description:
falcon_chill_thaw_compare failed with the following error:

# 19:31:34 Query: SELECT * FROM `table1000_falcon_int_autoinc` WHERE `bigint_key` > -2.40613714418467e+18 failed: result length mismatch between servers (973 vs. 1004)
--- /export/home/pb2/test/sb_1-577679-1244827829.22/tmp//randgen8894-server0.dump	2009-06-12 19:31:34.000000000 +0200
+++ /export/home/pb2/test/sb_1-577679-1244827829.22/tmp//randgen8894-server1.dump	2009-06-12 19:31:34.000000000 +0200
@@ -28,6 +28,7 @@
 0	0	12	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	120	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	121	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
+0	0	122	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	123	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	124	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	125	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
@@ -62,6 +63,7 @@
 0	0	151	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	152	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	153	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
+0	0	154	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	155	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	156	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	157	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
@@ -96,6 +98,7 @@
 0	0	183	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	184	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	185	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
+0	0	186	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	187	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	188	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	189	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
@@ -132,6 +135,7 @@
 0	0	215	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	216	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	217	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
+0	0	218	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	219	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	22	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
 0	0	220	3.16952110520756e18	mhmhelelpjpjbibireredxdxkmkmjbjbiqiqekekndndlylynunupipilelecdcdqpqpvivilplpdvdvswswuxuxfufugpgpepepqjqjpupugsgslili
@@ -167,6 +171,7 @@

... and so on (see complete diff in the error log)

How to repeat:
Seen once after running falcon_chill_thaw_compare on the latest version from mysql-6.0-falcon-team tree.
[10 Jul 2009 19:03] Olav Sandstå 
The initial three test failures were on Linux but for the latest push it also happened on Windows in Pushbuild 2. 

Log files:

http://pb2.norway.sun.com/web.py?action=archive_download&archive_id=637734&pretty=please