From nobody Wed Dec 17 15:31:30 2025 X-Original-To: freebsd-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 4dWd7R5bk2z6LJY3 for ; Wed, 17 Dec 2025 15:31:31 +0000 (UTC) (envelope-from bapt@FreeBSD.org) Received: from smtp.freebsd.org (smtp.freebsd.org [96.47.72.83]) (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 "smtp.freebsd.org", Issuer "R13" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4dWd7R4zjKz3Y5t for ; Wed, 17 Dec 2025 15:31:31 +0000 (UTC) (envelope-from bapt@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1765985491; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=ivaaz4e62jQH4h2Jn+KA75HZ50cegYCGyM4c2Ivu3TI=; b=qkC9dMlMpK8c+CyIfcmH5pfMIzgSsCHH/9M4Gyxicqk7yH2g+U6Vkmn6XCcECXqI/0qY0R koyJPqczmUmTrp182Hx4Cvs6UE7nlR6eeKu8KfUmvdRccP6kq0O6caIsWRSK638pyUIp9J C6lvwA5i3hZ2A77rGMQ0J+glimiFTVx0SaxwbWmFkYmNm/d7PZYikUqYB3KgSxvXwl7cOG Z2J7iWsvoVcWABSduPQSoa6G393GxPNewDaKwyUuEUlCjo/9tx4Hg7AEuHvqTiwc3du/sn TKCBEL1Nm90CgrXjq36rF+ZgycImqZBh4cbDfvY41EJptHyXXp/ulFpGNGfJzg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1765985491; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: in-reply-to:in-reply-to:references:references; bh=ivaaz4e62jQH4h2Jn+KA75HZ50cegYCGyM4c2Ivu3TI=; b=IGC6K8cKzxamfOYI6zPW0SmDpNvLd2/rTd2QE4nNxx/E5XTMcST3sp3cTBKm8sm+qBdhJl g7Gldn7u9sugFtp6bBE/8aZa+4G498pnSxqzH9YucZUmGfiS8qY9lyU/mFsMJmn8chtesz b5Us7kJsPPGIYVGFVAbfxw3bREEPU+hu+O4CBAVQqIzbh2x1ar0/uk51IJr9mGDJXyU6dT ZE60wMLdg+fFO5a4V7Tw3X6/gQ0tjgL8D0m9IaAgT8ANGfIVDA0YjxxXNo3MzDGL0ngFmb 72neLp0XlN9Zf+N1ok1/GySAo81yzFVFeacgeCUvzgCjXvUVUDJyXczl2HGgVA== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1765985491; a=rsa-sha256; cv=none; b=Df6xqtTU0mHym737udMXQpGplRFJUBcl/Ting01rJodLlCnZ9yg/Hp9m58OJenJpcE31xW ctIDOeqVClF1Bh0JWJTtUu7IjX1j/6EhAi7CFNgKn332F84CR4D2ib7/gZ+6XJwiqdOOdV oomlD2Xa7owW1aDUWpr1x9qISx68Y6dWaid7KODXxnZmaRCIGOJrFBmOdNHxJS/t6mrBHP fPyUFuTjbTxSnmlpivntVFHK3RNydnb5l1ufUKKNKCQifUaKPcP3OKAcm1rVgePmm5LLKn KEzAFjhj0L1VrlaI7ChBCJfBVnSI6F/5vyKzRjMFi55F2Eaj8fv7x5JD4369Ow== ARC-Authentication-Results: i=1; mx1.freebsd.org; none Received: from b.nours.eu (b.nours.eu [IPv6:2001:41d0:303:5e39::1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits)) (Client did not present a certificate) (Authenticated sender: bapt) by smtp.freebsd.org (Postfix) with ESMTPSA id 4dWd7R3jXzzk6G for ; Wed, 17 Dec 2025 15:31:31 +0000 (UTC) (envelope-from bapt@FreeBSD.org) Received: by b.nours.eu (Postfix, from userid 1001) id 520466ACEB; Wed, 17 Dec 2025 16:31:30 +0100 (CET) Date: Wed, 17 Dec 2025 16:31:30 +0100 From: Baptiste Daroussin To: freebsd-pkg@freebsd.org Subject: Re: pkg problems Message-ID: References: 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 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: On Wed 17 Dec 15:24, void wrote: > Hi, > > Getting this error: > > # pkg update -f > Updating FreeBSD-ports repository catalogue... > Fetching meta.conf: 100% 179 B 0.2kB/s 00:01 Fetching data.pkg: > 100% 10 MiB 11.0MB/s 00:01 Processing entries: 99% > pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path > pkg: sqlite error while executing grmbl in file update.c:154: NOT NULL constraint failed: packages.path > pkg: sqlite error while executing INSERT OR REPLACE INTO packages (origin, name, version, comment, desc, arch, maintainer, www, prefix, pkgsize, flatsize, licenselogic, cksum, path, manifestdigest, olddigest, vital)VALUES (?1, ?2, ?3, ?4, ?5, ?6, ?7, ?8, ?9, ?10, ?11, ?12, ?13, ?14, ?15, ?16, ?17) in file update.c:158: not an error > Processing entries: 99% > Unable to update repository FreeBSD-ports > Error updating repositories! > The dataset is corrupted for yet unknonw reason, a new dataset is being uploaded as we speak, so in the next couple of hours it should hit the mirrors next to you. Sorry about that, Best regards, Bapt