SAP Knowledge Base Article - Preview

3058565 - Server is in intermittently unresponsive or slowness status -- SAP IQ

Symptom

IQ server appeared a slowness rather than complete hang or unresponsive. Seeing stacks, some threads were changed between 1st and 3rd stack dumps and some threads were looked to be stuck. However nothing accepted new connection was.  Following thread looks to be stucked in dumps.

* Stack =>>

   Threads (1): 3983 
      ..  pthread_cond_wait@@GLIBC_2.3.2
      ..  hos_condvar::Wait() const
      ..  hos_SweeperLock::Lock(unsigned int)
      ..  hos_SweeperLock_lock::Lock(unsigned int)
      ..  s_iqstore::AdjustFreeList(s_bm const*, s_bm const*)

*.iqmsg =>>

...
I. 05/11 20:33:26. 0001341070 Rbck
I. 05/11 20:33:27. 0001341073 Rbck
I. 05/11 20:33:30. 0001341089 Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
I. 05/11 20:34:00. 0001341107 Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
...
I. 05/11 20:39:39. 0000000000 Cancellation request received: SA connHandle: 6648 SA connID: 57 IQ connID: 0001340032 User: ...sa
I. 05/11 20:39:59. 0001341291 Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
I. 05/11 20:40:49. 0000000000 Cancellation request received: SA connHandle: 6647 SA connID: 35 IQ connID: 0001339812 User: ...sa
...
I. 05/11 20:43:07. 0001341388 Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
I. 05/11 20:43:39. 0001341407 Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
I. 05/11 20:43:59. 0000000000 Cancellation request received:
I. 05/11 20:45:09. 0000000000 Cancellation request received:
I. 05/11 21:13:52. 0001342307 Cancellation request received:
I. 05/11 21:16:20. 0000000000 IQ OpenDatabase, checkpointblock: 3274658, recover: 1


Read more...

Environment

SAP IQ16.1 SP04(+)

Product

SAP IQ 16.1

Keywords

GetCleanPage , hos_SweeperLock , SweeperLock , Lock, CR822283, CR824813, , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.