From owner-freebsd-questions@freebsd.org Tue Aug 25 13:12:52 2015 Return-Path: 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 8AA9C99A7C9 for ; Tue, 25 Aug 2015 13:12:52 +0000 (UTC) (envelope-from fernando.apesteguia@gmail.com) Received: from mail-qk0-x230.google.com (mail-qk0-x230.google.com [IPv6:2607:f8b0:400d:c09::230]) (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 4985DEBD for ; Tue, 25 Aug 2015 13:12:52 +0000 (UTC) (envelope-from fernando.apesteguia@gmail.com) Received: by qkch123 with SMTP id h123so93874655qkc.0 for ; Tue, 25 Aug 2015 06:12:51 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type:content-transfer-encoding; bh=S8jbnnOo7IuNltANc96KYMOttweY6MqRsasfvSJS4Kk=; b=AyrgJTF2dSJDsTvsTNQxoDsRYkZI8BcspjcDUYFhSx1tf07oIzSLZniOV9dEzRJTh6 QWTpZgdhCZWrqsCbPnQKtDimWBprhNZFvYQqpvCW62TKjgGGxGMkb93iR6G5O4M1T5pk 3ElbGyQu4FonBLXYUwho7VBa+HtJHW0cEY5wWZPVcGqxThYxEGqtos0GqTpOuaEm7for WS2c6H0BEvu7Hr34aSxjG/SZStPH5Q0ACYEQyIkXSa2t1NZvjIMVHtcZsKd2NoIz079q LTlgahssCm8d88JgBpVaHUCuYSXccC1GjPdZ0GloxGPoHBdmq4D7pWg39VlzIEB+o2sy 1Hug== MIME-Version: 1.0 X-Received: by 10.55.23.219 with SMTP id 88mr5690199qkx.19.1440508371117; Tue, 25 Aug 2015 06:12:51 -0700 (PDT) Received: by 10.55.182.65 with HTTP; Tue, 25 Aug 2015 06:12:51 -0700 (PDT) In-Reply-To: References: Date: Tue, 25 Aug 2015 15:12:51 +0200 Message-ID: Subject: Re: pkg Assertion failed. Help needed. From: =?UTF-8?Q?Fernando_Apestegu=C3=ADa?= To: User Questions Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-BeenThere: freebsd-questions@freebsd.org X-Mailman-Version: 2.1.20 Precedence: list List-Id: User questions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 25 Aug 2015 13:12:52 -0000 On Mon, Aug 24, 2015 at 6:15 PM, Fernando Apestegu=C3=ADa wrote: > 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]: [ENTE= R] ^^^^^ It seems I missed the note in UPDATING about db* ports. It's fixed now. > Checking for upgrades (948 candidates): 100% > Processing candidates (948 candidates): 100% > pkg-static: sqlite error while executing UPDATE packages SET name=3D?1 > WHERE name=3D?2; in file pkg_jobs.c:1658: UNIQUE constraint failed: > packages.name > Checking integrity...Assertion failed: (strcmp(uid, p->uid) !=3D 0), > function pkg_conflicts_check_local_path, file pkg_jobs_conflicts.c, > line 368. > Child process pid=3D1106 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.