Bug #21179 Test "mysqlbinlog" shows incomplete log contents
Submitted: 20 Jul 2006 13:20 Modified: 17 Mar 2008 14:07
Reporter: Joerg Bruehe Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Logging Severity:S2 (Serious)
Version:4.1.21 OS:Other (various)
Assigned to: Assigned Account CPU Architecture:Any

[20 Jul 2006 13:20] Joerg Bruehe
Description:
Release build of 4.1.21,
effect has not been noticed before:

=====
mysqlbinlog                    [ fail ]

Errors are (from /PATH/mysqltest-time) :
Warning: ignoring Exec_load as there is no Create_file event for file_id: 6
Warning: ignoring Exec_load as there is no Create_file event for file_id: 1
Warning: ignoring Exec_load as there is no Create_file event for file_id: 2
Warning: ignoring Exec_load as there is no Create_file event for file_id: 3
Warning: ignoring Exec_load as there is no Create_file event for file_id: 4
Warning: ignoring Exec_load as there is no Create_file event for file_id: 5
Warning: ignoring Exec_load as there is no Create_file event for file_id: 6
Warning: ignoring Exec_load as there is no Create_file event for file_id: 1
Warning: ignoring Exec_load as there is no Create_file event for file_id: 2
Warning: ignoring Exec_load as there is no Create_file event for file_id: 3
Warning: ignoring Exec_load as there is no Create_file event for file_id: 4
Warning: ignoring Exec_load as there is no Create_file event for file_id: 5
mysqltest: Result length mismatch
(the last lines may be the most important ones)
Below are the diffs between actual and expected results:
-------------------------------------------------------
*** r/mysqlbinlog.result
--- r/mysqlbinlog.reject
***************
*** 105,109
  select * from t5  /* must be (1),(1) */;
  a
  1
- 1
  drop table t1, t2, t03, t04, t3, t4, t5;
--- 105,108
-------------------------------------------------------
=====

Occurred (until now, more product builds still running):
bsd60-4.1-debug.log   normal
bsd60-4.1-max.log   normal
bsd60-4.1-max.log   NDB
bsd60-4.1-pro.log   normal
bsd60-64-4.1-debug.log   normal
hpita2-64bit-4.1-debug.log   normal
hpita2-64bit-4.1-debug.log   ps

How to repeat:
Build + test on all platforms.
[17 Mar 2008 14:07] Andrei Elkin
Bug #34986  	Test 'mysqlbinlog' fails on FreeBSD 6.0 x86 32-bit, non PS mode
is set as the parent for the current one which is a duplicate according to log lines.