From owner-freebsd-current@freebsd.org Thu Aug 29 00:09:59 2019 Return-Path: Delivered-To: freebsd-current@mailman.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.nyi.freebsd.org (Postfix) with ESMTP id 1B3D1EA4ED for ; Thu, 29 Aug 2019 00:09:59 +0000 (UTC) (envelope-from rysto32@gmail.com) Received: from mail-qk1-x72c.google.com (mail-qk1-x72c.google.com [IPv6:2607:f8b0:4864:20::72c]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) server-signature RSA-PSS (4096 bits) client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1O1" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 46JjfZ6Dlvz3wrX; Thu, 29 Aug 2019 00:09:58 +0000 (UTC) (envelope-from rysto32@gmail.com) Received: by mail-qk1-x72c.google.com with SMTP id g17so1411736qkk.8; Wed, 28 Aug 2019 17:09:58 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=UM+hmNdb7Jkqc0gaq2F14HJV99OXFxYpsJ6TM3pHyUA=; b=TRMKznAS5/AvSuD0Z6NioJaJ1aDmjPy05KlK24p79+kqX7mlSNYlszwOxdKkfEyxEU b55qsDVjvtgB/UYPRVZduqCukP82EbQGTl92RohWFffHW8WOMAsmBKDizzdeyGtqBb2B 4x6zY++EEgK3hZea5TMIOyU9C7Fg4dagusBae2eoTXYVzibTbq/xOU3yNTc/fWF+zIA6 wSCpJakpQ37USRIs5ukKAcONgHscsCBx8e60mW6/5lr+KnM+glQLwiP5z5rbWYrrhkWJ TliYTIvonOjBU995XCPpifkLydQBsnkz2P6zE1bRLKpW3m/xfx170BIzCO0pQcVeP3xo g0BQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=UM+hmNdb7Jkqc0gaq2F14HJV99OXFxYpsJ6TM3pHyUA=; b=bFb9Gvn9jZrIbnDZDZ0YQOZJJrk74ZmpqNfsJR6xxYN5h0wwsxYpeqK6v8CSNHs7gN gMoYNG7YddX2WGZ6RRcM1cYkQmFvPp9TTAFGzHZqTiCmfktPw2yF8HR5lC9U9n4MsDb+ eQT85P2gJ8MQO73UuxYb9+oL+9Be98N4CooqkQQtOoPiuRpt4FyHoIqLEDlVxsntXaps GrQ2eECGbmg3ZIkpM86SdULgonJk5anUy/tqJFLWXvFLz8SI2vthImKzCFvvqfQzLdt0 4dZbBq2uc8euX91VResSQMO1knreZ+NDA+x1d94Qywe68LocBpBnTctowwwcuJqNGq5D 73WQ== X-Gm-Message-State: APjAAAWR7udmAoU42/Pt0dmC4yAk+E1vqcPm90QEVgSg+NO5lcuXZfZo n4qwKcWsICe3XZH5ow8559CJEF96inEbJe1c1BBhBaIf X-Google-Smtp-Source: APXvYqw6g03VqHBopMVSoajNJisYDT1qmF0YUiDdIJJTs95Kchv3SEZR3srvJleiW5jW71CpViRMGlkPkJQpIgNGGOY= X-Received: by 2002:a37:a843:: with SMTP id r64mr5868252qke.363.1567037396903; Wed, 28 Aug 2019 17:09:56 -0700 (PDT) MIME-Version: 1.0 References: <20190828212021.GA66282@in-addr.com> In-Reply-To: From: Ryan Stone Date: Wed, 28 Aug 2019 20:09:45 -0400 Message-ID: Subject: Re: Lost user database after bungled upgrade To: Ian Lepore Cc: FreeBSD Current Content-Type: text/plain; charset="UTF-8" X-Rspamd-Queue-Id: 46JjfZ6Dlvz3wrX X-Spamd-Bar: ------ Authentication-Results: mx1.freebsd.org; none X-Spamd-Result: default: False [-6.99 / 15.00]; NEURAL_HAM_MEDIUM(-1.00)[-0.999,0]; NEURAL_HAM_LONG(-1.00)[-1.000,0]; REPLY(-4.00)[]; NEURAL_HAM_SHORT(-0.99)[-0.988,0] X-BeenThere: freebsd-current@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Discussions about the use of FreeBSD-current List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 29 Aug 2019 00:09:59 -0000 On Wed, Aug 28, 2019 at 6:40 PM Ian Lepore 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.