From owner-freebsd-ports@freebsd.org Wed Apr 19 10:47:32 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 CFFA6D45F26 for ; Wed, 19 Apr 2017 10:47:32 +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 B221612A4 for ; Wed, 19 Apr 2017 10:47:32 +0000 (UTC) (envelope-from scratch65535@att.net) Received: by mailman.ysv.freebsd.org (Postfix) id AE8FED45F22; Wed, 19 Apr 2017 10:47:32 +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 AE30AD45F21 for ; Wed, 19 Apr 2017 10:47:32 +0000 (UTC) (envelope-from scratch65535@att.net) Received: from nm18-vm9.access.bullet.mail.gq1.yahoo.com (nm18-vm9.access.bullet.mail.gq1.yahoo.com [216.39.62.65]) (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 8B7A612A2 for ; Wed, 19 Apr 2017 10:47:32 +0000 (UTC) (envelope-from scratch65535@att.net) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=att.net; s=s1024; t=1492598704; bh=+uUl7g2l7kJdt1ynfsTYPRz3mOEP5SP05ZSLKaQK21E=; h=From:To:Cc:Subject:Date:References:In-Reply-To:From:Subject; b=i2fjI1PQuG51H3gxbd7h5RFJK8iLPhK2FwMV6ecEDS96DfAzxD3TfL5f0SECb9duAZV9BPlXS62RIkJaliaV38NDr9rSYoBfLd1I5v1iiozBThPxARjrrCyMKn511qgawH19QZGk58bkJT61E1JpO6zd5Cl2IIjbgOSFH58s060= Received: from [216.39.60.167] by nm18.access.bullet.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 10:45:04 -0000 Received: from [67.195.23.144] by tm3.access.bullet.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 10:45:04 -0000 Received: from [127.0.0.1] by smtp116.sbc.mail.gq1.yahoo.com with NNFMP; 19 Apr 2017 10:45:04 -0000 X-Yahoo-Newman-Id: 482271.13306.bm@smtp116.sbc.mail.gq1.yahoo.com X-Yahoo-Newman-Property: ymail-3 X-YMail-OSG: 38M2uwMVM1lH5HcVQLe.9ybukrNepmkC15feJCajpX09faP UaxnYh45fpXbM8aBlwEACjpn1UtgHchc5MO.1a19TKHVkqE0FWbD2HhklSx7 D_CnWiJIBYoJYQCk0IFbqrtPiSAFOcfX0hWEyKrF0tL1hbi1TuRRPKZ3S6r4 KiNRcJ1EMXveg6njF2x8ck4XqYXwwPqz8iNUc.4pvA2IQHwrrJy37GG0KHU. 382p9Olj.0Y4R95sjAT2YlAS2BrRg6GgjJKeivu73.pIcuewsz4F6uuU2D2Z ASk5RPLl073azngj83iAPhXaEyaR0FbLWZa1t9DpRfY2vj02enb4J5tc8uOa xaldga1wjXRV2w6OnSfTPjsPOxm.MPJ7JH8NwABPCcZolLRGaJs.37rHfDuJ GIQXQd17jRBpAtcgzwgayrVR61z8DQWo5LN16ABYv0olQM8gyurFoLC98fTH dbqrKT0s.24zw4Sldytcz.8kTtqcFsbcm5Fw8ZH.vqXra73tUI10XVUYZ0zu oFuZIpeexXpe_zaAR2QmJYYb622hjL6oTyTyThefsXSYFIqgP0lNFbxPD2vh Yuu0UspgKaNg- 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 06:45:10 -0400 Message-ID: References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> In-Reply-To: <58F66CEB.2090507@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 10:47:32 -0000 [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/bin/mysqlaccess): No such file or >> directory >> pkg: fstat() failed for(/usr/local/include/mysql/big_endian.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/byte_order_generic.h): >> No such file or directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/byte_order_generic_x86.h): No such file or >> directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/byte_order_generic_x86_64.h): No such file >> or directory >> pkg: fstat() failed for(/usr/local/include/mysql/client_plugin.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/decimal.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/errmsg.h): No such file >> or directory >> pkg: fstat() failed for(/usr/local/include/mysql/handler_ername.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/handler_state.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/keycache.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/little_endian.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/m_ctype.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/ma_dyncol.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_alloc.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_attribute.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_byteorder.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_compiler.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_dbug.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_dir.h): No such file >> or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_getopt.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_list.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_net.h): No such file >> or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_pthread.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/my_xml.h): No such file >> or directory >> pkg: fstat() failed for(/usr/local/include/mysql/mysql_com.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/mysql_com_server.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/mysql_embed.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/mysql_time.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/mysqld_ername.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/mysqld_error.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/plugin_audit.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/plugin_auth_common.h): >> No such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/plugin_encryption.h): >> No such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/plugin_ftparser.h): No >> such file or directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/plugin_password_validation.h): No such file >> or directory >> pkg: fstat() failed for(/usr/local/include/mysql/psi/mysql_idle.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/psi/mysql_socket.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/psi/mysql_stage.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/psi/mysql_statement.h): >> No such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/psi/mysql_table.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/psi/mysql_thread.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_debug_sync.h): >> No such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_encryption.h): >> No such file or directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/service_encryption_scheme.h): No such file >> or directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/service_kill_statement.h): No such file or >> directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_md5.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_my_snprintf.h): >> No such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_sha1.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_thd_alloc.h): >> No such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_thd_autoinc.h): >> No such file or directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/service_thd_error_context.h): No such file >> or directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/service_thd_specifics.h): No such file or >> directory >> pkg: fstat() failed >> for(/usr/local/include/mysql/service_thd_timezone.h): No such file or >> directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_thd_wait.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/service_wsrep.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/sql_common.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/sql_state.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/sslopt-case.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/sslopt-longopts.h): No >> such file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/sslopt-vars.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/include/mysql/typelib.h): No such >> file or directory >> pkg: fstat() failed for(/usr/local/lib/mysql/libmysqlclient.so): No such >> file or directory >> pkg: fstat() failed for(/usr/local/lib/mysql/libmysqlclient_r.a): No >> such file or directory >> pkg: fstat() failed for(/usr/local/lib/mysql/libmysqlclient_r.so): No >> such file or directory >> pkg: fstat() failed for(/usr/local/lib/mysql/libmysqlclient_r.so.18): No >> such file or directory >> pkg: fstat() failed for(/usr/local/lib/mysql/plugin/daemon_example.ini): >> No such file or directory >> pkg: fstat() failed for(/usr/local/lib/mysql/plugin/dialog.so): No such >> file or directory >> pkg: fstat() failed >> for(/usr/local/lib/mysql/plugin/mysql_clear_password.so): No such file >> or directory >> pkg: fstat() failed for(/usr/local/libdata/ldconfig/mariadb101-client): >> No such file or directory >> pkg: fstat() failed for(/usr/local/man/man1/msql2mysql.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysql.1.gz): No such file or >> directory >> pkg: fstat() failed for(/usr/local/man/man1/mysql_config.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysql_find_rows.1.gz): No >> such file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysql_plugin.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysql_waitpid.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysqlaccess.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysqlbinlog.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysqlcheck.1.gz): No such >> file or directory >> pkg: fstat() failed for(/usr/local/man/man1/mysqldump.1.gz): 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 >> >> [51/86] Installing mariadb101-client-10.1.22... >> [51/86] Extracting mariadb101-client-10.1.22: .......... done >> .. >> .. >> [69/86] Deinstalling mariadb101-client-10.1.21... >> [69/86] Deleting files for mariadb101-client-10.1.21: >> pkg: /usr/local/bin/mysql different from original checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysql_config different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqladmin different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqlbinlog different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqlcheck different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqldump different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqlimport different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqlshow different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/bin/mysqlslap different from original checksum, not >> removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/auth_dialog_client.h different from >> original checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21..... >> pkg: /usr/local/include/mysql/m_string.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/my_config.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/my_decimal_limits.h different from >> original checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21.... >> pkg: /usr/local/include/mysql/my_global.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/my_sys.h different from original checksum, >> not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/my_valgrind.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/mysql.h different from original checksum, >> not removing >> [69/86] Deleting files for mariadb101-client-10.1.21.... >> pkg: /usr/local/include/mysql/mysql_version.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/plugin.h different from original checksum, >> not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/plugin_auth.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21.... >> pkg: /usr/local/include/mysql/psi/mysql_file.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/psi/psi.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21.... >> pkg: /usr/local/include/mysql/service_logger.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/include/mysql/service_progress_report.h different from >> original checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21.... >> pkg: /usr/local/include/mysql/services.h different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/lib/mysql/libmysqlclient.a different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21... >> pkg: /usr/local/lib/mysql/libmysqlclient.so.18 different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21..... >> pkg: /usr/local/man/man1/mysqladmin.1.gz different from original >> checksum, not removing >> [69/86] Deleting files for mariadb101-client-10.1.21.... done >> .. >> .. >> [82/86] Upgrading mariadb101-server from 10.1.21 to 10.1.22... >> ===> Creating groups. >> Using existing group 'mysql'. >> ===> Creating users >> Using existing user 'mysql'. >> [82/86] Extracting mariadb101-server-10.1.22: .......... done >> >> This was on FreeBSD 10.3 amd64 with packages from own poudriere with >> follogin settings: >> >> OPTIONS_UNSET= X11 GUI CUPS DOCS EXAMPLES NLS HAL >> WITH_BDB_VER=5 >> WITH_GHOSTSCRIPT_VER=9 >> DEFAULT_VERSIONS=apache=2.4 perl5=5.24 mysql=10.1m php=5.6 python=2.7 >> python3=3.5 pgsql=9.4 ssl=openssl >> DISABLE_LICENSES=yes >> >> >> databases_mariadb101-client/options >> OPTIONS_FILE_SET+=GSSAPI_NONE >> >> databases_mariadb101-server/options >> OPTIONS_FILE_SET+=MAXKEY >> OPTIONS_FILE_SET+=GSSAPI_NONE >> OPTIONS_FILE_SET+=SPHINX >> OPTIONS_FILE_SET+=SPIDER >> >> I think all users of MariaDB 10.1 should be warned in UPDATING >> >> Let me know if you need some more details. > >Am I the only one beaten by this issue? I see this on each of our >machines during pkg upgrade. > >Miroslav Lachman 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.