SAP Knowledge Base Article - Preview

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

Symptom

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
-------


Read more...

Environment

IQ 16.1 SP03 PL07
IQ 16.1 SP04 PL06

Product

SAP IQ 16.0 ; SAP IQ 16.1

Keywords

s_bufpartition::GetCleanPage , _global_lock_common , freeze , sweeper , KBA , BC-SYB-IQ , Sybase IQ , 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.