Bug #34759 | Server crash when backing-up database with trigger | ||
---|---|---|---|
Submitted: | 22 Feb 2008 12:45 | Modified: | 21 May 2008 20:10 |
Reporter: | Rafal Somla | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Backup | Severity: | S2 (Serious) |
Version: | 6.0.5 | OS: | Any |
Assigned to: | Jørgen Løland | CPU Architecture: | Any |
[22 Feb 2008 12:45]
Rafal Somla
[28 Feb 2008 17:40]
MySQL Verification Team
Thank you for the bug report. CREATE TABLE t1(a int); CREATE TABLE t2(a int); delimiter || CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN DELETE FROM t2 WHERE a > 1; END|| delimiter ; INSERT INTO t2 VALUES (2); INSERT INTO t1 VALUES (1); BACKUP DATABASE test TO 'test.bak'; [miguel@mira dbs]$ 6.0b/bin/mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 6.0.5-alpha-debug Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use test Database changed mysql> CREATE TABLE t1(a int); Query OK, 0 rows affected (0.01 sec) mysql> CREATE TABLE t2(a int); Query OK, 0 rows affected (0.00 sec) mysql> mysql> delimiter || mysql> mysql> CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW -> BEGIN -> DELETE FROM t2 WHERE a > 1; -> END|| Query OK, 0 rows affected (0.01 sec) mysql> delimiter ; mysql> mysql> INSERT INTO t2 VALUES (2); Query OK, 1 row affected (0.01 sec) mysql> INSERT INTO t1 VALUES (1); Query OK, 1 row affected (0.02 sec) mysql> mysql> BACKUP DATABASE test TO 'test.bak'; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>
[18 Mar 2008 15:08]
Hema Sridharan
Even I could notice the similar behavior in my system. But to be more precise, there is a mysql server crash when backing up database with after insert trigger event and for default blocking drivers and not for CS drivers.
[27 Mar 2008 22:31]
Hema Sridharan
This Bug depends on Bug#35249
[21 May 2008 20:09]
Øystein Grøvlen
I am not able to reproduce this. The following script succeeds for me: CREATE TABLE t1(a int); CREATE TABLE t2(a int); delimiter ||; CREATE TRIGGER tr1 AFTER INSERT ON t1 FOR EACH ROW BEGIN DELETE FROM t2 WHERE a > 1; END; || delimiter ;|| INSERT INTO t2 VALUES (2); INSERT INTO t1 VALUES (1); BACKUP DATABASE test TO 'test.bak';