From unknown Sat Apr 04 21:18:58 2026 MIME-Version: 1.0 X-Mailer: MIME-tools 5.502 (Entity 5.502) X-Loop: owner@bugs.x2go.org From: owner@bugs.x2go.org (X2Go Bug Tracking System) Subject: Bug#708 closed by Stefan Baur (Re: x2gosqlitewrapper.pl reports "unable to open database" on session-resume, while the database is there.) Message-ID: References: <54AEB94E.9050500@baur-itcs.de> X-X2go-PR-Message: they-closed 708 X-X2go-PR-Package: x2goserver X-X2go-PR-Source: x2goserver Date: Thu, 08 Jan 2015 17:15:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1420737302-10016-0" This is a multi-part message in MIME format... ------------=_1420737302-10016-0 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 This is an automatic notification regarding your Bug report which was filed against the x2goserver package: #708: x2gosqlitewrapper.pl reports "unable to open database" on session-res= ume, while the database is there. It has been closed by Stefan Baur . Their explanation is attached below along with your original report. If this explanation is unsatisfactory and you have not received a better one in a separate message then please contact Stefan Baur by replying to this email. --=20 708: http://bugs.x2go.org/cgi-bin/bugreport.cgi?bug=3D708 X2Go Bug Tracking System Contact owner@bugs.x2go.org with problems ------------=_1420737302-10016-0 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 708) by bugs.x2go.org; 8 Jan 2015 17:11:28 +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=-0.5 required=5.0 tests=BAYES_05,URIBL_BLOCKED autolearn=ham version=3.3.2 X-Greylist: delayed 302 seconds by postgrey-1.34 at ymir.das-netzwerkteam.de; Thu, 08 Jan 2015 18:11:27 CET Received: from mout.kundenserver.de (mout.kundenserver.de [212.227.17.13]) by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 3AA6D5DB80 for <708@bugs.x2go.org>; Thu, 8 Jan 2015 18:11:27 +0100 (CET) Received: from [192.168.0.3] ([78.43.170.197]) by mrelayeu.kundenserver.de (mreue104) with ESMTPSA (Nemesis) id 0MXXss-1YKq5J1HHS-00WZBO; Thu, 08 Jan 2015 18:06:23 +0100 Message-ID: <54AEB94E.9050500@baur-itcs.de> Date: Thu, 08 Jan 2015 18:07:26 +0100 From: Stefan Baur User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: "Zuck, Daniel" , "708@bugs.x2go.org" <708@bugs.x2go.org> Subject: Re: x2gosqlitewrapper.pl reports "unable to open database" on session-resume, while the database is there. References: <54AEB3B4.7020109@baur-itcs.de> In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Provags-ID: V03:K0:RQH0xuoKzpNBwPHbRgSToBtJIIDRWBXsm5sqxDqt72jcCNIyjJZ iN0U+IRznzvVibIXZQB842oJU2L5k3rBOhci1I6bDnhycj/BtAwgS7NpjspP1k28ViJU3Tg DwB3jfgKci9h9X/QyU+kIsG3LoCzRz9CL4yDBTpaMSB9GCI4aUbFO8s6aB7hluIgS8PPNYF /28HrlCQAiJlItUypqypw== X-UI-Out-Filterresults: notjunk:1; -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Control: close -1 thanks Am 08.01.2015 um 18:00 schrieb Zuck, Daniel: > I understand it is hard to debug, and there is nothing more to do > at this point in time; so I am absolutely OK to close the bug. Thank you. :) > However, if it reappears in the future, we have some sort of > "knowledge base" to refer to - so the bug may be useful for this > type of purpose. Totally okay, that's why our bug tracker is public. > Related any "success stories", I am bound to pipe this thru our > "corporate communications", and it may be helpful to sort out the > level of "evangelism" internally before. I am personally open to do > so, and you may PING me from time to time in order to keep each > other posted - in case I forget. If you want to, you can pass my contact details (see footer) on to your corporate communications department, or send me their contact details off-list. I'll make a note in my calendar for January 29, 2015, and ping you again then, if I don't hear from you or your corporate communications department sooner. Okay? :-) - -Stefan - -- BAUR-ITCS UG (haftungsbeschränkt) Geschäftsführer: Stefan Baur Eichenäckerweg 10, 89081 Ulm | Registergericht Ulm, HRB 724364 Fon/Fax 0731 40 34 66-36/-35 | USt-IdNr.: DE268653243 -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.22 (MingW32) iQEcBAEBAgAGBQJUrrlOAAoJEG7d9BjNvlEZKc8H/jkthwmf/wdXdv8Qo+G26LdI UmaRvNyUBJX0HXRW4vINuFIuWHSkXKsWBKrrL63FzXtJID7cVP08OCZ+QKLFc9q5 u3sF5eKRRjbXPnlglDffwsvaOFHMRwnRNJ6AS9q+e17yad1KVOQnn++NbWVdcjf8 EGfXSRBh5JPwIVUESXoKMIPsDdCojs12a6R1zCrhYN81JvCtOetRs4FpC3EZPyLv V2GEUfRGnh2w+P75QOb2aTy9l/Fl/ok9FpHnkLRsZCxSYxYFF17yABULOHmNHkLt ntC+rNPUy8WDgE20U+OTZTJXsDNXIWSwzNWuL34v8N9i3eU3S+ip0KquOSabP/E= =jrwy -----END PGP SIGNATURE----- ------------=_1420737302-10016-0 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit 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. ------------=_1420737302-10016-0--