Skip to content

Abort long-running queries #1274

Closed
Closed

Description

@Bilge

There should be a mechanism to abort queries that run so long they hang the UI thread. Aside, it would probably be a good idea to run the query on a separate thread, but I digress. When a long-running query hangs the program, often due to incorrect query construction, there needs to be a way to abort the operation without killing the process and losing all your work.

Activity

  1. justinclift commented on Dec 22, 2017

    @justinclift
    Member

    Hmmm, I could have sworn we've done some work around this not long ago.

    Not sure if it's in the 3.10.1 release though. Just to check, are you using a recent-ish nightly build, or the 3.10.x release? If you're using the release build, try a recent nightly. 😄

  2. Bilge commented on Dec 22, 2017

    @Bilge
    Author

    Currently on 3.10.1.

  3. justinclift commented on Dec 22, 2017

    @justinclift
    Member

    Cool. Try a long running query (in the Execute SQL) window with a recent nightly build, and see if the UI gives a cancel option. I'm pretty sure it does now. (I don't have the bits in front of me to check myself just atm)

  4. MKleusberg commented on Oct 18, 2018

    @MKleusberg
    Member

    @Bilge Sorry for the long delay here. Are you still interested in this issue? I'm asking because we are currently preparing some changes which add, besides making some other changes, a cancel button to the Execute SQL area. 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:

  5. self-assigned this
    on Oct 18, 2018
  6. Bilge commented on Oct 18, 2018

    @Bilge
    Author

    I'm still interested but I'm not very good at writing queries that hang the program deliberately. That usually comes about due to incompetence!

  7. MKleusberg commented on Feb 12, 2020

    @MKleusberg
    Member

    No worries 😄 Let's just close this issue because we haven't heard about any problems regarding this for a very long time. If you should stumble upon any remaining problems with this, you can always re-open the issue, @Bilge 😄

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

Type

No type

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions