OraFAQ Forum: Streams & AQ » Getting C001: long running txn detected in alertlog

Home » Server Options » Streams & AQ » Getting C001: long running txn detected in alertlog (10.2.0.4 BP5 Win2003 server x64)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting C001: long running txn detected in alertlog [message #346404]

Mon, 08 September 2008 07:57

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

Report message to a moderator

Re: Getting C001: long running txn detected in alertlog [message #346408 is a reply to message #346404]

Mon, 08 September 2008 08:06

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have you any ORA-600 or ORA-7445 errors in alert.log?
Do you replicate LOB?

Regards
Michel

Report message to a moderator

Re: Getting C001: long running txn detected in alertlog [message #346604 is a reply to message #346408]

Tue, 09 September 2008 02:10

hristo
Messages: 258
Registered: May 2007

Senior Member

Hi!

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

Regards
Peter

Report message to a moderator

Re: Getting C001: long running txn detected in alertlog [message #346625 is a reply to message #346604]

Tue, 09 September 2008 03:01

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Does this happen only once?

Regards
Michel

Report message to a moderator

Re: Getting C001: long running txn detected in alertlog [message #346685 is a reply to message #346625]

Tue, 09 September 2008 06:25

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Sorry, can't help more maybe a transient error due a real long transaction.

Regards
Michel

Report message to a moderator

Re: Getting C001: long running txn detected in alertlog [message #346726 is a reply to message #346695]

Tue, 09 September 2008 09:05

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 01:13:27 CST 2025