heidi sql cant see any new transactions?

eos's profile image eos posted 8 years ago in General Permalink

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?

eos's profile image eos posted 8 years ago Permalink

Bog standard, not bug standard of course. You cant edit posts?

ansgar's profile image ansgar posted 8 years ago Permalink

Does that probably have something to do with transaction isolation settings? I have no clue.

kalvaro's profile image kalvaro posted 8 years ago Permalink

Have you set a startup script in Session Manager that's doing weird things with sessions?

eos's profile image eos posted 8 years ago Permalink

Have you set a startup script in Session Manager that's doing weird things with sessions?

I have not changed anything with the standard install of Mysql or the standard install of heidiSQL that I know of. Very strange I know.

kalvaro's profile image kalvaro posted 8 years ago Permalink

I mean the stored connections. Those don't come with HeidiSQL ????

kalvaro's profile image kalvaro posted 8 years ago Permalink

P.S. Those "????" where initially a Unicode smiley (that's what happens when you type in a tablet).

Please login to leave a reply, or register at first.