From owner-freebsd-pkg@freebsd.org Sun Apr 16 21:00:58 2017 Return-Path: Delivered-To: freebsd-pkg@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 6EDC5D41E93 for ; Sun, 16 Apr 2017 21:00:58 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) 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 5F81A1B3D for ; Sun, 16 Apr 2017 21:00:58 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: by mailman.ysv.freebsd.org (Postfix) id 5EF37D41E92; Sun, 16 Apr 2017 21:00:58 +0000 (UTC) Delivered-To: pkg@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 5EA57D41E91 for ; Sun, 16 Apr 2017 21:00:58 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (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 3CF081B3B for ; Sun, 16 Apr 2017 21:00:58 +0000 (UTC) (envelope-from bugzilla-noreply@FreeBSD.org) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id v3GL01m5022636 for ; Sun, 16 Apr 2017 21:00:58 GMT (envelope-from bugzilla-noreply@FreeBSD.org) Message-Id: <201704162100.v3GL01m5022636@kenobi.freebsd.org> From: bugzilla-noreply@FreeBSD.org To: pkg@FreeBSD.org Subject: Problem reports for pkg@FreeBSD.org that need special attention Date: Sun, 16 Apr 2017 21:00:58 +0000 X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Sun, 16 Apr 2017 21:00:58 -0000 To view an individual PR, use: https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=(Bug Id). The following is a listing of current problems submitted by FreeBSD users, which need special attention. These represent problem reports covering all versions including experimental development code and obsolete releases. Status | Bug Id | Description ------------+-----------+--------------------------------------------------- In Progress | 212022 | ports-mgmt/pkg: Segfaults when installing sensu p New | 193995 | [PATCH] ports-mgmt/pkg: floating point exception 2 problems total for which you should take action. From owner-freebsd-pkg@freebsd.org Tue Apr 18 19:54:27 2017 Return-Path: Delivered-To: freebsd-pkg@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 0A99BD449C1 for ; Tue, 18 Apr 2017 19:54:27 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) 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 E50321CEC for ; Tue, 18 Apr 2017 19:54:26 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: by mailman.ysv.freebsd.org (Postfix) id DA124D449BF; Tue, 18 Apr 2017 19:54:26 +0000 (UTC) Delivered-To: pkg@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 D990CD449BE; Tue, 18 Apr 2017 19:54:26 +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 774DF1CE7; Tue, 18 Apr 2017 19:54:26 +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 39DAF284B5; Tue, 18 Apr 2017 21:45:50 +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 EBFE3284AA; Tue, 18 Apr 2017 21:45:47 +0200 (CEST) Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files To: brnrd@FreeBSD.org, pkg@FreeBSD.org Cc: FreeBSD Ports References: <58DE5A34.3080305@quip.cz> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <58F66CEB.2090507@quip.cz> Date: Tue, 18 Apr 2017 21:45:47 +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: <58DE5A34.3080305@quip.cz> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 18 Apr 2017 19:54:27 -0000 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 From owner-freebsd-pkg@freebsd.org Wed Apr 19 19:41:49 2017 Return-Path: Delivered-To: freebsd-pkg@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 C89B6D46BF1 for ; Wed, 19 Apr 2017 19:41:49 +0000 (UTC) (envelope-from brnrd@FreeBSD.org) 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 AD9F1661 for ; Wed, 19 Apr 2017 19:41:49 +0000 (UTC) (envelope-from brnrd@FreeBSD.org) Received: by mailman.ysv.freebsd.org (Postfix) id ACF76D46BEF; Wed, 19 Apr 2017 19:41:49 +0000 (UTC) Delivered-To: pkg@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 AC71BD46BEE; Wed, 19 Apr 2017 19:41:49 +0000 (UTC) (envelope-from brnrd@FreeBSD.org) Received: from smtp01.qsp.nl (smtp01.qsp.nl [193.254.214.162]) by mx1.freebsd.org (Postfix) with ESMTP id 086BE65E; Wed, 19 Apr 2017 19:41:48 +0000 (UTC) (envelope-from brnrd@FreeBSD.org) Received: from smtp01.qsp.nl (localhost [127.0.0.1]) by smtp01.qsp.nl (Postfix) with ESMTP id D4F7A2A0D76; Wed, 19 Apr 2017 21:32:39 +0200 (CEST) Received: from mail.brnrd.eu (unknown [193.164.217.85]) by smtp01.qsp.nl (Postfix) with ESMTP; Wed, 19 Apr 2017 21:32:39 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=brnrd.eu; h=date:from:to:subject:message-id; s=default; bh=IF2AZFUPWJ7ahKRXgVR9ls9iwsSHy39ID+Bvcm5HmE8=; b=AlM45V3qm0pMd0PAURxF8o7kdqnIYqzVH+gavjR0kv1sgUMDQi5kth2IPjA60Mui8sMkCCLojYgvK5OvvkI3RwIlTCM47deyObishdHf5Os/k8z/mwq9z9q5IWvsLbl3QTDCuYAq2XUUUYp+b6L/kwg12wjov5yv1bx66MfMtyH9NLWKLAhKvR5XVKA+UA/yLzAtPstc6vCUaV/ztgVCXRHmW9LG6EU9oJr/lbRHOeusib+es2FJLVfDFUUFjdFmO2ngkAqYLVM99IYWxn0xWbxPjlFxOSUq5KYFngNKYjivL+57+uVPCvqRnw15VSv/6r0ULTr7YLg0khbDAlZaxQ== Received: from mail.bachfreund.nl (http.brnrd.eu [172.17.2.8]) by bachfreund.nl (OpenSMTPD) with ESMTPSA id 58434e76 TLS version=TLSv1.2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128 verify=NO; Wed, 19 Apr 2017 21:32:38 +0200 (CEST) MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit Date: Wed, 19 Apr 2017 21:32:38 +0200 From: Bernard Spil To: Miroslav Lachman <000.fbsd@quip.cz> Cc: pkg@freebsd.org, FreeBSD Ports Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files In-Reply-To: <58F66CEB.2090507@quip.cz> References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> Message-ID: <50950987cce41dc258762c89b80d8447@FreeBSD.org> X-Sender: brnrd@FreeBSD.org User-Agent: Roundcube Webmail/1.2.4 X-SMTP-Virus-Scanned: clamav at smtp01 X-Spam-Status: No, score=0.7 required=5.0 tests=DKIM_SIGNED, HK_RANDOM_ENVFROM, HK_RANDOM_FROM,T_DKIM_INVALID,UNPARSEABLE_RELAY autolearn=disabled version=3.4.1 X-Spam-Checker-Version: SpamAssassin 3.4.1 (2015-04-28) on svfilter04.qsp.nl X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 19 Apr 2017 19:41:49 -0000 On 2017-04-18 21:45, Miroslav Lachman 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 Hi Miroslav, Looks like it. My own servers were upgraded with mariadb from pkg without issues. Sorry for your inconvenience, don't know what would cause that. Bernard. From owner-freebsd-pkg@freebsd.org Thu Apr 20 08:08:59 2017 Return-Path: Delivered-To: freebsd-pkg@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 BE8ECD451CF for ; Thu, 20 Apr 2017 08:08:59 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) 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 AA00EEB0 for ; Thu, 20 Apr 2017 08:08:59 +0000 (UTC) (envelope-from 000.fbsd@quip.cz) Received: by mailman.ysv.freebsd.org (Postfix) id A5772D451CC; Thu, 20 Apr 2017 08:08:59 +0000 (UTC) Delivered-To: pkg@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 A4DB0D451CA; Thu, 20 Apr 2017 08:08:59 +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 68AF1EAE; Thu, 20 Apr 2017 08:08:59 +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 1B14E28462; Thu, 20 Apr 2017 10:08:57 +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 BABCF28423; Thu, 20 Apr 2017 10:08:55 +0200 (CEST) Subject: Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files To: Bernard Spil Cc: pkg@freebsd.org, FreeBSD Ports References: <58DE5A34.3080305@quip.cz> <58F66CEB.2090507@quip.cz> <50950987cce41dc258762c89b80d8447@FreeBSD.org> From: Miroslav Lachman <000.fbsd@quip.cz> Message-ID: <58F86C97.2080501@quip.cz> Date: Thu, 20 Apr 2017 10:08:55 +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: <50950987cce41dc258762c89b80d8447@FreeBSD.org> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-BeenThere: freebsd-pkg@freebsd.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: Binary package management and package tools discussion List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 20 Apr 2017 08:08:59 -0000 Bernard Spil wrote on 2017/04/19 21:32: > On 2017-04-18 21:45, Miroslav Lachman 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 [...] >>> [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 > > Hi Miroslav, > > Looks like it. My own servers were upgraded with mariadb from pkg > without issues. > > Sorry for your inconvenience, don't know what would cause that. The root cause is IMHO this change in pkg-plist https://svnweb.freebsd.org/ports/head/databases/mariadb101-client/pkg-plist?r1=436392&r2=436391&pathrev=436392 https://svnweb.freebsd.org/ports/head/databases/mariadb101-server/pkg-plist?r1=436857&r2=436856&pathrev=436857 but I don't understand why nobody else see this problem on pkg upgrade. We are using poudriere with standard ports tree, MariaDB is build with standard options etc. Miroslav Lachman