[MDEV-18765] Filter "Aborted connection" error log messages Created: 2019-02-27  Updated: 2019-02-27

Status: Open
Project: MariaDB Server
Component/s: Server
Fix Version/s: None

Type: Task Priority: Major
Reporter: Nuno Assignee: Unassigned
Resolution: Unresolved Votes: 1
Labels: None


 Description   

Could we please have an option to disable these warnings:

[Warning] Aborted connection 215716 to db: '<database>' user: '<user>' host: '127.0.0.1' (Got timeout reading communication packets)

I get loads of these because I use Persistent Connections with PHP.

These cause a big noise in the Error Log.

Something like MySQL 5.7 seems to have, "log_error_suppression_list", might help.
MariaDB doesn't seem to have that option.

"log_error_verbosity" might also be a good idea to implement, although that wouldn't fix my problem, as I want to continue to have Warnings logged in the Error Log.

 Comments   
Comment by Elena Stepanova [ 2019-02-27 ]

log-warnings=1 should do the trick.

Comment by Nuno [ 2019-02-27 ]

I don't have "log_warnings" in my my.cnf file, but it seems to be set to 2.
Probably means that the documentation at https://mariadb.com/kb/en/library/server-system-variables/#log_warnings
as it starts with: "If set to 1, the default, ..."
.

It also seems contradicting, because it says:

"If set to a number greater than 1, aborted connections and access-denied errors are also logged."

However, just below that sentence, it has:

log_warnings >= 1

  • Access denied errors
  • Connections that were forced to be closed or aborted
    .

I do want to be notified about all other errors/warnings.
I'm afraid that altering the value of this parameter might make me unaware of other important warnings.

Generated at Thu Feb 08 08:46:34 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.