Symptom
- After implementing TLS-related SAP IQ startup parameters, the TCPIP listener threads hang intermittently, preventing new connections.
- The database remains active and accessible via non-TLS connections, but it cannot be stopped using `stop_iq` or `dbstop` utilities, requiring a hard kill.
- Stacktrace for reference below:
-
pc: 0x400e71 backtrace+21
pc: 0x7efae0b211e4 pcstkwalk(stk_trace*, int, db_log*, hos_fd*)+34
pc: 0x7efae0b2190b ucstkgentrace(int, int)+18b
pc: 0x7efae0b226d7 DumpCurrentThread(int)+27
pc: 0x7efdfe93f990 <unknown>
pc: 0x7efdfe93b371 pthread_cond_wait+161
pc: 0x7efdff17a7a0 UnixTask::wait(unsigned short)+b0
pc: 0x7efdff177d46 CondVar::wait(Mutex&)+96
pc: 0x7efdfeedeafa Worker::do_wait(unsigned short)+21a
pc: 0x7efdff5c325c SocketIO::wait()+8c
pc: 0x7efdff5c4c58 SysSocket::send(char const*, unsigned int)+c8
pc: 0x7efdff5f98ad c_strm_sock_pconn::blocking_put(char const*, unsigned long)+d
pc: 0x7efdff61cc6a c_strm_tconn::tls_write(char const*, unsigned long)+1a
pc: 0x7efdff64cfbd SACI_WriteCallback(void*, unsigned char const*, unsigned long)+d
pc: 0x7efde767161b <unknown>
pc: 0x7efde767b8bf <unknown>
pc: 0x7efde7670d80 <unknown>
pc: 0x7efdff64c8aa TlsConnection::write(void const*, unsigned long)+8a
pc: 0x7efdff61deb2 c_strm_tconn::put(c_strm_buffer*, unsigned int)+132
pc: 0x7efdff617fe8 c_strm_sconn::put(c_strm_buffer*, unsigned int, unsigned int)+108
pc: 0x7efdff6183c0 c_strm_sconn::send_out_buff(unsigned int, unsigned int)+c0
pc: 0x7efdff619b3c c_strm_sconn::flush_out_buff(unsigned int, unsigned char, unsigned int)+1cc
pc: 0x7efdff619d0c c_strm_sconn::new_out_buff(unsigned char, a_strm_encrypt_flag)+2c
pc: 0x7efdff61a1e3 c_strm_sconn::send_raw(unsigned short, void**, unsigned char, a_strm_encrypt_flag)+63
pc: 0x7efdff6109fa SQLPresSendRaw+2a
pc: 0x7efdfef8b129 TDSRaw::SendRawBytesEx(void**, unsigned int, unsigned int)+29
pc: 0x7efdfef8b985 TDSRaw::SendMultiPiece(void const* const*, unsigned int)+85
pc: 0x7efdfef885af TDSPres::SendSmallValue(a_tds_desc*, an_sqlpres_value*)+6f
pc: 0x7efdfef7f954 TDSPres::SendAnyValue(a_defined_domain, void*, unsigned int, unsigned int, a_textptr_value*, unsigned int, unsigned int)+44
pc: 0x7efdfef80978 TDSPres::SendValue(a_defined_domain, void*, unsigned int, unsigned int, a_textptr_value*, unsigned int)+18
pc: 0x7efdfee9e693 IDbIStream::copy_to_stream(a_defined_domain, unsigned long, unsigned long, a_textptr_value*, Pres*)+163
pc: 0x7efdff43890e dom_Pres::PresWrite(dfe_Builder*, dfe_Domain const*, dfv_Value const&, a_row_descriptor*, unsigned int, a_textptr_value*, unsigned int*)+49e
pc: 0x7efdff439149 DFPRES_RootSendRow(a_dfo_root*, unsigned int*)+1e9
pc: 0x7efdfefaaa7f dbi_fetch(a_db_cursor*, int, unsigned short, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int, unsigned int)+2bf
pc: 0x7efdff117094 do_cursor_execute(Connection*, a_stmt*)+164
pc: 0x7efdff123069 db__execute_any_imm(Connection*, an_sqlpres_receive*)+2f9
pc: 0x7efdff137396 RequestProcedure::call()+eb6
pc: 0x7efdfeed94b1 Worker::spawn(Procedure*)+31
pc: 0x7efdff13b286 EngStream::handle_ind(unsigned char, unsigned int)+156
pc: 0x7efdff13cdbf EngStream::execute()+7ff
pc: 0x7efdff13cf3d RQConnItem::do_request()+d
pc: 0x7efdff134cde RQBaseItem::do_work(Worker*)+1e
pc: 0x7efdff178a07 RequestQueue::worker_body()+77
pc: 0x7efdff136099 request_task(void*)+89
pc: 0x7efdff5c1b9e run_task_body+1e
pc: 0x7efdff17a668 UnixTask::pre_body(void*)+78
pc: 0x7efdfe9351ca <unknown>
pc: 0x7efdfdc758d3 clone+43
..
Read more...
Environment
Sybase IQ 16.1 SP05.15
Product
Keywords
tcpip listener, tls implementation, intermittent hang, tds connections. , KBA , BC-SYB-IQ , Sybase IQ , Problem
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.
SAP Knowledge Base Article - Preview