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.