From owner-freebsd-questions@freebsd.org  Mon Aug 24 16:15:20 2015
Return-Path: <owner-freebsd-questions@freebsd.org>
Delivered-To: freebsd-questions@mailman.ysv.freebsd.org
Received: from mx1.freebsd.org (mx1.freebsd.org
 [IPv6:2001:1900:2254:206a::19:1])
 by mailman.ysv.freebsd.org (Postfix) with ESMTP id 6F9AA9C1D46
 for <freebsd-questions@mailman.ysv.freebsd.org>;
 Mon, 24 Aug 2015 16:15:20 +0000 (UTC)
 (envelope-from fernando.apesteguia@gmail.com)
Received: from mail-qk0-x22b.google.com (mail-qk0-x22b.google.com
 [IPv6:2607:f8b0:400d:c09::22b])
 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
 (Client CN "smtp.gmail.com",
 Issuer "Google Internet Authority G2" (verified OK))
 by mx1.freebsd.org (Postfix) with ESMTPS id 30EFEC53
 for <freebsd-questions@freebsd.org>; Mon, 24 Aug 2015 16:15:20 +0000 (UTC)
 (envelope-from fernando.apesteguia@gmail.com)
Received: by qkda128 with SMTP id a128so24610220qkd.3
 for <freebsd-questions@freebsd.org>; Mon, 24 Aug 2015 09:15:19 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113;
 h=mime-version:date:message-id:subject:from:to:content-type;
 bh=oZYgBjcuQmclW+9k60AwK/iPWPdTfBpypmJCGN259Ys=;
 b=YJz1SRYMi1UDGJJaM7LktqQEet40bwZENuePJPSekUfd742GEY1SVbHflz3RjneL6e
 2jOF7AJifoypDMUQRBBy6TetoxHgLOVzH2rnt4nhhV3lGYTqbCG8P7yJj02wkaEGH3zJ
 izZ6ebtnXlwZ9EJ5fcIc01UoeHL6WxFQWhbLuXmdb2ylW6FBxJFUTnBi+b5HgvYs+ZG7
 iMZLmnQeo2kBnTy7Tz7OxT0eS7GH3s/bP0+FtMq88cJtEh+Q9WdKKQbQOJwqNdH6yI5w
 JTPfugWg0489eHcvGoevf+WHOa8mS00YKDDRfn1N5YkSrcTcjEzP7T+YChxXMUOZB0KP
 ueKw==
MIME-Version: 1.0
X-Received: by 10.55.217.218 with SMTP id q87mr7279559qkl.56.1440432918926;
 Mon, 24 Aug 2015 09:15:18 -0700 (PDT)
Received: by 10.55.182.65 with HTTP; Mon, 24 Aug 2015 09:15:18 -0700 (PDT)
Date: Mon, 24 Aug 2015 18:15:18 +0200
Message-ID: <CAGwOe2YDhk+NFuqG2b4+Am7FDNYbcAAuUTw4ez+Ud+zQBXg7nA@mail.gmail.com>
Subject: pkg Assertion failed. Help needed.
From: =?UTF-8?Q?Fernando_Apestegu=C3=ADa?= <fernando.apesteguia@gmail.com>
To: User Questions <freebsd-questions@freebsd.org>
Content-Type: text/plain; charset=UTF-8
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.20
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <https://lists.freebsd.org/mailman/options/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions/>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <https://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
 <mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Mon, 24 Aug 2015 16:15:20 -0000

Hi there,

I'm in the process of upgrading to 10.2-RELEASE in on of my machines.
The base system is already updated. Although it is not strictly
necessary (I upgrade from 10.1-RELEASE), I wanted to reinstall all
packages as well.

When I try to do it, I get the following errors:

$ pkg-static upgrade -f
Updating FreeBSD repository catalogue...
FreeBSD repository is up-to-date.
All repositories are up-to-date.
Checking for upgrades (948 candidates):  90%
db41 has no direct installation candidates, change it to db? [Y/n]: [ENTER]
Checking for upgrades (948 candidates): 100%
Processing candidates (948 candidates): 100%
pkg-static: sqlite error while executing UPDATE packages SET name=?1
WHERE name=?2; in file pkg_jobs.c:1658: 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 368.
Child process pid=1106 terminated abnormally: Abort trap
$

I haven't had problems so far while installing/deinstalling packages,
but I suppose I was just "lucky" enough so the problem didn't show up
earlier. It seems my sqlite package database is corrupt.

Any ideas on how to fix this?

Thanks in advance.