Comment 0 for bug 1415898

EG version: 2.7.1 (affects all versions with TPAC)
Rest is irrelevant

When a patrons views their current circulations in the My Account section of the TPAC, a transaction is begun to retrieve the list out of the database and avoid the cache. This transaction opens a connected session to a cstore drone. The connection is never closed causing the cstore drone to remain unusable until the session timeout time arrives (6 seconds by default).

On a busy server, this can lead to a proliferation of cstore drones doing next to nothing. In extreme cases, it can lead to the maximum number of cstore drones being in service and a failure to create more. If this happens during a particularly busy time of the day, when libraries are doing pull lists or other cstore-intensive activities, the load on the server will spike as ejabberd and other services try to respond while cstore drones are mostly ignoring connections. This has lead to the need to restart services on at least one production system.

There is potentially a similar problem in the getit_results function of the EGKPacLoader as well.