From nobody Thu Jul 20 13:22:29 2023 X-Original-To: freebsd-pkg@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 4R6D0T18lXz4nKFW for ; Thu, 20 Jul 2023 13:23:37 +0000 (UTC) (envelope-from mail@nsood.in) Received: from wout4-smtp.messagingengine.com (wout4-smtp.messagingengine.com [64.147.123.20]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4R6D0S69CZz4Q1p; Thu, 20 Jul 2023 13:23:36 +0000 (UTC) (envelope-from mail@nsood.in) Authentication-Results: mx1.freebsd.org; none Received: from compute1.internal (compute1.nyi.internal [10.202.2.41]) by mailout.west.internal (Postfix) with ESMTP id 2917C3202941; Thu, 20 Jul 2023 09:23:34 -0400 (EDT) Received: from imap51 ([10.202.2.101]) by compute1.internal (MEProxy); Thu, 20 Jul 2023 09:23:34 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=nsood.in; h=cc :cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:sender :subject:subject:to:to; s=fm2; t=1689859413; x=1689945813; bh=Ij 7wMUcgX3kHfHst2eJSTuFqxLiJpwmw0acvyiWOY6g=; b=sfFe9qYXNUwV8p3Fe5 qFOjjUiWGHvHXAYDLBq5ncGNfRIN0FYBXiGpplngakSyLkO85HQ7VOsEFz/t1y3s VciaNsYDCpmcylYOCepv+cwMhR2dNdvmnZg3DhWK4mcb6C0o7ujZL6rNJRbYGHDu O1X5+QlMmoOGwrHWqLtccGn9FPnx6tJF36qQBXg9KsssthPVlXItaxu3Q+aLQ4+Y TNzTwjPiO4eUn1mZ1ehb1OXiXY3XyXWKXlzNuphsfk6GTvVf8Zjaga5mf0DToUEW ZN5XSUqLdtfF9ecKsDT7HFWbTeztpd1XynmrjpyDIe3F7gdKclOxnhiawbI6fTD0 u6Dg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender :x-sasl-enc; s=fm3; t=1689859413; x=1689945813; bh=Ij7wMUcgX3kHf Hst2eJSTuFqxLiJpwmw0acvyiWOY6g=; b=Yvw2vZa88IkXTwLDua3e16veZVhl/ G233VkFskDtVdba9M1XxPn89CWrkMN2EHczCKx9XXBJQMFeB0GwJT6Ij4YfPkARV hStkn4T7ZoFacd+NKxLAE0zCffWj9JiNlwQFhEylUBXyonsGs900SzuhkjX/dCS7 Y5vKaoRBPjzMvQGHwlGavlptKBwg8Lb/uY64DSc0/VZ/34qrDDkb8KS5CE5CqD0J 7iZmutfczyNWcyLQ9PM5VmTGZ+j0BLgD4oyAB/vUCiQe/Q3YWqnQ3pvrvlfn02Mq O1oiwc/aDt67UKBTmjRriy/w9xc2H1RNY5bNyCSkikGa7nzvlmF34ItFQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedviedrhedtgdeifecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefofgggkfgjfhffhffvvefutgesrgdtreerreertdenucfhrhhomhepfdfprghm rghnucfuohhougdfuceomhgrihhlsehnshhoohgurdhinheqnecuggftrfgrthhtvghrnh epteeikeetfeelueeuvddvtdfgjeehjeehkefhgeduteehgfeutdfhvefhuefgudejnecu vehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhgrihhlse hnshhoohgurdhinh X-ME-Proxy: Feedback-ID: ic6014606:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 51BE0B60089; Thu, 20 Jul 2023 09:23:33 -0400 (EDT) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.9.0-alpha0-531-gfdfa13a06d-fm-20230703.001-gfdfa13a0 List-Id: Binary package management and package tools discussion List-Archive: https://lists.freebsd.org/archives/freebsd-pkg List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-pkg@freebsd.org Mime-Version: 1.0 Message-Id: In-Reply-To: <2tt66xyidpyk6cxqstovqzwklp5zq6y74rfv3pzsceoptrp7ju@ubhtobnmhew2> References: <2tt66xyidpyk6cxqstovqzwklp5zq6y74rfv3pzsceoptrp7ju@ubhtobnmhew2> Date: Thu, 20 Jul 2023 09:22:29 -0400 From: "Naman Sood" To: "Baptiste Daroussin" Cc: freebsd-pkg@freebsd.org Subject: Re: Why did pkg delete mysql80-server here? Content-Type: multipart/alternative; boundary=4d599fa243a6486c9abba7fd229cf746 X-Rspamd-Queue-Id: 4R6D0S69CZz4Q1p X-Spamd-Bar: ---- X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:29838, ipnet:64.147.123.0/24, country:US] X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated --4d599fa243a6486c9abba7fd229cf746 Content-Type: text/plain Unfortunately I did hit y instead of N, so I've lost that information for now. If this happens again, I'll come back with this info. Thanks! Thanks, Naman. (they/them) On Thu, Jul 20, 2023, at 05:18, Baptiste Daroussin wrote: > On Wed, Jul 19, 2023 at 07:07:34PM -0400, Naman Sood wrote: > > Hi, > > > > I just started using FreeBSD 13.2 for a personal storage server. I had this extremely surprising interaction with pkg today: > > > > nsood@silicon:~ % sudo pkg install rclone > > Password: > > Updating FreeBSD repository catalogue... > > Fetching packagesite.pkg: 100% 7 MiB 465.6kB/s 00:15 > > Processing entries: 100% > > FreeBSD repository update completed. 33793 packages processed. > > All repositories are up to date. > > New version of pkg detected; it needs to be installed first. > > The following 1 package(s) will be affected (of 0 checked): > > > > Installed packages to be UPGRADED: > > pkg: 1.19.1_1 -> 1.19.2 > > > > Number of packages to be upgraded: 1 > > > > 8 MiB to be downloaded. > > > > Proceed with this action? [y/N]: y > > [1/1] Fetching pkg-1.19.2.pkg: 100% 8 MiB 1.7MB/s 00:05 > > Checking integrity... done (0 conflicting) > > [1/1] Upgrading pkg from 1.19.1_1 to 1.19.2... > > [1/1] Extracting pkg-1.19.2: 100% > > Updating FreeBSD repository catalogue... > > FreeBSD repository is up to date. > > All repositories are up to date. > > The following 2 package(s) will be affected (of 0 checked): > > > > Installed packages to be REMOVED: > > mysql80-server: 8.0.32 > > > > New packages to be INSTALLED: > > rclone: 1.62.2 > > > > Number of packages to be removed: 1 > > Number of packages to be installed: 1 > > > > The operation will free 138 MiB. > > 12 MiB to be downloaded. > > > > Proceed with this action? [y/N]: y > > [1/1] Fetching rclone-1.62.2.pkg: 100% 12 MiB 3.1MB/s 00:04 > > Checking integrity... done (0 conflicting) > > [1/2] Deinstalling mysql80-server-8.0.32... > > [1/2] Deleting files for mysql80-server-8.0.32: 100% > > ==> You should manually remove the "mysql" user. > > ==> You should manually remove the "mysql" group > > [2/2] Installing rclone-1.62.2... > > [2/2] Extracting rclone-1.62.2: 100% > > You may need to manually remove /usr/local/etc/mysql/my.cnf if it is no longer needed. > > > > It's definitely on me to have not read the message carefully before saying yes, but also extremely unintuitive that installing rclone, presumably an unrelated package, caused mysql80-server to be uninstalled. Reinstalling mysql80-server worked fine, and did not remove rclone, so it wasn't a package conflict. Thankfully the mysqld process in memory kept running while I reinstalled the package so I did not experience any downtime, but I would still like to avoid a heart attack in the future. So can someone explained what I did wrong here that caused mysql80-server to be uninstalled? > > > > Thanks, > > Naman. > > (they/them) > > > > Very hard to determine, without the debug output, somehow the solver considered > there was a conflict in the process. > > Partial update (aka installing something on a new repo without upgrading all the > packages at once) is fragile, and pkg needs to become more robust here. > > I don't know what is the best here, before we were forbidding it and forcing the > user to update everything. but this was not convenient for plenty of users as > most of the time it works as expected. > > So yes this a bug on pkg side, usually hard to debug when it happens, if you > have a reproducible way to make it happen I will be more han happy if you can > provide me your /var/db/pkg (the whole thing if you hit N instead of y). > > I will then be able to reproduce locally and try to fix. > > Another way to help me is when it happens, hit N and rerun with pkg -o > DEBUG_LEVEL=4 which will be very verbose and provide me the output so I can > analyze. > > Best regards, > Bapt > --4d599fa243a6486c9abba7fd229cf746 Content-Type: text/html Content-Transfer-Encoding: quoted-printable
Unfortunately I= did hit y instead of N, so I've lost that information for now. If this = happens again, I'll come back with this info. Thanks!

Thanks,
Naman.
(they/the= m)

On Thu, Jul 20, 2023, at 05:18, Ba= ptiste Daroussin wrote:
On Wed, Jul 19, 2023 at 07:07:34PM -0400, Naman Sood wrote:=
> Hi,
> 
> I ju= st started using FreeBSD 13.2 for a personal storage server. I had this = extremely surprising interaction with pkg today:
> = ;
> nsood@silicon:~ % sudo pkg install rclone
=
> Password:
> Updating FreeBSD repository catal= ogue...
> Fetching packagesite.pkg: 100%  &nb= sp; 7 MiB 465.6kB/s    00:15    
<= /div>
> Processing entries: 100%
> FreeBSD repos= itory update completed. 33793 packages processed.
> All= repositories are up to date.
> New version of pkg dete= cted; it needs to be installed first.
> The following 1= package(s) will be affected (of 0 checked):
> 
> Installed packages to be UPGRADED:
>&n= bsp;        pkg: 1.19.1_1 -> 1.19.= 2
> 
> Number of packages to be u= pgraded: 1
> 
> 8 MiB to be downl= oaded.
> 
> Proceed with this act= ion? [y/N]: y
> [1/1] Fetching pkg-1.19.2.pkg: 100%&nbs= p;   8 MiB   1.7MB/s    00:05 &n= bsp;  
> Checking integrity... done (0 confli= cting)
> [1/1] Upgrading pkg from 1.19.1_1 to 1.19.2...=
> [1/1] Extracting pkg-1.19.2: 100%
>= Updating FreeBSD repository catalogue...
> FreeBSD rep= ository is up to date.
> All repositories are up to dat= e.
> The following 2 package(s) will be affected (of 0 = checked):
> 
> Installed packages= to be REMOVED:
>      &n= bsp;  mysql80-server: 8.0.32
> 
> New packages to be INSTALLED:
>   =       rclone: 1.62.2
> 
> Number of packages to be removed: 1
>= Number of packages to be installed: 1
> 
> The operation will free 138 MiB.
> 12 MiB to= be downloaded.
> 
> Proceed with= this action? [y/N]: y
> [1/1] Fetching rclone-1.62.2.p= kg: 100%   12 MiB   3.1MB/s    00:04&= nbsp;   
> Checking integrity... done (0= conflicting)
> [1/2] Deinstalling mysql80-server-8.0.3= 2...
> [1/2] Deleting files for mysql80-server-8.0.32: = 100%
> =3D=3D> You should manually remove the "mysql= " user. 
> =3D=3D> You should manually remove t= he "mysql" group 
> [2/2] Installing rclone-1.62.2= ...
> [2/2] Extracting rclone-1.62.2: 100%
> You may need to manually remove /usr/local/etc/mysql/my.cnf if it= is no longer needed.
> 
> It's d= efinitely on me to have not read the message carefully before saying yes= , but also extremely unintuitive that installing rclone, presumably an u= nrelated package, caused mysql80-server to be uninstalled. Reinstalling = mysql80-server worked fine, and did not remove rclone, so it wasn't a pa= ckage conflict. Thankfully the mysqld process in memory kept running whi= le I reinstalled the package so I did not experience any downtime, but I= would still like to avoid a heart attack in the future. So can someone = explained what I did wrong here that caused mysql80-server to be uninsta= lled?
> 
> Thanks,
= > Naman.
> (they/them)
> 
<= /div>

Very hard to determine, without the debug outpu= t, somehow the solver considered
there was a conflict in t= he process.

Partial update (aka installing = something on a new repo without upgrading all the
packages= at once) is fragile, and pkg needs to become more robust here.

I don't know what is the best here, before we were = forbidding it and forcing the
user to update everything. b= ut this was not convenient for plenty of users as
most of = the time it works as expected.

So yes this = a bug on pkg side, usually hard to debug when it happens, if you
have a reproducible way to make it happen I will be more han happ= y if you can
provide me your /var/db/pkg (the whole thing = if you hit N instead of y).

I will then be = able to reproduce locally and try to fix.

A= nother way to help me is when it happens, hit N and rerun with pkg -o
DEBUG_LEVEL=3D4 which will be very verbose and provide me th= e output so I can
analyze.

Be= st regards,
Bapt

--4d599fa243a6486c9abba7fd229cf746--