MT Post in Shareplex 6.0 or up is not moving (as seen in "show post detail") and the following messages appear in the event log over and over:
[1] 09/04/08 14:09 Notice: FindAllLocks: Object "SPLEX"."SHAREPLEX_TRANS" locked by user "
SPLEX",session(1082), command(No command), type(Table Lock), mode(Row-X (RX)), request(NONE), blocking(No Block), block(75666), row(0) [sp_opst_mt(osp)/24663]
[3] 09/04/08 14:09 Notice: session=159 is blocked by session=47. They are in different threads. Will wait for blocker to release lock. [sp_opst_mt (for o.SID1-o.SID2 queue queue_name)/24663]
Numerous rollbacks in Post queue are causing Post sessions to block each other.
The resolution listed here applies to a specific situation where rollbacks are causing Post sessions to block each other. To quickly determine if this is the case and to resolve it at the same time, the following can be done:
1. Stop Import and stop Post.
2. Exit sp_ctrl and while being in the /proddir/bin directory, issue the following at the OS prompt:
$ ./qview -p ( where $ denotes the OS prompt)
Read release full rollback subqueue 179, seq 8150747
Read release full rollback subqueue 226, seq 2730255
Read release full rollback subqueue 225, seq 3996403
.
.
Read release full rollback subqueue 9, seq 33068995566
Read release full rollback subqueue 8, seq 50906157147
The messages above indicate that there were indeed numerous rollback in Post queue and were removed by "qview -p".
3. Launch sp_ctrl and restart Post.
4. Issue "show post detail" to see if the field "Transactions Posted" shows increasing values at all times. If so, the issue has been resolved.
If the rollbacks are not an issue, the Solution # SOL32842 or SOL25972 can be explored. In this case the resolution given in SOL25972 was explored but it did not work as the parameters were adequately set to begin with and there no scope for any improvement. Moreover, this was Shareplex 6.0 so there was no way to set Post in single-threaded mode as suggested in SOL32842.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center