SAP Knowledge Base Article - Preview

2799273 - Error 8211 "Mismatch found between the name and id descriptor hash table for table..." leads to ASE crash - SAP ASE

Symptom

  • ASE reported Error 8211 for a user process: (spid):

Error: 8211, Severity: 26, State: 1
Mismatch found between the name and id descriptor hash table for table 'xxxxxxxxxxx', objid = 1719674143. Descriptor hashed by name = 0x9c31c9d0 and hashed by id = 0x0.

  • It was followed by timeslice errors for the system process with spid 10:

timeslice -1501, current process infected at 100aeef58 (des_checkpoint_flush_sysstats.fdpr.chunk.5+0x4ac)
...
timeslice error: spid 10 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1500 ticks (150000 milliseconds). It has been marked for termination.
...
timeslice error: spid 10 exhausted its 'time slice' of 100 milliseconds and additional 'cpu grace time' of 1500 ticks (150000 milliseconds). It has been marked for termination.

  • The stack trace for spid 10 showed the following functions:

kitermproc
des_checkpoint_flush_sysstats.fdpr.chunk
sysstats_hk_flushstats

  • When spid 10 was terminated by ASE, it did not release a spinlock on the ASE internal structure Dbtable->dbt_defpipebufgpspin:

Spinlocks held by kpid 7929917
Spinlock Dbtable->dbt_defpipebufgpspin at address 0000000161137c20 owned by 7929917

  • ASE server crashed:

ueshutdown: exiting


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL04 HF1 ONE-OFF EBF 27333

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR801178, CR#801178, 801178, CR795239, CR797745, CR#795239, CR#797745, 795239, 797745 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.