Bug #19234 ERROR 2013 (HY000): Lost connection to MySQL server during query
Submitted: 20 Apr 2006 22:31 Modified: 24 Apr 2006 19:20
Reporter: Souvick De Sarkar Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Cluster: Cluster (NDB) storage engine Severity:S2 (Serious)
Version:5.1.7-beta-win3/5.1BK OS:Windows (Windows 2000/Linux)
Assigned to: CPU Architecture:Any

[20 Apr 2006 22:31] Souvick De Sarkar
Description:
I have installed mysql.5.1.7-beta afresh.
I was trying to create my own database and assign new tablespace for this purpose.
I gor the following error while I was trying to create a logfile group. Same error came up while trying to create tablespace. 

mysql> create tablespace sdsdb_tablespace add datafile 'c:\mysql5\data\sds01'
extent_size=1024 initial_size=10M;
ERROR 2013 (HY000): Lost connection to MySQL server during query.

In both situations the mysql server crashed. I had checked previous logs and found that the similiar type of bug has been closed earlier under a bug report - "incorrect parsing of create tablespace etc etc.

Help required.

How to repeat:
To repeat -
just install the mysql.5.1.7 beta and try to create a tablespace.

Suggested fix:
No suggested fixes yet.
[21 Apr 2006 23:24] MySQL Verification Team
Thank you for the bug report.

miguel@hegel:~/dbs/5.1> bin/mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.10-beta-debug

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

mysql> create tablespace sdsdb_tablespace add datafile '/home/miguel/dbs/5.1/var/sds01'
    -> extent_size=1024 initial_size=10M;
ERROR 2013 (HY000): Lost connection to MySQL server during query
mysql> 

[New Thread 1098406832 (LWP 6285)]
060422 20:21:57 [Note] /home/miguel/dbs/5.1/libexec/mysqld: ready for connections.
Version: '5.1.10-beta-debug'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
[New Thread 1118682032 (LWP 6287)]

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1118682032 (LWP 6287)]
0x083bbc0b in mysql_alter_tablespace (thd=0x92a39b0, ts_info=0x92c3eb8) at sql_tablespace.cc:33
33        if (hton->state == SHOW_OPTION_YES &&
(gdb) bt full
#0  0x083bbc0b in mysql_alter_tablespace (thd=0x92a39b0, ts_info=0x92c3eb8) at sql_tablespace.cc:33
        _db_func_ = 0x87631e1 "mysql_execute_command"
        _db_file_ = 0x876268a "sql_parse.cc"
        error = -1
        hton = (handlerton *) 0x0
        _db_level_ = 4
        _db_framep_ = (char **) 0x16
#1  0x0825ac4a in mysql_execute_command (thd=0x92a39b0) at sql_parse.cc:5069
        res = false
        lex = (LEX *) 0x92a39f0
        _db_func_ = 0x87635a4 "mysql_parse"
        _db_file_ = 0x876268a "sql_parse.cc"
        _db_level_ = 3
        _db_framep_ = (char **) 0x401de8a0
        result = 0
        select_lex = (SELECT_LEX *) 0x92a3c30
        first_table = (TABLE_LIST *) 0x0
        all_tables = (TABLE_LIST *) 0x0
        unit = (SELECT_LEX_UNIT *) 0x92a3a00
        __PRETTY_FUNCTION__ = "bool mysql_execute_command(THD*)"
#2  0x0825b0ae in mysql_parse (thd=0x92a39b0, 
<cut>
[24 Apr 2006 19:20] Tomas Ulin
duplicate with 18603