Bug #45500 falcon_chill_thaw_compare: mismatch in number of rows returned between servers
Submitted: 15 Jun 14:20 Modified: 15 Jun 14:47
Reporter: Olav Sandstaa
Status: In progress
Category:Server: Falcon Severity:S2 (Serious)
Version:6.0.12-alpha OS:Any
Assigned to: Kevin Lewis Target Version:6.0+
Tags: F_ISOLATION
Triage: Triaged: D2 (Serious)

[15 Jun 14:20] Olav Sandstaa
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 21:03] Olav Sandstaa
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