#1124 c2s sessions are referenced in two not entirely overlapping tables
The shared /*/c2s/sessions table contains all connected sessions, including unauthed ones.
The prosody.full_sessions table has all resource-bound session, including (if mod_smacks is used) hibernating ones.
Having two separate sets of sessions makes it difficult when you idealy want to have the union of both, eg in mod_admin_telnet, the c2s:show() command currently uses the shared table, resulting in hibernating sessions not being shown.
Also, BOSH sessions are in yet another shared table or two.
Just thinking about this, I'm not sure if the situation is so bad.
One is a list of established sessions (which may or may not have connections), one is a list of connections (which may or may not have sessions).
BOSH sessions are in full_sessions.