Date: Wed, 19 Apr 2017 11:55:11 -0400 From: <scratch65535@att.net> To: Miroslav Lachman <000.fbsd@quip.cz> Cc: freebsd-ports <ports@freebsd.org> Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files Message-ID: <5dtefclcrhm4324v2o60miegrnb86qb4ko@4ax.com> In-Reply-To: <58F75DA8.8070305@quip.cz> References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> <qlfefc9rviqk57inm9gjbo9aiglhe0bkic@4ax.com> <58F74DF2.4000208@quip.cz> <s2kefc9okjeol77ftgifoasiqiii31h0lf@4ax.com> <58F75DA8.8070305@quip.cz>
next in thread | previous in thread | raw e-mail | index | archive | help
[Default] On Wed, 19 Apr 2017 14:52:56 +0200, Miroslav Lachman <000.fbsd@quip.cz> wrote: >scratch65535@att.net wrote on 2017/04/19 14:05: >> [Default] On Wed, 19 Apr 2017 13:45:54 +0200, Miroslav Lachman >> <000.fbsd@quip.cz> wrote: >> >>> scratch65535@att.net wrote on 2017/04/19 12:45: >>>> [Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman >>>> <000.fbsd@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 That's odd. You're upping the 64-bit version, right?
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?5dtefclcrhm4324v2o60miegrnb86qb4ko>