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

[Miroslav Lachman]

scratch65535 at att.net wrote on 2017/04/19 12:45:
> [Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
> <000.fbsd at quip.cz> 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
>>> directory
>>> pkg: fstat() failed for(/usr/local/bin/mysql_find_rows): No such file or
>>> directory

[...]

>>> pkg: fstat() failed for(/usr/local/man/man1/mysqlimport.1.gz): No such
>>> file or directory
>>> pkg: fstat() failed for(/usr/local/man/man1/mysqlshow.1.gz): No such
>>> file or directory
>>> pkg: fstat() failed for(/usr/local/man/man1/mysqlslap.1.gz): No such
>>> file or directory
>>> Checking all packages.......... done
>>>
>>>
>>> I think this is the root cause
>>>
>>> Checking integrity... done (2 conflicting)
>>>     - mariadb101-server-10.1.22 conflicts with mariadb101-client-10.1.21
>>> on /usr/local/share/mysql/maria_add_gis_sp.sql

[...]

>
> I couldn't tell you whether you're the only one (probably not!)
> but I did a pkg upgrade on everything yesterday to recover from
> pkg's quarterly version skew, and mariadb *seems* to be all there
> and working correctly.  I haven't done any work yet this morning,
> so I'm keeping my fingers crossed.

Do you use MariaDB version 10.1?

MariaDB server is running without problems, only some "mysql client" 
libraries are missing, but if you use only PHP to connect to "mysql 
server" then you will not notice any problem, because PHP uses internal 
mysql client.
So first time I overlooked this issue because MariaDB was running fine 
and webserver was on separate machine - PHP website was still running.

Can you check this?

ls -l /usr/local/lib/mysql/libmysqlclient_r.so.18

I see "ls: /usr/local/lib/mysql/libmysqlclient_r.so.18: No such file or 
directory" on each upgraded server until i run *pkg upgrade -f 
mariadb101-client*

Miroslav Lachman