Toad World® Forums

AV when trying to load plan from saved XML file

Execution plan XML file I saved and tried to load:

[View:/cfs-file/__key/communityserver-discussions-components-files/86/auction_5F00_aoo_5F00_snapshot_2D00_BAD.xml:320:240]

EurekaLog 7.5.0.0

Application:

1.1 Start Date : Mon, 12 Sep 2016 07:54:09 -0500
1.2 Name/Description: Toad.exe - (Toad™ for Oracle®)
1.3 Version Number : 12.10.0.25
1.4 Parameters :
1.6 Up Time : 3 day(s), 2 hour(s), 55 minute(s), 46 second(s)

Exception:

2.1 Date : Thu, 15 Sep 2016 10:49:56 -0500
2.2 Address : 000000000724B2B7
2.3 Module Name: Toad.exe - (Toad™ for Oracle®)
2.5 Type : EAccessViolation
2.6 Message : Access violation at address 000000000724B2B7 in module ‘Toad.exe’. Read of address 0000000000000000.
2.7 ID : 984E0000
2.8 Count : 1
2.11 Sent : 0

User:

3.2 Name : CHX
3.3 Email:

Active Controls:

4.1 Form Class : TfrmMain
4.2 Form Text : Toad for Oracle (x64) BETA expires on 24-October-2016
4.3 Control Class: TComboBox
4.4 Control Text : Text compare (EP data)

Computer:

5.2 Total Memory : 8453214208 (7.87 Gb)
5.3 Free Memory : 1057579008 (1008.59 Mb)
5.4 Total Disk : 250056704000 (232.88 Gb)
5.5 Free Disk : 105366167552 (98.13 Gb)
5.6 System Up Time : 4 day(s), 8 hour(s), 34 minute(s), 8 second(s)
5.7 Processor : Intel® Core™2 Duo CPU E8400 @ 3.00GHz
5.12 Virtual Machine:

Operating System:

6.1 Type : Microsoft Windows 7 (64 bit)
6.2 Build # : 7601 (6.1.7601.23403)
6.4 Non-Unicode Language: English (0409)
6.5 Charset/ACP : 0/1252
6.6 Install Language : English (0409)
6.7 UI Language : English (0409)

Steps to reproduce:

8.1 Text:

Call Stack Information:

|Methods |Details|Stack |Address |Module |Offset |Unit |Class |Procedure/Method |Line |

|*Exception Thread: ID=7816; Parent=0; Priority=-2 |
|Class=; Name=MAIN |
|DeadLock=0; Wait Chain= |

Comment=
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=7892; Parent=7816; Priority=0
Class=TSendThread; Name=[Unnamed thread 7892] Kind: TThread. Thread function: CSLog.TSendThread.Execute. Thread caller: CSLog.TSendThread.Create (CSLog.TSendThread.Execute)
DeadLock=0; Wait Chain=thread: [ 1ED4 / 7892 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
7FFFFFFE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=7896; Parent=0; Priority=2
Class=; Name=[Unknown thread 7896] Kind: unknown. Thread function: winmm.dll + $0
DeadLock=0; Wait Chain=thread: [ 1ED8 / 7896 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=7904; Parent=7816; Priority=0
Class=TSaveSettingsThread; Name=[Unnamed thread 7904] Kind: TThread. Thread function: tdSaveSettings.TSaveSettingsThread.Execute. Thread caller: tdSaveSettings.TSaveSettingsThread.Create (tdSaveSettings.TSaveSettingsThread.Execute)
DeadLock=0; Wait Chain=thread: [ 1EE0 / 7904 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
00000040
7FFFFFFE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8112; Parent=7816; Priority=0
Class=TWorkerThread; Name=[Unnamed thread 8112] Kind: TThread. Thread function: VirtualTrees.WorkerThread.TWorkerThread.Execute. Thread caller: VirtualTrees.WorkerThread.TWorkerThread.Create (VirtualTrees.WorkerThread.TWorkerThread.Execute)
DeadLock=0; Wait Chain=thread: [ 1FB0 / 8112 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
7FFFFFFE
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8120; Parent=0; Priority=0
Class=; Name=[Unknown thread 8120] Kind: unknown. Thread function: WS2_32.dll [$000007FEFF329810]
DeadLock=0; Wait Chain=thread: [ 1FB8 / 8120 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8396; Parent=0; Priority=0
Class=; Name=[Unknown thread 8396] Kind: unknown. Thread function: ole32.dll [$000007FEFF0FFB40]
DeadLock=0; Wait Chain=thread: [ 20CC / 8396 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
00000040
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=7836; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=thread: [ 1E9C / 7836 ] is blocked
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=10992; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=10592; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9060; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9672; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=7868; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=8748; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Running Thread: ID=9132; Parent=0; Priority=0
Class=; Name=
DeadLock=0; Wait Chain=
Comment=
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
7FFFFFFE
00000040
00000040

Modules Information:

|Handle |Name |Description |Version |Size |Modified |Path |

|00000000034D0000|oraunls11.dll |Oracle UNLS Runtime Library |11.1.0.6 |112128 |2010-02-17 20:28:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000003500000|orauts.dll |Oracle CORE UTS PT Library |11.2.0.1 |10240 |2010-02-11 20:31:08|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000003530000|orasnls11.dll |Oracle SNLS Runtime Library |11.1.0.6 |231424 |2010-02-17 20:28:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000004190000|Toad.exe |Toad™ for Oracle® |12.10.0.25 |55001496|2016-08-25 13:05:22|C:\Program Files\Dell\Toad for Oracle 12.10 Beta\ |
|0000000010F50000|oracore11.dll |Oracle CORE Library |11.2.0.1 |1411072 |2010-02-11 20:31:06|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000110B0000|oranls11.dll |Oracle NLS Runtime Library |11.1.0.6 |1020928 |2010-02-17 20:28:50|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000111D0000|oranl11.dll |Oracle SQLNet ORANL DLL |11.2.0.1 |430592 |2010-03-15 19:48:00|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000011250000|orantcp11.dll |Oracle SQL
Net ORANTCP DLL |11.2.0.1 |199680 |2010-03-15 19:48:04|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000112A0000|oranldap11.dll |Oracle SQLNet ORANLDAP DLL |11.2.0.1 |290816 |2010-03-15 19:48:00|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000011320000|orancrypt11.dll |Oracle SQL
Net ORANCRYPT DLL |11.2.0.1 |133120 |2010-03-15 19:47:56|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000012C90000|oranhost11.dll |Oracle SQLNet ORANHOST DLL |11.2.0.1 |21504 |2010-03-15 19:47:58|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000012CB0000|oranro11.dll |Oracle SQL
Net ORANRO DLL |11.2.0.1 |350720 |2010-03-15 19:48:02|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000168D0000|oracommon11.dll |Oracle RDBMS Common Library |11.2.0.1 |2827264 |2010-03-30 06:12:30|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000016BA0000|orancds11.dll |Oracle SQLNet ORANCDS DLL |11.2.0.1 |8704 |2010-03-15 19:47:56|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000016BC0000|orantns11.dll |Oracle SQL
Net ORANTNS DLL |11.2.0.1 |48128 |2010-03-15 19:48:04|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000016BF0000|oraztkg11.dll |Oracle Kerberos/GSS-API DLL |11.1.0.1 |712704 |2010-03-13 08:39:54|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017320000|oraslax11.dll |Oracle SLAX runtime Library |11.1.0.6 |38400 |2010-01-21 04:35:20|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017500000|oravsn11.dll |Oracle RDBMS Version Library |11.2.0.1 |9728 |2010-03-30 03:27:38|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017A80000|oraocrutl11.dll |Oracle OPSM OCRUTL DLL |11.2.0.1 |49664 |2010-03-26 12:01:36|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|0000000017AF0000|oraplc11.dll |Oracle PLC runtime Library |11.1.0.6 |112128 |2010-03-30 06:11:26|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001BC60000|oraxml11.dll |Oracle XML Library |11.1.0.6 |5086720 |2010-01-17 09:08:36|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001C140000|oracell11.dll |Oracle SAGE shared library |11.1.0.6 |287744 |2010-03-30 03:07:54|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001C1E0000|orasql11.dll |Oracle SQL Runtime Library |11.1.0.6 |357888 |2010-03-30 06:01:38|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001C650000|oraocr11.dll |Oracle OPSM OCR DLL |11.2.0.1 |801280 |2010-03-26 12:01:34|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001C850000|orageneric11.dll |Oracle RDBMS Generic Library |11.2.0.1 |15667200|2010-03-30 06:15:20|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001D760000|oran11.dll |Oracle SQLNet ORAN DLL |11.2.0.1 |4518912 |2010-03-15 19:47:54|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001DBC0000|orannzsbb11.dll |Oracle SQL
Net ORANNZSBB11 DLL |11.0.0.1 |1564672 |2010-03-13 08:39:50|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001DD50000|oraldapclnt11.dll |Oracle Internet Directory Client Library |10.1.4.0 |2015232 |2010-03-13 08:39:48|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001DF50000|orazt11.dll |Oracle SQLNet SUPPORT DLL |11.1.0.1 |2003968 |2010-03-13 08:39:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001E140000|orapls11.dll |Oracle PLS runtime Library |11.1.0.6 |5360128 |2010-03-30 06:11:52|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001E670000|oraplp11.dll |Oracle PLP runtime Library |11.1.0.6 |4136960 |2010-03-30 06:12:06|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001EA70000|orahasgen11.dll |Oracle PCW generic Library |11.2.0.1 |2950656 |2010-03-26 11:57:32|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001ED50000|oraocrb11.dll |Oracle OPSM OCRB DLL |11.2.0.1 |978432 |2010-03-26 12:01:36|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000000001EF50000|oci.dll |Oracle Call Interface |11.2.0.1 |657408 |2010-03-30 06:03:20|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|00000000246C0000|QSE.dll |QSE DLL |12.10.0.25 |2899864 |2016-08-25 11:22:18|C:\Program Files\Dell\Toad for Oracle 12.10 Beta\ |
|00000000526E0000|QP5.dll | |5.300.16235.37314 |22589848|2016-08-22 21:24:54|C:\Program Files\Dell\Toad for Oracle 12.10 Beta\ |
|0000000054490000|x2fputQ5.dll |Print Ticket Provider Component |5351.800.0.0 |539136 |2014-02-19 12:54:26|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000054520000|x2coreQ5.dll |Print Driver Component |5351.800.0.0 |16546304|2014-02-19 13:03:28|C:\Windows\System32\spool\drivers\x64\3\ |
|00000000557A0000|x2utilQ5.dll |Print Driver Component |5351.800.0.0 |1971712 |2014-02-19 12:54:46|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000055990000|x2comsQ5.dll |Network Communications Library |5351.800.0.0 |659968 |2014-02-19 12:54:34|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000055A60000|x2upQ5.dll |Print Driver UI Component |5351.800.0.0 |2265600 |2014-02-19 12:54:56|C:\Windows\System32\spool\drivers\x64\3\ |
|0000000055D60000|icmp.dll |ICMP DLL |6.1.7601.23403 |3072 |2016-03-25 13:58:11|C:\Windows\System32\ |
|0000000057340000|security.dll |Security Support Provider Interface |6.1.7600.16385 |5120 |2009-07-13 20:32:34|C:\Windows\System32\ |
|0000000066180000|wmi.dll |WMI DC and DP functionality |6.1.7601.23403 |5120 |2016-03-25 14:04:11|C:\Windows\System32\ |
|00000000662A0000|msvcp80.dll |Microsoft® C++ Runtime Library |8.0.50727.6195 |1068368 |2011-06-29 11:32:00|C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6195_none_88e41e092fab0294\ |
|000000006CC60000|x2wftuQ5.dll |Print Driver Workflow Component |5351.800.0.0 |481280 |2014-02-19 12:54:32|C:\Windows\System32\spool\drivers\x64\3\ |
|000000006CCE0000|x2rpsQ5.dll |PS Print Driver Rendering Component |5351.800.0.0 |1603072 |2014-02-19 12:54:56|C:\Windows\System32\spool\drivers\x64\3\ |
|000000006CE70000|x2txtQ5.dll |Print Driver Resources |5351.800.0.0 |285184 |2014-02-19 11:54:20|C:\Windows\System32\spool\drivers\x64\3\Xerox\Language Data\V5.0\en-us\ |
|0000000071FE0000|libaprutil_tsvn.dll |Apache Portable Runtime Utility Library |1.5.3.0 |271616 |2014-05-06 20:37:34|C:\Program Files\TortoiseSVN\bin\ |
|0000000072030000|TortoiseSVN.dll |TortoiseSVN shell extension client |1.8.7.25475 |494848 |2014-05-06 20:37:48|C:\Program Files\TortoiseSVN\bin\ |
|00000000720B0000|msvcp100.dll |Microsoft® C Runtime Library |10.0.40219.325 |608080 |2015-08-03 19:34:00|C:\Program Files\Microsoft Office 15\root\office15\ |
|0000000072150000|msvcr100.dll |Microsoft® C Runtime Library |10.0.40219.325 |829264 |2015-08-03 19:34:00|C:\Program Files\Microsoft Office 15\root\office15\ |
|0000000072310000|msvcr80.dll |Microsoft® C Runtime Library |8.0.50727.6195 |802640 |2011-06-29 11:32:00|C:\Windows\winsxs\amd64_microsoft.vc80.crt_1fc8b3b9a1e18e3b_8.0.50727.6195_none_88e41e092fab0294\ |
|0000000073700000|libapr_tsvn.dll |Apache Portable Runtime Library |1.5.1.0 |181504 |2014-05-06 20:37:34|C:\Program Files\TortoiseSVN\bin\ |
|00000000737B0000|atl100.dll |ATL Module for Windows |10.0.40219.325 |158536 |2015-08-03 19:33:59|C:\Program Files\Microsoft Office 15\root\office15\ |
|00000000737F0000|TortoiseOverlays.dll |TortoiseSVN overlay handler shim |1.1.3.21564 |75544 |2011-06-13 10:20:44|C:\Program Files\Common Files\TortoiseOverlays\ |
|0000000073A40000|TortoiseStub.dll | |1.8.7.25475 |76032 |2014-05-06 20:37:48|C:\Program Files\TortoiseSVN\bin\ |
|0000000077280000|user32.dll |Multi-User Windows USER API Client DLL |6.1.7601.23403 |1009152 |2016-03-25 14:03:52|C:\Windows\System32\ |
|0000000077380000|kernel32.dll |Windows NT BASE API Client DLL |6.1.7601.23455 |1163264 |2016-05-16 18:14:25|C:\Windows\System32\ |
|0000000077520000|ntdll.dll |NT Layer DLL |6.1.7601.23455 |1732888 |2016-05-16 18:17:39|C:\Windows\System32\ |
|00000000776E0000|normaliz.dll |Unicode Normalization DLL |6.1.7600.16385 |2560 |2009-07-13 20:31:40|C:\Windows\System32\ |
|00000000776F0000|psapi.dll |Process Status Helper |6.1.7600.16385 |9216 |2009-07-13 20:41:53|C:\Windows\System32\ |
|0000000180000000|oraclient11.dll |Oracle RDBMS Client Library |11.2.0.1 |4765184 |2010-03-30 06:12:50|C:\Oracle\product\11.2.0\client_x64_1\BIN\ |
|000007FECF460000|PSCRIPT5.DLL |PostScript Printer Driver |0.3.9600.17388 |649216 |2015-06-03 15:21:37|C:\Windows\System32\spool\drivers\x64\3\ |
|000007FECF560000|mscms.dll |Microsoft Color Matching System DLL |6.1.7601.17514 |625664 |2010-11-20 08:27:01|C:\Windows\System32\ |
|000007FECF600000|PS5UI.DLL |PostScript Driver User Interface |0.3.9600.17246 |864768 |2015-06-03 15:21:37|C:\Windows\System32\spool\drivers\x64\3\ |
|000007FECF910000|newdev.dll |Add Hardware Device Library |6.0.5054.0 |313856 |2009-07-13 20:41:52|C:\Windows\System32\ |
|000007FECFA30000|hhctrl.ocx |Microsoft® HTML Help Control |6.1.7600.16385 |70195

I’m not sure what the problem is here. I was able to load that XML file without any errors.

Apparently this is only happening when I do an Explain Plan Compare and try to load it from there.

Thought it had failed when loading from Editor but that’s working so might be just the compare.

I tried to reproduce it there (using a set of user files that you sent me a few weeks ago) but it still worked OK. I did see some painting problems - similar to what was reported in Session Browser. So I fixed that. But I didn’t see the anything worse than that. I wonder if it had to do with the plan that you were comparing it to?

My steps were (using most recent 64 bit beta and your user files)

  1. Go to Editor and do an EP on “select * from user_tables”

  2. rt-click -> compare with another plan.

  3. in the Compare EP window, click the 2nd toolbar button on the right hand side to open the auction_aoo_snapshot-BAD.xml file.