MySQL Bugs: #41653: rpl_innodb_bug30888 fails sporadically on pushbuild: warning in log

Bug #41653	rpl_innodb_bug30888 fails sporadically on pushbuild: warning in log
Submitted:	20 Dec 2008 10:23	Modified:	30 Jan 2009 18:05
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:	5.1-rpl-green, pushbuild, rpl_innodb_bug30888, sporadic, test failure

Description:
Pushbuild failure in 5.1-rpl, started on Dec 5, quite frequent (hence 5.1-rpl-green tag):

rpl.rpl_innodb_bug30888                  [ fail ]  Found warnings in server log file!
        Test ended at 2008-12-20 08:46:51
@log_error
/dev/shm/var-ps_row-111/mysqld.2/mysqld.err
log_error
081220 10:45:23 [ERROR] Slave: Cannot add or update a child row: a foreign key constraint fails (`test`.`ti2`, CONSTRAINT `ti2_ibfk_1` FOREIGN KEY (`b`) REFERENCES `ti1` (`b`)) Error_code: 1452
081220 10:45:23 [ERROR] Slave: Can't find record in 't1' Error_code: 1032
Warnings:
Warning	1265	Data truncated for column 'text' at row 2
^ Found warnings!!

 - saving '/dev/shm/var-ps_row-111/log/rpl.rpl_innodb_bug30888/' to '/dev/shm/var-ps_row-111/log/rpl.rpl_innodb_bug30888/'

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

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-6.0-rpl&order=136 pb-valgrind/ps_row
xref: http://tinyurl.com/86regp

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/63345

2709 He Zhenxing	2009-01-15
      BUG#41653 rpl_innodb_bug30888 fails sporadically on pushbuild: warning in log
      
      In mtr.check_warnings, `text` was declares as type text, which is
      64K, and when the server log grows larger than this, it would be
      truncated, and then check_warnings was actually checking the 
      error messages of a previous test and complain warnings.
      
      This patch fixed the problem by change the type of `text` to
      mediumtext, which is 16M.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/63674

2714 He Zhenxing	2009-01-21
      BUG#41653 rpl_innodb_bug30888 fails sporadically on pushbuild: warning in log
      
      In mtr.check_warnings, `text` was declares as type text, which is
      64K, and when the server log grows larger than this, it would be
      truncated, and then check_warnings was actually checking the 
      error messages of a previous test and complain warnings.
      
      This patch fixed the problem by change the type of `text` to
      mediumtext, which is 16M.

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/63677

2785 He Zhenxing	2009-01-21 [merge]
      Merge BUG#41653 from 5.1-rpl to 6.0-rpl

Pushed into 6.0.10-alpha (revid:luis.soares@sun.com-20090129165607-wiskabxm948yx463) (version source revid:luis.soares@sun.com-20090129163120-e2ntks4wgpqde6zt) (merge vers: 6.0.10-alpha) (pib:6)

Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:msvensson@mysql.com-20090121134150-3trohhf2oc9bwhxr) (merge vers: 5.1.31) (pib:6)

Test suite changes. No changelog entry needed.

Pushed into 5.1.32-ndb-6.3.23 (revid:tomas.ulin@sun.com-20090217131017-6u8qz1edkjfiobef) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)

Pushed into 5.1.32-ndb-6.4.3 (revid:tomas.ulin@sun.com-20090217134419-5ha6xg4dpedrbmau) (version source revid:tomas.ulin@sun.com-20090203133556-9rclp06ol19bmzs4) (merge vers: 5.1.32-ndb-6.3.22) (pib:6)

Pushed into 5.1.32-ndb-6.2.17 (revid:tomas.ulin@sun.com-20090217134216-5699eq74ws4oxa0j) (version source revid:tomas.ulin@sun.com-20090201210519-vehobc4sy3g9s38e) (merge vers: 5.1.32-ndb-6.2.17) (pib:6)