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

[scratch65535 at att.net]

[Default] On Wed, 19 Apr 2017 13:45:54 +0200, Miroslav Lachman
<000.fbsd at quip.cz> wrote:

>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*

Yes, I do have that file. Could the difference in our results be
due to my having used the -f switch, which forces upgrade of
EVERYthing instead of just those bits that pkg thinks want
upgrading?