Last Request unknown(0)

[bgreiman]

We are using SQL Anywhere v12.01.3810. Periodically we check our system console and see some blank connections listed as unknown(0). Any idea what these are? We have seen a few times where these don't go away until we have a chance to re-start the database.

Thanks, Brian

[ian_mchardy]

This is likely an internal/temporary (non-client), http or event connection. connection_property( 'name' ) should give a name prefixed with INT: if it is an internal connection. connection_property( 'CommProtocol' ) will indicate if it is a CmdSeq (SQL Anywhere client), TDS (JConnect/Open Client) or HTTP/HTTPS. Note you can provide the connection ID as the second parameter to connection_property to get a property for another connection.