|
Problem IT44264
|
Status: Closed |
LONG LASTING PUSH DATA SESSIONS CAN ACCUMULATE LARGE AMOUNTS OF MEMORY EVEN IF CONFIGURED TO DISCARD MOST RECORDS
|
| product: |
INFORMIX SERVER / 5725A3900 / E10 - |
| Problem description: |
Any Smart Trigger (aka. Push Data (PD)) session would get a
specific PD transaction structure allocated to it for every
transaction reaching the Enterprise Replication (ER) grouper,
just in case the grouper would determine the transaction has
content for it. The
se structures, including a "PTMutex" mutex associated with each
of them, would only be freeded once the PD session's client
receivi
ng the data has moved beyond their respective COMMIT log
position, or if the PD session gets deleted.
As a consequence, a long lasting PD session, typically
'detachable', unattended (without SQL client session) and
possibly forgotten, could be the cause for lots and lots of
"PTMutex" mutexes and a larger than expected pushdata memory
pool. This would even happen if no real traffic occurred for the
tables replicated by such session, or if the session was
configured with max_pending_ops, so discarding any traffic
coming its way beyond this value. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Local Fix: |
Identify such session using 'onstat -g pd' or syscdr:pushdata_*
tables/views and purge it. |
| Solution |
|
| Workaround |
****************************************************************
* USERS AFFECTED: *
* Users of Informix Server prior to 14.10.xC11. *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Informix Server 14.10.xC11. *
**************************************************************** |
| Comment |
Fixed in Informix Server 14.10.xC11. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.07.2023
03.06.2024
03.06.2024 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
