Toad World® Forums

AV on Explain Plan using Threaded query session

Hi,

When running Explain Plan with Session for Explain Plan set to Threaded query session, the following error occurs:
Access violation at address 0000000009C3D4A5 in module 'Toad.exe'. Read of address FFFFFFFFFFFFFFFF.

Toad version: 13.1.1.5 (64-bit)
Oracle client version: 12.1.0.2

The issue doesn't happen if I use any of the other two options for the explain plan session.

Call Stack Information:
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Methods |Details|Stack           |Address         |Module      |Offset          |Source             |Unit           |Class                       |Procedure/Method                 |Line                             |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|*Exception Thread: ID=3944; Parent=0; Priority=-2                                                                                                                                                                    |
|Class=; Name=MAIN                                                                                                                                                                                                    |
|DeadLock=0; Wait Chain=                                                                                                                                                                                              |
|Comment=                                                                                                                                                                                                             |
|---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
|7FFFFFFE|04     |0000000000000000|0000000009C3D4A5|Toad.exe    |0000000005AAD4A5|DBAccess.pas       |DBAccess       |TCustomDADataSet            |SetConnection                    |10536[12]                        |
|00000040|04     |00000000007FF238|00000000052A02F6|Toad.exe    |00000000011102F6|Ora.pas            |Ora            |TOraDataSet                 |SetSession                       |8901[1]                          |
|00000040|04     |00000000007FF278|00000000096523D8|Toad.exe    |00000000054C23D8|frmSyntaxEditor.pas|frmSyntaxEditor|TSyntaxEditorForm           |ExplainPlan                      |2102[16]                         |
|00000040|04     |00000000007FF338|000000000917BE7D|Toad.exe    |0000000004FEBE7D|frmToadEditor.pas  |frmToadEditor  |TFormToadEditor             |actExplainPlanExecute            |3229[2]                          |
|00000040|03     |00000000007FF378|000000000432D350|Toad.exe    |000000000019D350|System.Classes.pas |System.Classes |TBasicAction                |Execute                          |                                 |
|00000040|03     |00000000007FF3A8|00000000045115A8|Toad.exe    |00000000003815A8|Vcl.ActnList.pas   |Vcl.ActnList   |TCustomAction               |Execute                          |                                 |
|00000040|04     |00000000007FF3E8|00000000095931C1|Toad.exe    |00000000054031C1|frmToad.pas        |frmToad        |TToadForm                   |ExecuteCommonAction              |1152[9]                          |
|00000040|04     |00000000007FF448|0000000005A2F2E9|Toad.exe    |000000000189F2E9|tdCommonActions.pas|tdCommonActions|TtdActionHandler            |ExecuteCommonAction              |59[4]                            |
|00000040|04     |00000000007FF4A8|0000000009B33B7B|Toad.exe    |00000000059A3B7B|dmCommonActions.pas|dmCommonActions|TdmCommonActions            |DoExecuteCommonAction            |2111[5]                          |
|00000040|04     |00000000007FF4F8|0000000009B33B28|Toad.exe    |00000000059A3B28|dmCommonActions.pas|dmCommonActions|TdmCommonActions            |ExecuteCommonAction              |2097[1]                          |
|00000040|03     |00000000007FF528|000000000432D350|Toad.exe    |000000000019D350|System.Classes.pas |System.Classes |TBasicAction                |Execute                          |                                 |
|00000040|03     |00000000007FF558|00000000045115A8|Toad.exe    |00000000003815A8|Vcl.ActnList.pas   |Vcl.ActnList   |TCustomAction               |Execute                          |                                 |
|00000040|03     |00000000007FF598|000000000432D044|Toad.exe    |000000000019D044|System.Classes.pas |System.Classes |TBasicActionLink            |Execute                          |                                 |
|00000040|03     |00000000007FF5C8|0000000009CF2404|Toad.exe    |0000000005B62404|dxBar.pas          |dxBar          |TdxBarItem                  |DoClick                          |                                 |
|00000040|03     |00000000007FF608|0000000009CF234C|Toad.exe    |0000000005B6234C|dxBar.pas          |dxBar          |TdxBarItem                  |DirectClick                      |                                 |
|00000040|03     |00000000007FF658|0000000009CF22DF|Toad.exe    |0000000005B622DF|dxBar.pas          |dxBar          |TdxBarItem                  |Click                            |                                 |
|00000040|03     |00000000007FF698|0000000009CE1B9E|Toad.exe    |0000000005B51B9E|dxBar.pas          |dxBar          |TdxBarCustomButton          |Click                            |                                 |
|00000040|03     |00000000007FF6D8|0000000009CF13B5|Toad.exe    |0000000005B613B5|dxBar.pas          |dxBar          |TdxBarItem                  |IsShortCut                       |                                 |
|00000040|03     |00000000007FF728|0000000009D3F87A|Toad.exe    |0000000005BAF87A|dxBar.pas          |dxBar          |TdxBarItemLinks             |IsShortCut                       |                                 |
|00000040|03     |00000000007FF788|0000000009CF13DB|Toad.exe    |0000000005B613DB|dxBar.pas          |dxBar          |TdxBarItem                  |IsShortCut                       |                                 |
|00000040|03     |00000000007FF7D8|0000000009D3F87A|Toad.exe    |0000000005BAF87A|dxBar.pas          |dxBar          |TdxBarItemLinks             |IsShortCut                       |                                 |
|00000040|03     |00000000007FF838|0000000009D45CAF|Toad.exe    |0000000005BB5CAF|dxBar.pas          |dxBar          |TdxBar                      |IsShortCut                       |                                 |
|00000040|03     |00000000007FF868|0000000009CD2E36|Toad.exe    |0000000005B42E36|dxBar.pas          |dxBar          |                            |IsBarManagerShortCut             |                                 |
|00000040|03     |00000000007FF8D8|0000000009CD3003|Toad.exe    |0000000005B43003|dxBar.pas          |dxBar          |TdxBarManager               |HandleShortCut                   |                                 |
|00000040|03     |00000000007FF928|0000000009CC5A71|Toad.exe    |0000000005B35A71|dxBar.pas          |dxBar          |TdxBarKeyboardHookController|HandleKey                        |                                 |
|00000040|03     |00000000007FF9A8|0000000009CC615C|Toad.exe    |0000000005B3615C|dxBar.pas          |dxBar          |TdxBarKeyboardHookController|HandleByManager                  |                                 |
|00000040|03     |00000000007FFA38|0000000009CC6780|Toad.exe    |0000000005B36780|dxBar.pas          |dxBar          |                            |Initialization                   |                                 |
|00000040|03     |00000000007FFA88|00000000047A233D|Toad.exe    |000000000061233D|dxHooks.pas        |dxHooks        |TdxSystemHook               |ProcessHookProcs                 |                                 |
|00000040|03     |00000000007FFAF8|00000000047A1F58|Toad.exe    |0000000000611F58|dxHooks.pas        |dxHooks        |                            |dxSystemKeyboardHook             |                                 |
|00000040|03     |00000000007FFB28|00007FFC9C9E84CE|user32.dll  |00000000000184CE|user32.dll         |user32         |                            | (possible CallNextHookEx+1134)  |                                 |
|00000040|03     |00000000007FFBB8|00007FFC9C9F10C3|user32.dll  |00000000000210C3|user32.dll         |user32         |                            | (possible IsProcessDPIAware+435)|                                 |
|00000040|03     |00000000007FFC08|00007FFC9C9F0FD9|user32.dll  |0000000000020FD9|user32.dll         |user32         |                            | (possible IsProcessDPIAware+201)|                                 |
|00000040|03     |00000000007FFC58|00007FFC9D86E6AF|ntdll.dll   |000000000009E6AF|ntdll.dll          |ntdll          |                            |KiUserCallbackDispatcher         |                                 |
|00000040|03     |00000000007FFCE0|00007FFC99B910A4|win32u.dll  |00000000000010A4|win32u.dll         |win32u         |                            |NtUserPeekMessage                |                                 |
|00000040|03     |00000000007FFCE8|00007FFC9C9E86AD|user32.dll  |00000000000186AD|user32.dll         |user32         |                            | (possible PeekMessageW+365)     |                                 |
|00000040|03     |00000000007FFD58|00007FFC9C9E8640|user32.dll  |0000000000018640|user32.dll         |user32         |                            | (possible PeekMessageW+256)     |                                 |
|00000040|03     |00000000007FFDA8|00000000046EA6AC|Toad.exe    |000000000055A6AC|Vcl.Forms.pas      |Vcl.Forms      |TApplication                |ProcessMessage                   |                                 |
|00000040|03     |00000000007FFE28|00000000046EA7E3|Toad.exe    |000000000055A7E3|Vcl.Forms.pas      |Vcl.Forms      |TApplication                |HandleMessage                    |                                 |
|00000040|03     |00000000007FFE98|00000000046EAC4F|Toad.exe    |000000000055AC4F|Vcl.Forms.pas      |Vcl.Forms      |TApplication                |Run                              |                                 |
|00000040|04     |00000000007FFED8|0000000009D4C1EB|Toad.exe    |0000000005BBC1EB|Toad.dpr           |Toad           |                            |Initialization                   |1935[113]                        |
|00000040|03     |00000000007FFF58|00007FFC9CD5402E|kernel32.dll|000000000001402E|KERNEL32.DLL       |KERNEL32       |                            |BaseThreadInitThunk              |                                 |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Thanks, I can reproduce that.

Update 12/9/2019: Fixed in Toad for Oracle 13.3 Beta