Home » Server Options » Streams & AQ » Getting C001: long running txn detected in alertlog (10.2.0.4 BP5 Win2003 server x64)
Getting C001: long running txn detected in alertlog [message #346404] Mon, 08 September 2008 07:57 Go to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Seeing this in the alertlog:

Fri Sep 05 10:01:55 2008
C001: long running txn detected, xid: 0x0019.028.0000d76c


Everything looks fine, but no data is being propagated. I have not found any good answers for this.

Any ideas?

Regards
Hristo
Re: Getting C001: long running txn detected in alertlog [message #346408 is a reply to message #346404] Mon, 08 September 2008 08:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Have you any ORA-600 or ORA-7445 errors in alert.log?
Do you replicate LOB?

Regards
Michel
Re: Getting C001: long running txn detected in alertlog [message #346604 is a reply to message #346408] Tue, 09 September 2008 02:10 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

No, no errors in the alertlog. And no LOBs.

Regards
Peter
Re: Getting C001: long running txn detected in alertlog [message #346625 is a reply to message #346604] Tue, 09 September 2008 03:01 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does this happen only once?

Regards
Michel
Re: Getting C001: long running txn detected in alertlog [message #346685 is a reply to message #346625] Tue, 09 September 2008 06:25 Go to previous messageGo to next message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

Yes, but for three databases. We had to redeploy streams to get them to work.

Regards
Peter

[Updated on: Tue, 09 September 2008 06:29]

Report message to a moderator

Re: Getting C001: long running txn detected in alertlog [message #346695 is a reply to message #346685] Tue, 09 September 2008 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Sorry, can't help more maybe a transient error due a real long transaction.

Regards
Michel
Re: Getting C001: long running txn detected in alertlog [message #346726 is a reply to message #346695] Tue, 09 September 2008 09:05 Go to previous message
hristo
Messages: 258
Registered: May 2007
Senior Member
Hi!

So, if its a really long transaction, would streams have started to work eventually? (if thats possible to answer..)

Regards
Peter

[Updated on: Tue, 09 September 2008 09:12]

Report message to a moderator

Previous Topic: Stream is not working... Need help.
Next Topic: streams state is paused for flow control
Goto Forum:
  


Current Time: Thu Mar 28 13:32:57 CDT 2024