Bug #43245 | Stored Procedure can crash replication slave | ||
---|---|---|---|
Submitted: | 26 Feb 2009 23:10 | Modified: | 27 Feb 2009 7:06 |
Reporter: | Andrew Garner | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Replication | Severity: | S3 (Non-critical) |
Version: | 5.0.75,5.0.77,5.1.30,5.1.31 | OS: | Linux (RHES5,RHES4) |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash, replication, stored procedure |
[26 Feb 2009 23:10]
Andrew Garner
[26 Feb 2009 23:25]
Andrew Garner
Notably, this problem is not limited to replication. Simply running the generated statement against a vulnerable MySQL Server will cause a crash: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.77-log Source distribution Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> SHOW GLOBAL VARIABLES LIKE 'log_bin'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | log_bin | OFF | +---------------+-------+ 1 row in set (0.00 sec) mysql> CREATE TABLE IF NOT EXISTS test_tbl (data VARCHAR(32));Query OK, 0 rows affected (0.00 sec) mysql> UPDATE test_tbl SET data = NAME_CONST('arg',_latin1'another string' COLLATE 'latin1_swedish_ci') WHERE IFNULL(data, '') <> NAME_CONST('arg',_latin1'another string' COLLATE 'latin1_swedish_ci');ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>
[27 Feb 2009 7:06]
Valeriy Kravchuk
This is a duplcate of bug #42014.