Bug #35347 Mysql Server crash while doing restore with views for default driver
Submitted: 17 Mar 2008 18:03 Modified: 11 Aug 2008 23:40
Reporter: Hema Sridharan Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Backup Severity:S3 (Non-critical)
Version:mysql-6.0-backup OS:Linux
Assigned to: Jørgen Løland CPU Architecture:Any

[17 Mar 2008 18:03] Hema Sridharan
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
[17 Mar 2008 19:37] Sveta Smirnova
Thank you for the report.

Verified as described.
[8 Aug 2008 15:38] Paul DuBois
Fixed is pushed in 6.0.7.
[11 Aug 2008 20:41] Paul DuBois
Noted in 6.0.7 changelog.

BACKUP DATABASE caused a server crash if it attempted to back up a
view that depended on another view.