Bug #66008 | MySQL crashes during manual insert into mysql.servers table | ||
---|---|---|---|
Submitted: | 25 Jul 2012 10:22 | Modified: | 27 Jul 2012 12:45 |
Reporter: | Vyacheslav Gritsenko | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server: Security: Privileges | Severity: | S1 (Critical) |
Version: | 5.1, 5.5, 5.6.7 | OS: | Linux (tested on CentOS-6.3) |
Assigned to: | CPU Architecture: | Any | |
Tags: | crash, federated, mysql.servers |
[25 Jul 2012 10:22]
Vyacheslav Gritsenko
[25 Jul 2012 11:30]
Valeriy Kravchuk
Thank you for the bug report. Same with 5.6: [openxs@chief 5.6]$ bin/mysql -uroot test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 5.6.7-debug Source distribution Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> select * from mysql.servers; Empty set (0.00 sec) mysql> insert into mysql.servers set host='sfdsfsfsdf'; Query OK, 1 row affected (0.00 sec) mysql> flush privileges; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> 120725 14:28:19 mysqld_safe Number of processes running now: 0 120725 14:28:19 mysqld_safe mysqld restarted 120725 14:28:21 mysqld_safe Number of processes running now: 0 120725 14:28:21 mysqld_safe mysqld restarted
[25 Jul 2012 14:23]
MySQL Verification Team
Could be a duplicate of this? Bug#14220942: DDL ON SERVERS WITH ZERO LENGTH NAME CRASHES SERVER!
[4 Sep 2012 8:52]
Raghavendra Prabhu
Is this bug a duplicate or has this been fixed to mark it closed? I tested on 5.5.27 and could replicate this.
[4 Sep 2012 10:12]
MySQL Verification Team
from what I see it was only fixed in 5.6.7 and 5.7.0 versions.