-
Title
Post Main thread is waiting seconds for session to commit before processing next operation. -
Description
Post process apparentelly is not posting messages or is too slow, and in the event_log you can see serious messages regarding sessions blocks and/or operation is too slow:
Notice 2015-04-09 10:37:30.477723 5982 7 Poster: Operation ODR_UPDATE1 on table "OWNER"."TABLE" is taking longer than 120 seconds. SID/serial: 9999/9998 Subqueue: 37. (posting from SOURCEDB, queue POST_QUEUE1, to TARGETDB) [module opo]
Warning 2015-04-09 10:37:48.592152 6263 1 Poster: Main thread is waiting 479 seconds for session 819 to commit before processing next operation. (posting from SOURCEDB, queue POST_QUEUE1, to TARGETDB) [module opo]
Warning 2015-04-09 10:40:51.615779 6263 1 Poster: Main thread is waiting 659 seconds for session 819 to commit before processing next operation. (osting from SOURCEDB, queue POST_QUEUE1, to TARGETDB) [module opo]
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.