SAP Knowledge Base Article - Preview

2713668 - Defunct IQ_MPX_SERVER_P* connections result in versioning in SAP IQ

Symptom


Defunct IQ_MPX_SERVER_P* connections result in versioning in SAP IQ

sp_iqconnection output shows:

ConnHandle AppName UserId MainUsedMB TempUsedMB TempWorkMB BlkdBy Threads ConnCreateTime LastIQCmdTime OldestTranTime ClientIP IQCmdType AppInfo

TxnID IQConnID
----------- -------------------- ------ ----------- ----------- ----------- ----------- ------------- ------------------- ------------------- -------------------
17255 IQ_MPX_SERVER_P949 dbo 0 0 0 0 0 Sep 6 2018 1:11AM Sep 6 2018 1:21AM Sep 6 2018 1:21AM XX.XX.XXX.XXX NONE

2093662550 24218


From Coordinator .iqmsg:
I. 09/06 01:11:28. 0000024218 Connect: SA connHandle: 17255 SA connID: 84 IQ connID: 0000024218 User: dbo
I. 09/06 01:11:28. 0000024218 Rbck
...
I. 09/06 01:21:44. 0000024218 TxnG 2093662550 11 2093662537
I. 09/06 01:21:44. 0000000000 Cancellation request received: SA connHandle: 17255 SA connID: 84 IQ connID: 0000024218 User: dbo

Cancellation request was received by Coordinator at 1:21

From secondary node .iqmsg:
I. 09/06 01:21:44. 0000137141 GThrow sqlcode: -1006274 from dblib/db_catalog.cxx:823 Args: "Connection was terminated"
I. 09/06 01:21:44. 0000137141 Exception Thrown from dblib/db_catalog.cxx:823, Err# 5, tid 193 origtid 193
I. 09/06 01:21:44. 0000137141 O/S Err#: 0, ErrID: 12291 (inc_CommandHandlerException); SQLCode: -1004012, SQLState: 'QIA12', Severity: 14
I. 09/06 01:21:44. 0000137141 [21223]: INC communication between coordinator and secondary failed due to : Connection was terminated
-- (dblib/db_catalog.cxx 823)

INC Connection failure occurred between Coordinator and Secondary, the connection was terminated. But it still shows up on Coordinator. the transaction is unable to continue building up versions. In some cases one is able to drop the defunct connection , but in this case we are not able to drop it.

 


Read more...

Environment

SAP IQ 16.0 SP 11 PL 11 Multiplex on Linux x64

Product

SAP IQ 16.0

Keywords

 Sybase ; version ; other versions ; mpx ; writer ; CR816598, CR#816598, 816598 ; 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.