From owner-freebsd-ports@freebsd.org Wed Apr 19 12:53:02 2017 Return-Path: Delivered-To: freebsd-ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id A71DBD450C6 for ; Wed, 19 Apr 2017 12:53:02 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 91F1B135E for ; Wed, 19 Apr 2017 12:53:02 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: by mailman.ysv.freebsd.org (Postfix) id 9153AD450C2; Wed, 19 Apr 2017 12:53:02 +0000 (UTC) Delivered-To: ports@mailman.ysv.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) by mailman.ysv.freebsd.org (Postfix) with ESMTP id 90FB9D450C1 for ; Wed, 19 Apr 2017 12:53:02 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (elsa.codelab.cz [94.124.105.4]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 231C0135C for ; Wed, 19 Apr 2017 12:53:01 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: from elsa.codelab.cz (localhost [127.0.0.1]) by elsa.codelab.cz (Postfix) with ESMTP id 210D6284A3; Wed, 19 Apr 2017 14:52:58 +0200 (CEST) Received: from illbsd.quip.test (ip-86-49-16-209.net.upcbroadband.cz [86.49.16.209]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) by elsa.codelab.cz (Postfix) with ESMTPSA id E8CDA28458; Wed, 19 Apr 2017 14:52:56 +0200 (CEST) Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files To: scratch65535@att.net Cc: freebsd-ports References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> <58F74DF2.4000208@quip.cz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <58F75DA8.8070305@quip.cz> Date: Wed, 19 Apr 2017 14:52:56 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:42.0) Gecko/20100101 Firefox/42.0 SeaMonkey/2.39 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 Apr 2017 12:53:02 -0000 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 Miroslav Lachman