From owner-freebsd-pkg@freebsd.org Sun Apr 21 03:16:02 2019 Return-Path: Delivered-To: freebsd-pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 9C5DA157F30A for ; Sun, 21 Apr 2019 03:16:02 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id E9F59879FA for ; Sun, 21 Apr 2019 03:16:01 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: by mailman.ysv.freebsd.org (Postfix) id AB30D157F308; Sun, 21 Apr 2019 03:16:01 +0000 (UTC) Delivered-To: pkg@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 6EFBE157F306 for ; Sun, 21 Apr 2019 03:16:01 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: from mail-pf1-x42e.google.com (mail-pf1-x42e.google.com [IPv6:2607:f8b0:4864:20::42e]) (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 2869F879F5 for ; Sun, 21 Apr 2019 03:16:00 +0000 (UTC) (envelope-from paulbeard@gmail.com) Received: by mail-pf1-x42e.google.com with SMTP id 10so4179722pfo.5 for ; Sat, 20 Apr 2019 20:16:00 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:subject:message-id:date :to; bh=V7tM4+JmqAs7FvB/Yffrz7/iHKHmbBfkVKm1/fNOPbY=; b=mgAK4/CdAuKGxD4LmHmwu8nESyW7S2nJLlVw4WCbZhhDuRVhfgIezmjEI9eUyU7GRH lDLJ/1g7K9iwWBC0QuaIFvhoYJPgrKBN6yQYEjvqvsY/jviczJHZDnA8LpZtV0woqL5K BU42kSUbNlaAEg+xRjMyceZAk183sYLxccOy2bfg4+1/FTniGvTeSNMwC14WU6dt4ABc RJofGUipqkU3dDby0Lt3VcC2viTlqZEZShKJ4fusW+5afOSoTNq/Sral1/igwyf+fs7r SU2Ds3odNr5VaoRYbaeQ305VZ51NzhId5IdIiaD0nM7NKvio+HEIfh0RaZU8fSSMYUXR qmCQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:message-id:date:to; bh=V7tM4+JmqAs7FvB/Yffrz7/iHKHmbBfkVKm1/fNOPbY=; b=qiF/XeGiPRX06EM4ViPIZk5TVmK2PHajGREZoHoMkcTLot7wf71cp9HEM5YvOA2vwp B507o6ry+0NdR8qiXVhi9EhgZ570hBBwv4DSDGC/aKOwzM2INRE4itKA4UNV349wsqQd noiSW/1ArmmmIlASvWsg6XICIK+CGtbVZhjmPtjbNEh1lSLLIqsk30IdqGC17a/plWpt 8qH3y5MMfrQF/IYcWqpqnJJaK7I6DqJ6pwP8CjWE1UZAZJj+tUh81/HDS1ef2ds23MNE 7hlyVnRGD4x6nI6ftZFfKiBRz1qLitPUJbICnPo0uoG+Ib0hh7tUW7mLpQiUKEa2d81F trtQ== X-Gm-Message-State: APjAAAVUyJPdTZ55kVSXYBfvJzgmdSQnmpNCn+JUK9rvqis0bS15q41R IekzVYOgUMLb5B1iNcffadIfypAG4kM= X-Google-Smtp-Source: APXvYqyY2JQ3RBLdtMX7mFHs90FOLNqI3Pz81oZnsOqEVlhD8+EhgNlghRLEjeuTvacQ2mpXLFO7wA== X-Received: by 2002:a63:28c8:: with SMTP id o191mr10678929pgo.164.1555816558477; Sat, 20 Apr 2019 20:15:58 -0700 (PDT) Received: from [192.168.0.11] (c-24-19-6-72.hsd1.wa.comcast.net. [24.19.6.72]) by smtp.gmail.com with ESMTPSA id p2sm25526285pfi.73.2019.04.20.20.15.57 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sat, 20 Apr 2019 20:15:57 -0700 (PDT) From: Paul Beard Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 12.4 \(3445.104.8\)) Subject: Error: database disk image is malformed Message-Id: Date: Sat, 20 Apr 2019 20:15:56 -0700 To: pkg@freebsd.org X-Mailer: Apple Mail (2.3445.104.8) X-Rspamd-Queue-Id: 2869F879F5 X-Spamd-Bar: ----- Authentication-Results: mx1.freebsd.org; dkim=pass header.d=gmail.com header.s=20161025 header.b=mgAK4/Cd; dmarc=pass (policy=none) header.from=gmail.com; spf=pass (mx1.freebsd.org: domain of paulbeard@gmail.com designates 2607:f8b0:4864:20::42e as permitted sender) smtp.mailfrom=paulbeard@gmail.com X-Spamd-Result: default: False [-5.95 / 15.00]; RCVD_VIA_SMTP_AUTH(0.00)[]; FREEMAIL_FROM(0.00)[gmail.com]; R_SPF_ALLOW(-0.20)[+ip6:2607:f8b0:4000::/36]; MV_CASE(0.50)[]; TO_DN_NONE(0.00)[]; RCVD_COUNT_THREE(0.00)[3]; DKIM_TRACE(0.00)[gmail.com:+]; DMARC_POLICY_ALLOW(-0.50)[gmail.com,none]; MX_GOOD(-0.01)[cached: alt3.gmail-smtp-in.l.google.com]; NEURAL_HAM_SHORT(-0.97)[-0.969,0]; FROM_EQ_ENVFROM(0.00)[]; RCVD_TLS_LAST(0.00)[]; MIME_TRACE(0.00)[0:+]; FREEMAIL_ENVFROM(0.00)[gmail.com]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US]; MID_RHS_MATCH_FROM(0.00)[]; DWL_DNSWL_NONE(0.00)[gmail.com.dwl.dnswl.org : 127.0.5.0]; ARC_NA(0.00)[]; SUBJECT_ENDS_SPACES(0.50)[]; R_DKIM_ALLOW(-0.20)[gmail.com:s=20161025]; NEURAL_HAM_MEDIUM(-1.00)[-1.000,0]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; NEURAL_HAM_LONG(-1.00)[-1.000,0]; MIME_GOOD(-0.10)[text/plain]; PREVIOUSLY_DELIVERED(0.00)[pkg@freebsd.org]; RCPT_COUNT_ONE(0.00)[1]; IP_SCORE(-2.97)[ip: (-9.41), ipnet: 2607:f8b0::/32(-3.13), asn: 15169(-2.26), country: US(-0.06)]; RCVD_IN_DNSWL_NONE(0.00)[e.2.4.0.0.0.0.0.0.0.0.0.0.0.0.0.0.2.0.0.4.6.8.4.0.b.8.f.7.0.6.2.list.dnswl.org : 127.0.5.0] X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 21 Apr 2019 03:16:02 -0000 Is there a fix for this?=20 sqlite> pragma integrity_check; row 1511 missing from index deps_unique row 1 missing from index pkg_shlibs_provided_package_id row 1 missing from index pkg_shlibs_required_package_id row 1 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 2 missing from index pkg_shlibs_required_package_id row 2 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 3 missing from index pkg_shlibs_required_package_id row 3 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 4 missing from index pkg_shlibs_required_package_id row 4 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 5 missing from index pkg_shlibs_required_package_id row 5 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 6 missing from index pkg_shlibs_required_package_id row 6 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 7 missing from index pkg_shlibs_required_package_id row 7 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 8 missing from index pkg_shlibs_required_package_id row 8 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 9 missing from index pkg_shlibs_required_package_id row 9 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 10 missing from index pkg_shlibs_required_package_id row 10 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 11 missing from index pkg_shlibs_required_package_id row 11 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 12 missing from index pkg_shlibs_required_package_id row 12 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 13 missing from index pkg_shlibs_required_package_id row 13 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 14 missing from index pkg_shlibs_required_package_id row 14 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 15 missing from index pkg_shlibs_required_package_id row 15 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 16 missing from index pkg_shlibs_required_package_id row 16 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 17 missing from index pkg_shlibs_required_package_id row 17 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 18 missing from index pkg_shlibs_required_package_id row 18 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 19 missing from index pkg_shlibs_required_package_id row 19 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 20 missing from index pkg_shlibs_required_package_id row 20 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 21 missing from index pkg_shlibs_required_package_id row 21 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 22 missing from index pkg_shlibs_required_package_id row 22 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 23 missing from index pkg_shlibs_required_package_id row 23 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 24 missing from index pkg_shlibs_required_package_id row 24 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 25 missing from index pkg_shlibs_required_package_id row 25 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 26 missing from index pkg_shlibs_required_package_id row 26 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 27 missing from index pkg_shlibs_required_package_id row 27 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 28 missing from index pkg_shlibs_required_package_id row 28 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 29 missing from index pkg_shlibs_required_package_id row 29 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 30 missing from index pkg_shlibs_required_package_id row 30 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 31 missing from index pkg_shlibs_required_package_id row 31 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 32 missing from index pkg_shlibs_required_package_id row 32 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 33 missing from index pkg_shlibs_required_package_id row 33 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 34 missing from index pkg_shlibs_required_package_id row 34 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 35 missing from index pkg_shlibs_required_package_id row 35 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 36 missing from index pkg_shlibs_required_package_id row 36 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 37 missing from index pkg_shlibs_required_package_id row 37 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 38 missing from index pkg_shlibs_required_package_id row 38 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 39 missing from index pkg_shlibs_required_package_id row 39 missing from index sqlite_autoindex_pkg_shlibs_required_1 row 40 missing from index pkg_shlibs_required_package_id row 40 missing from index sqlite_autoindex_pkg_shlibs_required_1 wrong # of entries in index pkg_shlibs_required_package_id wrong # of entries in index sqlite_autoindex_pkg_shlibs_required_1 Error: database disk image is malformed Worst case, what is the regex to break out the port name so I can = rebuild from the output of `pkg info | cut -d" " -f1`? Hard to work out = to match everything up to the last hyphen=E2=80=A6