From owner-freebsd-ports@freebsd.org Wed Apr 19 15:57:24 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 8C636D4504F for ; Wed, 19 Apr 2017 15:57:24 +0000 (UTC) (envelope-from scratch65535@att.net) Received: from mailman.ysv.freebsd.org (mailman.ysv.freebsd.org [IPv6:2001:1900:2254:206a::50:5]) by mx1.freebsd.org (Postfix) with ESMTP id 6DD928E5 for ; Wed, 19 Apr 2017 15:57:24 +0000 (UTC) (envelope-from scratch65535@att.net) Received: by mailman.ysv.freebsd.org (Postfix) id 6A4B4D4504C; Wed, 19 Apr 2017 15:57:24 +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 69EF4D4504A for ; Wed, 19 Apr 2017 15:57:24 +0000 (UTC) (envelope-from scratch65535@att.net) Received: from nm7-vm4.access.bullet.mail.gq1.yahoo.com (nm7-vm4.access.bullet.mail.gq1.yahoo.com [216.39.63.95]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id 4688D8E4 for ; Wed, 19 Apr 2017 15:57:23 +0000 (UTC) (envelope-from scratch65535@att.net) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=att.net; s=s1024; t=1492617307; bh=G/4nhR8nyFL6QhmzIpYtoB7Z+TexrfjxAH2zG45Nr2M=; h=From:To:Cc:Subject:Date:References:In-Reply-To:From:Subject; b=KZEZffgZB8HqiZhVGw3mkAAXh/FY0Y2cGBDsupEc3nM5H7zpKAx/DguT3IsZZbkEC2SdjRlcZdp+3m3Bo+sWcQaOOL+b+QI31RqilOR34QSs6T8cFnLZ2wGRGlgIDwIjA5Wx2ZFCpJuiK3drTid+Opzv+aQUJAf2itgudSNQLbw= Received: from [216.39.60.167] by nm7.access.bullet.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 15:55:07 -0000 Received: from [67.195.22.117] by tm3.access.bullet.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 15:55:07 -0000 Received: from [127.0.0.1] by smtp112.sbc.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 15:55:07 -0000 X-Yahoo-Newman-Id: 713719.2104.bm@smtp112.sbc.mail.gq1.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: MyOcPa8VM1l_WdncOXCKNiSg8SuYQ639aG1TBOnblcvh1mr _y0brmQak3i2eP1UY1JqnJ8ynVB1VPitDyPeRlVgKfLPAwMtkD4ystY0c16H 1Dj08hE76yEr91jH83TJvk8vww8lLRS89Lz1zCpxLUxFqzO6PUsNgcvwTXKy IqiZ44wolI66YAgy1RaROB_ztrzLxaWBZnh_V0.yRkrxK4OnmIdF7BXXA9v9 EkEew_DDoXAZ9TQjZP8D_96CfgtqzX_oF_YOwwxfysXArliqmWM.uVXfcJcx iBvG5h4zl0t.kqwETbfVm62nDQyADnLhELJKUXRAbCdoRt4_lfuHDncE8CDC LsD3vXoWcRQSTtwNfIEBpovUdnGe50ej6p96.eYVAEgHLLkAeehq20Yz_hWG R0lWvzs900ZSHGWsXZ1ED0L6C5vi1n2D67YE4eCmRJrxceode3pNXKEu.nXb 9jEm9LDwcG3PeDGs0JQi3qeapxz8VRunARzV98Olu9eVt9fOA.W6U.AvjZXC QVzNvFl7RqQpmYjWy0.cAdU1FsdknDs19gCT4cah4f5F7hrJkDe157Vc1Kln 1dXjW5a1zYq00zwtINyOdEDU- X-Yahoo-SMTP: pPvqnOaswBBbYZLVYFzvU7GaowLcbNioPp.aF8KvOjZk From: To: Miroslav Lachman <000.fbsd@quip.cz> Cc: freebsd-ports Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files Date: Wed, 19 Apr 2017 11:55:11 -0400 Message-ID: <5dtefclcrhm4324v2o60miegrnb86qb4ko@4ax.com> References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> <58F74DF2.4000208@quip.cz> <58F75DA8.8070305@quip.cz> In-Reply-To: <58F75DA8.8070305@quip.cz> X-Mailer: Forte Agent 4.2/32.1118 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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 15:57:24 -0000 [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?