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
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.