6.0.5.926 debugger consumes 100% CPU

[arvychile]

Iv'e just downloaded latest update, installed and I'm no longer able to debug my objects.

After pressing F9 I loose my CPU, having to terminate PL/SQL.

PL/SQL Developer
Version 6.0.5.926 (MBCS)
02.22856 - 20 user license
Windows 2000 version 5,0 (build 2195) Service Pack 4

Physical memory : 768.432 kB (138.988 available)
Paging file : 1.136.212 kB (513.864 available)
Virtual memory : 2.097.024 kB (2.002.168 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe
NOAUTOLOGON
NOAUTOLOGON

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins
*Browser Extender version 2.0 by Joachim Rupik (C:\Program Files\PLSQL Developer\PlugIns\be.dll)
*Comment lines v1.1 (C:\Program Files\PLSQL Developer\PlugIns\commentline.dll)
*FTP File Interface 1.1 (C:\Program Files\PLSQL Developer\PlugIns\ftp.dll)
*Syntax HighLighting (1.1) (C:\Program Files\PLSQL Developer\PlugIns\HighLighting.dll)
*Named Sql (DB) (C:\Program Files\PLSQL Developer\PlugIns\named_sql_db.dll)
*Save Bookmarks v1.0 by Joachim Rupik (C:\Program Files\PLSQL Developer\PlugIns\SaveBookmarks.dll)
*Save separate v1.0 (C:\Program Files\PLSQL Developer\PlugIns\saveseparate.dll)
*SmartEd 2.0 Plug-In (C:\Program Files\PLSQL Developer\PlugIns\SmartEd.dll)
*Version Control Interface 1.1 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
AGRO
DBNET
DES
OF0
OVDES
...

Homes
OraClient10g_home1 (c:\Oracle\product\10.1.0\Client_1)
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.6.0
Character size: 1 byte(s)

 

[Marco Kalter]

What version did you use previously?

 

[Ed Holloman]

I've noticed the very same thing. I was using version 6.0.3.x (waiting for the sql window AutoSelect bug to be fixed in 6.0.4).

I'll have to reinstall 6.0.3 again - have to have the debugger.

Ed Holloman

PL/SQL Developer
Version 6.0.5.926 (MBCS)
01.21939 - 1 user license
Windows XP version 6.0 (build 2600) Service Pack 1

Physical memory : 1,047,408 kB (281,980 available)
Paging file : 1,733,336 kB (1,032,032 available)
Virtual memory : 2,097,024 kB (1,994,124 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library: d:\Oracle9i\bin\oci.dll
Use OCI7: False

Plug-Ins
*Browser Extender version 2.0 by Joachim Rupik (C:\Program Files\PLSQL Developer\PlugIns\be.dll)
*Comment lines v1.1 (C:\Program Files\PLSQL Developer\PlugIns\commentline.dll)
*PL/SQL Developer FindAll Plug-In version 2003/11/05 (C:\Program Files\PLSQL Developer\PlugIns\FindAll.dll)
*Syntax HighLighting (1.1) (C:\Program Files\PLSQL Developer\PlugIns\HighLighting.dll)
*NamedSQL Plug-In (C:\Program Files\PLSQL Developer\PlugIns\namedsql.dll)
Named Sql (DB) (C:\Program Files\PLSQL Developer\PlugIns\named_sql_db.dll)
*Save Bookmarks v1.0 by Joachim Rupik (C:\Program Files\PLSQL Developer\PlugIns\SaveBookmarks.dll)
*PL/SQL Developer Scale Plug-In (C:\Program Files\PLSQL Developer\PlugIns\Scale.dll)
*Shortcuts Plug-In v1.2 by Tiger (C:\Program Files\PLSQL Developer\PlugIns\shortcuts.dll)
*SmartEd 2.0 Plug-In (C:\Program Files\PLSQL Developer\PlugIns\SmartEd.dll)
*PL/SQL Developer Sort Plug-In version 2003-11-05 (C:\Program Files\PLSQL Developer\PlugIns\Sort.dll)
*Version Control Interface 1.1 (C:\Program Files\PLSQL Developer\PlugIns\VCS.dll)
(* is Active)

Aliases
ATLSDEVL
EXTPROC_CONNECTION_DATA
HATSDEVL
INSITED
INSITEP
...

Homes
Oracle9i (d:\Oracle9i)

DLLs
d:\Oracle9i\bin\oci.dll

TNS File
d:\Oracle9i\Network\Admin\tnsnames.ora

Using
Home: Oracle9i
DLL: d:\Oracle9i\bin\oci.dll
OCI: version 9.2
Oracle9i Enterprise Edition Release 9.2.0.3.0
Character size: 1 byte(s)

 

[arvychile]

I went back to Version 6.0.3.893
Debugger is a must have

 

[Marco Kalter]

To obtain some more diagnostic information, can you modify the shortcut and add the debug parameter? For example:

"C:\Program Files\PLSQL Developer\plsqldev.exe" debug

Reproduce the problem and send me the debug.txt file that is generated in the PL/SQL Developer directory.

 

[arvychile]

Did what you told me but could not reproduce error, Debugger worked fine.

Anyway I can send you the debug.txt file if you like, to what email cause I don't see an upload button here.

 

[Ed Holloman]

Sent debug.txt to support@allroundautomations.com.

This problem appeared for me after first opening a test script with the first attempt to debug. After that, it appeared to work fine, until I reopened the test script again.

 

[Marco Kalter]

@arvychile: If you cannot reproduce the issue, then there is no need to send me the debug.txt file.

@Ed: It seems that the Oracle Server process crashes with an ORA-00600 exception:

ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], []
ORA-06544: PL/SQL: internal error, arguments: [2603], [], [], [], [], [], [], []
ORA-06553: PLS-707: unsupported construct or internal error [2603] At line 1, position 1
begin
  -- Call the procedure
  pkg_mr2_ed.get_grid_data(as_ldapid => :as_ldapid,
                           as_supplier_number => :as_supplier_number,
                           as_buyer_id => :as_buyer_id,
                           as_program_id => :as_program_id,
                           as_product_line => :as_product_line,
                           as_plant_code => :as_plant_code,
                           as_lac => :as_lac,
                           as_classification => :as_classification,
                           an_qty_type => :an_qty_type,
                           as_buyer_type => :as_buyer_type,
                           ad_from_need_date => :ad_from_need_date,
                           ad_to_need_date => :ad_to_need_date,
                           cur_grid => :cur_grid);
end;

I found a similar problem report on Oracle MetaLink (Oracle Bug No. 4231009). The suggestion was to shutdown and restart the database. Can you try this?