streams issue

From: <genegurevich_at_discoverfinancial.com>
Date: Sat, 23 Sep 2006 01:29:11 -0500
Message-ID: <OF8B26C56F.8FD2A021-ON862571F2.00235FE7-862571F2.00238CA5@discoverfinancial.com>

Hi all:

We have recently implemented an application with streams on Linux using Oracle 10.2.0.2.
Since last I am seeing apply process failing every few minutes with the following error in the alert log:

ORA-10388: parallel query server interrupt (failure) Sat Sep 23 02:06:34 2006
Streams APPLY A001 with pid=40, OS id=32280 stopped Sat Sep 23 02:06:34 2006
Errors in file /opt/oracle/admin/pihs10/bdump/pihs101_a001_32280.trc: ORA-12801: error signaled in parallel query server P000, instance rwlp75l1.ihs.discoverfinancial.com:pihs101 (1) ORA-00001: unique constraint (SYS.I_STREAMS_APPLY_SPILL_TXN) violated

I have searched metalink but did not find any relevant info. Has anyone seen that error and has an explanation and a fix?

thank you

Gene Gurevich

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Sep 23 2006 - 01:29:11 CDT