Print Thread
#14461 06/21/04 08:25 PM
Joined: Jun 2004
Posts: 2
J
Member
OP Offline
Member
J
Joined: Jun 2004
Posts: 2
Hello,

My developers are reporting, that


Jurijs
Re:
#14462 06/21/04 10:28 PM
Joined: Aug 1999
Posts: 22,487
Member
Offline
Member
Joined: Aug 1999
Posts: 22,487
The pbsde package is indeed used internally by the Oracle Debugger. I have seen reports where this problem is fixed by increasing the shared pool size for the database instance. Can you try this?


Marco Kalter
Allround Automations
Re:
#14463 06/22/04 01:56 PM
Joined: Jun 2004
Posts: 2
J
Member
OP Offline
Member
J
Joined: Jun 2004
Posts: 2
I don't belive it will help. I have 160Mb allocated to shared_pool in this particular instance. Plroblem reprodusable constantly, even immediately after instance restart.

I belive it is related to configuration. Are there any preconfiguration steps for PL/SQL Developer, before starting using DEBUG mode?


Jurijs
Re:
#14464 06/22/04 10:39 PM
Joined: Aug 1999
Posts: 22,487
Member
Offline
Member
Joined: Aug 1999
Posts: 22,487
There is no real preconfiguration required, but as a result of previous dbms upgrades, the dbms_debug packages can cause problems. If this database instance has previously bee upgraded, you can logon to the server computer, go to $ORACLE_HOME/rdbms/admin, start SQL*Plus under the SYS account, and run pbload.sql. This will reload the dbms_debug packages. Check if this has a positive influence on the problem.


Marco Kalter
Allround Automations
Re:
#14465 10/22/04 01:08 AM
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
Member
Offline
Member
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
We're experiencing the problem in PLSD 6.0.2 using Oracle release 9.2.04. We started seeing the problem after installing Oracle Security Patch #68, but we haven't conclusively pegged that as the cause.

Reloading the package did not help, we resized the SGA and are waiting to see. The problem here is intermittent with various developers reporting the problem at different times.

Since the problem appears to be with the pipes implementation, I wrote a dummy application using DBMS_PIPES. Looping on a pipe read (dbms_pipe.receive_message) does make the application hang, but we don't get the 7445 error that we see when debugging is the source of the problem.

Any observations and comments y'all have are appreciated.

Re:
#14466 10/25/04 01:00 PM
Joined: Nov 2003
Posts: 25
Ukraine
M
Member
Offline
Member
M
Joined: Nov 2003
Posts: 25
Ukraine
What version RDBMS?
Are you have system event trigger [after] servererror on database in your DB?

Re:
#14467 10/26/04 06:28 PM
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
Member
Offline
Member
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
We are using Oracle 9.2.04.

Thanks for the suggestion, but we do not have after servererror triggers on the DB.

I've had reports that the problem exists in other applications also, so my suspicions that this is an Oracle problem and not a PLSD problem seem to be confirmed.

No progress on our TAR with Oracle yet. Still working on this. :rolleyes:

Re:
#14468 11/24/04 05:40 PM
Joined: Nov 2004
Posts: 1
F
Member
Offline
Member
F
Joined: Nov 2004
Posts: 1
Hi,
I have a system event trigger (servererror) on database (9.2.0.4.0) and i'm having the same problem. It occurs when i click in "Break" (or Shift+Esc) while i'm in a debuging session.

Are there any workaround for this issue??

Re:
#14469 11/24/04 05:59 PM
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
Member
Offline
Member
Joined: Nov 2003
Posts: 6
JHU Applied Physics Lab
I find that I cannot break in a debug session until the debugger has stopped at a breakpoint. If I try to break a non-stopped process, one of the sessions stays active and has to be KILLed. Often the package I'm debugging stays locked and we have to bounce the database (easiest solution) to right things.

Another symptom I sometimes see if I break a process is that the debugger loses all of my breakpoints and the process runs to completion despite stepping or breakpoints.

My suggestion to you is to try not to break out of a debug process from the client until a breakpoint is reached. Having your DBA kill the session at the DB level also works.

FYI, when using the debugger you have two processes running, the program you're testing and the process that is stepping through it.

Re:
#14470 11/24/04 08:33 PM
Joined: Nov 2003
Posts: 25
Ukraine
M
Member
Offline
Member
M
Joined: Nov 2003
Posts: 25
Ukraine
[quote]Originally posted by fabiorcg:
Hi,
I have a system event trigger (servererror) on database (9.2.0.4.0) and i'm having the same problem. It occurs when i click in "Break" (or Shift+Esc) while i'm in a debuging session.

Are there any workaround for this issue??
[/quote]It maybe Oracle bug.
It's a database event trigger "after servererror" on database or schema.
If there's a trigger on schema (even empty) it's
impossible to debug code in this schema (the session hangs) but
in other schemas there's no problems.
A trigger on database schema (even empty too) causes a session hang up
while debugging any code in this database.
create or replace trigger tr_error
after servererror on database|schema
begin
null;
end;
For instance, attempts to debug (step by step) this
function always fail (the debugger session hangs):
create or replace procedure debug_test_ver2
is
l_s varchar2(1);
begin
l_s:='xxx';
end;
It seems that the reason is that the line "l_s:='xxx';" raises an exception
which is catched by the database event trigger "after servererror"
and the debugger hangs. After killing the hung up sessions the server generates
two trace files (PBSDE.DEBUG_LOOP (WAIT = pipe get)...). If the trigger ("after servererror") is
dropped or disabled then everything works fine.


Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.066s Queries: 13 (0.007s) Memory: 2.5392 MB (Peak: 3.0399 MB) Data Comp: Off Server Time: 2024-12-04 06:12:06 UTC
Valid HTML 5 and Valid CSS