Session Confusion

[expired user #6609]'s profile image [expired user #6609] posted 11 years ago in General Permalink
Hello,

Have an interesting issue. Using 7.0.0.4156.

I have connections for our Production and Development databases, so they have the same structures. If I am connected to both, I cannot see the distinct data in each session.

For example, I open a table to view the data in the Dev DB, then I go to look at the same table on Prod DB, but I see the same data as Dev (when I know they are not the same).

If I close the Dev connection, and then look at the Prod table, I still see the Dev data. I have to completely close HeidiSQL and connect to a single session to see the correct data.

Any thoughts?

Thanks
ansgar's profile image ansgar posted 11 years ago Permalink
Probably a bug in Heidi, although I recall I also compare the session instance when detecting if the data grid should be refreshed. Will check that.
ansgar's profile image ansgar posted 11 years ago Permalink
Hm, not reproducible here. Having a localhost and a remote server with both the same database name and table name. As soon as I switch between tables, the right session is activated and the right data is loaded.
[expired user #6609]'s profile image [expired user #6609] posted 11 years ago Permalink
Not sure if it makes a difference, but both of my connections are remote.
[expired user #6609]'s profile image [expired user #6609] posted 11 years ago Permalink
Also - using SSH Tunnel.

Just tried it again, same thing.

When I go to the Dev session, the host tab changes to the correct IP, I see the /* entering session "{session}" */ in the log, and the other active session is greyed out in the tree view.

Then I switch to the Prod session and same thing, everything looks like it switched correctly.

I created a new table on Dev, and I see that table in the Prod tree view, even though it doesn't exist there. Same result after a refresh of the session.
ansgar's profile image ansgar posted 11 years ago Permalink
I guess that's a bug with SSH tunneled connections - probably their plink process is mixed up... I recall there was an issue report at Google Code.
ansgar's profile image ansgar posted 11 years ago Permalink
See issue #2832
[expired user #6609]'s profile image [expired user #6609] posted 11 years ago Permalink
Awesome. The port for both tunnels was 3307, so I changed one to 3308 and now it's working properly.

Thanks anse!

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