Symptom
-
When an IMRS enabled database has just been created and sysimrslogs is empty,
-
DBCC LOG hits Error 624 when attempting to dump log records and specifying pageno=<ptnfirst> and rowno=0, for example:
1> dbcc imrslog(tdb1, show, ptnfirst)
2> go
PTNFIRST: 102401
1> dbcc imrslog(tdb1, show, ptnroot)
2> go
PTNROOT: 102401
1> dbcc imrslog(4, show, lastlr)
2> go
LAST IMRSLOG ROW: (0, 0)
1> dbcc log(4,-1, 102401,0,10,-3)
2> go
IMRSLOG SCAN DEFINITION:
Database id : 4
Forward scan: starting at (102401,0)
Maximum of 10 imrslog records.
Msg 624, Level 21, State 1:
Line 1:
Adaptive Server failed to retrieve a row via its RID in database 'mydb' because the requested RID has a higher number than the last RID on the page. Rid pageid = 102401; row num = 0. Page pointer = 0x0x155fc6800, pageno = 102401, status = 0x1, ptnid = 59, indexid = 0, level = 0, pnextrno = 0.
Invalid transaction id: 102401, 0
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
- The stack trace following Error 624 shows functions:
scan_getrow
apl__startscan
startptnscan
xsc__sysimrslogs_setscan
xls_startscan
d_log
d_calllog
exec_dbcc
Note: A complete stack trace is available under Attachments.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL02
- In-Memory Row Storage (IMRS)
Product
Keywords
CR#809777, CR809777, 809777 , 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.
SAP Knowledge Base Article - Preview