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
• Status: Closed
• Category: Tests: Replication
• Severity: S3 (Non-critical)
• OS: Any
• Assigned to: Andrei Elkin
• CPU Architecture: Any

[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: [e-mail]-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:[e-mail]-20091219082307-f3i4fn0tm8trb3c0) (version source revid:[e-mail]-20091217193315-s3ck6ltg8m1zz6r3) (merge vers: 6.0.14-alpha) (pib:15)

[19 Dec 2009 8:31] Bugs System

Pushed into 5.5.1-m2 (revid:[e-mail]-20091219082021-f34nq4jytwamozz0) (version source revid:[e-mail]-20091217150904-ugetvos7v0bo83qe) (merge vers: 5.5.0-beta) (pib:15)

[19 Dec 2009 8:36] Bugs System

Pushed into mysql-next-mr (revid:[e-mail]-20091219082213-nhjjgmphote4ntxj) (version source revid:[e-mail]-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:[e-mail]-20100114082402-05fod2h6z9x9wok8) (version source revid:[e-mail]-20091217143411-0h95s80ykl33so5d) (merge vers: 5.0.89) (pib:16)

[15 Jan 2010 9:00] Bugs System

Pushed into 5.1.43 (revid:[e-mail]-20100115085139-qkh0i0fpohd9u9p5) (version source revid:[e-mail]-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:[e-mail]-20100312135944-t0z8s1da2orvl66x) (version source revid:[e-mail]-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:[e-mail]-20100312134846-tuqhd9w3tv4xgl3d) (version source revid:[e-mail]-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:[e-mail]-20100312135724-xcw8vw2lu3mijrhn) (version source revid:[e-mail]-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.