From nobody Wed Jul 26 18:24:33 2023 X-Original-To: freebsd-questions@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 4RB2PC5h1Kz4nx02 for ; Wed, 26 Jul 2023 18:24:47 +0000 (UTC) (envelope-from olivares14031@gmail.com) Received: from mail-pj1-x102a.google.com (mail-pj1-x102a.google.com [IPv6:2607:f8b0:4864:20::102a]) (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 4RB2PB4KTdz42DX for ; Wed, 26 Jul 2023 18:24:46 +0000 (UTC) (envelope-from olivares14031@gmail.com) Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20221208 header.b=Tj39Nl4z; spf=pass (mx1.freebsd.org: domain of olivares14031@gmail.com designates 2607:f8b0:4864:20::102a as permitted sender) smtp.mailfrom=olivares14031@gmail.com; dmarc=pass (policy=none) header.from=gmail.com Received: by mail-pj1-x102a.google.com with SMTP id 98e67ed59e1d1-26837895fbbso111805a91.3 for ; Wed, 26 Jul 2023 11:24:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1690395884; x=1691000684; h=to:subject:message-id:date:from:mime-version:from:to:cc:subject :date:message-id:reply-to; bh=astN6A/YtO9FbPMcaDL61QTWhhf3kSqxQ/ko80or5JI=; b=Tj39Nl4zabF+7GphR4eP1Wq1HJYXdKw0E/wMCN75AK17csSGw0SqJPGxpGwC5l2Kru Xta7B8BYHj83qEY+w60M4DfnCWl27geNPZUry2KDP9SVhnHFegrF8y0363sTQBjJkgcj +MKAsXGB/t+LrN3gH6nNijQFU80FL4JXI3XuUbxDHV+hX6kofhwgOPh6GPT36jcU37/u XzMCejJi8V3MYU45FDIMBhceoASq9FysJpJ6AgQekBBJegEpvFL0KMUar5ZLCQfs/dmm TjlfscXl+/P2hj9bRVwvhcf79jXR1FVT+DunvWbsCSyihBhxyV9o7UVD59IdEzXe6b1F OsBA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1690395884; x=1691000684; h=to:subject:message-id:date:from:mime-version:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=astN6A/YtO9FbPMcaDL61QTWhhf3kSqxQ/ko80or5JI=; b=X81xUY8dUIE/xnKPz9HY1majNzySFaSZ0w8hyzu+kp7jQpbAOElvEW4iHyImSyEipS qgMY5VaeDp5bY/PHxf3IrfN5kP3HEU4KTOJaBI/9f0hAQbYwHnLJ8dC9GJjrCkz7xxSj OuLjRG3A/hpltP802k6dADrwrnWfC0O4Bm8B0yLdRuhdZm+mHvW94LtjOCSYZfyphkow ULy7ro+DbmxI1vCP8bB268oqBhmZ+gwNY5vGskjY3JN/z5WhwqQkPMV3Z2E2D43f+Dxs pdSkCfVy8XkgZewPJQt0VR3BB/x3WEPIYSj+1ZQMivCQVTjFZSIY8ACXx9sP7Akd47A1 vAIg== X-Gm-Message-State: ABy/qLa1au9CZYll/0D5pQGSVKgQhAXbmitLnefRYndoTiTcZrVXtbER nioHtywXv4whZLRE8GarInnLgYYkZOYw6QlinBsrXEwkCc4= X-Google-Smtp-Source: APBJJlFmyG1ZKcM+5nhlO9xhw65Kcb/TvQ/q9ALAx6RuYZG2pbQAwjspUUWHyWpuNKfDLB7/5iUQcQUMYIveHsAUnIQ= X-Received: by 2002:a17:90a:38e5:b0:262:ee7d:2d20 with SMTP id x92-20020a17090a38e500b00262ee7d2d20mr2824843pjb.12.1690395884553; Wed, 26 Jul 2023 11:24:44 -0700 (PDT) List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-questions@freebsd.org X-BeenThere: freebsd-questions@freebsd.org MIME-Version: 1.0 From: Antonio Olivares Date: Wed, 26 Jul 2023 13:24:33 -0500 Message-ID: Subject: pkg: sqlite error while executing INSERT OR REPLACE INTO packages To: FreeBSD Questions Content-Type: text/plain; charset="UTF-8" X-Spamd-Result: default: False [-3.71 / 15.00]; NEURAL_HAM_SHORT(-1.00)[-0.995]; NEURAL_HAM_LONG(-0.96)[-0.956]; NEURAL_HAM_MEDIUM(-0.76)[-0.761]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20221208]; MIME_GOOD(-0.10)[text/plain]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; FROM_EQ_ENVFROM(0.00)[]; MIME_TRACE(0.00)[0:+]; RCVD_IN_DNSWL_NONE(0.00)[2607:f8b0:4864:20::102a:from]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; FREEMAIL_ENVFROM(0.00)[gmail.com]; RCVD_TLS_LAST(0.00)[]; TO_DN_ALL(0.00)[]; RCVD_COUNT_TWO(0.00)[2]; FREEMAIL_FROM(0.00)[gmail.com]; FROM_HAS_DN(0.00)[]; ARC_NA(0.00)[]; DKIM_TRACE(0.00)[gmail.com:+]; TO_MATCH_ENVRCPT_ALL(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; MID_RHS_MATCH_FROMTLD(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com:dkim] X-Rspamd-Queue-Id: 4RB2PB4KTdz42DX X-Spamd-Bar: --- Dear FreeBSD users, I have updated an old machine from 13.1 to 13.2 RELEASE successfully updated packages as well. I ran pkg upgrade and I run into error on subject line. How can I fix this? THanks in advace root@coolermaster:~ # pkg clean Nothing to do. root@coolermaster:~ # pkg update Updating FreeBSD repository catalogue... FreeBSD repository is up to date. All repositories are up to date. root@coolermaster:~ # pkg upgrade Updating FreeBSD repository catalogue... FreeBSD repository is up to date. All repositories are up to date. Checking for upgrades (7 candidates): 100% Processing candidates (7 candidates): 100% Checking integrity... done (0 conflicting) The following 3 package(s) will be affected (of 0 checked): Installed packages to be UPGRADED: firefox-esr: 102.13.0,1 -> 102.14.0,1 llvm13: 13.0.1_3 -> 13.0.1_4 llvm15: 15.0.7_4 -> 15.0.7_5 Number of packages to be upgraded: 3 Proceed with this action? [y/N]: y [1/3] Upgrading llvm13 from 13.0.1_3 to 13.0.1_4... pkg: sqlite error while executing INSERT OR REPLACE INTO packages( origin, name, version, comment, desc, message, arch, maintainer, www, prefix, flatsize, automatic, licenselogic, time, manifestdigest, dep_formula, vital)VALUES( 'devel/llvm13', 'llvm13', '13.0.1_4', 'LLVM and Clang', 'The LLVM Project is a collection of modular and reusable compiler and toolchain technologies. This port includes Clang (a C/C++/Objective-C compiler), LLD (a linker), LLDB (a debugger), an OpenMP runtime library, and the LLVM infrastructure these are built on. WWW: https://llvm.org/', NULL, 'FreeBSD:13:amd64', 'brooks@FreeBSD.org', 'https://llvm.org/', '/usr/local', 1489141387, 1, 38, NOW(), '2$2$9qhfm9hkp49p6x6rcsnwihbimh7thmks8j88837zpz7qs9jjqogqfp37ge93nogz8bcezexxmd4cn33jcakncm38dgyokdmtrfr6ykn', NULL, 0 ) in file pkgdb.c:1633: database disk image is malformed root@coolermaster:~ # Best Regards, Antonio