Bug #12079 'Create table' gets 'already exists' (due to replication?)
Submitted: 21 Jul 2005 11:25 Modified: 28 Jun 2006 18:15
Reporter: Joerg Bruehe Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Replication Severity:S2 (Serious)
Version:4.1.15 + 5.0.10 and higher OS:Unix (various)
Assigned to: Lars Thalmann CPU Architecture:Any

[21 Jul 2005 11:25] Joerg Bruehe
Description:
Build of 5.0.10, based on ChangeSet
  1.1960 05/07/20 10:16:43 jimw@mysql.com +1 -0
  Fix date conversion on 32-bit machines.

Test 'rpl000008' fails, only on host 'build', only in default test (PS passes):

rpl000008                      [ fail ]

Errors are (from /build/mysqldev/build/test/mysql-max-5.0.10-beta-linux-i686/mysql-test/var/log/mysqltest-time) :
/build/mysqldev/build/test/mysql-max-5.0.10-beta-linux-i686/bin/mysqltest: At line 21: query 'create table mysqltest_foo (n int)' failed: 1050: Table 'mysqltest_foo' already exists
(the last lines may be the most important ones)

Ending Tests

How to repeat:
Test suite failure
[5 Oct 2005 15:31] Joerg Bruehe
Same symptom in 5.0.14-rc:

===== cut =====
count_distinct2                [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line 5: query 'create table t1(n1 int, n2 int, s char(20), vs varchar(20), t text)' failed: 1050: Table 't1' already exists
(the last lines may be the most important ones)

Ending Tests
===== cut =====

occurred:
production-icc-glibc23-5.0-max.log   normal
[5 Oct 2005 15:34] Joerg Bruehe
Another one, 5.0.14-rc:

===== cut =====
multi_update                   [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line 364: query 'CREATE TABLE t1 ( a int )' failed: 1050: Table 't1' already exists
(the last lines may be the most important ones)

Ending Tests
===== cut =====

Occurred:
nocona-icc-glibc23-5.0-max.log   normal

And finally:
===== cut =====
xa                             [ fail ]

Errors are (from PATH/mysqltest-time) :
mysqltest: At line 8: unable to execute statement 'create table t1 (a int) engine=innodb': Table 't1' already exists (mysql_stmt_errno=1050 returned=1)
(the last lines may be the most important ones)

Ending Tests
===== cut =====

Occurred:
sol10-sparc-a-64bit-5.0-max.log   ps-protocol
[7 Oct 2005 12:04] Joerg Bruehe
Bug is spreading to 4.1: In a test build of 4.1.15, we get this:

func_concat                    [ fail ]

Errors are (from /usr/people/mysqldev/octane2/test/mysql-max-4.1.15-20051007-sgi-irix6.5-mips/mysql-test/var/log/mysqltest-time) :
mysqltest: At line 9: query 'CREATE TABLE t1 ( number INT NOT NULL, alpha CHAR(6) NOT NULL )' failed: 1050: Table 't1' already exists

(on "octane2", in "max").

Happened only in "default" test, "--ps-protocol" passed.
(the last lines may be the most important ones)

Ending Tests