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.