Bug #39001 binlog.binlog_stm_innodb_stat
Submitted: 25 Aug 2008 10:38 Modified: 20 Oct 2008 7:53
Reporter: Sven Sandberg Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version:5.1-rpl OS:Any
Assigned to: Zhenxing He CPU Architecture:Any
Tags: binlog.binlog_stm_innodb_stat, pushbuild, test failure

[25 Aug 2008 10:38] Sven Sandberg
Description:
pushbuild failure:

binlog.binlog_stm_innodb_stat            [ fail ]

CURRENT_TEST: binlog.binlog_stm_innodb_stat
--- e:/pb/bzr_mysql-5.1-rpl/33/mysql-5.1.28-pb33/mysql-test/suite/binlog/r/binlog_stm_innodb_stat.result	2008-08-09 13:24:58.000000000 +0300
+++ e:\pb\bzr_mysql-5.1-rpl\33\mysql-5.1.28-pb33\mysql-test\suite\binlog\r\binlog_stm_innodb_stat.reject	2008-08-09 14:39:06.678000000 +0300
@@ -1,39 +1,39 @@
-show status like "binlog_cache_use";
-Variable_name	Value
-Binlog_cache_use	0
-show status like "binlog_cache_disk_use";
-Variable_name	Value
-Binlog_cache_disk_use	0
-drop table if exists t1;
-create table t1 (a int) engine=innodb;
-show status like "binlog_cache_use";
-Variable_name	Value
-Binlog_cache_use	1
-show status like "binlog_cache_disk_use";
-Variable_name	Value
-Binlog_cache_disk_use	1
-begin;
-delete from t1;
-commit;
-show status like "binlog_cache_use";
-Variable_name	Value
-Binlog_cache_use	2
-show status like "binlog_cache_disk_use";
-Variable_name	Value
-Binlog_cache_disk_use	1
-drop table t1;
-show status like "Innodb_buffer_pool_pages_total";
-Variable_name	Value
-Innodb_buffer_pool_pages_total	512
-show status like "Innodb_page_size";
-Variable_name	Value
-Innodb_page_size	16384
-show status like "Innodb_rows_deleted";
-Variable_name	Value
-Innodb_rows_deleted	2000
-show status like "Innodb_rows_inserted";
-Variable_name	Value
-Innodb_rows_inserted	2000
-show status like "Innodb_rows_updated";
-Variable_name	Value
-Innodb_rows_updated	0
+show status like "binlog_cache_use";
+Variable_name	Value
+Binlog_cache_use	0
+show status like "binlog_cache_disk_use";
+Variable_name	Value
+Binlog_cache_disk_use	0
+drop table if exists t1;
+create table t1 (a int) engine=innodb;
+show status like "binlog_cache_use";
+Variable_name	Value
+Binlog_cache_use	1
+show status like "binlog_cache_disk_use";
+Variable_name	Value
+Binlog_cache_disk_use	1
+begin;
+delete from t1;
+commit;
+show status like "binlog_cache_use";
+Variable_name	Value
+Binlog_cache_use	2
+show status like "binlog_cache_disk_use";
+Variable_name	Value
+Binlog_cache_disk_use	1
+drop table t1;
+show status like "Innodb_buffer_pool_pages_total";
+Variable_name	Value
+Innodb_buffer_pool_pages_total	512
+show status like "Innodb_page_size";
+Variable_name	Value
+Innodb_page_size	16384
+show status like "Innodb_rows_deleted";
+Variable_name	Value
+Innodb_rows_deleted	2000
+show status like "Innodb_rows_inserted";
+Variable_name	Value
+Innodb_rows_inserted	2000
+show status like "Innodb_rows_updated";
+Variable_name	Value
+Innodb_rows_updated	0

mysqltest: Result content mismatch

 - saving 'e:/pb/bzr_mysql-5.1-rpl/33/mysql-5.1.28-pb33/mysql-test/var-n_mix-5/1/log/binlog.binlog_stm_innodb_stat/' to 'e:/pb/bzr_mysql-5.1-rpl/33/mysql-5.1.28-pb33/mysql-test/var-n_mix-5/log/binlog.binlog_stm_innodb_stat/'

Retrying test, attempt(2/3)...

This looks different from BUG#37312.

How to repeat:
Seen in both binlog_stm_innodb_stat and binlog_row_innodb_stat, on

https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=33 win2003-x86/n_mix and ps_row

Also on vm-win2003-32-a in the same  push.
[20 Oct 2008 7:53] Zhenxing He
This is a problem caused by CR/LF difference on difference flatforms, already been fixed by the following push:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=34