I haven’t been using Toad in a while, but I did today and it froze up again and I thought I’d provide the scenario so it would give more info on what might have caused my initial problem. I created a query in the Editor. It started off attempting to auto-provide table names/file names but then stopped and I couldn’t get any autocomplete working after that. I noticed the hourglass when the mouse was over Toad, but it still let me run the query.
Unfortunately, I had a typo in the query and it came back with ERROR 2624: Column “ais” does not exist in the alert window. However, the Toad window got lightly grayed out and when I clicked on ‘OK’ Or the ‘x’ in the upper right hand corner, the alert window would not close. It is frozen, as I can’t do anything. It does bring focus back to the alert window when I click the button, but it does not close. I had not run any queries in this session before the hourglass showed up. It doesn’t seem like any queries are going on - maybe it is trying to get table information for an autocomplete?
The big problem here is that the alert window will not close. I can’t get any logs with this as I can’t click on anything. So something is going on in the background unrelated to any actual queries, that is blocking the ability to close the alert window. (and keeping everything else in a grayed state).
I had updated to Toad Data Point 3.7 and still am using Vertica 7.
It is using between 4-7% cpu and around 100k memory.