Bug #30064 MySQL Crashes if mysql.procs_priv doesn't exist
Submitted: 26 Jul 2007 9:56 Modified: 26 Aug 2007 10:57
Reporter: Trevor White Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: Information schema Severity:S2 (Serious)
Version:5.0.18-standard OS:Other (Sco Openserver)
Assigned to: CPU Architecture:Any

[26 Jul 2007 9:56] Trevor White
For some reason we have a lot of servers upgraded form MySQL 4 to 5 and they don't have a proc_priv table grants have worked in the past but they don't work now, if you try to grant access to a user the MySQL server crashes and all users lose connections with MySQL has gone away and error log indicates a crash querying a bug.

How to repeat:
Dtop the proc_fix table or upgrade from MySQL 4 to 5 and it won't be there.

Suggested fix:
If the proc_fix table doesn't exist can MySQL handle this gracefully or create the table as needed.
[26 Jul 2007 10:57] Sveta Smirnova
Thank you for the report.

But version 5.0.18 is quite old. Please upgreade to current version 5.0.45, run mysql_upgrade script, try with it and say us result.
[26 Aug 2007 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".