Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.6.15
-
None
-
None
-
ubuntu server 22.04. mariadb-server installed from mariadb apt repo.
Description
We have a busy server with many users and many connections. At the same starting time just two of these users were repeatedly unable to connect.
2024-08-13 18:06:32 257506881 [Warning] Access denied for user 'app_xyz'@'1.2.3.4' (using password: YES)
|
Interestingly the users were able to connect to replicas. The password hashes on the primary and replicas matched. I don't think anyone/anything made any attempt to update the passwords with an update statement.
On a whim I executed a "flush privileges" on the primary which immediately fixed the issue. But I have no idea why that would have fixed this issue.
I do not ever recall experiencing a similar issue. We have been running mariadb 10.3.12 for the past several years.