# Crash & Freeze with beta 607

**URL:** <https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085>\
**Category:** Toad for Oracle - Beta\
**Created:** [September 24, 2020, 6:01pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085 "2020-09-24T18:01:45Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\
**Post date:** [September 24, 2020, 6:01pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/1 "2020-09-24T18:01:45Z")

</div>

One of our developers has encountered a few crashes, each time with Toad freezing requiring it to be killed. He mentioned that the last time this occurred he had just closed a schema browser.

![image](https://global.discourse-cdn.com/quest/original/2X/0/080b2f16966e950699d0939af1a437f2f68cfa52.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 24, 2020, 6:05pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/2 "2020-09-24T18:05:55Z")

</div>

I believe that will not be a problem in the official release.

Next time it happens, instead of posting the dialog above, please do the following:

1. Click where it says "click here"
2. Dialog changes to show a call stack. At the bottom, you'll see a "copy to clipboard" box. Check that, click OK, and then post your clipboard contents here.

Thanks.

---

<div class="post-metadata">

**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\
**Post date:** [September 24, 2020, 6:32pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/3 "2020-09-24T18:32:48Z")

</div>

In this case it was not possible to get the stack trace. Toad was frozen and clicking on "click here" was not responsive.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 24, 2020, 6:35pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/4 "2020-09-24T18:35:09Z")

</div>

Oh wow, I've never seen that happen before. OK, thanks.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 24, 2020, 6:58pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/5 "2020-09-24T18:58:18Z")

</div>

I do want to highjack this thread, I toad just went to the grey screen with no popup. Just froze.

I just coded a package body, saved, copied the signature to the clipboard, went the the spec and pasted the signature . Started to modify the signature to be for the spec and froze.

Happened, 2 times at the same, place, I could not repro a 3rd time. Tried 4 times.

Sometimes killing the connection unfreezes toad, but NOT this time. This was the current statement the frozen toad was doing.  
 ![image](https://global.discourse-cdn.com/quest/original/2X/d/d21a8d582ca3b14d85a46ac07e04af821e390eed.png)

---

<div class="post-metadata">

**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\
**Post date:** [September 24, 2020, 7:16pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/6 "2020-09-24T19:16:42Z")

</div>

Same developer that reported the crash/freeze encountered another freeze with spinning mouse pointer when pasting over highlighted text in the editor. He was trying to paste an id value over the sub-select.

![image](https://global.discourse-cdn.com/quest/original/2X/7/7801587428c359b74c93fa135dd9e9c1d386a6d5.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 24, 2020, 7:21pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/7 "2020-09-24T19:21:53Z")

</div>

Was Spool SQL active (either to file or screen)?  
It may seem unrelated, but try Michael's workaround here: [Missing navigator](https://forums.toadworld.com/t/missing-navigator/50973/10)

Edit: oh, Marc - hah, that was you over there on that other thread. hmm... Maybe that will help for Doug?

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 24, 2020, 7:32pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/8 "2020-09-24T19:32:12Z")

</div>

I changed my spool to screen to fix the debug.sql file lock issue and the auto analyze is off

---

<div class="post-metadata">

**Author:** ![DougK](https://avatars.discourse-cdn.com/v4/letter/d/e9c0ed/32.png) [@DougK](https://forums.toadworld.com/u/DougK)\
**Post date:** [September 24, 2020, 9:06pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/9 "2020-09-24T21:06:03Z")

</div>

The developer with the freeze pasting into an editor window reports that "Code Analysis Check Rules is unchecked already."

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 24, 2020, 9:42pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/10 "2020-09-24T21:42:01Z")

</div>

@DougK and @marc_109 - We've got a beta planned for tomorrow. Spool SQL will be fixed and some other things that might affect this, so we'll eliminate some unknowns. Let me know if it happens again after that and if so I'll see if I can get your user files folder and reproduce the problem.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 30, 2020, 6:43pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/11 "2020-09-30T18:43:38Z")

</div>

Just happened again with the latest. I did have output to file on and the last statement was chopped off. How else can i help. Repo was similar to the last. I just coded a package body, saved, copied the signature to the clipboard, went the the spec and pasted the signature . Started to modify the signature to be for the spec and froze.

 ![image](https://global.discourse-cdn.com/quest/original/2X/1/1d6a9ced7359a6ec5fabfbbb47099749024f5d4a.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 30, 2020, 6:55pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/12 "2020-09-30T18:55:04Z")

</div>

Earlier I thought spool SQL might have been related to this problem, but now, after the changes that I made, I don't think that it is. The file writing component flushes every 1024 bytes, or when you turn off Spool SQL, or when you close Toad. So it would have finished the SQL in a normal circumstance.

Can you send me the package you that you made? I can try to reproduce the problem.

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 30, 2020, 7:07pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/13 "2020-09-30T19:07:49Z")

</div>

Can you send me your email to send to

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 30, 2020, 7:09pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/14 "2020-09-30T19:09:26Z")

</div>

Sure, send to [john.dorlon@quest.com](mailto:john.dorlon@quest.com)

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [September 30, 2020, 7:22pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/15 "2020-09-30T19:22:50Z")

</div>

sent, tell me if it was blocked some how.

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [September 30, 2020, 9:22pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/16 "2020-09-30T21:22:01Z")

</div>

Hi Marc,

I got your email but there was no script attached or in the body. I guess it got stripped out.

-John

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [October 1, 2020, 11:51am UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/17 "2020-10-01T11:51:02Z")

</div>

sent again, but this time in a zip

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [October 13, 2020, 3:07pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/18 "2020-10-13T15:07:23Z")

</div>

toad froze again 3 times this morning. John I sent you the dmp file in an email. Today was slightly different.

I was running "exec P\_VOLS\_PRICE.TEST\_TRADE\_LOG", the following error appeared in a popup, I hit "copy to clipboard" and then all froze. The cut and paste was similar, but not in the same place. I can not repro a 4th time. It is not happening consistently, but maybe I can try a few times if you need any debug help.

I was just playing around and was able to lock up and this appeared. I am not debugging at all.  
 ![image](https://global.discourse-cdn.com/quest/original/2X/8/8b70ad58bf01e9b049b49411769a7074a5639a30.png)  
 ![image](https://global.discourse-cdn.com/quest/original/2X/e/e82700da1b4d04398b78c64fc452f475032b837f.png)

---

<div class="post-metadata">

**Author:** ![JohnDorlon](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/johndorlon/32/9997_2.png) [@JohnDorlon](https://forums.toadworld.com/u/JohnDorlon)\
**Post date:** [October 13, 2020, 5:21pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/19 "2020-10-13T17:21:03Z")

</div>

Thanks, I got the .dmp file but they don't really help me.

I'll try that "copy to clipboard" after a timeout. I know you've had it lock up on the other error dialog with the copy to clipboard. Do you have any kind of clipboard monitoring/history software installed?

---

<div class="post-metadata">

**Author:** ![marc\_109](https://avatars.discourse-cdn.com/v4/letter/m/74df32/32.png) [@marc\_109](https://forums.toadworld.com/u/marc_109)\
**Post date:** [October 13, 2020, 5:43pm UTC](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085/20 "2020-10-13T17:43:49Z")

</div>

This is my company pc, there is a few pieces of software running that can react with the clipboard.

[Next page](https://forums.toadworld.com/t/crash-freeze-with-beta-607/51085.md?page=2)
