Bug #27818 a comedy of errors related to events in 5.1.17
| Submitted: | 13 Apr 2007 22:27 | Modified: | 8 May 2007 1:16 |
|---|---|---|---|
| Reporter: | Peter Brawley (Basic Quality Contributor) | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Installing | Severity: | S2 (Serious) |
| Version: | 5.1.17 | OS: | Windows |
| Assigned to: | Daniel Fischer | CPU Architecture: | Any |
| Tags: | events, mysql_fix_privilege_tables, mysql_upgrade, qc | ||
[13 Apr 2007 22:27]
Peter Brawley
[15 Apr 2007 11:57]
Jon Stephens
The changes in Event Scheduler metadata in 5.1.17 were already documented here: http://dev.mysql.com/doc/refman/5.1/en/news-5-1-17.html http://dev.mysql.com/doc/refman/5.1/en/create-event.html http://bugs.mysql.com/16420 I have updated the following portions of the Manual to remove any inconsistencies: http://dev.mysql.com/doc/refman/5.1/en/events-table.html http://dev.mysql.com/doc/refman/5.1/en/show-events.html See http://lists.mysql.com/commits/24565 for my commit with these changes. According to http://dev.mysql.com/doc/refman/5.1/en/mysql-fix-privilege-tables.html when upgrading to 5.1.10 or later on Windows, you should instead run mysql_upgrade, which is discussed here: http://dev.mysql.com/doc/refman/5.1/en/mysql-upgrade.html If error or warning messages issued by the server say to do something else, that's a server issue AFAIK. If mysql_upgrade doesn't perform correctly, that's also a server issue. If the location of mysql_fix_privilege_tables has been changed, then Docs needs to be informed of this, and that it's intentional. Removing myself and Stefan from this bug, and changing status/category/severity to Open/Server:Installing/Serious.
[16 Apr 2007 13:34]
Valeriy Kravchuk
This is a verified server problem. Error message is incorrect for Windows in any case.
[19 Apr 2007 17:41]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/24923 ChangeSet@1.2596, 2007-04-19 18:58:32+02:00, df@pippilotta.erinye.com +1 -0 BUG#27818 comedy of errors
[20 Apr 2007 6:56]
Daniel Fischer
The above patch changes the error message to be slightly more helpful (i.e. recommends the correct tool to use now). I verified that 5.1.16 -> 5.1.17 upgrade works with mysql_upgrade (bin/mysql_upgrade.exe on windows).
[24 Apr 2007 10:19]
Daniel Fischer
queued in 5.1-build
[27 Apr 2007 9:21]
Bugs System
Pushed into 5.1.18-beta
[8 May 2007 1:16]
Paul DuBois
Noted in 5.1.18 changelog. An error message suggested the use of mysql_fix_privilege_tables after an upgrade, but the recommended program is now mysql_upgrade.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.059 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.