Symptom
Database maintenance job running update index statistics across many tables with DOL locking scheme, table has many rows (900 million row count), table also has several non-clustered indexes and an unique clustered index, getting error/stacktrace:
Error: 2628, Severity: 21, State: 2
In database 'servername', page 45021021 is linked forward to page 45021048, but that page is linked backward to page 53088753. Please report this internal error to SAP Technical Support.
SQL causing error : update INDEX statistics <tablename>
curdb = 8 tempdb = 2 pstat = 0x10000 p2stat = 0x101000
lasterror = 2628 preverror = 0 transtate = 1
kernel pc: 0x0000000001c8287b bt__getnextscanpg+0x165b()
kernel pc: 0x0000000001c80032 bt__handle_pagedone+0x122()
kernel pc: 0x0000000001c7c846 bt_getnext+0xca6()
kernel pc: 0x0000000001c5a212 dol_bt_getnext+0x2f2()
kernel pc: 0x0000000001bce453 getnext+0x653()
kernel pc: 0x00000000021c8486 ups_deadlock_getnext+0x36()
kernel pc: 0x00000000021c806b ups_build_gather_stats+0x36b()
kernel pc: 0x00000000021c1508 ups_build+0x498()
kernel pc: 0x00000000021bd419 ups__updstats+0x4f9()
kernel pc: 0x00000000021be2a7 ups__updstats_driver+0x2b7()
kernel pc: 0x00000000021bc7a1 update_statistics+0x631()
kernel pc: 0x00000000021bb261 ups_main+0x571()
Read more...
Environment
SAP Adaptive Server Enterprise ASE 16.0
Product
Keywords
Error 2628, update index statistics, buffer, DOL, data only, locking scheme, locking , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
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.