From nobody Fri Jul 19 11:21:43 2024 X-Original-To: pkg@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 4WQS1N22c7z5RTMx for ; Fri, 19 Jul 2024 11:21:44 +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 "R11" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4WQS1N0ZFNz4XKd for ; Fri, 19 Jul 2024 11:21:44 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1721388104; a=rsa-sha256; cv=none; b=nYdNXgUQQtgrcD8uohGYdPRcIvLBcH059UTNsEm7jFDbxyBJheSSlC+dYvAzl54ywI1GCF 5B/uF6IUpaRoSAskvQS0SMoffT5kAUr/r2xKRTz2VyQ5bHPiTmJGrIJgX9vSwsaI6U0//r E0WXHDK/l7PD/L8kxYOfKSnOI+bXahyBLnbzRTO5qfro0/SlVt4FTQcH9dcB4OMTPYiCt3 eZLJuh7LYiFtoBGMQQTMBQLrMbHUX1svCVkF23ajQqCInfv+BTkOIokP67UJ+HGc77Xa3D qj5K8Gj5Tfz5/QXYoPNTgjqTLguSkNLsLS8zLs3GNOp19T5OgHvHrEHKinJOUA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1721388104; 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=hrwf5OmAaFVC3ps+6TBy3RbES64W1e03zGw1tmPcr4A=; b=R/ABUVdckA7Ys0Z0SfBmFkoFFl0bVAGk51ANaYVZSXu5EKoMXG/Xc5iTcPoKgJhbt2Dl50 73YAS7BDoJx79pCLu/0A1rmnkvPtzopxrnP/30vVrcc96OiZSNcg8bbgerFVbGlUkuIH7w JmefBxSU88OfAZW4z+rTy46JJPNjN2VqRoyeXUewdC27gSalUxdWuyapdZZqKrzZWH/Kvs ZzCixOrIqbXMDv+yF85jplT7PJCVeG71NS1q8wu9ZjSMDj7IEq8d5QpvNDsz4kqQAXX4dP 6CziPhRJV2JmtHiGePZhOPKglLOyrXuXY2mYtToiD1uF5A6E20JxcYhFc8PBjw== 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 4WQS1N078yzV5m for ; Fri, 19 Jul 2024 11:21:44 +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 46JBLhUQ041580 for ; Fri, 19 Jul 2024 11:21:43 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 46JBLhfR041579 for pkg@FreeBSD.org; Fri, 19 Jul 2024 11:21:43 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: pkg@FreeBSD.org Subject: [Bug 276931] ports-mgmt/pkg: writes big journal files Date: Fri, 19 Jul 2024 11:21:43 +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: ronald@FreeBSD.org X-Bugzilla-Status: Closed X-Bugzilla-Resolution: Works As Intended X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? 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: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@FreeBSD.org MIME-Version: 1.0 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D276931 --- Comment #5 from Ronald Klop --- (In reply to Martin Birgmeier from comment #0) I also found that vacuum does not shrink the db file much. But it does remo= ve the journal for me. NB: Your files in /var/db/pkg are from Feb, 9th. That seems relatively old. Just noticed that pkg nowadays stores the files in /var/db/pkg/repos/FreeBS= D. On my machine: # ls -l /var/db/pkg/repos/FreeBSD/ total 60520 -rw-r--r-- 1 root wheel 61919232 Jun 29 21:19 db -rw-r--r-- 1 root wheel 0 Jul 3 09:21 db-journal -rw-r--r-- 1 root wheel 2 Jul 3 09:21 groups.ucl -rw-r--r-- 1 root wheel 0 Jul 19 09:21 lock -rw-r--r-- 1 root wheel 172 Jun 29 21:19 meta vs # ls -l /var/db/pkg/repo*sqli* -rw-r--r-- 1 root wheel 61403136 Apr 26 04:10 /var/db/pkg/repo-FreeBSD.sql= ite -rw-r--r-- 1 root wheel 0 Apr 28 18:21 /var/db/pkg/repo-FreeBSD.sqlite-journal --=20 You are receiving this mail because: You are the assignee for the bug.=