Symptom
- sp_locklogin hits two Errors 12322
Error: 12322, Severity: 21, State: 3
Row 14 on DOL datapage 2306 in database 'xxxxx_db' has size 199 and an invalid holesize 0. Page is corrupted.
Error: 12322, Severity: 21, State: 3
Row 26995 on DOL datapage 2306 in database 'xxxxx_db' has size 10 and an invalid holesize 0. Page is corrupted
- With a stacktrace that shows the following functions:
dol_gc_page_compact
dol_garbage_collect
dol__delete_insert
dol__update_datapage
dol_update
- The same 12322 errors with no stacktraces are also reported by a system process (most likely by a housekeeper process).
- The DBCC CHECKDB command running on the master database reports Errors 9991 and 2306 for the syslogins system table:
Checking partition 'syslogins_33' (partition ID 33) of table 'syslogins'. The logical page size of this table is 2048 bytes.
Msg 9991, Level 16, State 1:
Server 'ASExxxxx', Line 1:
Page 2306, partition ID 33, of object 33, contains an orphan row at offset 867 which must be marked committed delete and is not.
...
Msg 7928, Level 18, State 1:
Server 'ASExxxxx', Line 1:
Index ncsyslogins is not consistent; found 1082 leaf rows but 1078 data rows. Drop and recreate the index.
Msg 7928, Level 18, State 1:
Server 'ASExxxxx', Line 1:
Index csyslogins is not consistent; found 1082 leaf rows but 1078 data rows. Drop and recreate the index.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 15.0.3
Product
Keywords
sp_locklogin, master , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem
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.