From nobody Tue Mar 07 17:01:38 2023 X-Original-To: ports-bugs@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4PWMDM20jtz3wNRg for ; Tue, 7 Mar 2023 17:01:39 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4PWMDM0kbQz4Lmx for ; Tue, 7 Mar 2023 17:01:39 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1678208499; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=MM9/mlMTUGFAZynwKKOnHHhgAvltUZTX4WBzYBCpMYE=; b=SUMPlZXgxfk1vRyPiPsiWBmyNcKIeJVIw4FWNO9fOOeFgS3HrJzyF4gcm6fmbtwIdNt18/ F5VmCWGUjpZHFQL94QTm/Xh2XA1v46DIZuwTsn78dPcBLOAsjNAtzslVcPIkYLrE41PuaF yz5w7hOW1ReazBoTZXGp1dGlucVHdvCV3Qz6aKM2iwcFzAM+uDczUPnW8qEixFrBc40dqw QFElTlMMZe2UxYcWIP0WbRnPQS5/qQypOYzla4+A7RSQv6sI7JGBe3J8kAFV9KAnnuk43b TvAuHGoTHgeATijCGcVljhROQpEpXL9N9eQJCZX4saauKPxHjL+bOlIpnKmz+g== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1678208499; a=rsa-sha256; cv=none; b=QMjVx6yuTxz3UTAf31Pl3dlsGKnbPFk+jiZHcLy48slx1HQbbbM/QWsvQKnVm6l6Ue3yZR cjpAlFnusY0613kzTO1yw4PXaOPrMcbqXnk9cNZNGiHnB3fhi1HNBuo9ZhKH1NYU4j9Vip /KvJ3+viLobZ7P2+pRu25TZQ1dQi1AhXktAoslyy5duR6vfVcbLmQPuszzZ3CnMbVTOP6t do4VVlIeGZxmHzHXdw4CiITUqaIk6suoTTUQb6yvpzprUNKlh0St8/dQ4hgOk2zZ1P8uNH lzECSuH886GJXLFLmce0j6XJGIx5rbHj5ZF6DiksBLc/J3uA5V5jImPo3HiYZw== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4PWMDL6vG8zrxM for ; Tue, 7 Mar 2023 17:01:38 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 327H1cN8041328 for ; Tue, 7 Mar 2023 17:01:38 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 327H1cHT041327 for ports-bugs@FreeBSD.org; Tue, 7 Mar 2023 17:01:38 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 269966] net/vnstat: no longer works after databases/sqlite3 disabled DQS Date: Tue, 07 Mar 2023 17:01:38 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: freebsd@kumba.dev X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D269966 --- Comment #5 from Joshua Kinard --- (In reply to ~Luna from comment #4) > Hi. After a pkg update I have the same issues with vnstat. Do I understand > correctly that it would be best if vnstat would change this in their code? >=20 > For now though I need vnstat to work so did you find out how to downgrade > sqlite3 with pkg (instead of ports)? I kinda found a way to downgrade sqlite3 via pkg. There's a site (which I don't have the URL on hand atm) that gave the mirror link to the older 3.40= .1 copy. Ideally, you would install that, then lock it from being upgraded. But the fix I finally went with was to build sqlite3 from ports via 'make package', making sure to enable DQS, then, and this is the critical part, I used 'pkg add' instead of 'pkg install' to install the locally-built port, which dodges around the possible bug in pkg's solver component that gets confused. Then I locked both vnstat and sqlite3 so that pkg won't try to automatically upgrade them. It requires some manual work to watch for updates in ports and rebuild as appropriate, but I have such a small number of locally-built ports for my FreeBSD systems and jails, that it's fairly manageable. I looked through some of vnstat's code and I don't really see where they're relying on the DQS feature. Most of their core database code is in src/dbsql.c, and I am wondering if it's an issue of whether the database was initialized while DQS was enabled. I have a Gentoo Linux machine that also runs vnstat, but the ebuild there does not (and hasn't ever, I think) enabl= ed DQS, so my vnstat database there had no issues when sqlite was updated to 3= .41. Thus it may be a matter of re-initializing the vnstat.db database with DQS disabled to get a proper fix. Then one would have to dump the old DB and import it into the new DB. Totally untested, but it's a thought I had. --=20 You are receiving this mail because: You are the assignee for the bug.=