From nobody Fri Feb 09 19:41:07 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 4TWkjw0nFFz5BD5j 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 4TWkjv4KTZz4p4y 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=qhUGGhRiqj6hytFP/kRNv5LS1Eq2R5x1FXptSyM6i+PJ4ruwOFoPGflxgGF/R6e9wr1Xah PudLNOSWkHCWmg7HOFwg4zb/H9VugZoXLFi1t0UJKXmJ0p0YEM6UYk/PUGJbKagupeG/qO E42NrKd+PKYfX3+5tgSo/RoH5iC2CPC95R/toVb4MPhdKlQ8vWlG7DVPTC2CYYcFyZGhDR 7KK9DT2/uDXRTyOEG9W53xAABxQ6bX7a7xrqO0cXALPCPfv6P72j+hWlZxN5grHHM0YAI1 VJofVWs3FdMP/jpmaAVVrb3Z4T8lkZk+UsUQFtPgxDITCblsmluSISh7Q4mq3Q== 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=qd7rrC21bCEVMjiacsLsVjGqRX8zzJJaPYzwiMuXnNBMEuZdy3junNpFhJwm6nD3LGphkz JmVZx6L6Iv9YsnK+lzN8TOl7XMP/z2FoJTsg+/8c5vt3/usdAgIAwLO8Cn3GM5iBo7fxuP rNfcEQF2aa2mWbOU7iLHmjwIFu8gCGpwVuP1oyhXrG5PCNBxsKDa4HV1O3ehdBuyoMQxiM 1Wue4XXAXvqYKB2rEdrWR1ICgmvSE7152kJTijI3ZnBIOhXcvxvi8qVBK1ftOBCRI7mPdI pHNhOCUf+onpfHcXTxRUU7q5DnOdmPJ1fc7vpOnP/iaNxJPBl1uTlAL5R+GXMQ== 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 4TWkjv3PzzzlhM 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 419Jf7TB092295 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 419Jf7sH092294 for pkg@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: pkg@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: 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 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.=