MySQL Bugs: #38575: rpl.rpl_insert 'mix' test case fails

Bug #38575	rpl.rpl_insert 'mix' test case fails
Submitted:	5 Aug 2008 15:31	Modified:	14 Oct 2008 16:04
Reporter:	BJ Dierkes	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	Tests: Replication	Severity:	S3 (Non-critical)
Version:	5.1.26-rc	OS:	Linux (Redhat Enterprise Linux 5 - 64bit)
Assigned to:		CPU Architecture:	Any

Description:
MySQL 5.1.26-rc
Redhat Enterprise Linux 5Server 64bit

Note that the issue is not apparent on RHEL5 32bit, additionally the build completes successfully on RHEL4 32bit (am trying 64bit now).  I have attempted RHEL5 64bit atleast 4-5 times with the same exact failure.

MYSQL TEST OUTPUT:

rpl.rpl_innodb_bug30919 'mix'  
[ pass ]           1152
rpl.rpl_innodb_mixed_ddl 'mix' 
[ pass ]            650
rpl.rpl_innodb_mixed_dml 'mix' [ pass ]           4789
rpl.rpl_insert 'mix'           
[ fail ]
mysqltest: At line 20: command "$MYSQL_SLAP --silent --concurrency=5 --iterations=200
--query=$query --delimiter=";"" failed
The result from queries just before the failure was:
#
# Bug#20821: INSERT DELAYED fails to write some rows to binlog
#
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
CREATE SCHEMA IF NOT EXISTS mysqlslap;
USE mysqlslap;
CREATE TABLE t1 (id INT, name VARCHAR(64));
exec of '/builddir/build/BUILD/mysql-5.1.26-rc/client/mysqlslap -uroot --port=9306
--socket=/builddir/build/BUILD/mysql-5.1.26-rc/mysql-test/var/tmp/master.sock --password= 
--silent --concurrency=5 --iterations=200 --query="INSERT DELAYED INTO t1 VALUES (1, 'Dr.
No'), (2, 'From Russia With Love'), (3, 'Goldfinger'), (4, 'Thunderball'), (5, 'You Only
Live Twice')" --delimiter=";"' failed, error: 512, status: 2, errno: 0
More results from queries before failure can be found in
/builddir/build/BUILD/mysql-5.1.26-rc/mysql-test/var/log/rpl_insert.log
Aborting: rpl.rpl_insert failed in default mode. 
To continue, re-run with '--force'.
Stopping All Servers
make: *** [test-ns] Error 1

OTHER LOG: 

/builddir/build/BUILD/mysql-5.1.26-rc/mysql-test/var/log/rpl_insert.log

#
# Bug#20821: INSERT DELAYED fails to write some rows to binlog
#
stop slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
reset master;
reset slave;
drop table if exists t1,t2,t3,t4,t5,t6,t7,t8,t9;
start slave;
CREATE SCHEMA IF NOT EXISTS mysqlslap;
USE mysqlslap;
CREATE TABLE t1 (id INT, name VARCHAR(64));
exec of '/builddir/build/BUILD/mysql-5.1.26-rc/client/mysqlslap -uroot --port=9306
--socket=/builddir/build/BUILD/mysql-5.1.26-rc/mysql-test/var/tmp/master.sock --password= 
--silent --concurrency=5 --iterations=200 --query="INSERT DELAYED INTO t1 VALUES (1, 'Dr.
No'), (2, 'From Russia With Love'), (3, 'Goldfinger'), (4, 'Thunderball'), (5, 'You Only
Live Twice')" --delimiter=";"' failed, error: 512, status: 2, errno: 0

Not that I think it is related, however I did also apply the patches committed for bug:

Bug#21358

And the tests for mysqlslap were still failing... so I added the mysqlslap test to
disabled.def ....  Like I said not sure if anything would be related...  but it seems the test failures keep compounding so the only way to get through a build is to disable them.

Please let me know if there is any further info that might be helpful.

Thanks.

How to repeat:
make && make test

Suggested fix:
uncertain.

Thank you for the report.

I can not repeat described behavior with current development sources. Please provide configure options you used.

Using the exact same build.... everything completes successfully on EL4 i386, EL4 x86_64, and EL5 i386 ....  only EL5 x86_64 is failing currently.

./configure --build=x86_64-redhat-linux-gnu \
--host=x86_64-redhat-linux-gnu \
--target=x86_64-redhat-linux-gnu \
--program-prefix= \
--prefix=/usr \
--exec-prefix=/usr \
--bindir=/usr/bin \
--sbindir=/usr/sbin \
--sysconfdir=/etc \
--datadir=/usr/share \
--includedir=/usr/include \
--libdir=/usr/lib64 \
--libexecdir=/usr/libexec \
--localstatedir=/var \
--sharedstatedir=/usr/com \
--mandir=/usr/share/man \
--infodir=/usr/share/info \
--with-pic \
--with-readline \
--with-ssl \
--without-debug \
--enable-shared \
--with-bench \
--localstatedir=/var/lib/mysql \
--with-unix-socket-path=/var/lib/mysql/mysql.sock \
--with-mysqld-user=mysql \
--with-extra-charsets=all \
--with-innodb \
--with-berkeley-db \
--enable-local-infile \
--enable-largefile \
--enable-thread-safe-client \
--disable-dependency-tracking \
--with-plugin-partition \
--with-plugin-csv \
--with-plugin-ndbcluster \
--with-named-thread-libs=-lpthread

I couldn't repeat on FC 64-bit with current source.

Please, try to repeat with a newer version, 5.1.28, and inform about the results.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".