[X2go-dev] phantom sessions

[Gerry Reno]

On 10/25/2010 06:33 PM, Gerry Reno wrote:
> On 10/25/2010 06:19 PM, Gerry Reno wrote:
>>
>> Ok, I'm still finding many problems with phantom sessions when we 
>> hammer the server with lots of sessions.
>>
>> I've got many users with 2 sessions showing even though they only 
>> started 1 session.
>>
>> I've got sessions in the database but no corresponding session 
>> processes.
> This console message might explain how this one happens:
> delete from  sessions     where 
> session_id='userQ6EN-65-1288043069_stDGNOME_dp24';
> SQL error: delete on table "sessions" violates foreign key on table 
> "mounts"
>
> Sounds like something gets out of sync.
Actually this is coming from x2golistsessions_sql

# sudo  /usr/bin/x2golistsessions_sql myhost
18865|ubuntu-50-1288040327_stDGNOME_dp24|50|myhost|R|25.10.10 
20:58:47|aa5a19e48f063585397df2b7fb4398f9|XXX.XXX.XXX.XXX|30001|30002|25.10.10 
20:58:47|ubuntu|10444|30003
delete from  sessions     where 
session_id='userQ6EN-65-1288043069_stDGNOME_dp24';
SQL error: delete on table "sessions" violates foreign key on table "mounts"
12483|userQ6EN-65-1288043069_stDGNOME_dp24|65|myhost|F|25.10.10 
21:44:29|fc9b1981ce9c8ede372c7095960ed977|XXX.XXX.XXX.XXX|30045|30046|25.10.10 
22:14:01|userQ6EN|7702|30047

>
>
>>
>> I've got session processes with no corresponding session in the 
>> database.
>>
>> I've got session listing script output showing  'tail <some file> no 
>> such file'
>>
>> Ugh!!
>>
>> Has anyone seen these problems?  Any solutions?
>>
>>
>> Regards,
>> Gerry
>>
>> _______________________________________________
>> X2go-dev mailing list
>> X2go-dev at lists.berlios.de
>> https://lists.berlios.de/mailman/listinfo/x2go-dev
>>
>
> _______________________________________________
> X2go-dev mailing list
> X2go-dev at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/x2go-dev
>