Bug #21967 Strange warnings on repair of the log tables

• Submitted: 1 Sep 2006 13:42
• Modified: 1 Sep 2006 14:00
• Reporter: Petr Chardin
• Status: Duplicate
• Category: MySQL Server: Logging
• Severity: S3 (Non-critical)
• Version: 5.1
• CPU Architecture: Any

[1 Sep 2006 13:42] Petr Chardin

Description:
Incorrect warnings occur on repair of the log table

How to repeat:
mysql> repair table general_log;
+-------------------+--------+----------+----------+
| Table             | Op     | Msg_type | Msg_text |
+-------------------+--------+----------+----------+
| mysql.general_log | repair | status   | OK       | 
+-------------------+--------+----------+----------+
1 row in set, 1 warning (0.04 sec)

mysql> show warnings;
+-------+------+----------------------------------------------------------------+
| Level | Code | Message                                                        |
+-------+------+----------------------------------------------------------------+
| Error | 1542 | You can't write-lock a log table. Only read access is possible | 
+-------+------+----------------------------------------------------------------+
1 row in set (0.00 sec)

[1 Sep 2006 14:01] Petr Chardin

duplicate of Bug#21966