From nobody Mon Aug 12 14:24:02 2024 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 4WjGwk0FC5z5SkX1 for ; Mon, 12 Aug 2024 14:24:06 +0000 (UTC) (envelope-from void@f-m.fm) Received: from fout7-smtp.messagingengine.com (fout7-smtp.messagingengine.com [103.168.172.150]) (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 mx1.freebsd.org (Postfix) with ESMTPS id 4WjGwj3DJvz4jBj for ; Mon, 12 Aug 2024 14:24:05 +0000 (UTC) (envelope-from void@f-m.fm) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=f-m.fm header.s=fm3 header.b=aG8evZ4L; dkim=pass header.d=messagingengine.com header.s=fm3 header.b=TO2qhnlm; dmarc=pass (policy=none) header.from=f-m.fm; spf=pass (mx1.freebsd.org: domain of void@f-m.fm designates 103.168.172.150 as permitted sender) smtp.mailfrom=void@f-m.fm Received: from phl-compute-07.internal (phl-compute-07.nyi.internal [10.202.2.47]) by mailfout.nyi.internal (Postfix) with ESMTP id 4FFAB138FC84 for ; Mon, 12 Aug 2024 10:24:04 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by phl-compute-07.internal (MEProxy); Mon, 12 Aug 2024 10:24:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=f-m.fm; h=cc :content-type:content-type:date:date:from:from:in-reply-to :message-id:mime-version:reply-to:subject:subject:to:to; s=fm3; t=1723472644; x=1723559044; bh=wWY4SPJP2485m7tglvq/+IFsoDX4xo5L E7sWG4FgnpI=; b=aG8evZ4L/0Jh/N/pgLdu2dE5Em2JBzavfBn7fCNVGF1MZa5r ytngWS0QCuAk/PLISlWbQNdpujieWMLStvs4EzGQ1Dodvb2MxLmgddUTQr/mP4dZ d8CidQNHqvppM3jrLADdtAVIuhugSQ9H7ACodS293ExwSsSKQyxRWyTHhVtkB2jD J4bmEVch9QbxS5mBsG8uw/Zy2UwVfTkE6rpnNry3OC4evt3/oXGFkxObVHkabCDQ kpYwVNgf2URFHa2gZtvkwMxdbywvmAb/Qn0tlAIEJYVC4PAR5p5YIEb1HSnZ8i/P HcWnGzoAJopMAQhY4A8RewQQAwC1m294HH4MuA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:message-id :mime-version:reply-to:subject:subject:to:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t= 1723472644; x=1723559044; bh=wWY4SPJP2485m7tglvq/+IFsoDX4xo5LE7s WG4FgnpI=; b=TO2qhnlmykdqdxio6TjETQgONpRQMQ3EdWEPOnQL1L8mR+sKA66 EBLQ4kv0Q+kBBEDw93zJDb5lHwrB+FL0CpfrSGvSgciDL4pu6W9niy6MT1iS+Ttp s1s6pQ18bqryuyaDsrNbqSnyex3wyq6BYavbMpG1SkSZvVr/l1DRI6fDh/LFZGNc qokw8YQwJs6dA24baPUYq8WexZyrqOA0H5GXlroSxqZwitTN0rldKXIV6zToRIfd oiwF+uMwOi9lm2AavB8KA7xB6+aHLDhcl/w7RYUw+Es0j/DYIm/7CcVWFCPoQCjX mwVKjv1ZaCXFKIECf09h9Uot3Lkbf0f0DAA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddruddttddgjeehucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucenucfjughrpeffhffvuf fkgggtugesthdtredttddtvdenucfhrhhomhepvhhoihguuceovhhoihgusehfqdhmrdhf mheqnecuggftrfgrthhtvghrnhepveduffeivdfffffghfegfeejfefftdeiteehteekfe fhvdefgfettdeuheegffeunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehm rghilhhfrhhomhepvhhoihgusehfqdhmrdhfmhdpnhgspghrtghpthhtohepuddpmhhoug gvpehsmhhtphhouhhtpdhrtghpthhtohepfhhrvggvsghsugdqphhkghesfhhrvggvsghs ugdrohhrgh X-ME-Proxy: Feedback-ID: i2541463c:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA for ; Mon, 12 Aug 2024 10:24:03 -0400 (EDT) Date: Mon, 12 Aug 2024 15:24:02 +0100 From: void To: freebsd-pkg@freebsd.org Subject: pkg sqlite problem? Message-ID: 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; format=flowed Content-Disposition: inline X-Spamd-Bar: -- X-Spamd-Result: default: False [-2.79 / 15.00]; SUBJECT_ENDS_QUESTION(1.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.99)[-0.985]; MID_RHS_NOT_FQDN(0.50)[]; DMARC_POLICY_ALLOW(-0.50)[f-m.fm,none]; RWL_MAILSPIKE_VERYGOOD(-0.20)[103.168.172.150:from]; R_DKIM_ALLOW(-0.20)[f-m.fm:s=fm3,messagingengine.com:s=fm3]; R_SPF_ALLOW(-0.20)[+ip4:103.168.172.128/27]; RCVD_IN_DNSWL_LOW(-0.10)[103.168.172.150:from]; MIME_GOOD(-0.10)[text/plain]; ARC_NA(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; MIME_TRACE(0.00)[0:+]; RCVD_TLS_LAST(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; FREEMAIL_FROM(0.00)[f-m.fm]; RCVD_COUNT_THREE(0.00)[3]; FROM_HAS_DN(0.00)[]; FREEMAIL_ENVFROM(0.00)[f-m.fm]; PREVIOUSLY_DELIVERED(0.00)[freebsd-pkg@freebsd.org]; TO_DN_NONE(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; DKIM_TRACE(0.00)[f-m.fm:+,messagingengine.com:+]; MLMMJ_DEST(0.00)[freebsd-pkg@freebsd.org]; ASN(0.00)[asn:209242, ipnet:103.168.172.0/24, country:US]; RCVD_VIA_SMTP_AUTH(0.00)[]; MISSING_XM_UA(0.00)[]; DWL_DNSWL_NONE(0.00)[messagingengine.com:dkim] X-Rspamd-Queue-Id: 4WjGwj3DJvz4jBj [49/121] Upgrading py311-urllib3 from 1.26.18_1,1 to 1.26.19,1... pkg: sqlite error while executing INSERT OR ROLLBACK INTO pkg_annotation(package_id, tag_id, value_id) VALUES (2151, (SELECT annotation_id FROM annotation WHERE annotation = 'build_timestamp'), (SELECT annotation_id FROM annotation WHERE annotation = '2024-07-10T11:32:55+0000')) in file pkgdb.c:2055: UNIQUE constraint failed: pkg_annotation.package_id, pkg_annotation.tag_id pkg: sqlite error while executing ROLLBACK TRANSACTION in file pkgdb.c:1157: cannot rollback - no transaction is active Looks like a problem with pkg itself? How to fix? context FreeBSD 14.1-RELEASE-p3 GENERIC amd64 1401000 1401000 # pkg -v 1.21.3 --