Bug #19440 | GRANT SELECT ON db.table crashes mysqld | ||
---|---|---|---|
Submitted: | 30 Apr 2006 5:14 | Modified: | 7 Jun 2006 13:06 |
Reporter: | Sam Henderson | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | mysql-max-5.0.20-linux-i686-glibc23 | OS: | Linux (Debian 3.1 2.4.27-3-686-smp) |
Assigned to: | Assigned Account | CPU Architecture: | Any |
[30 Apr 2006 5:14]
Sam Henderson
[30 Apr 2006 5:41]
MySQL Verification Team
Thank you for the bug report. I was unable to repeat on current source server on Suse linux 10. mysql> create database mpa2; Query OK, 1 row affected (0.00 sec) mysql> use mpa2 Database changed mysql> create table cdetails (id int); Query OK, 0 rows affected (0.01 sec) mysql> grant select on mpa2.cdetails to geoip@'192.168.14.%'; Query OK, 0 rows affected (0.00 sec) mysql> grant select on mpa2.cdetails to geoip@'192.168.14.99'; Query OK, 0 rows affected (0.00 sec) mysql> grant select on mpa2.cdetails to geoip@'192.168.14.0/255.255.255.0'; Query OK, 0 rows affected (0.00 sec) mysql> select version(); +--------------+ | version() | +--------------+ | 5.0.22-debug | +--------------+ 1 row in set (0.00 sec) It is your installation from an upgrade over a prior version than 5.0? Thanks in advance.
[30 Apr 2006 8:50]
Sam Henderson
Yes, it was upgrade -> 3.23 -> 4.0. -> 4.1 -> 5 What do you think is possibly wrong? Thanks for the quick response! server:~$ cd /usr/local/mysql/bin server:/usr/local/mysql/bin$ ./mysql -u root -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 108099 to server version: 5.0.20-max-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> grant select on mpa2.cdetails to 'geoip'@'192.168.14.0/255.255.255.0'; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>
[30 Apr 2006 13:22]
MySQL Verification Team
Thank you for the feedback. Please read carefully the below Manual's chapters: http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html http://dev.mysql.com/doc/refman/5.0/en/mysql-upgrade.html Thanks in advance.
[30 May 2006 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
[7 Jun 2006 13:06]
Hartmut Holzgraefe
duplicate of bug #16470