Grafana was configured to connect to database type mysql and it was configured to connect to Readwritesplit port of mariadb which his running in maxscale mode. Initial login was successful and also dashboards were loaded properly. But after some time “504 Gateway Time-out” was observed in UI. This issue was reproducible.
Following logs were observed in grafana in different instances.
logger=login.authinfo t=2025-10-14T11:37:11.221625624Z level=warn msg=“failed to retrieve auth info from cache” error=“invalid connection”
logger=context userId=0 orgId=0 uname= t=2025-10-14T11:57:06.497646145Z level=info msg=“Request Completed” method=POST path=/api/ds/query status=401 remote_addr=10.144.204.159 time_ms=4 duration=4.438674ms size=105 referer=“https://grafana.apps.net/dashboard/d/test4/test?from=now-30m&orgId=1&refresh=5s&timezone=browser&to=now&var-Adaptation=usecase-en-gnb&var-Pod=%24__all” handler=/api/ds/query status_source=server errorReason=Unauthorized errorMessageID=session.token.rotate error=“token needs to be rotated”
logger=authn.service t=2025-10-15T07:32:36.952021124Z level=warn msg=“Failed to authenticate request” client=auth.client.session error=“user token not found”
After changing mariadb maxscale configuration from Readwritesplit to MasterOnly port issue is not observed. Can you pls confirm that grafana can work with Readwritesplit port of mariadb when it is running in maxscale mode OR it should be with masterOnly port?
I can see GitHub · Where software is built where it was recommanded to use master only port.
Note: Issue started from grafana v11.5.1. i.e. In previous version of grafana, grafana was working fine with Readwritesplit port of mariadb. But from v11.5.1 version of grafana, it is expecting it to be masteronly port