SAP Knowledge Base Article - Preview

3565453 - Secondary Node hanging after Alter table statement -SAP IQ

Symptom

  • IQ secondary node non-responsive after alter table statement.

  • In iqmsg file :
     
    Connection ID xxxx ev_begintxn started

    ....

    ...
     Connection ID xxxx TxnWt xxx 0 xxx <======== Last global transaction

    ..
     Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
     Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
     Collation ISO_BINENG, Case Respect, Blank Padding On, Comparisons are Binary
    -----

  • In zrlog file :

    =,[,1001444852,*batch*,1,set temporary option CREATE_HG_AND_FORCE_PHYSICAL_DELETE = 'ON'
    =,],1001444852,*batch*,1
    =,[,1001444852,*batch*,1,alter table <table_name> add   col double null
    +12,{,1001444852,6020,T,2332,0

  • The stacktrace thread corresponding the Connection ID NNN of ev_begintxn :

    ===== Thread Number **** (IQ connID: NNN ) =====

    pthread_cond_wait
    UnixTask::wait
    CondVar::wait
    Worker::do_wait
    Worker::block
    ZLock::get
    DM_LockTable
    dbi_upgrade_lock_to_exclusive
    dbi_exclusive_table_object(an_object_name
    dbi_exclusive_table_object
    dbi_alter

  • All other threads look like

    pthread_cond_wait
    hos_condvar::Wait()+6d
    st_txnMgr::WaitForTLVReplay
    st_txnMgr::BeginTransaction2 

 


Read more...

Environment

SAP IQ 16.1 SP05 PL12

Product

SAP IQ 16.1

Keywords

CR830340, CR#830340, 830340, sybase , 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.