3637804 - Server crashed with stack trace on unknown functions - SAP IQ

• SAP IQ production system crashed, causing delays in report generation.
  
  
• The stack trace shows the server failed with the following functions:
  
  
  • dfv_RowViewContextBase::GetValuePtrs
  • dfv_Row::ComparePresentRowEq
  • df_SysCursor::DoFetch
  • hos_ABORT
  • SigHndlr
    
    
• In the IQMSG log file the following happens:
  
  

  • I. 07/21 23:00:43. 0000000000 [DIO] hos_svbio::OpenFile() on /iqprod/iqstore/dbfile1 succeeded with DIRECT IO.
    I. 07/21 23:00:43. 0000000000 [DIO] hos_svbio::OpenFile() on /iqprod/iqstore/dbfile_5 succeeded with DIRECT IO.
    I. 07/21 23:00:43. 0000000000 [DIO] hos_svbio::OpenFile() on /iqprod/iqstore/dbfile_1 succeeded with DIRECT IO.
    
    

  • I. 07/21 23:02:14. 0000000125 Cancellation request received:  SA connHandle: 1000000023  SA connID: 12  IQ connID: 0000000012  User: iquser
    I. 07/21 23:02:14. 0000000125 Cancellation request received:  SA connHandle: 1000000045  SA connID: 23  IQ connID: 0000000034  User: iquser
    I. 07/21 23:02:14. 0000000125 Cancellation request received:  SA connHandle: 1000000067  SA connID: 34  IQ connID: 0000000056  User: iquser
    I. 07/21 23:02:14. 0000000125 Cancellation request received:  SA connHandle: 45  SA connID: 56  IQ connID: 0000000123  User: iquser
    I. 07/21 23:02:14. 0000000053 Disconnect:  SA connHandle: 22  SA connID: 7  IQ connID: 0000000012  User: iquser2
    I. 07/21 23:02:14. 0000000120 Disconnect:  SA connHandle: 46  SA connID: 60  IQ connID: 0000000124  User: iquser
    I. 07/21 23:02:14. 0000000075 Disconnect:  SA connHandle: 28  SA connID: 41  IQ connID: 0000000076  User: iquser2
    I. 07/21 23:02:14. 0000000024 Disconnect:  SA connHandle: 2  SA connID: 8  IQ connID: 0000000023  User: iquser3
    I. 07/21 23:02:14. 0000000055 Disconnect:  SA connHandle: 23  SA connID: 10  IQ connID: 0000000065  User: iquser2
    I. 07/21 23:02:14. 0000000056 Disconnect:  SA connHandle: 24  SA connID: 11  IQ connID: 0000000057  User: iquser2
    I. 07/21 23:02:14. 0000000044 Disconnect:  SA connHandle: 16  SA connID: 12  IQ connID: 0000000043  User: iquser2
    I. 07/21 23:02:14. 0000000029 Disconnect:  SA connHandle: 6  SA connID: 13  IQ connID: 0000000023  User: iquser2
    I. 07/21 23:02:14. 0000000076 Disconnect:  SA connHandle: 29  SA connID: 42  IQ connID: 0000000071  User: iquser2
    I. 07/21 23:02:14. 0000000119  I. 07/21 23:02:14. Exception Thrown from dflib/dfjo_NestedLoop.cxx:1258, Err# 0, tid 874 origtid 874
    I. 07/21 23:02:14. 0000000119    O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
    I. 07/21 23:02:14. 0000000045 Disconnect:  SA connHandle: 18  SA connID: 16  IQ connID: 0000000054  User: iquser2
    I. 07/21 23:02:14. 0000000119 [2188]: Statement interrupted by user
    I. 07/21 23:02:14. 0000000119  I. 07/21 23:02:14. Exception Thrown from dflib/dfjo_NestedLoop.cxx:1258, Err# 0, tid 872 origtid 874
    I. 07/21 23:02:14. 0000000052 Disconnect:  SA connHandle: 21  SA connID: 6  IQ connID: 0000000035  User: iquser2
    I. 07/21 23:02:14. 0000000119    O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
    I. 07/21 23:02:14. 0000000119 [2188]: Statement interrupted by user
    I. 07/21 23:02:14. 0000000031 Disconnect:  SA connHandle: 7  SA connID: 15  IQ connID: 0000000063  User: iquser2
    I. 07/21 23:02:14. 0000000119  I. 07/21 23:02:14. Exception Thrown from dflib/dfjo_NestedLoop.cxx:1258, Err# 0, tid 878 origtid 874
    I. 07/21 23:02:14. 0000000119    O/S Err#: 0, ErrID: 519 (hos_attnexception); SQLCode: -299, SQLState: '57014', Severity: 16
    I. 07/21 23:02:14. 0000000119 [2188]: Statement interrupted by user
    
    

• Sybase IQ 16.1 SP05 PL07
• Solaris

sap iq, production system crash, solaris, stack trace, iqmsg, unknown. , KBA , BC-SYB-IQ , Sybase IQ , Problem