streams issue

  • From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
  • To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 23 Sep 2006 01:29:11 -0500

Hi all:

We have recently implemented an application with streams on Linux using
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 (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


Other related posts: