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

[Miroslav Lachman]

scratch65535 at att.net wrote on 2017/04/19 14:05:
> [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?

I tried it on next machine with pkg upgrade -f but the result is the same:

pkg check -Ba

Checking all packages....
(p5-DBD-mysql-4.042) 
/usr/local/lib/perl5/site_perl/mach/5.24/auto/DBD/mysql/mysql.so - 
required shared library libmysqlclient.so.18 not found
Checking all packages........
(sphinxsearch-2.2.11_1) /usr/local/bin/indexer - required shared library 
libmysqlclient.so.18 not found
(sphinxsearch-2.2.11_1) /usr/local/bin/indextool - required shared 
library libmysqlclient.so.18 not found
(sphinxsearch-2.2.11_1) /usr/local/bin/spelldump - required shared 
library libmysqlclient.so.18 not found
(sphinxsearch-2.2.11_1) /usr/local/bin/wordbreaker - required shared 
library libmysqlclient.so.18 not found
(sphinxsearch-2.2.11_1) /usr/local/sbin/searchd - required shared 
library libmysqlclient.so.18 not found

Miroslav Lachman