dbForge MySQL 2020 Bug - Disabling Autocommit in [mysqld] destroys dbForge

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
Requnix
Posts: 113
Joined: Thu 12 Dec 2019 19:41

dbForge MySQL 2020 Bug - Disabling Autocommit in [mysqld] destroys dbForge

Post by Requnix » Mon 11 May 2020 22:40

If you set autocommit = 0 in the [mysqld] of the .ini, dbForge completely falls apart.

This tells me the IDE is executing non-transactional statements.

This also forces those who use dbForge to use an auto-commit environment, which is not proper for a large-scale complex environment. Granted we can disable autocommit for each stored procedure, it we need to do it globally for the instance of the database.

This is bad. Red flag bad.

Requnix
Posts: 113
Joined: Thu 12 Dec 2019 19:41

Re: dbForge MySQL 2020 Bug - Disabling Autocommit in [mysqld] destroys dbForge

Post by Requnix » Tue 12 May 2020 00:44

To confirm, doing a simple SET autocommit = 0; in any stored procedure also guarantees the IDE will hang.

This is a huge problem guys - very bad! Guarantees the IDE will crash for anyone who wants to turn off autocommit!

alexa

Re: dbForge MySQL 2020 Bug - Disabling Autocommit in [mysqld] destroys dbForge

Post by alexa » Tue 12 May 2020 13:25

We will investigate this issue.

Requnix
Posts: 113
Joined: Thu 12 Dec 2019 19:41

Re: dbForge MySQL 2020 Bug - Disabling Autocommit in [mysqld] destroys dbForge

Post by Requnix » Tue 12 May 2020 14:58

Awesome - thanks for the quick response. I want to ensure the full release is as solid as possible since I rely on the tool for pretty much everything I do in MySQL :)

Post Reply