X2Go Bug report logs - #708
x2gosqlitewrapper.pl reports "unable to open database" on session-resume, while the database is there.

Full log

Message #5 received at submit@bugs.x2go.org (full text, mbox, reply):

Received: (at submit) by bugs.x2go.org; 19 Dec 2014 10:19:19 +0000
From Daniel.Zuck@six-group.com  Fri Dec 19 11:19:17 2014
X-Spam-Checker-Version: SpamAssassin 3.3.2 (2011-06-06) on
	ymir.das-netzwerkteam.de
X-Spam-Level: 
X-Spam-Status: No, score=-4.2 required=5.0 tests=BAYES_50,RCVD_IN_DNSWL_HI,
	URIBL_BLOCKED autolearn=ham version=3.3.2
X-Greylist: delayed 300 seconds by postgrey-1.34 at ymir.das-netzwerkteam.de; Fri, 19 Dec 2014 11:19:17 CET
Received: from mail1.telekurs.com (mail1.telekurs.com [153.46.252.105])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id A2EC85DB26
	for <submit@bugs.x2go.org>; Fri, 19 Dec 2014 11:19:17 +0100 (CET)
Received: from mpzhwcasht01.base.dom (Not Verified[10.22.17.152]) by mail1.telekurs.com (using TLS: SSLv23)
	id <B5493fa780000>; Fri, 19 Dec 2014 11:14:16 +0100
Received: from MPZHWMBX15.base.dom ([fe80::656e:e4bd:cdcf:2423]) by
 mpzhwcasht01.base.dom ([::1]) with mapi id 14.03.0195.001; Fri, 19 Dec 2014
 11:14:14 +0100
From: "Zuck, Daniel" <Daniel.Zuck@six-group.com>
To: "submit@bugs.x2go.org" <submit@bugs.x2go.org>
CC: Guggenbühl, Oliver
	<Oliver.Guggenbuehl@six-group.com>, "Talvacchia, Claudio"
	<Claudio.Talvacchia@six-group.com>
Subject: x2gosqlitewrapper.pl reports "unable to open database" on
 session-resume, while the database is there.
Thread-Topic: x2gosqlitewrapper.pl reports "unable to open database" on
 session-resume, while the database is there.
Thread-Index: AdAbcna5yjlC/yhRRmuJQBlLoPDh5g==
Date: Fri, 19 Dec 2014 10:14:13 +0000
Message-ID: <B62526E3DA9E30409AE8B69A0AC2F588A32332AE@mpzhwmbx15.base.dom>
Accept-Language: de-CH, en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
x-originating-ip: [10.22.12.42]
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Package: x2goserver
Version: 4.0.1.15

Hello

The environment ist:
x2goagent: 3.5.0.27
x2goserver: 4.0.1.15
x2goserver-compat: 4.0.1.15
x2goserver-extensions: 4.0.1.15
x2goserver-fmbindings: 4.0.1.15
x2goserver-printing: 4.0.1.15
x2goserver-pyhoca: 4.0.1.15
x2goserver-xsession: 4.0.1.15
running on SLES11SP3. We have several servers running X2go, where at two systems a session resume raises an error since the same day:

DBD::SQLite::st execute failed: unable to open database file at /usr/lib/x2go/x2gosqlitewrapper.pl line 320.
syslog: invalid level/facility: error at /usr/lib/x2go/x2gosqlitewrapper.pl line 323

The message is shown by the X2Go-Client on a reconnect, right before the "session-status-info-window" becomes visible. Now at the GUI "Suspend Session" (in German: Anhalten) is selected, after this a reconnect to the session to resume. On clicking "Suspend Session", the error message is shown again. Then the session is selected and "klicked", which results in a "normal" resume of the session, and the remote GUI becomes visible.

The Syslog however has entries which read like the session is suspended/resumed correctly without any issues:

Dec 19 10:15:35 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session with ID XYZAB-76-1417681012_stDGNOME_dp32 has been suspended successfully
Dec 19 10:16:30 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session with ID XYZAB-76-1417681012_stDGNOME_dp32 has been suspended successfully
Dec 19 10:16:39 mxxxxxxxxx02 /usr/bin/x2goresume-session: client 10.43.142.67 has successfully resumed session with ID XYZAB-76-1417681012_stDGNOME_dp32
Dec 19 10:16:49 mxxxxxxxxx02 /usr/bin/x2gosetkeyboard: Setting X keyboard according to /home/XYZAB/.x2go/C-XYZAB-76-1417681012_stDGNOME_dp32/keyboard

Investigating further: When calling "x2golistsessions_root", the script lists a number of states, including the error-message above. So it appears to me, there is a consistency issue with the SQLite-DB. I strongly assume, it can be worked-around by recreating the DB, but I would like to sort out the reason, why it came to this status.

My questions:
Is this issue known? - I did not find anything like this at the bugtracker.
What information is needed for further investigations? - The system is still in this state, so we can pull further infos.

Regards

Daniel Zuck

SIX
DGI-OIE
Hardturmstrasse 201
Postfach
8021 Zürich

T +41 58 399 23 56 

http://www.six-group.com
mailto:Daniel.Zuck@six-group.com

The content of this e-mail is intended only for the confidential use of the person addressed. 
If you are not the intended recipient, please notify the sender and delete this email immediately.
Thank you.

Send a report that this bug log contains spam.