[MDEV-24301] [Warning] Aborted connection (This connection closed normally) Created: 2020-11-27  Updated: 2023-02-16  Resolved: 2023-02-06

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 5.5, 10.1, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.11.3, 10.4.29, 10.5.20, 10.6.13, 10.8.8, 10.9.6, 10.10.4

Type: Bug Priority: Minor
Reporter: Andy Assignee: Daniel Black
Resolution: Fixed Votes: 0
Labels: None


 Description   

Hi, I am unable to find detailed documentation on mariadb regarding this, but from mysql[1] page it explains that aborted connections in logs should be happening only during certain cases which doesn't apply to our environment.

For each connection, closed gracefully we get entry like this with logging setting
[Warning] Aborted connection 2934 to db: 'unconnected' user: 'ABC' host: '127.0.0.1' (This connection closed normally)

Settings:
log_warnings 5
OS Ubuntu 20.04 latest updates
1:10.5.8+maria~focal

The question is if I am missing something here or this is expected from normal connection(different from mysql).

If this is normal logging then I would question whether this is useful and systematic. If intention is to allow some auditing then connectivity start and finish should be recorded alongside source port number as otherwise it is hard to identify among many connections from the same source IP.

Many thanks

[1] https://dev.mysql.com/doc/refman/5.7/en/communication-errors.html



 Comments   
Comment by Elena Stepanova [ 2021-01-11 ]

Indeed, the warning is printed in all MariaDB versions from at least 5.5, with log_warnings >= 4.
I don't have a reasonable explanation for it, maybe sanja does.

Comment by David Krupicka [ 2022-10-10 ]

Hello, I know it's a minor bug, but can you please provide an estimate of when this could be fixed in 10.5?
Many thanks in advance.

Comment by Daniel Black [ 2023-01-05 ]

PR https://github.com/MariaDB/server/pull/2412 for review

Comment by Oleksandr Byelkin [ 2023-02-06 ]

OK to push

Comment by Daniel Black [ 2023-02-06 ]

Thanks sanja.

Sorry david-dot-krupicka, just missed the current release, but will be in the releases as marked as Fixed-version above.

Generated at Thu Feb 08 09:28:57 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.