From owner-freebsd-ports@freebsd.org Wed Apr 19 12:09: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 9C4AFD4589D for ; Wed, 19 Apr 2017 12:09:02 +0000 (UTC) (envelope-from scratch65535@att.net) Received: from mailman.ysv.freebsd.org (unknown [127.0.1.3]) by mx1.freebsd.org (Postfix) with ESMTP id 7EDD110B5 for ; Wed, 19 Apr 2017 12:09:02 +0000 (UTC) (envelope-from scratch65535@att.net) Received: by mailman.ysv.freebsd.org (Postfix) id 7E34ED4589C; Wed, 19 Apr 2017 12:09: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 7DD8CD4589B for ; Wed, 19 Apr 2017 12:09:02 +0000 (UTC) (envelope-from scratch65535@att.net) Received: from nm8-vm5.access.bullet.mail.gq1.yahoo.com (nm8-vm5.access.bullet.mail.gq1.yahoo.com [216.39.63.126]) (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 5B07D10B4 for ; Wed, 19 Apr 2017 12:09:02 +0000 (UTC) (envelope-from scratch65535@att.net) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=att.net; s=s1024; t=1492603543; bh=O5CH5i4y5Ab8Opwg1ltLbUNsGO9qbkPwv+X3W9XH6LA=; h=From:To:Cc:Subject:Date:References:In-Reply-To:From:Subject; b=eWj9xJGLFFdfJHpfYj0G6P6ilPSpGEo0+qrqX+njiaYsgoqYIZ/91zcBVwEoOUHvU3CAE2kkq9uaAHuSJ5JpMzmcQUFeYu3kv3z63ESVMsEXBT3OMWDiQquIyNOHWA29d72zZUS5ZmWZx7SE04cGexvAAWewUzs5MWFq5ITl2uM= Received: from [216.39.60.166] by nm8.access.bullet.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 12:05:43 -0000 Received: from [67.195.22.118] by tm2.access.bullet.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 12:05:43 -0000 Received: from [127.0.0.1] by smtp113.sbc.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 12:05:43 -0000 X-Yahoo-Newman-Id: 705292.18921.bm@smtp113.sbc.mail.gq1.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: JHjJtlAVM1l52CM8K1z4fEUngz6m7huWoV15Fgq2Dc0AV5B fSc5RVJY6k.CuZDjINcqiKveEPSbVlAujt8u3VkoLBrkWaYiRhMs21qwkzzC dbxuWz2HOIEppKOS01tqZs69faNaIg.LFwvmUrsImjZ2DDZidUC2l4GFQeMp C6xUhrNg9K_7Ew5u7Kt1NX89J3Do9i2bm9wq3WCcHMWdK8HT.jgM.WkltjpL 0ICaRSShWMhhNfygV9tYPdwO.IQPGrrgljbZe0vmr8kp5WbbWoQURZAOeT5d xFuaQk6qI4hNtnCGiOT7aa4xXnkgsbADtZU.Jz5itemqwRmjeCrE8PoN446u 8Skb6P4vMvDOuAgaaLRftBOI89MmxjnVYq6DxFnLkM9c3zHzAp15QszYM8u8 HXDVH2zGAi3FV2xzHuGTa55SpUQ1DwQeAD113invqQdvKE9I2WYq7gIvoVed bi0b02E0xcQ4qevQGyfuvSMsZCMqbGEo_vI1S3H5srh6m2uXy5FhQ25ygJdh z8kjTNlZQODVlOSCoIHIDbiz5IxWkAoi3PA14_NsQASp.858e3zV5T7fU4ll Tg1of7NZEg.C.pq7RRIpyoXo- 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 08:05:50 -0400 Message-ID: References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> <58F74DF2.4000208@quip.cz> In-Reply-To: <58F74DF2.4000208@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 12:09:02 -0000 [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?