2949071 - After upgrading from IQ 16.x, IQ freezes during large HG creation. SAP IQ

IQ Server freezes or slows while creating large HG index.
Following 15 minute .iqmsg segment shows typical observations.

• Normal activity
• Several new connections in initial stages of connection hadnshake
• Huge timestamp gaps
• Cancellation requests which are not originated by end-user.

-------
I. XX/XX 14:34:34. 0000000392 [20896]: Insert for 'XX' completed in 5 seconds. 410 rows inserted. <---- Normal activity
I. XX/XX 14:35:00. 0000000674 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:35:00. 0000000675 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:35:03. 0000000678 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:36:00. 0000000707 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:36:49. 0000000732 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:37:04. 0000000740 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:37:15. 0000000748 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:38:42. 0000000792 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:39:39. 0000000823 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:40:00. 0000000834 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned <---- Several connection in initial stages of handshake
I. XX/XX 14:40:00. 0000000835 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:40:18. 0000000845 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:41:49. 0000000891 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:42:04. 0000000899 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:42:15. 0000000906 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:46:49. 0000001042 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned <--- Huge timestamp gap
I. XX/XX 14:47:04. 0000001051 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:47:15. 0000001057 Collation 1251CYR, Case Respect, Blank Padding On, Comparisons are Conditioned
I. XX/XX 14:48:15. 0000000000 Cancellation request received: SA connHandle: 23 SA connID: 30 IQ connID: 0000000028 User: XXX  <-------- Cancellation requests
I. XX/XX 14:48:15. 0000000028 Exception Thrown from slib/s_garray.cxx:6839, Err# 0, tid 2512 origtid 2512
I. XX/XX 14:48:15. 0000000028 O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
-------

IQ 16.1 SP03 PL07
IQ 16.1 SP04 PL06

s_bufpartition::GetCleanPage , _global_lock_common , freeze , sweeper , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed