databases/mariadb101-client upgraded in wrong order, resulted in missing files

[Miroslav Lachman]

Bernard Spil wrote on 2017/04/19 21:32:
> On 2017-04-18 21:45, Miroslav Lachman wrote:
>> Miroslav Lachman wrote on 2017/03/31 15:31:
>>> I don't know if it was "pkg" fault or mariadb101-server and
>>> mariadb101-client conflict.
>>>
>>> I did standard "pkg upgrade" and at the end I have half files of
>>> mariadb101-client missing:
>>>
>>> # pkg check -Ba
>>> Checking all packages: ...
>>> pkg: fstat() failed for(/usr/local/bin/msql2mysql): No such file or

[...]

>>> [82/86] Upgrading mariadb101-server from 10.1.21 to 10.1.22...
>>> ===> Creating groups.
>>> Using existing group 'mysql'.
>>> ===> Creating users
>>> Using existing user 'mysql'.
>>> [82/86] Extracting mariadb101-server-10.1.22: .......... done
>>>
>>> This was on FreeBSD 10.3 amd64 with packages from own poudriere with
>>> follogin settings:
>>>
>>> OPTIONS_UNSET= X11 GUI CUPS DOCS EXAMPLES NLS HAL
>>> WITH_BDB_VER=5
>>> WITH_GHOSTSCRIPT_VER=9
>>> DEFAULT_VERSIONS=apache=2.4 perl5=5.24 mysql=10.1m php=5.6 python=2.7
>>> python3=3.5 pgsql=9.4 ssl=openssl
>>> DISABLE_LICENSES=yes
>>>
>>>
>>> databases_mariadb101-client/options
>>> OPTIONS_FILE_SET+=GSSAPI_NONE
>>>
>>> databases_mariadb101-server/options
>>> OPTIONS_FILE_SET+=MAXKEY
>>> OPTIONS_FILE_SET+=GSSAPI_NONE
>>> OPTIONS_FILE_SET+=SPHINX
>>> OPTIONS_FILE_SET+=SPIDER
>>>
>>> I think all users of MariaDB 10.1 should be warned in UPDATING
>>>
>>> Let me know if you need some more details.
>>
>> Am I the only one beaten by this issue? I see this on each of our
>> machines during pkg upgrade.
>>
>> Miroslav Lachman
>
> Hi Miroslav,
>
> Looks like it. My own servers were upgraded with mariadb from pkg
> without issues.
>
> Sorry for your inconvenience, don't know what would cause that.

The root cause is IMHO this change in pkg-plist

https://svnweb.freebsd.org/ports/head/databases/mariadb101-client/pkg-plist?r1=436392&r2=436391&pathrev=436392
https://svnweb.freebsd.org/ports/head/databases/mariadb101-server/pkg-plist?r1=436857&r2=436856&pathrev=436857

but I don't understand why nobody else see this problem on pkg upgrade.

We are using poudriere with standard ports tree, MariaDB is build with 
standard options etc.

Miroslav Lachman