Bug #49740 rpl.rpl_temporary fails in PB2 in mysql-trunk-merge
Submitted: 16 Dec 2009 17:58 Modified: 15 Mar 2010 4:23
Reporter: Alexey Kopytov Email Updates:
Status: Closed Impact on me:
None 
Category:Tests: Replication Severity:S3 (Non-critical)
Version: OS:Any
Assigned to: Andrei Elkin CPU Architecture:Any
Triage: Triaged: D3 (Medium)

[16 Dec 2009 17:58] Alexey Kopytov
Description:
rpl.rpl_temporary started to fail in PB2 on all hosts in mysql-trunk-merge after a merge from mysql-5.1-bugteam (see the attached log).

How to repeat:
http://pb2.norway.sun.com/web.py?template=push_details&push=769045
[16 Dec 2009 17:59] Alexey Kopytov
PB2 log

Attachment: rpl_temporary_log.txt (text/plain), 8.07 KiB.

[17 Dec 2009 14:26] Luis Soares
Verified in PB2 and in local execution.

PB2
===

Environment details:

mysql-trunk-merge
770104	binary-max-linux-x86_64-tar-gz
770282 tyr31	test-max-linux-x86_64
770700 tyr76	n_mix	rpl	rpl_temporary	None	2009-12-16 19:38:55

Failure sample:

http://pb2.norway.sun.com/web.py?template=mysql_show_test_failure&search=yes&push_id=77010...

Locally
=======

This was not failing if I execute only the given test case.
However, I ran the mtr once with PB2 like parameters, which 
triggered the failure.

Tree Details:
  - tree: mysql-trunk-merge
  - revision-id: revision-id: alik@sun.com-20091216183525-vbefoeydwonfxkye

How to reproduce:
  1. clone mysql-trunk-merge with given revision.
  2. build it
  3. run: perl mysql-test-run.pl --mysqld=--binlog-format=mixed \
                                 --suite=main,binlog,innodb,federated,rpl
[17 Dec 2009 14:35] 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/94764

2825 Andrei Elkin	2009-12-17
      Bug #49740  rpl.rpl_temporary fails in PB2 in mysql-trunk-merge
      
      The test allowed random coincidence of connection ids for two concurrent
      sessions performing CREATE/DROP temp tables.
      
      Fixed with correcting the test. The sessions connection ids are not changed
      from their defaults anymore.
[17 Dec 2009 14:56] Andrei Elkin
Queued to bugteam trees.
[19 Dec 2009 8:28] Bugs System
Pushed into 6.0.14-alpha (revid:alik@sun.com-20091219082307-f3i4fn0tm8trb3c0) (version source revid:alik@sun.com-20091217193315-s3ck6ltg8m1zz6r3) (merge vers: 6.0.14-alpha) (pib:15)
[19 Dec 2009 8:31] Bugs System
Pushed into 5.5.1-m2 (revid:alik@sun.com-20091219082021-f34nq4jytwamozz0) (version source revid:alexey.kopytov@sun.com-20091217150904-ugetvos7v0bo83qe) (merge vers: 5.5.0-beta) (pib:15)
[19 Dec 2009 8:36] Bugs System
Pushed into mysql-next-mr (revid:alik@sun.com-20091219082213-nhjjgmphote4ntxj) (version source revid:alik@sun.com-20091217191654-rb9sci536v96viaz) (pib:15)
[19 Dec 2009 11:47] Jon Stephens
Changes are in testing code only; closed.
[14 Jan 2010 8:26] Bugs System
Pushed into 5.0.90 (revid:joro@sun.com-20100114082402-05fod2h6z9x9wok8) (version source revid:aelkin@mysql.com-20091217143411-0h95s80ykl33so5d) (merge vers: 5.0.89) (pib:16)
[15 Jan 2010 9:00] Bugs System
Pushed into 5.1.43 (revid:joro@sun.com-20100115085139-qkh0i0fpohd9u9p5) (version source revid:jimw@mysql.com-20091217191514-t4zu0fd4z9534u1q) (merge vers: 5.1.42) (pib:16)
[12 Mar 2010 14:07] Bugs System
Pushed into 5.1.44-ndb-7.0.14 (revid:jonas@mysql.com-20100312135944-t0z8s1da2orvl66x) (version source revid:jonas@mysql.com-20100312115609-woou0te4a6s4ae9y) (merge vers: 5.1.44-ndb-7.0.14) (pib:16)
[12 Mar 2010 14:23] Bugs System
Pushed into 5.1.44-ndb-6.2.19 (revid:jonas@mysql.com-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:jonas@mysql.com-20100312060623-mx6407w2vx76h3by) (merge vers: 5.1.44-ndb-6.2.19) (pib:16)
[12 Mar 2010 14:37] Bugs System
Pushed into 5.1.44-ndb-6.3.33 (revid:jonas@mysql.com-20100312135724-xcw8vw2lu3mijrhn) (version source revid:jonas@mysql.com-20100312103652-snkltsd197l7q2yg) (merge vers: 5.1.44-ndb-6.3.33) (pib:16)
[15 Mar 2010 4:23] Jon Stephens
Closed. See my previous comment.