Toad World® Forums

Toad 10 Crash on Explain Plan


#1

Sometimes, when I click the ambulance button to get an Explain Plan in
Toad 10, it gives me the SQL hourglass for a second or two and then
completely vanishes. No “this program must close” dialog box, no
TOAD.ELF generated, nothing; the window is simply gone. (According to
Task Manager the process is gone too.) Looking in PLAN_TABLE and
TOAD_PLAN_SQL, I don’t see anything from the Explain, so it was
presumably in the Explain part, not the formatting-results part (or it
didn’t Commit, if a Commit is needed for an Explain Plan?).

This is consistent for a given SQL; if I restart Toad and try to explain
the same query again, it will crash again. However, it doesn’t happen
with all queries; generally, it seems to happen on the more complicated
ones. Toad 9.7 can Explain the same SQL successfully.

Support bundle and toad.ini attached below. (You can see it reports the
“most recent error” from the TOAD.ELF from a couple months ago, i.e.
this crash didn’t create a TOAD.ELF.) This support bundle was created
after I restarted Toad and reconnected to the same server as the same
ID, although at the time of today’s crash I had another connection also
open.

Any suggestions?

Nate Schroeder
IT Commercial Technical Services - Data Management Team
Monsanto Company
800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167
314-694-2592

Issue:

winmail.dat (50.8 KB)


#2

Sounds like a stack overflow somewhere.

Please try this:

Do the explain in Toad 9.7. Right-click it and save to XML.
Open T10, go to the explain plan and try to load the XML. Does it cause toad
to vanish? If so, please send me the XML.

-John



#3

Nope, unfortunately when I do that it doesn’t crash. (The Explain Plan has
48 steps, incidentally. The query has 318 lines.)

Nate Schroeder

IT Commercial Technical Services - Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167

314-694-2592


#4

Too bad – that would have been the easy way for me to reproduce it!

Well, can you send me table DDL and the query?


#5

(Replied outside the group, to avoid cluttering your Inboxes with the 17 or so
sets of DDL for the underlying objects.)

Nate Schroeder

IT Commercial Technical Services - Data Management Team

Monsanto Company

800 N. Lindbergh Blvd. G3WI - Saint Louis, MO - 63167

314-694-2592