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
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.