From nobody Fri Feb 9 19:41:07 2024 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 4TWkjw0nMsz5BCwl for ; Fri, 9 Feb 2024 19:41:08 +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 4TWkjv52Tbz4p00 for ; Fri, 9 Feb 2024 19:41:07 +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=1707507667; 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; bh=LuoXGNbId0fTVg7ql4MrSaKZOeonZ5bhn8N5tkCYJvc=; b=W2ZrsmM+vuKmJYcRGjcyyHmXJWDq7CI7Fb6/ndFzU16ROaCBaw8eqiheR1ctUCtlbnboyY 0au+/nDdUtYVjm2x117gffza4otOPcThv1yppDql0VNtxl6VP5WTuxNG4GYiRAzDvfGd71 WGvdRN0v7sLC/t9SFCtZNU7ZLiSxVKQ6hUznKCqOBIC1uP3Vt3XVmf2ntXySntg0FbmYiT gdXJ3oQj+hIWC7Tv+eAEamSvecT3ws2K2WnaGNk9dE2E6yQ2yjP5BK35lTLlVkmjd5bFzF 5juR+A8r8jEqnlYS05xyfptOssLuTy+oVoUprfhffIrmoejrVLX02nyWqAFKuQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1707507667; a=rsa-sha256; cv=none; b=DZily0rS8wNN3RKbof4Rz+fTxg5pYhGh2FAVTHO7+8zq6sVkUb1CQzP8BltmZlmH3KOfIq fi5MDw46U79WIQan8DCfGfT/8bBJvFLKUgudDqsgMJrc097GJ9nsM4buFPAk2o/doEnSfF iMc5L061fb8YQmnJx5W37JkeIz98TZLH1nlHDuYChrkYkj6JwWSbCaVOhwE9rjbvdtNRjN kV64jdbj6t83h9OUroueetmUJPwoen5Ol5pxSF+avO7DGeSF4cLTnyRfW3tmEHoKTOKmVb Mj5tJ8MHwyeZtWvyMWGJzhVbfJBTG334cG/4fhiglLFfQKGW0kN2xziYrU4niA== 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 4TWkjv46srzmQR for ; Fri, 9 Feb 2024 19:41:07 +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 419Jf7Ag092303 for ; Fri, 9 Feb 2024 19:41:07 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 419Jf75t092302 for ports-bugs@FreeBSD.org; Fri, 9 Feb 2024 19:41:07 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 276931] ports-mgmt/pkg: writes big journal files Date: Fri, 09 Feb 2024 19:41:07 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new 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: d8zNeCFG@aon.at X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter flagtypes.name Message-ID: 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 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D276931 Bug ID: 276931 Summary: ports-mgmt/pkg: writes big journal files Product: Ports & Packages Version: Latest Hardware: Any OS: Any Status: New Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: pkg@FreeBSD.org Reporter: d8zNeCFG@aon.at Assignee: pkg@FreeBSD.org Flags: maintainer-feedback?(pkg@FreeBSD.org) Scenario: - FreeBSD stable/14 as of today - ports latest Result: - It seems that since some days pkg(8) has started to create huge journal f= iles in /var/db/pkg whenever a package is deleted or added: [0]# ll /var/db/pkg total 45617 -rw-r--r-- 1 root wheel 71303168 Feb 9 20:34 local.sqlite -rw-r--r-- 1 root wheel 71349200 Feb 9 20:34 local.sqlite-journal - This leads to a massive slowdown if many packages are installed separately and the storage is not very fast. In fact, for all but the bigget packages, writing the journal file now by far dominates the time it takes to delete or add a package. Expected result: - As before, pkg operations should be fast. -- Martin --=20 You are receiving this mail because: You are the assignee for the bug.=