We have been having a weird problem since the last few weeks.
We connect with heidi sql via tunnel to a bug standard mysql DB.
We can see everything (e.g. select).
If Some other process now changes the DB (and commits of course), heidi still sees the old version. If we exit Heidi sql and restart it, suddenly we can see the changes made by the other system (tomcat in this case).
This is driving us crazy, we have to stop and start hedi sql literally thousands of times a day.
We saw this issue some time back when using galeara cluster, but now it has started with a single standard mysql instance.
The problem occurs even if we only do selects in Heidi, i.e. lock nothing.
Any ideas?