SOQL executed automatically on start

Question

SOQL executed automatically on start

bluejackDE opened this issue 3 years ago · 8 comments

Describe the bug
When I start SoqlXplorer and login to an org, it automatically executes the most recent query. Since I have accidentally tried to execute a too long query, this would always block me from working and after minutes, result in a timeout. How can I prevent SoqlXplorer from starting the query, or, alternatively: where are the recent queries stored so that I can delete them?

To Reproduce
Steps to reproduce the behavior:

Have a query that is formally too long.
Force-quit SoqlXplorer, because you are impatient.
Start it again, login to the org
Wait hours until you will be able to delete the current query.

Expected behavior
Have an option to not execute the most recent query automatically after login.
Alternatively: Identify the location the recent queries are stored to manually delete them from the system.

Desktop (please complete the following information):

OS: macOS Monterrey 12.3.1 (21E258)
SoqlXplorer Version 4.3 (4.3)

edit: typo

Answer 1 · 2022-05-06T17:16:08.000Z

It doesn’t intentionally run a query at startup. Are you selecting a stored token for login, or going through the new login flow?

…

On May 6, 2022, at 10:01 AM, bluejackDE ***@***.***> wrote: Describe the bug When I start SoqlXplorer and login to an org, it automatically executes the most recent query. Since I have accidentally tried to execute a too long query, this would always block me from working and after minutes, result in a timeout. How can I prevent SoqlXplorer from starting the query, or, alternatively: where are the recent queries stored so that I can delete them? To Reproduce Steps to reproduce the behavior: Have a query that is formally too long. Force-quit SoqlXplorer, because you are inpatient. Start it again, login to the org Wait hours until you will be able to delete the current query. Expected behavior Have an option to not execute the most recent query automatically after login. Alternatively: Identify the location the recent queries are stored to manually delete them from the system. Desktop (please complete the following information): OS: macOS Monterrey 12.3.1 (21E258) SoqlXplorer Version 4.3 (4.3) Additional context Add any other context about the problem here. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.

Answer 2 · 2022-05-06T17:23:35.000Z

Stored token - and yes, I have reviewed the process on an org with a "safe" recent query. It doesn't execute it, but it seems to somehow try to interpret it already. My disastrous query holds 600k record ids in a WHERE clause - dumb mistake.

Answer 3 · 2022-05-06T17:28:49.000Z

I have now tried to circumvent this by logging in through a fresh login after removing the existing token - same behaviour. SoqlXplorer doesn't even retrieve the list of objects but immediately goes into no response mode (rotating beach ball).

Answer 4 · 2022-05-06T18:08:47.000Z

You should be able to find the plist file with all the settings and queries somewhere under Library/Application Support you can delete this file while soqlx isn’t running and it should reset everything. Not near a Mac right now so can’t tell you the exact file name. If it’s beachballing then it’s not running the query as that’s all on a background thread. Thinking about it, it’s probably the soql syntax parser/colorer that it’s tied up in.

…

On May 6, 2022, at 10:29 AM, bluejackDE ***@***.***> wrote: I have now tried to circumvent this by logging in through a fresh login after removing the existing token - same behaviour. SoqlXplorer doesn't even retrieve the list of objects but immediately goes into no response mode (rotating beach ball). — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you commented.

Answer 5 · 2022-05-06T18:24:10.000Z

@superfell, thank you - file name and location would be great, because I could not locate any soqlx related files on my system, especially not in Library/Application Support and no plist file.

Answer 6 · 2022-05-07T02:25:20.000Z

The file to delete is ~/Library/Preferences/com.pocketsoap.osx.SoqlXplorer.plist
Alternatively you can run this from the terminal defaults delete com.pocketsoap.osx.SoqlXplorer soql
In either case you should do it with SoqlX closed. And afterwards launch SoqlX again.

Answer 7 · 2022-05-07T08:38:08.000Z

This did the job! Thanks for your support, @superfell. Just needed to leave out the soql attribute from the command.

Answer 8 · 2022-10-23T16:59:00.000Z

with the parser perf improvements in the last release this shouldn't be an issue anymore