essage-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck;
 bh=BA3Ap72A1RRuAlU8nmAtaCqs0chQ3CYNu9PKJW6C70E=;
 b=MTMXyoLdBkMiZpL8dJc+OdHDfwSOR+nLlqLR7R2wpnCBFiucViWPDLq7TMtoW/rUIcrvwvkwO86BNsDRmy20pfqOWdmSl1m173H56xyv4WrKwPX6Cqtcu67ZcSDiyK9W8/aa8TZsDrNtMzH5MMx+QWtwcfTVxj/0hZpB3ZMUA8FtswulC8aLc1EEqVd/HvILZUv5VbRYQZxclJAztBPxJfOVOHHnO2Rhc1KrhliMMh7xFUPBR2qnZDxrgnn0hkzinxt4w+aWVMlx7ngFRMqBzTG5UeMBP+S9Q3SRT800DBsnX/RkZnFcpyO8IA+pOOXA+O/XcsLS+kEID260N+pr9A==
Message-ID:
 <PH0PR11MB47766DB6CF67FC1981D5F5CFE6592@PH0PR11MB4776.namprd11.prod.outlook.com>
Date: Tue, 12 Nov 2024 11:22:59 -0700
User-Agent: Mozilla Thunderbird
Subject: Re: Unable to upgrade MariaDB 10.11.9 to 10.11.10
To: ports@freebsd.org
References: <e24d0013f719302b159cf5411a76482e4a3af79d.camel@uos.de>
 <20241112082017.6010fc70@daleth.home>
 <4c443038d6ee6dc71a0827c7054057b3ecf2072d.camel@uos.de>
Content-Language: en-US
From: "Edward Sanford Sutton, III" <mirror176@hotmail.com>
In-Reply-To: <4c443038d6ee6dc71a0827c7054057b3ecf2072d.camel@uos.de>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Sender: owner-freebsd-ports@FreeBSD.org
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: PH0PR11MB4776:EE_|BN9PR11MB5225:EE_
X-MS-Office365-Filtering-Correlation-Id: e0f96990-40fb-4713-7986-08dd03470af1
X-Microsoft-Antispam:
	BCL:0;ARA:14566002|8060799006|5072599009|15080799006|7092599003|6090799003|461199028|19110799003|440099028|4302099013|3412199025|1602099012|10035399004;
X-Microsoft-Antispam-Message-Info:
	=?utf-8?B?SUFJckZYdExHM3ZCOTAzbDlYQVlTYjF0K1FEbzJSa1BjVkVRcVM4emtlaTBO?=
 =?utf-8?B?amdObkpaZjlvcmMwa0pXNVErTEV6aGFHWHM1Snk4elFrWUljOFRjOXpJZUxi?=
 =?utf-8?B?UVRGZEJnTFdEOXFaekF0QXcwblRETU9lUWdSdURJUG1aWTdlMk56T0xML0JB?=
 =?utf-8?B?M3NiTzB0WEQrOEdDcEJ2a3RPRzA4RFFyRG9TcEYyYzc0VzhxOWJlQkREU3hZ?=
 =?utf-8?B?RTlncGg3VEl6eTBpSHBCczlYa3JCT05rK2krc2RzYitVMVVEQ3QxZ3J6d0xW?=
 =?utf-8?B?RjJJM0xXOHV6bGlIbHJnY0JmVE1GQU8rK2VaL3U5aUpQb1cxV3kvRW1iMmFl?=
 =?utf-8?B?ejdnUFozdnQ2YlRkQ0Q0dTBDQWFydWppOTdIbUtGbURxdVhpS3hzNm9LQit5?=
 =?utf-8?B?ZUdkTnVXMXQ3VVBUYTNKalhuYStBbTZTTW5qRWZoMFkwRE1KUmpnSkJFY0ZD?=
 =?utf-8?B?QXNhU2F1Z21Ha202bWJhbTk5bXNENU53UXBNYTZMeXhzaW5BSVhaclAvYSto?=
 =?utf-8?B?d0xEbU1ySHlRTGh6MjBGUm5iZGwrNjFHV3FHRHErQ3RDRGZIVEIwUWc1R2wx?=
 =?utf-8?B?dUxlMFIyeEVBZlZ5ejViU0FrWE94V3FwbDF2a2hTTDNYM1RvR0Q0SFh2b2RV?=
 =?utf-8?B?dk40K2x5VnlFWWZsYm1OeWt0azJIRTh6YXdVcTM4dmF4L2YwSnpOazR4Znlq?=
 =?utf-8?B?TDUyWHgwUUR6QVlNdGRMWi9TSllzUVdobSt2WXl3RlhtRkpjZWxyNzdjb1dw?=
 =?utf-8?B?UWhlNHY2b25DWEhaNER5aW5aTjB1ZUhkaGE4Qnk5alkvTDlKK0VCY21OZUdw?=
 =?utf-8?B?WWRua1drenVkYlI0aEhOR3Jsa2Q2WllDeFVSalJZRG5JejFhb3I5U25tTmJH?=
 =?utf-8?B?MXN4YTcwNWh1VDM1ajNqeElGWmdRaExpMXlXdnFmOElCSzNiMkYxU2NlNGZK?=
 =?utf-8?B?bnR4YjRsODNhVzgrd1dieUxrM3dwOVpGSE5NbFM1WmdsMThRdmdMN2ZDOURZ?=
 =?utf-8?B?Y2p1QjhaK1pxVlZpcWVjVFFsUXdCYVA4RCtaVWtnblJkQk0yNVBqM05PUVNZ?=
 =?utf-8?B?TXJFWkIySyswalYzWHhNVTJKc2NmTXJ4RXh5U2ZXZTRPaTZ4K0dEUWViOGly?=
 =?utf-8?B?MDZQQ1IwaVozMENHNUtrQUVxWGhVYlRtYm9UcTZqNnhwMWg2OTVjdzNtWmdp?=
 =?utf-8?B?Qy9JSkE3OUpzQTdYNWNMb2hHZWJncGV4MzNxS3UxalU0c0UySHZBS0Rjc1lB?=
 =?utf-8?B?eGRVblF1S2RQcmQ2UVlycm5zQzUyYVdIU2NhdTJLQmp4dDZ0M0VuTlRpNGFZ?=
 =?utf-8?B?WEtyaEZ6Z0lRcDNJSG0rQVVOMmNLdUVhQktRQ2pTZ0YzZmxuL1NPbkZybFQ3?=
 =?utf-8?B?eWVCV3pDTW12d2gwbkswLzRvSWszcG96QTFqTmJCdWthU3NwL2UyM0dOWFdz?=
 =?utf-8?B?c3ByVnMwRUJDUjhIQVdoY2RISi9ON2NiMUYxNUc0MksvNmZ6RGNWVkErL2V4?=
 =?utf-8?B?NmJ3MU5DS2M1b2FNbzRHNnZBK1lkbktqWEZ1bEZ1ak9XN1FSa2VsUmIyOTdE?=
 =?utf-8?Q?HIYXno8AhDGAp3ost8ZkZxFME=3D?=
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?utf-8?B?d3VXa2U0WnZkZld1eXlNMG1iVmNTQUxDWlphaFRoVDhMSldvbmJlaWc1VDY2?=
 =?utf-8?B?bURpWkVlSThTSW1DLy90MTY0UXdDNURENWhuNEZRTktzaHV0RDhtbjcra1Bl?=
 =?utf-8?B?eit3Vno0amxzUUNGZWtWQktlY04raS80OTlVOEdBOE1xZGJkQjhtZFNqd2FJ?=
 =?utf-8?B?aElEL1V5Tk5JSjZtTnZNY0xsZy9iQjRSaENjc0tZRVRhVHNuWmJxMFYwY0ZC?=
 =?utf-8?B?b2tQQ3J2TmZHRXB5UTdSdzI5cEhEZU5vaGcwc0oxekJTNkFNV1RlSWNWdnhU?=
 =?utf-8?B?eFFWNzhtdUdxY20xL1ZZY3B1SU9FcWwvcnBtZEw0MUNseng5bnIraTlNWjJJ?=
 =?utf-8?B?VDlkb21lallDUXdmc0FzbkE5Sno2dS9nZGFYRjBQNGs2K3Q1dWJKMU5jNThM?=
 =?utf-8?B?WFQ5S2E4OWRqdDQzbnlxVFZYUnlaYk00allXVVBkUGUyOS9EK3EreEVkQXdC?=
 =?utf-8?B?cHZPWjljN251eEJMZmdTNElhU0UxQ2NjZHlkWXJnNjRVc0c1OVFSelhMbC9m?=
 =?utf-8?B?SGtFT09uNjFyZWUwb1RDQWk2NlVyMFVaeVAvQzBxRHpaajBzS0M1L2hXZCsy?=
 =?utf-8?B?b3IrNURHb3RlK1Jucnc4ajdkU3k1anFaUE1EU2p5RDFmNGUxU0V2L1BtSGd1?=
 =?utf-8?B?enJwK3VOM25pVTZmbU9qOGdyWFpzOE9HQjl0a2pQQi9qWWRGZXBiM2I4NENY?=
 =?utf-8?B?Z1ViRGtwRHJydFg1Q2RpWHo4WVNsK2YwaWVJNDJLT0pGQndKTWJUMmdKeE8y?=
 =?utf-8?B?UXJIckcrRGpaMzBTNTlXWWZaMERYeGVpQkR3ajJaNHVTcitNakVIRWQzSjFE?=
 =?utf-8?B?bW1Ba3cranJCM21NUmVVTmcyUWp2Tzd0WCtPSXJzaG83dU9XbjUydFNsVTRT?=
 =?utf-8?B?Y1h2a1RxakdCeGJDSml5M0ZBaUcrZzdqTHFVZVJ3dlBOTmQyNERrUVlNdkdI?=
 =?utf-8?B?T0xueWlicXcvVm5yd2c4UlMwaDhQUkFzMXRER04vazhSNmpEZWRTRmpnek4r?=
 =?utf-8?B?NmovMWVBWVlPb3JCZ3dhVnpudEZDQklhT0dWZG5YUjRVbXRrNENBODNKcS9U?=
 =?utf-8?B?enlndkdoWmFXekhNZ1VUeEFMTEwvRkl0VjFoSngxMXY1R25KRHJHdjVSTTNI?=
 =?utf-8?B?WGludTI2NXpUaDB3Nm9QZkUxUUFMdlFsazBoRzE2T0NiVE5SUkRpa01iTHFa?=
 =?utf-8?B?dkpwWnNMSjVNQkRWNmpyOWVzWmd5S3g0azZFc0pOdFplZ2JFVVlWc3JENkpD?=
 =?utf-8?B?azRKeUFjYUFSTXZDQU5WZ3c2WW9ianNFR2t4enlGRDQ1NDMvbVZqLys1Ymxl?=
 =?utf-8?B?aGJ1T3c3VFh6dTVhTmRHZTd6eXFGVGgycTNtYllmWU1nL2ZVUmNKcDgxWWs4?=
 =?utf-8?B?RFJ4Z214Zi8xVzNXK2crUjd2V3VwaCsxTHMxL0lHVmdHV29ld1A4elg0SnFv?=
 =?utf-8?B?TVNsYjFteHVZTk5lTTA4M2hsQUpnYjFKNjRaUXFLN2RoY0VOQlozM2dtMytV?=
 =?utf-8?B?QTZucXBiU3hIUDJmUE8xeStwQTRTL3VEQUlGSndmOWxvSCt2NThWSjV4V2tv?=
 =?utf-8?B?MnhhNm1nSWtnVDVaNHJqRzdBZTR6Mnl5endIQkxTUC9LcEEvK3VRMlRxUy8v?=
 =?utf-8?Q?tfBfeR1XJ1+qDdd9XbiBhnMYxlIf/apViA3UQdAVmizc=3D?=
X-OriginatorOrg: sct-15-20-7719-20-msonline-outlook-d1079.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: e0f96990-40fb-4713-7986-08dd03470af1
X-MS-Exchange-CrossTenant-AuthSource: PH0PR11MB4776.namprd11.prod.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 12 Nov 2024 18:23:02.5144
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg:
	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: BN9PR11MB5225
X-Spamd-Result: default: False [-2.46 / 15.00];
	FORGED_MUA_THUNDERBIRD_MSGID_UNKNOWN(2.50)[];
	NEURAL_HAM_LONG(-1.00)[-1.000];
	ARC_ALLOW(-1.00)[microsoft.com:s=arcselector10001:i=1];
	NEURAL_HAM_MEDIUM(-1.00)[-1.000];
	NEURAL_HAM_SHORT(-0.97)[-0.967];
	DMARC_POLICY_ALLOW(-0.50)[hotmail.com,none];
	R_DKIM_ALLOW(-0.20)[hotmail.com:s=selector1];
	R_SPF_ALLOW(-0.20)[+ip6:2a01:111:f403::/49];
	MIME_GOOD(-0.10)[text/plain];
	XM_UA_NO_VERSION(0.01)[];
	ASN(0.00)[asn:8075, ipnet:2a01:111:f000::/36, country:US];
	FREEMAIL_FROM(0.00)[hotmail.com];
	MIME_TRACE(0.00)[0:+];
	DWL_DNSWL_NONE(0.00)[hotmail.com:dkim];
	FREEMAIL_ENVFROM(0.00)[hotmail.com];
	RCPT_COUNT_ONE(0.00)[1];
	MLMMJ_DEST(0.00)[ports@freebsd.org];
	TO_MATCH_ENVRCPT_ALL(0.00)[];
	FROM_HAS_DN(0.00)[];
	RCVD_TLS_LAST(0.00)[];
	FROM_EQ_ENVFROM(0.00)[];
	TO_DN_NONE(0.00)[];
	RCVD_COUNT_TWO(0.00)[2];
	DKIM_TRACE(0.00)[hotmail.com:+]
X-Rspamd-Queue-Id: 4Xnvt23LW9z4s6L
X-Spamd-Bar: --

On 11/12/24 07:10, Dr. Peter Voigt wrote:
> On Tue, 2024-11-12 at 08:20 +0100, Piotr Smyrak wrote:
>> On Mon, 11 Nov 2024 23:29:27 +0100
>> "Dr. Peter Voigt" <pvoigt@uos.de> wrote:
>>
>>> I am unable to upgrade MariaDB from 10.11.9 to 10.11.10.
>>>
>>> I am using FreeBSD 13.4-RELEASE-p2 and have tried to upgrade MariaDB
>>> using portmaster and make install.
>>>
>>> Build of MariaDB 10.11.10 completes just fine but I am unable to
>>> install:
>>>
>>> pkg-static: mariadb1011-server-10.11.10 conflicts with mariadb1011-
>>> client-10.11.10 (installs files into the same place).
>>>    Problematic file: /usr/local/bin/mytop
>>> *** Error code 1
>>>
>>> I have not installed databases/mytop at all.
>>>
>>> I've left a comment for closed bug report 266630:
>>> https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=266630
>>>
>>> because it seems related to my issue. Starting with 10.11.10 MariaDB
>>> shipped mytop is installed per default which seems to conflict with
>>> server and client port.
>>>
>>> Howver, bug report 266630 has status "closed" and my comment might not
>>> be read at all.
>>>
>>> Could anybody please give me a hint, how to upgrade to MariaDB
>>> 10.11.10 or should I place a new bug report?
>>
>> You can patch locally databases/mariadb1011-server/pkg-plist by
>> reversing the latest delta to the file.
>>
>> patch -R < attached_file
>>
>> HTH,
> 
> Thanks, Piotr and Edward for pointing me into the right direction and informing
> the port maintainer.
> 
> I was not aware how the package file list can be modified.

Editing the pkg-plist does not always alter what is installed for a port 
as that is often a list recording what should have been installed with a 
separate install step of building a port. Port maintainers create that 
list to include only what is installed and packages later refer to that 
list for what they do. Editing that list can lead to a port's install 
stage not matching what a pkg installs/removes and should be considered 
a bug if such a mistake is made. If you use a cleanroom environment to 
build a package and install that package to your system then your system 
should be fine but the cleanroom environment may have had otherwise 
unexpected additional or missing files when you remove, add, or modify 
pkg-plist lines. I think the `make stage` and `make stage-qa` steps are 
designed to try to further detect/limit such changes but they don't seem 
to always do as I'd expect.

> I've upgraded now to MariaDB 10.11.10 now with the modified file list.
> 
>