Skip site navigation (1)Skip section navigation (2)
Date:      Wed, 28 Aug 2019 20:09:45 -0400
From:      Ryan Stone <rysto32@gmail.com>
To:        Ian Lepore <ian@freebsd.org>
Cc:        FreeBSD Current <freebsd-current@freebsd.org>
Subject:   Re: Lost user database after bungled upgrade
Message-ID:  <CAFMmRNxF6MzZpxeqC5GgZQOovSy2sE2U4qQgZyHM%2BocZ2dYsNQ@mail.gmail.com>
In-Reply-To: <c09e3441f303cf5c95a48a7ac6c1add9b4e53e51.camel@freebsd.org>
References:  <CAFMmRNy4aj7A0aqrKEpjYzP1TW_h7cUDp2Gm%2BnABD=H01FxFzA@mail.gmail.com> <20190828212021.GA66282@in-addr.com> <CAFMmRNy40KG0QcFMmx9e2BKeWPb_3yKtoJa9jddYotGQ6jwD0Q@mail.gmail.com> <c09e3441f303cf5c95a48a7ac6c1add9b4e53e51.camel@freebsd.org>

next in thread | previous in thread | raw e-mail | index | archive | help

On Wed, Aug 28, 2019 at 6:40 PM Ian Lepore <ian@freebsd.org> wrote:
> Or maybe in your case the files are fine and it really is a uid
> problem.  But a "pkg check -s -a" as suggested in the PR couldn't hurt.
> :)

I did have some problems here, but unfortunately re-installing the
affected packages (and confirming that a subsequent run of pkg check
showed no more problems) didn't resolve my issue.  I'm also seeing
errors like this:

pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
name=?2; in file pkg_jobs.c:1731: UNIQUE constraint
failed: packages.name
pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
name=?2; in file pkg_jobs.c:1731: UNIQUE constraint
failed: packages.name
pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
name=?2; in file pkg_jobs.c:1731: UNIQUE constraint
failed: packages.name
pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
name=?2; in file pkg_jobs.c:1731: UNIQUE constraint
failed: packages.name
pkg: sqlite error while executing UPDATE packages SET name=?1  WHERE
name=?2; in file pkg_jobs.c:1731: UNIQUE constraint
failed: packages.name

So unfortunately it looks like something is corrupted somewhere.



Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CAFMmRNxF6MzZpxeqC5GgZQOovSy2sE2U4qQgZyHM%2BocZ2dYsNQ>