SAP Knowledge Base Article - Preview

2178445 - Error 12322 "Row xx on DOL datapage xx ... has size nn and an invalid holesize 0. Page is corrupted." when sp_locklogin runs - SAP ASE

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

Sybase Adaptive Server Enterprise 15.0

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.