Postプロセスで以下のようにORA-00060が発生します。
Notice 2017-01-19 14:15:15.484405 27210 102467904 Poster: session=4 is blocked by session=2. They are in different threads.
Will wait for blocker to release lock (posting from xxxx, queue queue01, to xxxx) [module opo]
Notice 2017-01-19 14:15:52.422630 27210 91978048 s:2 Poster: ORA-00060: リソース待機の間にデッドロックが検出されました。
(posting from xxxx, queue queue01, to xxxx) [module osp]
Error 2017-01-19 14:15:52.422912 27210 91978048 s:2 Poster: que/seq = 2/ xxxxx seqno/offset = xxxxx/xxxxx
Unexpected Oracle error: ORA-00060: リソース待機の間にデッドロックが検出されました。 (object name: "SPTEST1"."TEST1")
(posting from xxxx, queue queue01, to xxxx) [module opo]
Notice 2017-01-19 14:15:52.627179 27210 91978048 s:2 Poster: No locks found (posting from xxxx, queue queue01, to xxxx) [module osp]
Info 2017-01-19 14:15:52.639728 18175 752990784 Poster exited with code=1, pid = 12345 (posting from xxxx, queue queue01, to xxxx)
© ALL RIGHTS RESERVED. Feedback 利用規約 プライバシー Cookie Preference Center