Bug #40708 rpl_row_create_table fails sporadically in pushbuild
Submitted: 13 Nov 2008 17:10 Modified: 30 Jan 2009 17:56
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: Serge Kozlov CPU Architecture:Any
Tags: 5.1-rpl-green, pushbuild, rpl_row_create_table, sporadic, test failure

[13 Nov 2008 17:10] Sven Sandberg
Description:
pushbuild failure happened once so far:

rpl.rpl_row_create_table                 [ fail ]

CURRENT_TEST: rpl.rpl_row_create_table
mysqltest: At line 269: query 'CREATE DATABASE mysqltest1' failed: 1007: Can't create database 'mysqltest1'; database exists

The result from queries just before the failure was:
< snip >
DROP TABLE t1,t2;
CREATE TABLE t1 (a INT);
INSERT INTO t1 VALUES (1),(1);
CREATE TABLE t2 (a INT UNIQUE) ENGINE=INNODB SELECT * FROM t1;
ERROR 23000: Duplicate entry '1' for key 'a'
INSERT INTO t1 VALUES (2);
*** the proof of the fix:
select must show that the last insert performed on the slave ***
SELECT * FROM t1;
a
1
1
2
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;

More results from queries before failure can be found in /dev/shm/var-ps_row-131/3/log/rpl_row_create_table.log

 - saving '/dev/shm/var-ps_row-131/3/log/rpl.rpl_row_create_table/' to '/dev/shm/var-ps_row-131/log/rpl.rpl_row_create_table/'

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

How to repeat:
https://intranet.mysql.com/secure/pushbuild/showpush.pl?dir=bzr_mysql-5.1-rpl&order=78 sapsrv1/ps_row
xref: http://tinyurl.com/5mdgrx
[21 Nov 2008 13:22] Sven Sandberg
The failure has now happened three times according to the xref link
[24 Nov 2008 21:04] 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/59724

2704 Serge Kozlov	2008-11-25
      Bug#40708: Added DROP DATABASE as cleanup operation.
[25 Nov 2008 11:02] 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/59771

2704 Serge Kozlov	2008-11-25
      Bug#40708: Sometimes DB mysqltest1 did not removed before
      starting test rpl_row_create_table therefore the patch add 
      the cleanup operation if DB with such name already exists. 
      
      Added DROP DATABASE IF EXISTS before query CREATE DATABASE.
[27 Nov 2008 12:05] 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/60026

2705 Serge Kozlov	2008-11-27
      Bug#40708: Sometimes DB mysqltest1 did not removed before
      starting test rpl_row_create_table therefore the patch add 
      the cleanup operation if DB with such name already exists.
[27 Nov 2008 12:21] 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/60029

2740 Serge Kozlov	2008-11-27 [merge]
      Bug#40145. Argument for LOAD_FILE() can be too long and sometimes
      a query with two or more these functions truncated. Therefore data 
      from each LOAD_FILE() copied into its local variables and then used
      in a query.
      Bug#40708: Sometimes DB mysqltest1 did not removed before
      starting test rpl_row_create_table therefore the patch add 
      the cleanup operation if DB with such name already exists.
[28 Nov 2008 9:53] 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/60130

2702 He Zhenxing	2008-11-28 [merge]
      Auto merge
[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:msvensson@mysql.com-20081205211552-7odzip74f430g1du) (merge vers: 5.1.31) (pib:6)
[30 Jan 2009 17:56] Paul DuBois
Test case changes. No changelog entry needed.
[17 Feb 2009 14:54] 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:42] 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:18] 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)