From nobody Thu Dec 09 17:46:30 2021 X-Original-To: freebsd-current@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 3678318E1F35 for ; Thu, 9 Dec 2021 17:46:33 +0000 (UTC) (envelope-from jamie@catflap.org) Received: from donotpassgo.dyslexicfish.net (donotpassgo.dyslexicfish.net [IPv6:2001:19f0:300:2185:123::1]) by mx1.freebsd.org (Postfix) with ESMTP id 4J91gD5XRhz3N2n for ; Thu, 9 Dec 2021 17:46:32 +0000 (UTC) (envelope-from jamie@catflap.org) Received: from donotpassgo.dyslexicfish.net (donotpassgo.dyslexicfish.net [104.207.135.49]) by donotpassgo.dyslexicfish.net (8.14.5/8.14.5) with ESMTP id 1B9HkU1a023850; Thu, 9 Dec 2021 17:46:30 GMT (envelope-from jamie@donotpassgo.dyslexicfish.net) Received: (from jamie@localhost) by donotpassgo.dyslexicfish.net (8.14.5/8.14.5/Submit) id 1B9HkUf4023849; Thu, 9 Dec 2021 17:46:30 GMT (envelope-from jamie) From: Jamie Landeg-Jones Message-Id: <202112091746.1B9HkUf4023849@donotpassgo.dyslexicfish.net> Date: Thu, 09 Dec 2021 17:46:30 +0000 Organization: Dyslexic Fish To: freebsd-current@FreeBSD.org, dclarke@blastwave.org Subject: Re: pkg sqlite database borked ( again ). How to restore? References: <4d9d5406-c257-e5cb-d237-d26889468f62@blastwave.org> <202111291122.1ATBM1vp034286@donotpassgo.dyslexicfish.net> <3b4d90c7-cacf-8b9d-60cd-694e68e76ed1@blastwave.org> In-Reply-To: <3b4d90c7-cacf-8b9d-60cd-694e68e76ed1@blastwave.org> User-Agent: Heirloom mailx 12.4 7/29/08 List-Id: Discussions about the use of FreeBSD-current List-Archive: https://lists.freebsd.org/archives/freebsd-current List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-current@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Greylist: Sender passed SPF test, not delayed by milter-greylist-4.2.7 (donotpassgo.dyslexicfish.net [104.207.135.49]); Thu, 09 Dec 2021 17:46:30 +0000 (GMT) X-Rspamd-Queue-Id: 4J91gD5XRhz3N2n X-Spamd-Bar: -- Authentication-Results: mx1.freebsd.org; dkim=none; dmarc=pass (policy=none) header.from=catflap.org; spf=pass (mx1.freebsd.org: domain of jamie@catflap.org designates 2001:19f0:300:2185:123::1 as permitted sender) smtp.mailfrom=jamie@catflap.org X-Spamd-Result: default: False [-2.70 / 15.00]; ARC_NA(0.00)[]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; FREEFALL_USER(0.00)[jamie]; FROM_HAS_DN(0.00)[]; R_SPF_ALLOW(-0.20)[+mx:dyslexicfish.net:c]; NEURAL_HAM_LONG(-1.00)[-1.000]; MIME_GOOD(-0.10)[text/plain]; TO_DN_NONE(0.00)[]; HAS_ORG_HEADER(0.00)[]; TO_MATCH_ENVRCPT_SOME(0.00)[]; NEURAL_HAM_SHORT(-1.00)[-1.000]; RCPT_COUNT_TWO(0.00)[2]; DMARC_POLICY_ALLOW(-0.50)[catflap.org,none]; RCVD_NO_TLS_LAST(0.10)[]; FROM_EQ_ENVFROM(0.00)[]; R_DKIM_NA(0.00)[]; MIME_TRACE(0.00)[0:+]; ASN(0.00)[asn:20473, ipnet:2001:19f0::/38, country:US]; SUBJECT_ENDS_QUESTION(1.00)[]; RCVD_COUNT_TWO(0.00)[2] X-ThisMailContainsUnwantedMimeParts: N Dennis Clarke via freebsd-current wrote: > Ah well ... that seems to toss a ton of errors and yet works ? Ooops. Sorry for the delay, I originally missed your post. I forgot to mention, this is for rebuilding the db from scratch, as such, you needed to delete the old db file first - hence the warnings about tables already existing, and presumably the other "UNIQUE" errors. I'd personally be uncomfortable keeping it like this, but I don't know enought about pkg, but if as you said it works, it seems the merge went ok! Cheers, Jamie