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: | |
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
[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