Coordinator hangs after upgrade to SAP IQ 16 SP11 PL20 when drop partition on large table is executed on secondary node.
Pstacks on hung coordinator show the thread executing Alter Partition is doing a Check Index Consistency which is running under forbid and until that is complete nothing else gets processed.
Following conditions will cause the Coordinator hangs situation :
FP_NBIT_ENABLE_TOKENCOUNT_CHECK is enabled
- Drop Partition for a large table (for e.g 20billion rows) is executed on Secondary node
The issue has not been seen in SAP IQ 16 SP11 PL13
- SAP IQ 16 SP11 PL20
- Linux x64
sybase ; multiple ; cn ; writer ; reader ; sp_iqcheckfpconsistency ; dbcc ; checkdb , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed
About this pageThis 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.