Symptom
- REORG DEFRAG does not progress after some time.
- Command DBCC stack traces on the spid which is running REORG DEFRAG:
upsleepgeneric+0x52f()
smp_bufpredirty+0x3cc()
util_logpgimage+0x74b()
rdfrag__do_page_endchores+0x103()
rdfrag__copy_row+0xab4()
reorg_handler installed by the following function:-]
reorg__ptn_defrag+0x1106()
reorg_handler installed by the following function:-]
reorg_defrag+0x7ab()
reorg_handler installed by the following function:-]
reorg_main+0x7a9()
s_execute+0x69dd()
- Killing the REORG DEFRAG spid will produce error 1265:
An illegal attempt was made to release an invalid lock or a lock that is not owned by the process family (lr=0x0x1af20fae0, lrmagic=f).
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.7 and 16.0
Product
Keywords
CR778448, CR#778448, 778448, SQL1265, 1265, upsleepgeneric, smp_bufpredirty, util_logpgimage, rdfrag__do_page_endchores, rdfrag__copy_row, reorg_handler, reorg__ptn_defrag, reorg_defrag, reorg_main , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.