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

• 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 

SAP IQ 16.1 SP05 PL12

CR830340, CR#830340, 830340, sybase , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed