lnxdb1:~# gdb /usr/local/mysql/libexec/mysqld GNU gdb 6.4-debian Copyright 2005 Free Software Foundation, Inc. GDB is free software, covered by the GNU General Public License, and you are welcome to change it and/or distribute copies of it under certain conditions. Type "show copying" to see the conditions. There is absolutely no warranty for GDB. Type "show warranty" for details. This GDB was configured as "i486-linux-gnu"...Using host libthread_db library "/lib/tls/i686/cmov/libthread_db.so.1". (gdb) run --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/mysql.pid --skip-locking --debug="d:t:O,mysql.log" Starting program: /usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/usr/local/mysql/var --user=mysql --pid-file=/usr/local/mysql/var/mysql.pid --skip-locking --debug="d:t:O,mysql.log" [Thread debugging using libthread_db enabled] [New Thread -1210619232 (LWP 22737)] [New Thread -1222415440 (LWP 22740)] [New Thread -1230808144 (LWP 22741)] [New Thread -1239200848 (LWP 22742)] [New Thread -1247593552 (LWP 22743)] 060203 14:33:31 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 060203 14:33:31 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 2509212. InnoDB: Doing recovery: scanned up to log sequence number 0 2509464 060203 14:33:31 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed InnoDB: Last MySQL binlog file position 0 0, file name [New Thread -1260766288 (LWP 22744)] [New Thread -1269158992 (LWP 22745)] [New Thread -1277580368 (LWP 22746)] [Thread -1260766288 (zombie) exited] [New Thread -1286018128 (LWP 22747)] 060203 14:33:32 InnoDB: Started; log sequence number 0 2509464 [New Thread -1256899664 (LWP 22748)] 060203 14:33:32 [Note] /usr/local/mysql/libexec/mysqld: ready for connections. Version: '5.0.18-debug' socket: '/usr/local/mysql/tmp/mysql.sock' port: 3306 Source distribution [New Thread -1257100368 (LWP 22755)] [New Thread -1257432144 (LWP 22756)] [New Thread -1257632848 (LWP 22757)] [New Thread -1257833552 (LWP 22758)] [New Thread -1258034256 (LWP 22759)] [New Thread -1258234960 (LWP 22760)] [New Thread -1258435664 (LWP 22761)] [New Thread -1302852688 (LWP 22762)] [Thread -1257100368 (zombie) exited] [New Thread -1257100368 (LWP 22763)] [New Thread -1303053392 (LWP 22764)] [Thread -1257632848 (zombie) exited] [Thread -1257432144 (zombie) exited] [New Thread -1257432144 (LWP 22765)] [New Thread -1257632848 (LWP 22766)] [New Thread -1303254096 (LWP 22767)] [Thread -1257833552 (zombie) exited] [New Thread -1257833552 (LWP 22768)] [Thread -1258435664 (zombie) exited] [Thread -1302852688 (zombie) exited] Program received signal SIGSEGV, Segmentation fault. [Switching to Thread -1257632848 (LWP 22766)] 0x081a6c89 in check_table_access (thd=0x8bd7038, want_access=8, tables=0x8d5d648, no_errors=false) at sql_parse.cc:5108 5108 if (tables->derived || tables->schema_table || tables->belong_to_view || (gdb) bt #0 0x081a6c89 in check_table_access (thd=0x8bd7038, want_access=8, tables=0x8d5d648, no_errors=false) at sql_parse.cc:5108 #1 0x081a6f58 in multi_delete_precheck (thd=0x8bd7038, tables=0x8d5d828) at sql_parse.cc:6923 #2 0x081adcc9 in mysql_execute_command (thd=0x8bd7038) at sql_parse.cc:3368 #3 0x08216750 in Prepared_statement::execute (this=0x8d36038, expanded_query=0xb509ffb8, open_cursor=false) at sql_prepare.cc:2898 #4 0x08216c64 in mysql_stmt_execute (thd=0x8bd7038, packet_arg=0x8c7ccf1 "\006", packet_length=22) at sql_prepare.cc:2225 #5 0x081b34bb in dispatch_command (command=COM_STMT_EXECUTE, thd=0x8bd7038, packet=0x8c7ccf1 "\006", packet_length=22) at sql_parse.cc:1674 #6 0x081b4960 in do_command (thd=0x8bd7038) at sql_parse.cc:1514 #7 0x081b4d6c in handle_one_connection (arg=0x8bd7038) at sql_parse.cc:1158 #8 0xb7f1ce70 in start_thread () from /lib/tls/i686/cmov/libpthread.so.0 #9 0xb7e47c0e in clone () from /lib/tls/i686/cmov/libc.so.6 (gdb) print tables->table->s $1 = (TABLE_SHARE *) 0x8001081 (gdb) print *(tables->table->s) Cannot access memory at address 0x8001081 (gdb)