MTP post core dumps and event log has this message on a object with LOBs.
[6] 02/21/07 07:41 Notice: Operation is not blocked -- just taking longer than expected on "SEUSER"."ATTACHMENT". Make sure proper index is being used. sp_opst_mt (for o.prod-o.prod queue db0b)/27812]
[1] 02/21/07 07:42 Warning: Main thread waiting for syncop.done for 60 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812] [38926] 02/21/07 07:42 Warning: session=5 waiting for block_resolve_done for 60 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812]
[1] 02/21/07 07:43 Warning: Main thread waiting for syncop.done for 120 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812] [38926] 02/21/07 07:43 Warning: session=5 waiting for block_resolve_done for 120 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812]
[1] 02/21/07 07:50 Warning: Main thread waiting for syncop.done for 540 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812] [38926] 02/21/07 07:50 Warning: session=5 waiting for block_resolve_done for 540 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812]
[1] 02/21/07 07:51 Warning: Main thread waiting for syncop.done for 600 seconds [sp_opst_mt (for o.prod-o.prod queue db0b)/27812] 02/21/07 07:51 Error: process sp_opst_mt killed due to SIGSEGV [sp_cop/22611] 02/21/07 07:51 Notice: process sp_opst_mt killed due to SIGSEGV; (core file = /opt/shareplex/var/dump/core.27812) [sp_cop/22611] 02/21/07 07:51 Process launched: sp_opst_mt (for o.prod-o.prod queue db0b) [pid = 3894]
[1] 02/21/07 07:51 Notice: Oracle env - prod:/u01/app/oracle/product/9.2.0 [sp_opst_mt(pdb)/3894] [1] 02/21/07 07:51 Notice: Oracle version 92 [sp_opst_mt(osp)/3894]
Core.out file in SP_SYS_VARDIR/dump directory indicates that it is failing in LOB Routine.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center