Bug #42370 rpl_trigger.test: Test case timeout after 900 seconds
Submitted: 27 Jan 2009 11:24 Modified: 30 Jan 2009 18:09
Reporter: Luis Soares Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S7 (Test Cases)
Version: OS:Any
Assigned to: Luis Soares CPU Architecture:Any
Tags: 5.1-rpl-green, sporadic, test failure

[27 Jan 2009 11:24] Luis Soares
Description:
rpl.rpl_trigger                          [ fail ]  timeout after 900 seconds
        Test ended at 2009-01-26 20:47:31

Test case timeout after 900 seconds

== /dev/shm/var-n_mix-120/log/rpl_trigger.log == 
3	c
drop table t1;
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 table t1 ( f int ) engine = innodb;
create table log ( r int ) engine = myisam;
create trigger tr
after insert on t1
for each row insert into log values ( new.f );
set autocommit = 0;
insert into t1 values ( 1 );
rollback;
Warnings:
Warning	1196	Some non-transactional changed tables couldn't be rolled back
Comparing tables master:test.t1 and slave:test.t1
Comparing tables master:test.log and slave:test.log

 == /dev/shm/var-n_mix-120/tmp/analyze-timeout-mysqld.1.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/dev/shm/pbtmp-n_mix-120/mysqld.1.sock' (111)

 == /dev/shm/var-n_mix-120/tmp/analyze-timeout-mysqld.2.err ==
mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/dev/shm/pbtmp-n_mix-120/mysqld.2.sock' (111)

 - saving '/dev/shm/var-n_mix-120/log/rpl.rpl_trigger/' to '/dev/shm/var-n_mix-120/log/rpl.rpl_trigger/'
 - found 'core.8265' (0/5)

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=120

'sapsrv1' Autopush: 	n_mix

http://tinyurl.com/aux6vb
[27 Jan 2009 11:32] Bugs System
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/64117

2719 Luis Soares	2009-01-27
      BUG#42370: rpl_trigger.test: Test case timeout after 900 seconds
      
      The test fails with timeout when applying diff on two tables.
      
      In this test case, there can be a situation when the slave is not yet synced
      with the master, thence the changes may not be on the slave at diff time.
      
      This patch addresses this issue by synchronizing master and slave before the
      diff takes place.
[30 Jan 2009 13:27] Bugs System
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)
[30 Jan 2009 15:07] Bugs System
Pushed into 5.1.32 (revid:luis.soares@sun.com-20090129165946-d6jnnfqfokuzr09y) (version source revid:luis.soares@sun.com-20090127113216-03o72etze6nzry8a) (merge vers: 5.1.32) (pib:6)
[30 Jan 2009 18:09] Paul Dubois
Test case changes. No changelog entry needed.
[17 Feb 2009 14:53] Bugs System
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)
[17 Feb 2009 16:41] Bugs System
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)
[17 Feb 2009 18:17] Bugs System
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)