Sequel-Ace / Sequel-Ace

MySQL/MariaDB database management for macOS
https://sequel-ace.com
Other
6.69k stars 247 forks source link

Extra connection opened simultaneously for metadata which is only terminated when i quit the application #2115

Open muhammetbudak opened 6 days ago

muhammetbudak commented 6 days ago

Is Issue Present in Latest Beta?

Yes. I downloaded latest beta [4.1.4 (20075)] and issue still exists.

Description An extra connection is established when i try to access a database, this connection checks some metadata. But this connection is not closed when i close this connection tab. It's only closed when i completely quit Sequel Ace application.

Steps To Reproduce 1.Connect to a mysql database using terminal and check processes with a specific user. 2.Then open a sequel ace connection tab with this user and check processlist from other connection. 3.There will be an extra connection. To specify each connection different databases can be picked in each connection. i.e. information_schema on one connection, performance_schema on other connection. 4.Close sequel ace tab and check processlist using terminal. 5.Extra connection will appear until sequel ace application is completely terminated.

Expected Behaviour

I've 3 recommendations. 1.Metadata can be checked with same connection. 2.The connection used for metadata check can be closed immediately when the tab is closed. 3.There may be a setting to disable this extra connection.

Related Issues

Additional Context

I can not produce a screenshot because i need to show not a moment, a connection flow. And i can not provide a crash log because there is no crash. But issue is very easy to reproduce with the steps i mentioned above. I can only provide a flow of commands on a terminal while there is an open connection with the application background.

Jason-Morcos commented 5 days ago

@Kaspik I wonder if this is the memory leak that's existing? An extra connection to pull metadata?

Kaspik commented 4 days ago

What, that exists?!