You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
In my never-ending quest to demonstrate that I can make every possible mistake ...
Details for the issue
What did you do?
In the execute query window I generated a recursive select that failed to terminate.
What did you expect to see?
A "stop" button.
What did you see instead?
A busy-wait loop, spinning disk, unresponsive GUI.
The only thing I could do was take a screenshot of my SQL & kill the browser.
Two issues (and I think both constitute bugs)...
There really needs to be a "STOP" button so that a query (or other operation) can be cancelled.
The Execute SQL tabs should have a checkpointing facility (as editors and now webbrowsers do), so that when the browser, computer, or user crashes, work can be recovered.
Restarting the browser should offer to recover the session/execute SQL tabs.
(I had 8 open where I was trying to figure out how to make a tree-walking select work - the screenshot captured only one...)
I suppose that the browser could use a, er, database to journal user sessions with full roll-back and roll-forward ;-) But a simple text file (e.g. emacs session files) would do.
Useful extra information
The info below often helps, please fill it out if you're able to. :)
There really needs to be a "STOP" button so that a query (or other operation) can be cancelled.
Yeah. This is a reasonably commonly requested feature. We've been putting effort into getting the underlying bits ready and from rough memory I think we're fairly close to having this.
The Execute SQL tabs should have a checkpointing facility (as editors and now webbrowsers do), so that when the browser, computer, or user crashes, work can be recovered.
Very good idea. I don't think this anyone has suggested it yet either. We should definitely do this. 😄
@tlhackque We are finally preparing some changes which add, besides making some other changes, a cancel button to the Execute SQL area and keep the UI more responsive. Because it's changing a lot of our code we want to test this as good as we can. Are you interested in giving it a try? You can find the Windows and OSX build here:
A checkpoint feature sounds like a good idea too. It might be a separate issue though. By the way, a special thank you for opening all these issues, @tlhackque! 👍 Even though it will take us some time to work through all of them they are very much appreciated 😄
Did this new feature go anywhere? Do you still need someone to test? (Just ran a never-ending query and was wishing for a stop button! Had to kill the program, but then I had issues with locked DB because I had uncommitted writes before the crash)
@mgrojo - ah, that explains it! I could have sworn I saw a cancel button in a version I had tested. So I was kind of confused / surprised when I couldn't find it today. Must be because after 3.11.2 was released, I switched over to it from the nightly version I was testing before then.
@MKleusberg - I recall having tested at the time, and it worked. But I went to test again now, since it's been awhile. Am I looking in the wrong place (https://nightlies.sqlitebrowser.org/latest/). I didn't see any msi versions, and the zips are empty (22byte files)?
@justinclift@MKleusberg I tried the nightly, and the ability to stop a long-running query worked for me! I used this method to create a long-running test query.
It looks like the nightly also prompts to save my SQL?! Is that addressing issue #938?
Thanks, @beRto-. Yes, #938 has been addressed too, although it remained hidden under our pile of issues. I'll close both, but feel free to reopen any of them, if you think there is still some rough corner.
Activity
justinclift commentedon Jun 24, 2018
Yeah. This is a reasonably commonly requested feature. We've been putting effort into getting the underlying bits ready and from rough memory I think we're fairly close to having this.
Very good idea. I don't think this anyone has suggested it yet either. We should definitely do this. 😄
MKleusberg commentedon Oct 18, 2018
@tlhackque We are finally preparing some changes which add, besides making some other changes, a cancel button to the Execute SQL area and keep the UI more responsive. Because it's changing a lot of our code we want to test this as good as we can. Are you interested in giving it a try? You can find the Windows and OSX build here:
A checkpoint feature sounds like a good idea too. It might be a separate issue though. By the way, a special thank you for opening all these issues, @tlhackque! 👍 Even though it will take us some time to work through all of them they are very much appreciated 😄
beRto- commentedon May 28, 2019
Did this new feature go anywhere? Do you still need someone to test? (Just ran a never-ending query and was wishing for a stop button! Had to kill the program, but then I had issues with locked DB because I had uncommitted writes before the crash)
chrisjlocke commentedon May 28, 2019
mgrojo commentedon May 28, 2019
This was added to the master branch in 1f9101a but it hasn't been released yet. It will be in the next one and meanwhile, in the nightlies.
beRto- commentedon May 29, 2019
@mgrojo - ah, that explains it! I could have sworn I saw a cancel button in a version I had tested. So I was kind of confused / surprised when I couldn't find it today. Must be because after 3.11.2 was released, I switched over to it from the nightly version I was testing before then.
MKleusberg commentedon Feb 14, 2020
Did you have a chance to test this in the nightlies, @tlhackque and @beRto-? 😄
beRto- commentedon Feb 15, 2020
@MKleusberg - I recall having tested at the time, and it worked. But I went to test again now, since it's been awhile. Am I looking in the wrong place (https://nightlies.sqlitebrowser.org/latest/). I didn't see any msi versions, and the zips are empty (22byte files)?
justinclift commentedon Feb 15, 2020
Ouch. That generally means one of the changes since the last build (yesterday) is breaking the build on windows.
I'll take a look at it later on today, but need to get some sleep now first.
justinclift commentedon Feb 16, 2020
In theory (!) the build problem is now fixed, and new nightly builds will be online in about 40 minutes.
justinclift commentedon Feb 16, 2020
Yep, new builds are online now:
https://nightlies.sqlitebrowser.org/latest/
beRto- commentedon Feb 16, 2020
@justinclift @MKleusberg I tried the nightly, and the ability to stop a long-running query worked for me! I used this method to create a long-running test query.
It looks like the nightly also prompts to save my SQL?! Is that addressing issue #938?
mgrojo commentedon Feb 17, 2020
Thanks, @beRto-. Yes, #938 has been addressed too, although it remained hidden under our pile of issues. I'll close both, but feel free to reopen any of them, if you think there is still some rough corner.