From nobody Tue Aug 30 16:36:52 2022 X-Original-To: freebsd-ports@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4MHCf12xv9z4Zrwn for ; Tue, 30 Aug 2022 16:37:45 +0000 (UTC) (envelope-from kob6558@gmail.com) Received: from mail-il1-x12e.google.com (mail-il1-x12e.google.com [IPv6:2607:f8b0:4864:20::12e]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "GTS CA 1D4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4MHCf02CX5z46Jx for ; Tue, 30 Aug 2022 16:37:44 +0000 (UTC) (envelope-from kob6558@gmail.com) Received: by mail-il1-x12e.google.com with SMTP id h14so4563672ilh.10 for ; Tue, 30 Aug 2022 09:37:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=to:subject:message-id:date:from:mime-version:from:to:cc; bh=ZoiLsco/Ok8jbYvCpWRBoSO+WYJRK8hfUum1qGDnRZw=; b=YlkbQQOPGY5aWAkBbrlbom6QgYiylWA7R114ggQosMOKZG6500FGYkMZpDgkQ4iexI 1Ij3px5ppkEC0VqODKa2Qdc/m9WGo3AR0uCaxR+u/byrLEDhoxjMh/bR8kwCqjQ02SpE 2/Ch6vnDnFCmPaHXIcmsLFY/iuKwDaibmrYAdQnLC+T6WMM1R6BOIJlMiZHXOGaUlAgl 8o/CO9dbfnkcmhSEUVZrYsoRcSpt2hXCEEGJcmuhgmSWI67UXmq1vWcROe0xh4YSo9EQ aOt/nPrAPjWn4OSPcbGA1M6FFlQUjLPgVSwjKVpE7OutnzN4XJJRwkabkxV7Jg5G8nwT 1PPA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc; bh=ZoiLsco/Ok8jbYvCpWRBoSO+WYJRK8hfUum1qGDnRZw=; b=eqzXEX/vWgSnHi+hErym8QRG4s3ZeTUjP++RGCJyy+UdHD+EcvXBqXGbbS6htER7Ns sVSVN4Z2tGW+E5ii2N6jZXsJB+Dnw0T5kOoG6fdEq+JhBVu4z0mWO5diVKQNH2eHBDrU 3e7D6vGgmZZIaAPv/ELm0tEb6JAQcdac4rteRb9IW1d0mQlXPnJUNoSSdHbGQdB0Lc/a h/m8JhUfxudYVJwZknfJIAjqlasP4il/qBMdlIA078C4ZpuAM5q4fe9VyBWNvfjLszID FAgJdaigTTpmn3H8ZIjoxV+al6ssVfShIQ/YAxL1+ifjoymEoQRHAKTRQ03i/xxy/2rW AwbA== X-Gm-Message-State: ACgBeo0rx8W2B0arcvuK+HS51PKS6Cbq8CghVvJhqhHiOFDF2Sjy5xRa lynudxPElFKHTkdQUminK4xRZC2JSJ+nWl42QM/ikXJDBts= X-Google-Smtp-Source: AA6agR4eLSq6SpEYgigzO7xfTKvP4ZB/I3ds0ofNRfqiyIrI2vzSuyE+44ZES3Uam6koUisWe4u3l+AZ1+WOGE/AKnQ= X-Received: by 2002:a92:cd84:0:b0:2e5:cecc:6595 with SMTP id r4-20020a92cd84000000b002e5cecc6595mr12731346ilb.248.1661877463228; Tue, 30 Aug 2022 09:37:43 -0700 (PDT) List-Id: Porting software to FreeBSD List-Archive: https://lists.freebsd.org/archives/freebsd-ports List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org MIME-Version: 1.0 From: Kevin Oberman Date: Tue, 30 Aug 2022 09:36:52 -0700 Message-ID: Subject: Recover from a corrupt pkg DB To: FreeBSD Ports ML Content-Type: multipart/alternative; boundary="000000000000db27a205e777ff64" X-Rspamd-Queue-Id: 4MHCf02CX5z46Jx X-Spamd-Bar: --- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20210112 header.b=YlkbQQOP; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of kob6558@gmail.com designates 2607:f8b0:4864:20::12e as permitted sender) smtp.mailfrom=kob6558@gmail.com X-Spamd-Result: default: False [-3.66 / 15.00]; NEURAL_HAM_SHORT(-1.00)[-0.998]; NEURAL_HAM_MEDIUM(-0.99)[-0.993]; NEURAL_HAM_LONG(-0.97)[-0.967]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; FORGED_SENDER(0.30)[rkoberman@gmail.com,kob6558@gmail.com]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20210112]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36:c]; MIME_GOOD(-0.10)[multipart/alternative,text/plain]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::12e:from]; PREVIOUSLY_DELIVERED(0.00)[freebsd-ports@freebsd.org]; FROM_HAS_DN(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; TO_MATCH_ENVRCPT_ALL(0.00)[]; ARC_NA(0.00)[]; FROM_NEQ_ENVFROM(0.00)[rkoberman@gmail.com,kob6558@gmail.com]; MLMMJ_DEST(0.00)[freebsd-ports@freebsd.org]; TO_DN_ALL(0.00)[]; MID_RHS_MATCH_FROMTLD(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim]; DKIM_TRACE(0.00)[gmail.com:+]; MIME_TRACE(0.00)[0:+,1:+,2:~]; RCVD_TLS_LAST(0.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; FREEMAIL_ENVFROM(0.00)[gmail.com]; RCVD_COUNT_TWO(0.00)[2] X-ThisMailContainsUnwantedMimeParts: N --000000000000db27a205e777ff64 Content-Type: text/plain; charset="UTF-8" I had a crash while building ffmpeg on a new system. The build had not begun, so I don't think ffmpeg is really an issue. portmaster(8) was walking the dependency tree when the system panicked and, after a reboot and full fsck, I get the error: pkg: sqlite error while executing PRAGMA user_version; in file pkgdb.c:2357: database disk image is malformed Is there any way to rebuild the DB or, if not, how do I remove it and start from scratch? -- Kevin Oberman, Part time kid herder and retired Network Engineer E-mail: rkoberman@gmail.com PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683 --000000000000db27a205e777ff64 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

I had a crash = while building ffmpeg on a new system. The build had not begun, so I don= 9;t think ffmpeg is really an issue. portmaster(8) was walking the dependen= cy tree when the system panicked and, after a reboot and full fsck, I get t= he error:
pkg: sqlite error while executing PRAGMA user_vers= ion; in file pkgdb.c:2357: database disk image is malformed
=
Is there any way to rebuild the DB or, if not, how do I= remove it and start from scratch?
--
Kevin Oberm= an, Part time kid herder and retired Network Engineer
E-mail: rkoberman@gmail.com
<= /div>
PGP Fingerprint: D03FB98AFA78E3B78C1694B318AB39EF1B055683
--000000000000db27a205e777ff64--