-
Title
TDP locks up every so often while running query in Vertica. -
Description
An intermittent issue occurs when running queries while connected to Vertica databases. Sometimes Toad seems to hang up, freeze, or lock up. Toad shows as not responding.
-
Cause
Using an ODBC Vertica driver that is not supported by TDP
-
Resolution
RESOLUTION 1:
Check the Release Notes of your TDP version and ensure your Vertica ODBC driver version is listed and supported.
RESOLUTION 2:
Ensure you let TDP finish each action or activity you do, especially long running queries before you run another one or do another activity. Keep in mind as well any other Vertica software tools you are using that may also be running queries on the same tables.
RESOLUTION 3:
Perform a reset of TDP to clear cache / temp / corrupt files.
NOTE: Replace the "X.X" below with your TDP version number.1) Fully exit Toad Data Point (TDP).2) Go to: C:\Users\<YOUR_USER>\AppData\Roaming\Quest Software\3) Rename the “Toad Data Point X.X” folder to “Toad Data Point X.X OLD”.4) Start TDP (this will cause TDP to create a new “Toad Data Point X.X” folder).5) If asked if you want to ‘Migrate’ settings from previous versions, choose CANCEL or NO.6) Ensure that your TDP seems to have been reset to factory defaults.7) Re-test the issue.NOTE: If you want to transfer back your Saved Connections, see the steps below. However, please re-test the issue first before we try to re-use any ‘old’ files.1) Fully exit Toad Data Point (TDP) again.2) Go to the OLD “Toad Data Point X.X OLD” folder you renamed previously.3) Perform a Copy on the “Connections.xml” file (make a BACKUP of this file just in case of errors).4) Go to the NEW “Toad Data Point X.X” folder that was just created by TDP.5) Paste the “Connections.xml” file in there.6) Start TDP and you should now have your previous Saved Connections. -
Additional Information
Vertica completely rewrote their ODBC driver and, in our opinion, there are a lot of bugs in their driver. We have several open support cases with them to try and get them resolved. When we support the 5.0 driver for Vertica depends on when Veritca can get us a stable driver.