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

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.041 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.