[horde] Large numbers of open sessions

[Michael J Rubinsky]

Quoting Michael M Slusarz <slusarz at horde.org>:

> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>> Quoting Simon Wilson <simon at simonandkate.net>:
>>
>>> Hi list...
>>>
>>> I upgraded my Horde install last night, after a couple of months  
>>> since the last upgrade. As a matter or course now I check  
>>> Sessions, and there were 3025 open sessions. Given there are  
>>> typically only 3 or 4 users, I was a bit surprised at the number.
>>>
>>> The sessions are all (bar a couple) from iOS devices, of which  
>>> there are 5 currently registered to ActiveSync.
>>>
>>> In the 12 hours since the upgrade, 4 of those iOS devices (iOS4  
>>> and iOS5) have added 224 new open sessions.
>>
>>> It would appear that for some reason iOS and Horde ActiveSync are  
>>> not closing and terminating sessions between them. Is there a  
>>> known issue with this,
>>
>> I'm not seeing this on my production machine - which is currently  
>> linked to 1 iPhone 4S, 1 iPad, 2 iPod Touches, and 3 android  
>> devices of varying versions.
>
> FWIW, I am still seeing this myself.  Running ActiveSync on a  
> good-old Original Droid.  My IMAP logs look like this:
>
>>> Timestamp: Wed, 25 Jan 2012 10:16:42 -0700
> S: * OK [CAPABILITY IMAP4rev1 LITERAL+ LOGIN-REFERRALS ID ENABLE  
> AUTH=LOGIN XIMAPPROXY] Dovecot ready.
> C: [LOGIN Command - username: slusarz]
> S: * OK [XPROXYREUSE] IMAP connection reused by squirrelmail-imap_proxy
> S: 1 OK User logged in
> C: 2 CAPABILITY
> S: * CAPABILITY IMAP4rev1 LITERAL+ SASL-IR LOGIN-REFERRALS ID ENABLE  
> IDLE SORT SORT=DISPLAY THREAD=REFERENCES THREAD=REFS MULTIAPPEND  
> UNSELECT CHILDREN NAMESPACE UIDPLUS LIST-EXTENDED I18NLEVEL=1  
> CONDSTORE QRESYNC ESEARCH ESORT SEARCHRES WITHIN CONTEXT=SEARCH  
> LIST-STATUS ACL RIGHTS=texk
> S: 2 OK Capability completed.
> C: 3 ENABLE QRESYNC
> S: * ENABLED QRESYNC
> S: 3 OK Enabled.
> C: 4 NAMESPACE
> S: * NAMESPACE (("" ".")) (("#shared." ".")) (("#public2." "."))
> S: 4 OK Namespace completed.
> C: 5 LOGOUT
> S: * BYE LOGOUT received
> S: 5 OK Completed
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:43 -0700
> [same IMAP traffic as above]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:44 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:44 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:45 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:45 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:46 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:46 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:47 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:47 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:47 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:48 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:48 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:49 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:49 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:50 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:50 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:51 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:51 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:52 -0700
> [same]
> ------------------------------
>>> Timestamp: Wed, 25 Jan 2012 10:16:52 -0700
> [same]
>
> ...and so on.
>
> And:
>
> slusarz at bigworm % sudo ./horde-active-sessions
> 1696
> But IIRC, this is the whole point of Bug #9733.  So maybe I should  
> just shut up and wait patiently for Horde 4.1.

I'm still not clear why some are seeing this and some are not. I am  
using IMP auth as well, and don't see anywhere near that frequency of  
requests. ./horde-active-sessions on my production machine has  
fluctuated between 0, 1, 2 for the last hour. I have at least one  
device actively syncing right now.

Bug #9733 will only address the issue of Horde requiring $_SESSION to  
be available as storage for Horde_Session data for certain  
inter-application calls to be made. Adding some per-request storage  
ability to Horde_Session will allow us to disable sessions for  
ActiveSync (and any other RPC request that doesn't require sessions).  
The IMAP server will still need to be polled though - unless I am  
totally misunderstanding why it is being polled so frequently. In  
fact, with Email support being added, this will only cause the server  
to be hit more frequently.
-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org