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 4TWkjv4tCDz5BD2W for ; Fri, 9 Feb 2024 19:41:07 +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 4TWkjv30gtz4pGH 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: in-reply-to:in-reply-to:references:references; bh=BkSRJ1MfMxxS/eo6YbyxV1PZfavSpFehsCiRsHy28eM=; b=kSNtFZpXn+VaimpSUy3SWXUdRJRssejcOkA3rAXj893QSMycSs49FTThltrUa8Xq6owCGi 1lHI7dgtDAiWZl01ZUCwk8bROYZW6wpphjxU3SwPrudFn5sgCL86w52NALEKpXdhLTNetJ 5YOGe9LtuGuDXEZ8XSOgi0dqMEH4H1AovfUNBr6zdEhgg/lbDRa/44P8nGpkVPCW04CIos c4ZJC90/ravOXWKrppqBSt6Nuhg0/MyabN1ke3GRlBeDy2SygeYioZCjXjKpNqT4dXsHUZ fFwcDyO6/by0718Xrzr1yU/e1jXpjenQavOh1Fe5H3XdRifmyPvTzPGdiHlbrw== 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=ZF7xNeIQCVeTFeTyJ3rmUorUW1uX2Zg0JfrzJ85FvUDXBAsYMxIJlGwKHRYgaLGXJsvQES AgJWh5HlXMi0VeGp3t5KUfgbn4AJjaOOdWSdG2ZfjD5NtE1Ev9S8NB+gRLVjQVudpo/YSv 3KdMCtKWth0O6s09MR8zamWwIJdMVIBNUKtcmjDYRs1XW5R/7nKB3VnviSbuwTTetNrDVY 7MewuElEhAKHGECRwXP4gM3WxP9eY1nmoLW62+kUipPMBE7iVk9il9wni59dXR0Xtmrwbp XxPqBt67Z1jYvFmX26cyRIC2KDruwAQdKj13JYUyP8cQnhWQ5Qgw9M0PkHKN9Q== 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 4TWkjv23zTzm3g 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 419Jf7HH092289 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 419Jf7Vd092288 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 Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="UTF-8" From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: maintainer-feedback requested: [Bug 276931] ports-mgmt/pkg: writes big journal files Date: Fri, 09 Feb 2024 19:41:07 +0000 X-Bugzilla-Type: request 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: X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? Message-ID: In-Reply-To: References: 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 Bugzilla Automation has asked freebsd-pkg (Nobody) for maintainer-feedback: Bug 276931: ports-mgmt/pkg: writes big journal files https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D276931 --- Description --- 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