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 stuck 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
Keywords
GetCleanPage , hos_SweeperLock , SweeperLock , Lock, CR822283, CR824813, , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.