View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001786 | Database Workbench v5 | MySQL Module | public | 2020-05-26 13:49 | 2020-06-30 11:16 |
Reporter | Svein Erling Tysvær | Assigned To | Martijn Tonies | ||
Priority | normal | Severity | minor | Reproducibility | always |
Status | closed | Resolution | no change required | ||
Product Version | 5.7.0 | ||||
Summary | 0001786: Lost connection | ||||
Description | When 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)? | ||||
Tags | No tags attached. | ||||
|
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). |
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 |