Symptom
There are multiple symptoms of this issue:
- sp_iqconnection() shows a connection name INT:flushstats.
- Server can not be stopped by any recommended procedures like stop_iq or dbstop. Server can only be killed with kill -6 PID or kill -9 PID.
- sp_iqwho fails with an error
> sp_iqwho();
SQL Anywhere Error -157: Cannot convert '' to a timestamp - Server may become slow, sluggish and unresponsive even though pstacks will not show server is in hung state.
- Server may not accept new connections even though only one known connection is present.
- Versions may build up if INT:flushstats connection persists.
- sp_iqcontext() shows a connection present with ConnHandle value larger than 1000000000.
Read more...
Environment
- SAP IQ 16 before SP10
- SAP IQ 15
Product
SAP IQ 16.0 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4
Keywords
sp_iqwho, "SQL Anywhere Error -157", "Cannot convert '' to a timestamp", kill server, stop_iq, FlashStats, INT:FlashStats, very large ConnHandle, ConnHandle value larger than 1000000000, persistent connection, unknown connection. , 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.
SAP Knowledge Base Article - Preview