Home » Server Options » Streams & AQ » Deadlock detected
Deadlock detected [message #75644] Mon, 24 November 2003 08:30 Go to next message
Mahesh
Messages: 90
Registered: January 2001
Member
While creating apply process,i am getting following error message. Could you please help me?
SQL> BEGIN
2 DBMS_APPLY_ADM.CREATE_APPLY(
3 queue_name => 'strmadmin.streams_queue',
4 apply_name => 'apply_oe',
5 rule_set_name => 'strmadmin.apply_oe_rs',
6 message_handler => 'oe.mes_handler',
7 apply_user => 'oe',
8 apply_captured => false);
9 END;
10 /
BEGIN
*
ERROR at line 1:
ORA-04020: deadlock detected while trying to lock object
STRMADMIN.STREAMS_QUEUE
ORA-06512: at "SYS.DBMS_AQADM_SYSCALLS", line 0
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 3801
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_APPLY_ADM_INTERNAL", line 87
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 553
ORA-06512: at line 2

Could you please help me?

Regards
Mahesh R
Re: Deadlock detected [message #75645 is a reply to message #75644] Mon, 24 November 2003 11:53 Go to previous messageGo to next message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

Try to stop and drop, your previously defined
queue/ queue table before defining a new one. Look at
this example:

begin
DBMS_AQADM.STOP_QUEUE(
queue_name => 'strmadmin.streams_queue');

DBMS_AQADM.DROP_QUEUE(
queue_name => 'strmadmin.streams_queue');

DBMS_AQADM.DROP_QUEUE_TABLE(
queue_table => 'strmadmin.streams_qtable',
force => TRUE);

end;
/


Best regards.

Frank
Re: Deadlock detected [message #75707 is a reply to message #75645] Sun, 23 May 2004 08:19 Go to previous message
prince_raj
Messages: 1
Registered: May 2004
Junior Member
I am also getting Dead Lock Detected when our users use to make some trasaction data.
How can i over come the problem.
Previous Topic: Help please! Can't find Oracle Transparent Gateway for SQLServer
Next Topic: Streams implementation experiences
Goto Forum:
  


Current Time: Fri Mar 29 06:28:14 CDT 2024