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

  Note: A complete stack trace is available under Attachments.

  • 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 for Me (Login required).

Search for additional results

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