Bug #37354 Backup: crash if view of view of Falcon table

• Submitted: 11 Jun 2008 18:44
• Modified: 8 Sep 2008 11:32
• Reporter: Trudy Pelzer
• Status: Duplicate
• Category: MySQL Server: Backup
• Severity: S3 (Non-critical)
• Version: 6.0.6-alpha-debug
• OS: Linux (SUSE 10 | 32-bit)
• Assigned to: Assigned Account
• CPU Architecture: Any

[11 Jun 2008 18:44] Trudy Pelzer

Description:
I create a Falcon table.
I create a view of the table.
I create a view of the view.
I say BACKUP DATABASE.
Crash.

I'm using mysql-6.0, not mysql-6.0-backup.

How to repeat:
create database d3;
use d3
create table t (s1 int) engine=falcon;
create view v1 as select * from t;
create view v2 as select * from v1;
backup database d3 to '8';

Example run:

mysql> create database d3;
Query OK, 1 row affected (0.02 sec)

mysql> use d3
Database changed
mysql> create table t (s1 int) engine=falcon;
Query OK, 0 rows affected (0.06 sec)

mysql> create view v1 as select * from t;
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> backup database d3 to '8';
ERROR 2013 (HY000): Lost connection to MySQL server during query

[11 Jun 2008 22:43] MySQL Verification Team

Thank you for the bug report. Verified as described.

[8 Sep 2008 11:32] Sergey Vojtovich

Not repeatable with current trees. A duplicate of BUG#34758.