3445060 - Understanding the "Running" Connection Status with "Inactive" Transaction Status in SAP HANA DB Version 2.0

We've noticed a few instances where connections are labeled as "Running" while their corresponding transaction status is marked as "Inactive". We tried to gather SQL trace on the m_transactions_ and m_connections_ internal tables, but were unable to obtain any recordings.

These connections seem to be fleeting, appearing only for short durations before vanishing. It seems that the m_transactions_ table is updated first, followed by the m_connections_ table.

The SQL query we used for this investigation is as follows:

select * from m_connections c join m_transactions t on c.connection_id=t.connection_id where transaction_status='INACTIVE' and connection_status='RUNNING'

SAP HANA DB Version 2.0

SAP HANA DB Version 2.0, Connection Status, Transaction Status, Running, Inactive, m_connections, m_transactions, SQL Query, Automatic Clean-up Process, M_CONNECTIONS System View , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem