Bug #77258 MySQL 5.6 not logging excess of user limits

• Submitted: 5 Jun 2015 10:32
• Modified: 1 Jun 2018 18:52
• Reporter: Konstantin Pavlov
• Status: No Feedback
• Category: MySQL Server: Logging
• Severity: S3 (Non-critical)
• Version: 5.6.24
• OS: Linux
• CPU Architecture: Any
• Tags: logging

[5 Jun 2015 10:32] Konstantin Pavlov

Description:
After we moved from MySQL 5.1 to 5.6 it stopped writing excess of user limits to warning log.

How to repeat:
On both servers we create user test with max_queries_per_hour 10, then we run 10+ queries from that user.

1)
# mysql -V
mysql Ver 14.14 Distrib 5.1.73, for debian-linux-gnu (x86_64) using readline 6.1
# cat mysql.log:
150526 14:10:26 [Warning] User 'test' has exceeded the 'max_questions' resource (current value: 10)

2)
# mysql -V
mysql Ver 14.14 Distrib 5.6.24, for Linux (x86_64) using EditLine wrapper
When user excess queries limit user get error, but mysql.log remains empty.

In my.cnf we have:
...
log-error = /var/log/mysql/mysql.log
log-warnings = 2
...

[1 May 2018 18:52] MySQL Verification Team

Sorry for the delay.. Please check with 5.6.40 released version: https://dev.mysql.com/downloads/mysql/5.6.html#downloads . Thanks.

[1 May 2018 20:44] MySQL Verification Team

I wasn't able even on 5.1.72 the log on error.log. So wonder how you did.

[2 Jun 2018 1: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".