From Daniel.Zuck@six-group.com Fri Dec 19 11:19:17 2014 Received: (at submit) by bugs.x2go.org; 19 Dec 2014 10:19:19 +0000 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 ; 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 ; 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" To: "submit@bugs.x2go.org" CC: =?iso-8859-1?Q?Guggenb=FChl=2C_Oliver?= , "Talvacchia, Claudio" 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: 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 Ses= sion" (in German: Anhalten) is selected, after this a reconnect to the se= ssion to resume. On clicking "Suspend Session", the error message is show= n 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/r= esumed correctly without any issues: Dec 19 10:15:35 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session with I= D XYZAB-76-1417681012_stDGNOME_dp32 has been suspended successfully Dec 19 10:16:30 mxxxxxxxxx02 /usr/bin/x2gosuspend-session: session with I= D XYZAB-76-1417681012_stDGNOME_dp32 has been suspended successfully Dec 19 10:16:39 mxxxxxxxxx02 /usr/bin/x2goresume-session: client 10.43.14= 2.67 has successfully resumed session with ID XYZAB-76-1417681012_stDGNOM= E_dp32 Dec 19 10:16:49 mxxxxxxxxx02 /usr/bin/x2gosetkeyboard: Setting X keyboard= =20according to /home/XYZAB/.x2go/C-XYZAB-76-1417681012_stDGNOME_dp32/key= board Investigating further: When calling "x2golistsessions_root", the script l= ists a number of states, including the error-message above. So it appears= =20to me, there is a consistency issue with the SQLite-DB. I strongly ass= ume, it can be worked-around by recreating the DB, but I would like to so= rt out the reason, why it came to this status. My questions: Is this issue known? - I did not find anything like this at the bugtracke= r. What information is needed for further investigations? - The system is st= ill in this state, so we can pull further infos. Regards Daniel Zuck SIX DGI-OIE Hardturmstrasse 201 Postfach 8021 Z=FCrich T +41 58 399 23 56=20 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 t= he person addressed.=20 If you are not the intended recipient, please notify the sender and delet= e this email immediately. Thank you.