search

charles-001 / dolphie

Your single pane of glass for real-time analytics into MySQL/MariaDB & ProxySQL
https://pypi.org/project/dolphie/
GNU General Public License v3.0
651 stars 40 forks source link

[BUG] Can't load replica panel #26

Closed valentintraen closed 1 year ago

valentintraen commented 1 year ago

Hi !

Thanks for the correction of replica panel on source of RS. I have another problem with another ReplicaSet which works a lot more :

screen_4

Edit : It doesn't seem related, the panel doesn't load either with this load

screen_6

Replica panel never loads

screen_5

I don't see any queries coming from Dolphie on my instance. Are there any logs somewhere ?

I'm connecting on a remote Percona Server 8.0.29 instance from my computer.

Do not hesitate to ask me for more information

charles-001 commented 1 year ago

Hi @valentintraen - when you open the replica panel, it connects to each replica using the credentials you provided to connect to the current host. If it's stuck on Loading, that tells me it's having an unknown issue connecting to it. Is this an asynchronous replica?

As for queries not showing, that seems like a weird issue. You could try pressing P command to use processlist instead of performance_schema and see if that fixes the issue for you. Maybe you have certain performance_schema variables turned off? Hard to say for sure.

valentintraen commented 1 year ago

when you open the replica panel, it connects to each replica using the credentials you provided to connect to the current host. If it's stuck on Loading, that tells me it's having an unknown issue connecting to it. Is this an asynchronous replica?

Yes it's an asynchronous replica. I'm connecting with root account (to be sure). What query does dolphie run to generate this panel? I can try running it with the mysql client to see what happens.

_As for queries not showing, that seems like a weird issue. You could try pressing P command to use processlist instead of performance_schema and see if that fixes the issue for you. Maybe you have certain performanceschema variables turned off? Hard to say for sure.

I misspoke. Everything works fine in Dolphie at the query level. When the replica panel loads, I connect live to my Percona Server instance to see if I see any requests coming from the session I opened with Dolphie, but I don't see anything.

valentintraen commented 1 year ago

Oh I found the solution ! Sorry, it's a compatibility issue between Dolphie and ProxySQL. If I don't go through proxySQL, everything works.

charles-001 commented 1 year ago

Ahh, gotcha. Glad you figured it out :)

valentintraen commented 1 year ago

ProxySQL compatibility issue