From owner-freebsd-pkg@FreeBSD.ORG Sun Dec 21 19:48:16 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 6B2D0B34; Sun, 21 Dec 2014 19:48:16 +0000 (UTC) Received: from mx5.roble.com (mx5.roble.com [206.40.34.5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mx5.roble.com", Issuer "mx5.roble.com" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 5AE6A3C36; Sun, 21 Dec 2014 19:48:15 +0000 (UTC) Date: Sun, 21 Dec 2014 11:42:31 -0800 (PST) From: Roger Marquis To: freebsd-pkg@freebsd.org Subject: sqlite error while executing DROP INDEX In-Reply-To: References: User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII Cc: freebsd-ports@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Dec 2014 19:48:16 -0000 Of all the pkgng bugs we've finally hit one that doesn't have an obvious workaround. # pkg pkg: sqlite error while executing DROP INDEX deps_unique;CREATE UNIQUE INDEX deps_unique ON deps(name, version, package_id); in file pkgdb.c:2262: UNIQUE constraint failed: deps.name, deps.version, deps.package_id Any sqlite gurus out there know how to fix this? Roger From owner-freebsd-pkg@FreeBSD.ORG Sun Dec 21 20:39:48 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id A6092210 for ; Sun, 21 Dec 2014 20:39:48 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 3131D2A76 for ; Sun, 21 Dec 2014 20:39:48 +0000 (UTC) Received: from maggot.black-earth.co.uk (maggot.black-earth.co.uk [81.2.117.101]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.1/8.15.1) with ESMTPSA id sBLKdaRh020687 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Sun, 21 Dec 2014 20:39:37 GMT (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk sBLKdaRh020687 Authentication-Results: smtp.infracaninophile.co.uk/sBLKdaRh020687; dkim=none reason="no signature"; dkim-adsp=none; dkim-atps=neutral Message-ID: <54973008.3050901@FreeBSD.org> Date: Sun, 21 Dec 2014 20:39:36 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX References: <20141221194818.788B9B51@hub.freebsd.org> In-Reply-To: <20141221194818.788B9B51@hub.freebsd.org> Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: 7bit X-Virus-Scanned: clamav-milter 0.98.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.9 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00 autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Dec 2014 20:39:48 -0000 On 2014/12/21 19:42, Roger Marquis wrote: > Of all the pkgng bugs we've finally hit one that doesn't have an obvious > workaround. > > # pkg > pkg: sqlite error while executing DROP INDEX deps_unique;CREATE UNIQUE > INDEX deps_unique ON deps(name, version, package_id); in file > pkgdb.c:2262: UNIQUE constraint failed: deps.name, deps.version, > deps.package_id > > Any sqlite gurus out there know how to fix this? This is trying to create a unique index on the name column of the packages table. The unique key was finally changed to pkg name just recently: previously it was a combination of name and version. This entailed a bit of work in the ports tree making sure all the different ports have unique package names -- which is all fine and dandy, except that there will be people with older packages installed which *don't* have unique names. What you can do: to see packages with non-unique names: % pkg shell SQLite version 3.8.7 2014-10-17 11:24:17 Enter ".help" for usage hints. sqlite> select name from packages group by name having count(name) > 1 ; Now, pkg(8) does this next bit automatically anyhow: # pkg shell SQLite version 3.8.7 2014-10-17 11:24:17 Enter ".help" for usage hints. sqlite> UPDATE packages SET name= name || "~pkg-renamed~" || hex(randomblob(2)) WHERE name IN ( SELECT name FROM packages GROUP BY name HAVING count(name) > 1 ); ...> ...> ...> sqlite> That appends '~pkg-renamed~' and a string of 4 random hex digits to the name of anything if it is non-unique. Now, 4 random hex digits gives a 1 in 65536 chance that you'll get the same 4 random digits again, so it's entirely possible but pretty long odds that this will actually fail to make the name column unique. In which case, just revert the change and try again. To revert the change easily, use transactions, and rollback instead of committing. Oh, and if you're worried about dealing with all those randomly named packages, you can use the portname 'posrts-mgmt/pkg' instead for most purposes. Cheers, Matthew From owner-freebsd-pkg@FreeBSD.ORG Sun Dec 21 20:56:45 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id DD255466 for ; Sun, 21 Dec 2014 20:56:45 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 7956E2D0B for ; Sun, 21 Dec 2014 20:56:44 +0000 (UTC) Received: from maggot.black-earth.co.uk (maggot.black-earth.co.uk [81.2.117.101]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.1/8.15.1) with ESMTPSA id sBLKuRmW021000 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Sun, 21 Dec 2014 20:56:28 GMT (envelope-from m.seaman@infracaninophile.co.uk) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=infracaninophile.co.uk DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk sBLKuRmW021000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1419195388; bh=r+JB1/oYkfHm/g6G/bDBluX98y73C5B8jSEdCf2G5J0=; h=Date:From:To:Subject:References:In-Reply-To; z=Date:=20Sun,=2021=20Dec=202014=2020:56:20=20+0000|From:=20Matthew =20Seaman=20|To:=20freebsd-pkg@fr eebsd.org|Subject:=20Re:=20sqlite=20error=20while=20executing=20DR OP=20INDEX|References:=20=20<20141221194818.788B9B51@hub.freebsd.org>=20<549730 08.3050901@FreeBSD.org>|In-Reply-To:=20<54973008.3050901@FreeBSD.o rg>; b=bxCTiqf58+Wzu/88g4aARnwjTe0WWn+yyLAV/jj1kcu2qTm36VxULM/BkUJRU/7TV s5BM1Z3VnqjU06B/Z5N9PReEHRlRhpbAj+np3CpzHytM9MLtqk/tvbMhQwW8Pl6VHS g/8E1u6HmEsMRkjmaT/3NcRcxPlIjSSu6KH9vqSo= Message-ID: <549733F4.1090507@infracaninophile.co.uk> Date: Sun, 21 Dec 2014 20:56:20 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX References: <20141221194818.788B9B51@hub.freebsd.org> <54973008.3050901@FreeBSD.org> In-Reply-To: <54973008.3050901@FreeBSD.org> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="jGQMi2aHpqIElehsBohKreTECpulV1aWT" X-Virus-Scanned: clamav-milter 0.98.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Dec 2014 20:56:46 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --jGQMi2aHpqIElehsBohKreTECpulV1aWT Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable On 2014/12/21 20:39, Matthew Seaman wrote: > On 2014/12/21 19:42, Roger Marquis wrote: >> Of all the pkgng bugs we've finally hit one that doesn't have an obvio= us >> workaround. >> >> # pkg >> pkg: sqlite error while executing DROP INDEX deps_unique;CREATE UNIQ= UE >> INDEX deps_unique ON deps(name, version, package_id); in file >> pkgdb.c:2262: UNIQUE constraint failed: deps.name, deps.version, >> deps.package_id >> >> Any sqlite gurus out there know how to fix this? >=20 > This is trying to create a unique index on the name column of the > packages table. The unique key was finally changed to pkg name just > recently: previously it was a combination of name and version. This > entailed a bit of work in the ports tree making sure all the different > ports have unique package names -- which is all fine and dandy, except > that there will be people with older packages installed which *don't* > have unique names. >=20 > What you can do: to see packages with non-unique names: >=20 > % pkg shell > SQLite version 3.8.7 2014-10-17 11:24:17 > Enter ".help" for usage hints. > sqlite> select name from packages group by name having count(name) > 1 = ; >=20 > Now, pkg(8) does this next bit automatically anyhow: >=20 > # pkg shell > SQLite version 3.8.7 2014-10-17 11:24:17 > Enter ".help" for usage hints. > sqlite> UPDATE packages SET name=3D name || "~pkg-renamed~" || > hex(randomblob(2)) > WHERE name IN ( > SELECT name FROM packages GROUP BY name HAVING count(name) > 1 > ); > ...> ...> ...> sqlite> >=20 > That appends '~pkg-renamed~' and a string of 4 random hex digits to the= > name of anything if it is non-unique. Now, 4 random hex digits gives a= > 1 in 65536 chance that you'll get the same 4 random digits again, so > it's entirely possible but pretty long odds that this will actually fai= l > to make the name column unique. >=20 > In which case, just revert the change and try again. To revert the > change easily, use transactions, and rollback instead of committing. >=20 > Oh, and if you're worried about dealing with all those randomly named > packages, you can use the portname 'posrts-mgmt/pkg' instead for most > purposes. Errr.... actually, this isn't the solution to exactly the problem you described. But it's close -- you're failing to create a unique index on the deps table, not the packages table. As it's a unique index over multiple columns, you'll need to adapt the code a bit. Something like: SELECT name, version, package_id FROM deps GROUP BY name, version, package_id HAVING count(*) > 1 ; However, just renaming stuff in the deps table won't fix the problem. You need to work out what the duplicated rows are, find out what packages reference those rows and force them all to refer to one of those row in the deps table, then delete the other duplicate rows. The fact that you have duplicates at all in that table means that something went pretty badly wrong with pkg(8) at an earlier date, so there could be all sorts of weirdnesses in there. Failing heroic DBA action to fix up the schema, you might find it quicker and easier to blow away your package database, start again with an empty package DB and reinstall all your packages... It depends on just how much stuff you've got on that system. Cheers, Matthew Cheers, Matthew --jGQMi2aHpqIElehsBohKreTECpulV1aWT Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.22 (Darwin) Comment: GPGTools - https://gpgtools.org iQIcBAEBCgAGBQJUlzP7AAoJEABRPxDgqeTnLdIP/iU9hybTH25O1Ld8PT7GPW83 zKvHiO/CL/gRKqI4zVKHvX6NT+FHyBK/IVtr4+XCxgSCyYKRns9PStYyVo1dfUeY iZDaD4yTVxcr9h5LckEj2d4M8sAoc2XsHF1parDo/vI/RKYTe8mIbI6jr9mw4xhA 7ToHyu6Md6gpo0Q/fh8d76ca4oMnfGiFMv072MYreyl5u3XPy9fzA/MWmh/y3v+X KfwHiJGYJ3sK839WvGAZVEFq/xYZQPdzgeFZ4+mhpOktsJMtCOZw2WHpYjCsm/Qh cg9/4qBRgmMK5ygeFpI/aeBBV5muOAn6nK8Y98nevhteKkfT36DnoMibe2ngPSl1 P0IHN1hgzxF30iO3ebD5VWT8OZJAOAx5POCFWvcfyCo2+8TAjD3xs6I4jMLHhAgM 2KEhc/JaC1DWpTEY/aLkwwqpwp9TgPIuKtkFu5/Aflwc6nkC7CW15s9o+95CVL2y ZAOB0ghnGG03EkwkqNjaLM0vcc9rxsafgP0g2OfcyZ5H8JTO7uxFe+xi2eSu7If4 DsFEsel5iToVfIlonTZ2LZFAWIpOLiuzwrHWCaNqSq7OvP0zEj45QPu4M1FRXcNY so2Jc/nuKX/pB4rEbThaHU+IGj9N0PAxuQjvL0tvlEvaqb7Uqp/8BkzqDdrLE3aB X/s6U8L3JfR1gaWobFGJ =7f+t -----END PGP SIGNATURE----- --jGQMi2aHpqIElehsBohKreTECpulV1aWT-- From owner-freebsd-pkg@FreeBSD.ORG Sun Dec 21 23:38:33 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 96DAD19C; Sun, 21 Dec 2014 23:38:33 +0000 (UTC) Received: from mail-wi0-x22c.google.com (mail-wi0-x22c.google.com [IPv6:2a00:1450:400c:c05::22c]) (using TLSv1 with cipher ECDHE-RSA-RC4-SHA (128/128 bits)) (Client CN "smtp.gmail.com", Issuer "Google Internet Authority G2" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 1E0B52F84; Sun, 21 Dec 2014 23:38:33 +0000 (UTC) Received: by mail-wi0-f172.google.com with SMTP id n3so6593641wiv.5; Sun, 21 Dec 2014 15:38:31 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=sender:date:from:to:cc:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to:user-agent; bh=yOCSKdPtlBMMws5DC3kLvx7iIdQ1pxxp7P6WiEZrlzw=; b=Bmc5NOkE0R+tZKASMdOCnJVc0T//83X08FoQP/KEjfi466YkX/1aJyk1GD7Edy3whF sHY1Vs/GXN4oO/77MLnhzh9f+YvxPQbc2Ow3G9Ph92i1r/50bHSjSIScWZ5vHvKdmNC2 5J0nPycR1YX5V24jukkwzFKJ8/3bai3GiCokmCRXId2u0M7F58YCGmdDcmEdt4EMmTti THSg0x0l7F15PCN2V8l724i7Xu1KyVKnXIKoD4wT4CKerOI5JNcr6Z4MniH20hXC8QHo YN6vz0mKV9oj3xF0T8tK7OzPO5N4MgbFJZopk8FZ64yfhmQBLf2Q7ijRF6YGYKOox8hr DmMQ== X-Received: by 10.180.72.199 with SMTP id f7mr26352989wiv.58.1419205111503; Sun, 21 Dec 2014 15:38:31 -0800 (PST) Received: from ivaldir.etoilebsd.net ([2001:41d0:8:db4c::1]) by mx.google.com with ESMTPSA id td6sm11178739wic.15.2014.12.21.15.38.30 (version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 21 Dec 2014 15:38:30 -0800 (PST) Sender: Baptiste Daroussin Date: Mon, 22 Dec 2014 00:38:28 +0100 From: Baptiste Daroussin To: Roger Marquis Subject: Re: sqlite error while executing DROP INDEX Message-ID: <20141221233828.GA43454@ivaldir.etoilebsd.net> References: <20141221194819.94F2FB59@hub.freebsd.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="AhhlLboLdkugWU4S" Content-Disposition: inline In-Reply-To: <20141221194819.94F2FB59@hub.freebsd.org> User-Agent: Mutt/1.5.23 (2014-03-12) Cc: freebsd-ports@freebsd.org, freebsd-pkg@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Dec 2014 23:38:33 -0000 --AhhlLboLdkugWU4S Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sun, Dec 21, 2014 at 11:42:31AM -0800, Roger Marquis wrote: > Of all the pkgng bugs we've finally hit one that doesn't have an obvious = workaround. >=20 > # pkg > pkg: sqlite error while executing DROP INDEX deps_unique;CREATE UNIQUE= INDEX deps_unique ON deps(name, version, package_id); in file pkgdb.c:2262= : UNIQUE constraint failed: deps.name, deps.version, deps.package_id >=20 > Any sqlite gurus out there know how to fix this? >=20 Can you host somewhere you /var/db/pkg/local.sqlite somehow one of your dependency is very bad, in theory this is impossible, either a bug in the p= orts tree or in portmaster/portupgrade (don't know what you do use) Based on that I'll give you a workaround. Best regards, Bapt --AhhlLboLdkugWU4S Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iEYEABECAAYFAlSXWe8ACgkQ8kTtMUmk6Ez2ggCeLDD6Kn/Oab7ppPYLAmD+Vb3F 19UAn3BaSvEehCyDQlhlEw+5OY2q8mBW =viqT -----END PGP SIGNATURE----- --AhhlLboLdkugWU4S-- From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 04:26:16 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 1B72F7FD; Mon, 22 Dec 2014 04:26:16 +0000 (UTC) Received: from mx5.roble.com (mx5.roble.com [206.40.34.5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mx5.roble.com", Issuer "mx5.roble.com" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 0A9E13801; Mon, 22 Dec 2014 04:26:15 +0000 (UTC) Date: Sun, 21 Dec 2014 20:26:15 -0800 (PST) From: Roger Marquis To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX In-Reply-To: <20141221233828.GA43454@ivaldir.etoilebsd.net> References: <20141221194819.94F2FB59@hub.freebsd.org> <20141221233828.GA43454@ivaldir.etoilebsd.net> User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-ports@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Dec 2014 04:26:16 -0000 Matthew Seaman wrote: > Something like: > SELECT name, version, package_id FROM deps GROUP BY name, version, > package_id HAVING count(*) > 1 ; That returns: pkgconf|0.8.7_2|7714 Though the server's daily 'pkg info' gave no indication this was multiply installed. Question now is how to remove the package or at least the package's (index?) records using 'pkg shell'? Roger From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 12:51:55 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id AA1E8E31 for ; Mon, 22 Dec 2014 12:51:55 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 223EF3394 for ; Mon, 22 Dec 2014 12:51:54 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.1/8.15.1) with ESMTPSA id sBMCpibW041473 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Mon, 22 Dec 2014 12:51:44 GMT (envelope-from m.seaman@infracaninophile.co.uk) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=infracaninophile.co.uk DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk sBMCpibW041473 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1419252704; bh=iviKyS7ukgVH6EjCfCQqc8lKBaldtcoQ+paXuS+gA3k=; h=Date:From:To:Subject:References:In-Reply-To; z=Date:=20Mon,=2022=20Dec=202014=2012:51:42=20+0000|From:=20Matthew =20Seaman=20|To:=20freebsd-pkg@fr eebsd.org|Subject:=20Re:=20sqlite=20error=20while=20executing=20DR OP=20INDEX|References:=20=20<20141221194819.94F2FB59@hub.freebsd.org>=20<201412 21233828.GA43454@ivaldir.etoilebsd.net>=20<20141222042618.969CF81A @hub.freebsd.org>|In-Reply-To:=20<20141222042618.969CF81A@hub.free bsd.org>; b=EuEpS/OIyBdrZltaYqqXd9PzsnL8b21tWgKh4l7ouIgQU+XfqaRN0GJ9HrGsf8w/q GAJHkzAzKDFncRIW+D5O0HhDEF3lxbDXlsqiPqNOPnZal9EjlJsz349zfyXZCHb/HK dCARwVp949EjFf+SeqcKsGkTj+MDgR2t2rdM47Ac= Message-ID: <549813DE.60902@infracaninophile.co.uk> Date: Mon, 22 Dec 2014 12:51:42 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX References: <20141221194819.94F2FB59@hub.freebsd.org> <20141221233828.GA43454@ivaldir.etoilebsd.net> <20141222042618.969CF81A@hub.freebsd.org> In-Reply-To: <20141222042618.969CF81A@hub.freebsd.org> OpenPGP: id=E1ECF9BB Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4SjrHb2HenJEXmMXAx76XciEu5iQOsiSH" X-Virus-Scanned: clamav-milter 0.98.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Dec 2014 12:51:55 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --4SjrHb2HenJEXmMXAx76XciEu5iQOsiSH Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 22/12/2014 04:26, Roger Marquis wrote: > Matthew Seaman wrote: >> Something like: >> SELECT name, version, package_id FROM deps GROUP BY name, version, >> package_id HAVING count(*) > 1 ; >=20 > That returns: >=20 > pkgconf|0.8.7_2|7714 >=20 > Though the server's daily 'pkg info' gave no indication this was multip= ly > installed. Question now is how to remove the package or at least the > package's (index?) records using 'pkg shell'? Unlike the old pkg_tools, in principle it is not possible to have 'multiply installed' packages with pkg(8)[*]. In exactly the same way that it is impossible to have the sort of duplicated dependency you're seeing here. You could fix up the apparent problem by deleting all but one of the duplicated rows in the deps table, but that doesn't explain how the problem happened in the first place and it gives no guarantee that you haven't got similar problems elsewhere. First, check exactly what the duplicated lines contain. There's an 'origin' field in the deps table, which could be enlightening, and there could be more than two duplicated rows: SELECT * FROM DEPS WHERE name=3D'pkgconf' AND version=3D'0.8.7_2' AND package_id=3D'7714'; Given two rows that are exactly the same then: (untested...) Hmmm... LIMIT 1 on a DELETE statement requires sqlite be compiled with the -DSQLITE_ENABLE_UPDATE_DELETE_LIMIT define set, which appears not to be the case as far as I can see by inspecting the pkg(8) sources. So you might have to install sqlite3 from ports with the appropriate flags and then: # sqlite3 /var/db/pkg/local.sqlite BEGIN; DELETE FROM deps WHERE name=3D'pkgconf' AND version=3D'0.8.7_2' AND package_id=3D'7714' LIMIT 1; SELECT * FROM DEPS WHERE name=3D'pkgconf' AND version=3D'0.8.7_2' AND package_id=3D'7714'; Then if that achieved the desired effect: COMMIT; or else ROLLBACK; Cheers, Matthew [*] which was more about duplicated records of a package being installed than the same package being installed twice. --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey JID: matthew@infracaninophile.co.uk --4SjrHb2HenJEXmMXAx76XciEu5iQOsiSH Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) iQJ8BAEBCgBmBQJUmBPfXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkATbRsQAK0NBz0QcIhTHy4thRf+ihfG kgmXYMGY/J8rCSIrvLy3UxQwjhG2XLnxk764LbRMHBs1pC2Q/9UHa8Q6C/l9cBJL GELNdOc8F6akX1YMtelO5SvGmSrnIb3mt1nfpvNG3IWaX3ux4RUGXUO2VOGkeYst Nu+A0asDLNuVEs+I3d64ZD39P6GTk7/t+cBvOXDGSoXNppg7CADfFqLMCuUHGc1C urvf3rG9Ixxzd3iAr7sP0pVF94URvbYFQI1IsyqFj0BRUWMmY8X4YAZWyputw45D y+4ppCgMjQs9q8vTfA1OvB6LeQrlT7yo/Kc/hYJR/KU0dHtmeUmKO0rERL5K6aa2 i95gBFyfiHftmTunDmdrDnu4vTL60ozb3wMq8TQJUPlDQTW3Cef3UGMPbYctwwhj wXS09mRLc/Xixz+NciKGutzOpfcgU/U+lWYy7y1EOz30DrlNRpYWt2w8akbrOaz4 fYC9YB/eiZs/xijPRYIkIN+Sy2b5eeKNYppedm2LZppx+9KZIejGp+Eu0IRtDgsn mT0PR6dYNw6upfooccmZ0UxgzzkE2X5CUYbk0BO5uikjZlGy1IsWTC09RqjRD+bc 2TO05euYzQEb1zaU7DIAeW1X98+g3F4IOm6arzQKc/OMJ3UXG31q170fFORPfjV8 QVdC7iv8RBpJ70zi2bK8 =PVte -----END PGP SIGNATURE----- --4SjrHb2HenJEXmMXAx76XciEu5iQOsiSH-- From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 14:31:39 2014 Return-Path: Delivered-To: pkg@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 8FA492F3 for ; Mon, 22 Dec 2014 14:31:39 +0000 (UTC) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 717E9648AD for ; Mon, 22 Dec 2014 14:31:39 +0000 (UTC) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.14.9/8.14.9) with ESMTP id sBMEVdsh087499 for ; Mon, 22 Dec 2014 14:31:39 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 195961] ports-mgmt/pkg: Checking integrity...Assertion failed Date: Mon, 22 Dec 2014 14:31:39 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports Tree X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: thierry@FreeBSD.org X-Bugzilla-Status: New X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: see_also assigned_to short_desc product component version Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Dec 2014 14:31:39 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=195961 Thierry Thomas changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.freebsd.org/bu | |gzilla/show_bug.cgi?id=1959 | |62 Mark Linimon changed: What |Removed |Added ---------------------------------------------------------------------------- Assignee|freebsd-bugs@FreeBSD.org |pkg@FreeBSD.org Summary|pkg: Checking |ports-mgmt/pkg: Checking |integrity...Assertion |integrity...Assertion |failed |failed Product|Base System |Ports Tree Component|bin |Individual Port(s) Version|10.1-STABLE |Latest --- Comment #1 from Thierry Thomas --- Remark: the previous session was run inside a `su -m' session. Trying to run it again from a root login session gives this result: # pkg upgrade -f Updating FreeBSD repository catalogue... FreeBSD repository is up-to-date. All repositories are up-to-date. Checking for upgrades (1431 candidates): 58% libfreehand00 has no direct installation candidates, change it to libfreehand? [ Y/n]: Checking for upgrades (1431 candidates): 91% db42 has no direct installation candidates, change it to db? [Y/n]: Checking for upgrades (1431 candidates): 100% Processing candidates (1431 candidates): 100% pkg: sqlite error while executing UPDATE packages SET name=?1 WHERE name=?2; in file pkg_jobs.c:1601: UNIQUE constraint failed: packages.name pkg: sqlite error while executing UPDATE packages SET name=?1 WHERE name=?2; in file pkg_jobs.c:1601: UNIQUE constraint failed: packages.name Checking integrity...Assertion failed: (strcmp(uid, p->uid) != 0), function pkg_ conflicts_check_local_path, file pkg_jobs_conflicts.c, line 350. Child process pid=65455 terminated abnormally: Abort trap --- Comment #2 from Thierry Thomas --- Same failure one week later with the next packages set! Checking integrity...Assertion failed: (strcmp(uid, p->uid) != 0), function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, line 350. Child process pid=53216 terminated abnormally: Abort trap -- You are receiving this mail because: You are the assignee for the bug. From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 15:17:03 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id A129CBF8; Mon, 22 Dec 2014 15:17:03 +0000 (UTC) Received: from mx5.roble.com (mx5.roble.com [206.40.34.5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mx5.roble.com", Issuer "mx5.roble.com" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 90CB8A3E; Mon, 22 Dec 2014 15:17:03 +0000 (UTC) Date: Mon, 22 Dec 2014 07:17:02 -0800 (PST) From: Roger Marquis To: freebsd-ports@freebsd.org Subject: Re: sqlite error while executing DROP INDEX In-Reply-To: References: User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed Cc: freebsd-pkg@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Dec 2014 15:17:03 -0000 Matthew Seaman wrote: > SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2' > AND package_id='7714'; > Given two rows that are exactly the same No two rows but it apears one of pkg's dependencies may have changed names at some point: # SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2' # AND package_id='7714'; devel/pkgconf|pkgconf|0.8.7_2|7714 # SELECT * FROM DEPS WHERE name='pkgconf' AND version='0.8.7_2'; devel/pkg-config|pkgconf|0.8.7_2|7669 devel/pkg-config|pkgconf|0.8.7_2|7670 devel/pkg-config|pkgconf|0.8.7_2|7671 devel/pkg-config|pkgconf|0.8.7_2|7685 devel/pkg-config|pkgconf|0.8.7_2|7686 devel/pkgconf|pkgconf|0.8.7_2|7700 devel/pkgconf|pkgconf|0.8.7_2|7714 devel/pkg-config|pkgconf|0.8.7_2|7714 devel/pkgconf|pkgconf|0.8.7_2|7747 devel/pkgconf|pkgconf|0.8.7_2|7748 devel/pkg-config|pkgconf|0.8.7_2|7755 devel/pkg-config|pkgconf|0.8.7_2|7756 devel/pkg-config|pkgconf|0.8.7_2|7772 devel/pkg-config|pkgconf|0.8.7_2|7775 devel/pkgconf|pkgconf|0.8.7_2|7798 devel/pkgconf|pkgconf|0.8.7_2|7800 devel/pkgconf|pkgconf|0.8.7_2|7802 devel/pkg-config|pkgconf|0.8.7_2|7804 Can all of these records can be safely deleted, all of the pkg-configs, or should the delete be limited to pkg-config|7714? Also curious about the significance of the package_id field and how n+1 records were written in the first place. I trust someone has filed one or more bugzillas as it appears pkg should be checking for dupes on at least two dimensions. Forensics is also hampered by the lack of a date field, ideally reflecting the package's install date (with epoch/unix timestamp precision). Consider this a feature request. Grazie! Roger From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 15:25:03 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 8383FD9E; Mon, 22 Dec 2014 15:25:03 +0000 (UTC) Received: from mx5.roble.com (mx5.roble.com [206.40.34.5]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mx5.roble.com", Issuer "mx5.roble.com" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 6701DB8A; Mon, 22 Dec 2014 15:25:03 +0000 (UTC) Date: Mon, 22 Dec 2014 07:25:03 -0800 (PST) From: Roger Marquis To: Baptiste Daroussin Subject: Re: sqlite error while executing DROP INDEX In-Reply-To: <20141221233828.GA43454@ivaldir.etoilebsd.net> References: <20141221194819.94F2FB59@hub.freebsd.org> <20141221233828.GA43454@ivaldir.etoilebsd.net> User-Agent: Alpine 2.00 (BSF 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; format=flowed; charset=US-ASCII Cc: freebsd-ports@freebsd.org, freebsd-pkg@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Dec 2014 15:25:03 -0000 Baptiste Daroussin wrote: > The way to fix is: > sqlite3 /var/db/pkg/local.sqlite "delete from deps where origin='devel/pkg-config';" > Then everything should be back to normal That worked! Merci Baptiste and Matthew, Roger From owner-freebsd-pkg@FreeBSD.ORG Mon Dec 22 16:11:20 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 282DA13B for ; Mon, 22 Dec 2014 16:11:20 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id BD1843F3F for ; Mon, 22 Dec 2014 16:11:19 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.1/8.15.1) with ESMTPSA id sBMGBBER046062 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Mon, 22 Dec 2014 16:11:12 GMT (envelope-from matthew@FreeBSD.org) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=FreeBSD.org DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk sBMGBBER046062 Authentication-Results: smtp.infracaninophile.co.uk/sBMGBBER046062; dkim=none reason="no signature"; dkim-adsp=none; dkim-atps=neutral Message-ID: <5498429F.5040005@FreeBSD.org> Date: Mon, 22 Dec 2014 16:11:11 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: Re: sqlite error while executing DROP INDEX References: <20141222151705.BF84CC16@hub.freebsd.org> In-Reply-To: <20141222151705.BF84CC16@hub.freebsd.org> Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC" X-Virus-Scanned: clamav-milter 0.98.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.8 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Mon, 22 Dec 2014 16:11:20 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 22/12/2014 15:17, Roger Marquis wrote: > Can all of these records can be safely deleted, all of the pkg-configs,= > or should the delete be limited to pkg-config|7714? Also curious about= > the significance of the package_id field and how n+1 records were writt= en > in the first place. I trust someone has filed one or more bugzillas as= > it appears pkg should be checking for dupes on at least two dimensions.= Glad to hear that you've got the problem sorted now. As I recall the switch between devel/pkg-config and devel/pkgconf was over two years ago, and there were some UPDATING instructions that should have been followed at the time: 20120726: AFFECTS: users of devel/pkg-config AUTHOR: bapt@FreeBSD.org devel/pkg-config has been replaced by devel/pkgconf # portmaster -o devel/pkgconf devel/pkg-config or # portupgrade -fo devel/pkgconf pkg-config-\* pkgng: # pkg set -o devel/pkg-config:devel/pkgconf # pkg install -f devel/pkgconf There's been a lot of changes in both ports and pkg since then, but I think not doing the above in 2012 and the subsequent changes to pkg(8) culminating in the latest schema changes in 1.4.0 explain what you've see= n. > Forensics is also hampered by the lack of a date field, ideally > reflecting the package's install date (with epoch/unix timestamp > precision). Consider this a feature request. There is a date field, but it's in the packages table. Try: SELECT id, origin, name, version, time FROM PACKAGES WHERE name LIKE 'pkgconf%' ; time is given as a unix epoch time which you can convert to something more understandable like so: % date -j -r 1411539887 Wed Sep 24 07:24:47 BST 2014 Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey --NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) iQJ8BAEBCgBmBQJUmEKfXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkAT5TAP/j4Lexf2nWvHQUozkW6yOuF/ id5A00mXuyP4IlXv9ICoKo1pNcBmTJe0+R2alvEasL9945FfC8KkKdKIeJpqORCP v+0WrE7MqPqe1CfJPbPjuwho61FcLCQkAAUrnSk5yemJZpurm7r/AchagcEQ7zCH +1/74kugkYbSKk16E59kJAezw744tRCAG5uDA4bI1dKgN2y20k45vJk4R4Xjvgf6 04rdd78zv8xtmC4JiqsZpmoHQzjusU/w7U7BvP+LwWRJbD9GkzjAgXTHltdGPdH0 HTbxbMzVtsoWlru4GSi6DWg2l3uaPDl90GeYNB2Fiy9oEeWG0jD+D52RG1/+bELq jEk/68V6X6jlkFchONV/sD4RdkkspfJGzlfHOOc44m9imaH0CoUaJKpZFvZjDNeA ez4pLFuj+TZnDMsorR3LSbV8C3bzmDf08KlAA7RfnLHIKSlxpJWs9l+5f7SKdmFR PybjixhDnJrv1oMP8TccWh4RvkaSF4ysw2HXACZTEBH8HShm8zoXndEI22tMmWV6 qeOAqfD3EWC+N7mlvKqOcplkTcO00UdBZP1o7BAnOKd0sZ/GcSawa1vgG993XIat ZrNPjDI7HnoS3tN3Cpr7AwrXMEHBh1Kfq2j/83WYdE+3Lzs7Aa+yG4DvMHob3nPT b2WQEM3mZThishutACFN =mD2A -----END PGP SIGNATURE----- --NhJ6wMiQBhXiN0W0cKwUEfKJb2p8FIwUC-- From owner-freebsd-pkg@FreeBSD.ORG Thu Dec 25 02:32:13 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 64FCF460 for ; Thu, 25 Dec 2014 02:32:13 +0000 (UTC) Received: from parez.praha12.net (parez.6.praha12.net [IPv6:2a01:490:16:2::2]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id D414117DF for ; Thu, 25 Dec 2014 02:32:12 +0000 (UTC) Received: from [10.40.8.101] (gandalf.tocnet.praha12.czf [10.40.8.101]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: posta@hell) by parez.praha12.net (Postfix) with ESMTPSA id 069A0201553 for ; Thu, 25 Dec 2014 03:32:01 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=praha12.net; s=parez; t=1419474721; bh=62M/rQmmh+PcDr8gQF3QiRXDPifEoFQKOXKB+d1+oEo=; h=Date:From:To:Subject:From; b=aU/KIrYIGDEnzoBy+v0IsOJeir4a5tAB8SqsWjz5y86vGIG67AvBEJJyx8PfUvNdM yGcFMeP5CN3uKnIbSX0Ui/rI5CSrt2wU09rFjvwz9pHSrsZHuyyfOyxKoDxnzC+NGq qLzWi60HpaKNquwvUYM2VCaOgfw8nHZuer00dXhE= Message-ID: <549B7720.6080306@atlas.cz> Date: Thu, 25 Dec 2014 03:32:00 +0100 From: =?ISO-8859-2?Q?=22Daniel_Dvo=F8=E1k=24=22?= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.2.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: pkgdb perl unknown modifier Content-Type: text/plain; charset=iso-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.18-1 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 25 Dec 2014 02:32:13 -0000 Hi all, I would like to ask about this strange error output of pkgdb command. I think something terrible wrong with perl, but if I want to upgrade it, it fails at the same place. So another commands like portversion or portupgrade have the same error output like pkgdb. pkgdb -F Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' "/usr/ports/Mk/bsd.sites.mk", line 991: Malformed conditional (!empty(_PERL_CPAN_ID) && ${_PERL_CPAN_FLAG:tl} == "cpan") Unknown modifier 't' Unknown modifier 't' "Mk/bsd.port.mk", line 3041: warning: Missing closing parenthesis for defined() Unknown modifier 't' "Mk/bsd.port.mk", line 3041: Malformed conditional (((!defined(OPTIONS_DEFINE) && !defined(OPTIONS_SINGLE) && !defined(OPTIONS_MULTI))&& !defined(OPTIONS_GROUP) && !defined(OPTIONS_RADIO)|| defined(CONFIG_DONE_${UNIQUENAME:tu}) ||defined(PACKAGE_BUILDING) || defined(BATCH))) Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' Unknown modifier 't' 5 open conditionals: at line 6027 (skipped) at line 6027 (skipped) at line 6027 (skipped) at line 6027 (skipped) at line 6027 (evaluated to false) make: fatal errors encountered -- cannot continue can't convert nil into String I hope this mailling list is right place where I can ask for help for error like that. If this is not right place, I am sorry for that. May I ask you to guide me to the right mailling list ? Thank you. Best regards, Daniel Merry Christmas !!! From owner-freebsd-pkg@FreeBSD.ORG Thu Dec 25 05:52:42 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 3B6CCB12 for ; Thu, 25 Dec 2014 05:52:42 +0000 (UTC) Received: from mail.soaustin.net (pancho.soaustin.net [76.74.250.40]) by mx1.freebsd.org (Postfix) with ESMTP id 1E2C9268A for ; Thu, 25 Dec 2014 05:52:40 +0000 (UTC) Received: by mail.soaustin.net (Postfix, from userid 502) id 4BE5656083; Wed, 24 Dec 2014 23:52:40 -0600 (CST) Date: Wed, 24 Dec 2014 23:52:40 -0600 From: Mark Linimon To: =?utf-8?B?IkRhbmllbCBEdm/FmcOhayQi?= Subject: Re: pkgdb perl unknown modifier Message-ID: <20141225055240.GA11092@lonesome.com> References: <549B7720.6080306@atlas.cz> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <549B7720.6080306@atlas.cz> User-Agent: Mutt/1.5.21 (2010-09-15) Cc: freebsd-pkg@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 25 Dec 2014 05:52:42 -0000 What version of FreeBSD are you on? This error can happen if you have certain versions that are no longer in support. mcl From owner-freebsd-pkg@FreeBSD.ORG Sat Dec 27 03:45:25 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 8EE72A0F for ; Sat, 27 Dec 2014 03:45:25 +0000 (UTC) Received: from parez.praha12.net (parez.6.praha12.net [IPv6:2a01:490:16:2::2]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 1C71166439 for ; Sat, 27 Dec 2014 03:45:24 +0000 (UTC) Received: from [10.40.8.101] (gandalf.tocnet.praha12.czf [10.40.8.101]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: posta@hell) by parez.praha12.net (Postfix) with ESMTPSA id 6DA402014DF; Sat, 27 Dec 2014 04:45:20 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=praha12.net; s=parez; t=1419651920; bh=oTCZZvGRvfru2D9DRUwoWzPKEedDj9iqE94lhdWEwh0=; h=Date:From:To:CC:Subject:References:In-Reply-To:From; b=16LN23bhRalsml3ryMbZ24zsAPYxAWGsbb0OYaYWmaXeZZBZPZ9zH6C1NyDO6pPMk DqEHGPpdiNjcuV/EGfXAZV7aaTC0nAPgTdfxefrnyW/Dw5vCxjHvCS06zqCivF5C7o eyo/hQYRsUU9uy8mPhoiBeD9iDg8plmNvKA/Erds= Message-ID: <549E2B50.1040306@atlas.cz> Date: Sat, 27 Dec 2014 04:45:20 +0100 From: =?UTF-8?B?IkRhbmllbCBEdm/FmcOhayQi?= User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: Mark Linimon Subject: Re: pkgdb perl unknown modifier References: <549B7720.6080306@atlas.cz> <20141225055240.GA11092@lonesome.com> In-Reply-To: <20141225055240.GA11092@lonesome.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Content-Filtered-By: Mailman/MimeDel 2.1.18-1 Cc: freebsd-pkg@freebsd.org X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 27 Dec 2014 03:45:25 -0000 Dne 25.12.2014 v 6:52 Mark Linimon napsal(a): > What version of FreeBSD are you on? This error can happen if you have > certain versions that are no longer in support. > > mcl Hi Mark, it is 8.4-RELEASE-p19. I found out something new to me in handbook: When upgrading an existing system that originally used the older package system, the database must be converted to the new format, so that the new tools are aware of the already installed packages. Once pkg has been installed, the package database must be converted from the traditional format to the new format by running this command: |#| *|pkg2ng|* Note: This step is not required for new installations that do not yet have any third-party software installed. Does it connect with my error somehow ? Durring last freebsd-update there were not any info about new pkg db generation. I do not remember that I had to execute this command. Best regards, Daniel From owner-freebsd-pkg@FreeBSD.ORG Sat Dec 27 10:06:34 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 95D04AF9 for ; Sat, 27 Dec 2014 10:06:34 +0000 (UTC) Received: from sleipnir.msys.ch (smtp.msys.ch [46.175.8.2]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "smtp.msys.ch", Issuer "CAcert Class 3 Root" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 28B07664AE for ; Sat, 27 Dec 2014 10:06:33 +0000 (UTC) Received: from mail.msys.ch (smtp.msys.ch [46.175.8.2]) by sleipnir.msys.ch (8.14.3/8.14.3) with ESMTP id sBRA6NSL010919 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Sat, 27 Dec 2014 11:06:23 +0100 (CET) Received: from [46.175.8.84] ([46.175.8.84]) (authenticated bits=0) by mail.msys.ch (8.14.3/8.14.3) with ESMTP id sBRA6M6h002840 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Sat, 27 Dec 2014 11:06:22 +0100 (CET) From: Marc Balmer Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: libintl missing on FreeBSD 10.1 system Message-Id: <46D06ACB-6726-46A2-9CED-98437B72BC6A@msys.ch> Date: Sat, 27 Dec 2014 11:06:10 +0100 To: freebsd-pkg@freebsd.org Mime-Version: 1.0 (Mac OS X Mail 8.1 \(1993\)) X-Mailer: Apple Mail (2.1993) X-SMTP-Vilter-Version: 1.3.6 X-Spamd-Symbols: AWL,RCVD_IN_SORBS_WEB X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 27 Dec 2014 10:06:34 -0000 I am trying to compile a piece of software on FreeBSD 10.1 that includes = a PostgreSQL server header file, which tries to include libintl.h. I = have the gettext package installed, but this libintl.h header file is = missing: In file included from = /usr/local/include/postgresql/server/postgres.h:47: /usr/local/include/postgresql/server/c.h:101:10: fatal error: = 'libintl.h' file not found #include ^ 1 error generated. *** Error code 1 Which package doese provide this file? Thanks, Marc From owner-freebsd-pkg@FreeBSD.ORG Sat Dec 27 10:59:08 2014 Return-Path: Delivered-To: freebsd-pkg@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 7B14C4DB for ; Sat, 27 Dec 2014 10:59:08 +0000 (UTC) Received: from smtp.infracaninophile.co.uk (smtp6.infracaninophile.co.uk [IPv6:2001:8b0:151:1:3cd3:cd67:fafa:3d78]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "smtp.infracaninophile.co.uk", Issuer "ca.infracaninophile.co.uk" (not verified)) by mx1.freebsd.org (Postfix) with ESMTPS id 1CEDC66CBA for ; Sat, 27 Dec 2014 10:59:07 +0000 (UTC) Received: from seedling.black-earth.co.uk (seedling.black-earth.co.uk [81.2.117.99]) (authenticated bits=0) by smtp.infracaninophile.co.uk (8.15.1/8.15.1) with ESMTPSA id sBRAwpfq036491 (version=TLSv1.2 cipher=DHE-RSA-AES128-SHA bits=128 verify=NO) for ; Sat, 27 Dec 2014 10:58:59 GMT (envelope-from m.seaman@infracaninophile.co.uk) Authentication-Results: smtp.infracaninophile.co.uk; dmarc=none header.from=infracaninophile.co.uk DKIM-Filter: OpenDKIM Filter v2.9.2 smtp.infracaninophile.co.uk sBRAwpfq036491 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=infracaninophile.co.uk; s=201001-infracaninophile; t=1419677939; bh=KBZOOh+En/rxERkDCyiiS1oPjg7TBZ+10nDTDQ+Dpio=; h=Date:From:To:Subject:References:In-Reply-To; z=Date:=20Sat,=2027=20Dec=202014=2010:58:35=20+0000|From:=20Matthew =20Seaman=20|To:=20freebsd-pkg@fr eebsd.org|Subject:=20Re:=20libintl=20missing=20on=20FreeBSD=2010.1 =20system|References:=20<46D06ACB-6726-46A2-9CED-98437B72BC6A@msys .ch>|In-Reply-To:=20<46D06ACB-6726-46A2-9CED-98437B72BC6A@msys.ch> ; b=fQgzYW45LeTqG+tyxJhHqbtIldg0ib9YxueTvSeRBLEqk1fw3ZKG3FcC5lnUDJnw2 5VBZOeFM39aTFOmhDTpbtH3n6ONyb3VGErgEkXkGGFzk5hunEyoE2j0ohtwQsf/st3 +sqIl3D+M8bCAdPlTcQ1hC6RPFyGkfQ106kDvwyQ= Message-ID: <549E90DB.3000501@infracaninophile.co.uk> Date: Sat, 27 Dec 2014 10:58:35 +0000 From: Matthew Seaman User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10; rv:31.0) Gecko/20100101 Thunderbird/31.3.0 MIME-Version: 1.0 To: freebsd-pkg@freebsd.org Subject: Re: libintl missing on FreeBSD 10.1 system References: <46D06ACB-6726-46A2-9CED-98437B72BC6A@msys.ch> In-Reply-To: <46D06ACB-6726-46A2-9CED-98437B72BC6A@msys.ch> OpenPGP: id=E1ECF9BB Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="tt3qCckNxa5PlFTAGPopN0drntXAJko99" X-Virus-Scanned: clamav-milter 0.98.5 at lucid-nonsense.infracaninophile.co.uk X-Virus-Status: Clean X-Spam-Status: No, score=-2.5 required=5.0 tests=ALL_TRUSTED,AWL,BAYES_00, DKIM_SIGNED,DKIM_VALID,DKIM_VALID_AU,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.0 X-Spam-Checker-Version: SpamAssassin 3.4.0 (2014-02-07) on lucid-nonsense.infracaninophile.co.uk X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 27 Dec 2014 10:59:08 -0000 This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --tt3qCckNxa5PlFTAGPopN0drntXAJko99 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable On 27/12/2014 10:06, Marc Balmer wrote: > I am trying to compile a piece of software on FreeBSD 10.1 that include= s a PostgreSQL server header file, which tries to include libintl.h. I h= ave the gettext package installed, but this libintl.h header file is miss= ing: >=20 > In file included from /usr/local/include/postgresql/server/postgres.h:4= 7: > /usr/local/include/postgresql/server/c.h:101:10: fatal error: 'libintl.= h' file > not found > #include > ^ > 1 error generated. > *** Error code 1 >=20 > Which package doese provide this file? This is more a question for freebsd-ports@ rather than this mailing list, but wotthehell, wotthehell. lucid-nonsense:~:% pkg which /usr/local/include/libintl.h /usr/local/include/libintl.h was installed by package gettext-runtime-0.1= 9.3 Hmmm.... although neither postgresql client nor server have any dependency on gettext-runtime themselves (at least, not on my systems, but then I do have 'OPTIONS_UNSET=3D NLS X11' in my poudriere instance.) Cheers, Matthew --=20 Dr Matthew J Seaman MA, D.Phil. PGP: http://www.infracaninophile.co.uk/pgpkey JID: matthew@infracaninophile.co.uk --tt3qCckNxa5PlFTAGPopN0drntXAJko99 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG/MacGPG2 v2.0.20 (Darwin) iQJ8BAEBCgBmBQJUnpDrXxSAAAAAAC4AKGlzc3Vlci1mcHJAbm90YXRpb25zLm9w ZW5wZ3AuZmlmdGhob3JzZW1hbi5uZXQ2NTNBNjhCOTEzQTRFNkNGM0UxRTEzMjZC QjIzQUY1MThFMUE0MDEzAAoJELsjr1GOGkAT6EYP/ixqhljia7rIHQU1+ylGiniY F9JhHawqTldROGhP0UrLpLNQ38hRppwENSYNzqQ3zBp+AVQZ36BsWRUzCoO494E6 nPeTCW3hzuePB3zh5TnYPBQRVtK3SCCl7HXRUgEUhbX3jI6ZlWRgTsMQU2+tGQ0b oM008j+eQX+KTRTgZ66+8n1/U8Q1wgY9n1NZxAWNgVBwJA0cSxED4ite0bT7suAj KHCzir9CXFV8NlSu9zPx+pFNzesbjTR5zvglSau35RUJH8DATXMQrQQGR80QHMbL lLFjipt41xHui3fdbpK5nKb+0yxvXXUl/jy7aMxvmn+wFo2M7pSDM1HspY74BnXF xe3bwQucZJbwzpl12x0hxnxQZ87JG6C66j6wde7OhWW5sIdFlte6WJt4uaDwgV7V 9vVxgSh4dBzJikVR/7YtNJb0ahfg2I5+fT+9ldX3clymxyU28DBUB21dZ2Q35KlM UeoMdWCpYNim0002MM82KG9MQqKZu1JwOMXzDRLzZXnZj8j6B9AQ1KxNTe2CA5RJ dyD/dNLiLDae2XPK1Z9jHwORcCAqGX7auDfElAr0PRDebgtNBcs/ucok6gPyebPc L6zHDsl6WAE0kHcYPXWuCYipWbjtppotTre7GYM+mT0MM87tZZjci3jq+PQiOKZB moVZgFaAorr8pBc+uOjk =kTVY -----END PGP SIGNATURE----- --tt3qCckNxa5PlFTAGPopN0drntXAJko99-- From owner-freebsd-pkg@FreeBSD.ORG Sat Dec 27 13:12:53 2014 Return-Path: Delivered-To: pkg@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 83E6DC45 for ; Sat, 27 Dec 2014 13:12:53 +0000 (UTC) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 6B053641FF for ; Sat, 27 Dec 2014 13:12:53 +0000 (UTC) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.14.9/8.14.9) with ESMTP id sBRDCr4Q083513 for ; Sat, 27 Dec 2014 13:12:53 GMT (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: pkg@FreeBSD.org Subject: [Bug 195471] ports-mgmt/pkg: pkg install [upgrade]l [most ports] tries to pull in unrelated ports... consistently Date: Sat, 27 Dec 2014 13:12:53 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports Tree X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Some People X-Bugzilla-Who: jbtakk@iherebuywisely.com X-Bugzilla-Status: New X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: pkg@FreeBSD.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.18-1 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sat, 27 Dec 2014 13:12:53 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=195471 --- Comment #4 from J. B. --- v9 > v10 "pkg install" seems to work okay. ... despite installing gnomehier that has already been deprecated AND removed from the ports tree... probably as a dependency -PP portupgrade )) works fine, sometimes does not find the pkg, pkg fetch finds it... [maybe also see pair of emails dec 26-27 2014 to the ports@freebsd.org list] I would suggest if resources allow using a pre-pkg v9 system, pkg2ng it, and test for this PR to resolve where it may still happen. Then the bug there could maybe be solved in pkg (all versions) so that it does not appear again, say, in v 11 or v 12... Additionally, updating a v9 > v10 pkg files and usage and reinstall of pkg only eventually worked because I had a working v10 from which to synchronize "repos" "etc/pkg" "/usr/local/etc/pkg*" files until the errors dissipated. Maybe a wiki or pkg-message or pkg-check-lines-of-files could make that use case simpler for new installs, etc... [ not to mention the 'key' files ] and be also put into the wiki and man page(s) ... sort of like a 'sysinstall but just for pkg files and parameters...' Hopefully my last entry to this PR since I am mostly running V10... -- You are receiving this mail because: You are the assignee for the bug.