Bug #16532 mysql server assert in debug if table det is removed

Submitted: 16 Jan 2006 12:01 Modified: 2 Aug 2006 18:01
Reporter: Tomas Ulin Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: General Severity:S3 (Non-critical)
Version:5.1.5/5.1.6 BK OS:Linux (Linux)
Assigned to: Andrey Hristov CPU Architecture:Any

[16 Jan 2006 12:01] Tomas Ulin
Description:
removing table definition causes assert to trigger

How to repeat:
create table t1 (a int primary key, b int);
insert into t1 values(1,1);
rm test/t1.*
create table t1 (a int primary key, b int, c int);

-->

ERROR 2013 (HY000): Lost connection to MySQL server during query

#12 0x08305e5e in mysql_create_table(THD*, char const*, char const*, st_ha_create_information*, List<create_field>&, List<Key>&, bool, unsigned) (
    thd=0x92fa290, db=0x92c16e0 "test", table_name=0x93077b0 "t2", create_info=0x92fa828, fields=@0x92fa74c, keys=@0x92fa740, 
    internal_tmp_table=false, select_field_count=0) at sql_table.cc:1943
1943        DBUG_ASSERT(get_cached_table_share(db, alias) == 0);
[16 Jan 2006 12:08] MySQL Verification Team
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 2 to server version: 5.1.6-alpha-debug

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> create table t1 (a int primary key, b int, c int);
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql>
[21 Jan 2006 12:42] Brian Aker
I have been noticing this as well. We may not be able to support this any longer. Kostja's team gets to own the table definition cache.
[19 Jul 2006 16:49] 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/9340
[2 Aug 2006 10:32] Andrey Hristov
Will be fixed in 5.1.12
[2 Aug 2006 18:01] Paul DuBois
Noted in 5.1.12 changelog.

If the files for an open table were removed at the OS level (external
to the server), the server exited with an assertion failure.

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

Page generated in 0.039 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.