X2Go Bug report logs - #1535
users randomly (but repeatedly) get a "libx2go-server-db-sqlite3-wrapper insertsession" error at connection attempts

Package: x2goserver; Maintainer for x2goserver is X2Go Developers <x2go-dev@lists.x2go.org>; Source for x2goserver is src:x2goserver.

Reported by: Enrico Bertocchi <busomaka@gmail.com>

Date: Sat, 27 Mar 2021 16:15:02 UTC

Severity: normal

Full log

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

Received: (at submit) by bugs.x2go.org; 27 Mar 2021 16:12:38 +0000
From busomaka@gmail.com  Sat Mar 27 17:12:34 2021
X-Spam-Checker-Version: SpamAssassin 3.4.2 (2018-09-13) on
	ymir.das-netzwerkteam.de
X-Spam-Level: **
X-Spam-Status: No, score=2.7 required=3.0 tests=BAYES_50,DEAR_SOMETHING,
	DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,FREEMAIL_FROM,SPF_HELO_NONE,
	URIBL_BLOCKED autolearn=no autolearn_force=no version=3.4.2
Received: from mail-lf1-x12c.google.com (mail-lf1-x12c.google.com [IPv6:2a00:1450:4864:20::12c])
	by ymir.das-netzwerkteam.de (Postfix) with ESMTPS id 641BC5DD7B
	for <submit@bugs.x2go.org>; Sat, 27 Mar 2021 17:12:34 +0100 (CET)
Received: by mail-lf1-x12c.google.com with SMTP id g8so12183734lfv.12
        for <submit@bugs.x2go.org>; Sat, 27 Mar 2021 09:12:34 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=20161025;
        h=mime-version:from:date:message-id:subject:to;
        bh=Bsp8eQWpCCjl5RZ36JaIXm06SAfbwVCEGknt+A9F2OU=;
        b=DCniFcpg9ed2vE7Kf88ra70rPER7UduL6hLyDAgmR4pqg/UzjnUKRX4Y/gZPs4gfg6
         VTNCs1+YNUVTRNBCY/MLQ+NWksOg4Eb5zdK31HmeIrJP56CyUf875znvUxA1gFwrbI27
         aB2DI2g6uW8hx+Vvts9jr37cJoTWm0MmqFMaMHK5nLZFDkV0O4BFI2XYf4wR1KB/h+Pi
         KjSov2l8sKMQtElkiwcmAnZgRUGAwLHklSbcuXdi+yHXMdRYBZ4OkqFC9hNhrsOAV1eY
         psCswyOv4oTd/3KAHQnki7xUJVaaC3ITQcMiqwbwT38ebfwLGYweoCh8DG7fooEnP5JQ
         DV/A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:from:date:message-id:subject:to;
        bh=Bsp8eQWpCCjl5RZ36JaIXm06SAfbwVCEGknt+A9F2OU=;
        b=Y99z1IS5GHPnL3A9Y8tBYSEELRQBZiD3z5cy//AX1WWmkTr9dX6VvL/Kxq0e2cO1NW
         147DIehIgy1G7Y91fRh1JN1s+CzHNm7t5c8BLvgtGXFMe2rhzWWzg8qkOXVrXcDQAc4V
         BB0ci2T/Nj5acuKHyDsbQsBLR3h6ubkb53wCOdkGhUdM6udaoCfak0vIG6k3CGxnPgVD
         w0kgezRxkwnSN1OpkVaq/wdB6y9236ZWx4p8RD6215ihSaG6IOG7BGcI3EdNWIxkG40U
         fLJlZqEFEOpTroCb5K88a4QKKzsgkf4h06TAaLNa6//wn6OJTgdNpZfsRZu24zKT6O0J
         ii9Q==
X-Gm-Message-State: AOAM530AbJIAii2eGx7aGyEqykpJ5zuS7quxli9FgXikmVkO+PAR/zEC
	4nof/a2wZBoDUA9ZHBAU7fF7biyyogPymAx1PhmFBzUGrqE=
X-Google-Smtp-Source: ABdhPJxZ+VrLQclk5FKSazkE0QY8TDHEF4NHYMxkPDqb8tHTOe58yyVo0smw4k2FL/n4xxtffJk2H9rtzTJpv9apWtk=
X-Received: by 2002:ac2:4e6f:: with SMTP id y15mr11648781lfs.428.1616861553520;
 Sat, 27 Mar 2021 09:12:33 -0700 (PDT)
MIME-Version: 1.0
From: Enrico Bertocchi <busomaka@gmail.com>
Date: Sat, 27 Mar 2021 17:12:22 +0100
Message-ID: <CAHqu7y1acxsUO1P2gsdCWqEO6VUkvubYNPr6Mx44ve4QFb7VEQ@mail.gmail.com>
Subject: users randomly (but repeatedly) get a "libx2go-server-db-sqlite3-wrapper
 insertsession" error at connection attempts
To: submit@bugs.x2go.org
Content-Type: text/plain; charset="UTF-8"

Package: x2goserver
Version: Devuan Beowulf package x2goserver/stable,now 4.1.0.3-4

Dear sirs,
I'm currently employing x2go (Devuan Beowulf package
x2goserver/stable,now 4.1.0.3-4) to operate a terminal server for
computer lab lessons.

It randomly happens that some of the students experience sequences of
failed connection attempts (usually 5-10 in a row) with the following
kind of error (typed from a typical screenshot)

[...]
n283287-55-1616084795_stDmwm_dp32 at
/usr/share/perl5/X2Go/Server/DB.pm line 251. :
/usr/lib/x2go/libx2go-server-db-sqlite3-wrapper insertsession 55
x2go-cdm [...] n283287-55-1616084798_stDmwm_dp32 at
/usr/share/perl5/X2Go/Server/DB.pm line 251. :
/usr/lib/x2go/libx2go-server-db-sqlite3-wrapper insertsession 55
x2go-cdm n283287-55-1616084799_stDmwm_dp32 at
/usr/share/perl5/X2Go/Server/DB.pm line 251. Unable to find free
display port or insert new sessions into database; parameters:
port(55), hostname (x2go-cdm) and session name
(n283287-55-1616084799_stDmwm_dp32).

A further, subsequent connection attempt randomly succeeds instead.
At the same time, other students experience regular login procedures.

The student passwd data is taken from a "sssd-ldap" domain, fact this
that might cause some of the quirks.

Please indicate me which further data on the server side might be
relevant for investigating the problem.

Thanks.

--
Enrico Bertocchi

Send a report that this bug log contains spam.

X2Go Developers <owner@bugs.x2go.org>. Last modified: Wed Apr 24 03:01:30 2024; Machine Name: ymir.das-netzwerkteam.de

X2Go Bug tracking system

Debbugs is free software and licensed under the terms of the GNU Public License version 2. The current version can be obtained from https://bugs.debian.org/debbugs-source/.

Copyright © 1999 Darren O. Benham, 1997,2003 nCipher Corporation Ltd, 1994-97 Ian Jackson, 2005-2017 Don Armstrong, and many other contributors.