View Issue Details

IDProjectCategoryView StatusLast Update
0001786Database Workbench v5MySQL Modulepublic2020-06-30 11:16
ReporterSvein Erling Tysvær Assigned ToMartijn Tonies  
PrioritynormalSeverityminorReproducibilityalways
Status closedResolutionno change required 
Product Version5.7.0 
Summary0001786: Lost connection
DescriptionWhen I run DELETE FROM <table> against 5.5.5-10.2.14-MariaDB, connection gets lost after 15 seconds (provided it takes more than 15 seconds to delete the rows, of course). However, the DELETE query continues to run on the server. If I immediately restarts the DELETE query, a lock conflict is reported after 50 seconds. However, if I just wait until the stray query on the server finishes before I restart, then the query successfully deletes the rows.

Is there a way to avoid losing the connection after 15 seconds the first time I try to run the query? E.g. is it configurable how long DBW should wait before reporting lost connection (when I know the query will take between 5 and 10 minutes to execute, it would be nice if I could set the limit to, say, 20 minutes)?
TagsNo tags attached.

Activities

Martijn Tonies

2020-06-02 13:44

administrator   ~0000542

Last edited: 2020-06-02 13:45

The connection/statement timeout is a server setting.

In the SQL Editor, you can execute statements like these
SET interactive_timeout=128800
SET wait_timeout=128800

to avoid the timeout.

There will be an option in DBW to execute statements after connecting, so you can enter such statements there and automating this for you (see 0001783).

Issue History

Date Modified Username Field Change
2020-05-26 13:49 Svein Erling Tysvær New Issue
2020-06-02 13:44 Martijn Tonies Assigned To => Martijn Tonies
2020-06-02 13:44 Martijn Tonies Status new => feedback
2020-06-02 13:44 Martijn Tonies Note Added: 0000542
2020-06-02 13:45 Martijn Tonies Note Edited: 0000542
2020-06-02 13:45 Martijn Tonies Note Edited: 0000542
2020-06-30 11:16 Martijn Tonies Status feedback => closed
2020-06-30 11:16 Martijn Tonies Resolution open => no change required