Description:
1) I create database and tables in database.I create table with default blocking drivers(myisam)
2) I create views from tables.
3) I backup database , the command is successful
4) When I restore it, mysql server crashes .
Stack dump:
080317 20:49:55 [Note] Backup: Starting backup process
080317 20:49:55 [Note] Backup: Backing up selected databases
080317 20:49:55 [Note] Backup: Backup completed
080317 20:50:09 [Note] Restore: Starting restore process
080317 20:50:09 - mysqld got signal 11 ;
Here is the stack trace:
ndbdev@ndb16:/data2/hemanew_clone/mysql-6.0-backup/extra> ./resolve_stack_dump -s /tmp/mysqld.sym -n mysqld.stack
0x87a725 print_stacktrace + 21
0x6dc09b handle_segfault + 595
0x3f4080c430 _end + 1060661000
0x87bf98 _Z21check_duplicate_namesR4ListI4ItemEb + 140
0x87a05a _Z21mysql_derived_prepareP3THDP6st_lexP10TABLE_LIST + 324
0x879e9d _Z20mysql_handle_derivedP6st_lexPFbP3THDS0_P10TABLE_LISTE + 137
0x7340c7 _Z28open_and_lock_tables_derivedP3THDP10TABLE_LISTb + 339
0x6f9458 _Z20open_and_lock_tablesP3THDP10TABLE_LIST + 34
0xcb0cd1 _ZN6backup18restore_table_dataEP3THDRNS_12Restore_infoERNS_7IStreamE + 887
0xca96ec _Z13mysql_restoreP3THDRN6backup12Restore_infoERNS1_7IStreamE + 278
0xca7259 _Z22execute_backup_commandP3THDP6st_lex + 1421
0x6ecb8a _Z21mysql_execute_commandP3THD + 1934
0x6f565d _Z11mysql_parseP3THDPKcjPS2_ + 407
0x6eacec _Z16dispatch_command19enum_server_commandP3THDPcj + 2176
0x6ea229 _Z10do_commandP3THD + 543
0x6e7ca7 handle_one_connection + 287
0x3f4080610a _end + 1060635618
0x3f3ffc68b3 _end + 1051986827
How to repeat:
mysql> create database db1;
Query OK, 1 row affected (0.00 sec)
mysql> use db1;
Database changed
mysql> create table t1(id int, name char(10))engine=myisam;
Query OK, 0 rows affected (0.04 sec)
mysql> insert into t1 values(1,'aa'),(2,'bb');
Query OK, 2 rows affected (0.00 sec)
Records: 2 Duplicates: 0 Warnings: 0
mysql> create view v1 as select name from t1;
Query OK, 0 rows affected (0.00 sec)
mysql> create view v2 as select * from v1;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from v1;
+------+
| name |
+------+
| aa |
| bb |
+------+
2 rows in set (0.00 sec)
mysql> select * from v2;
+------+
| name |
+------+
| aa |
| bb |
+------+
2 rows in set (0.00 sec)
mysql> backup database db1 to '/data2/heman/backup_dmp/views/db1';
+-----------+
| backup_id |
+-----------+
| 1 |
+-----------+
1 row in set (0.09 sec)
mysql> restore from '/data2/heman/backup_dmp/views/db1';
ERROR 2013 (HY000): Lost connection to MySQL server during query