Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-20 Thread Miroslav Lachman

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=436391=436392
https://svnweb.freebsd.org/ports/head/databases/mariadb101-server/pkg-plist?r1=436857=436856=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
___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"


Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-20 Thread Miroslav Lachman

scratch65...@att.net wrote on 2017/04/19 17:55:

[Default] On Wed, 19 Apr 2017 14:52:56 +0200, Miroslav Lachman
<000.f...@quip.cz> wrote:



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?


Yes, we are using FreeBSD 10.3-p18 amd64 on all our machines.
___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"


Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-19 Thread Bernard Spil

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

Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-19 Thread scratch65535
[Default] On Wed, 19 Apr 2017 14:52:56 +0200, Miroslav Lachman
<000.f...@quip.cz> wrote:

>scratch65...@att.net wrote on 2017/04/19 14:05:
>> [Default] On Wed, 19 Apr 2017 13:45:54 +0200, Miroslav Lachman
>> <000.f...@quip.cz> wrote:
>>
>>> scratch65...@att.net wrote on 2017/04/19 12:45:
 [Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
 <000.f...@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?
___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"


Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-19 Thread Miroslav Lachman

scratch65...@att.net wrote on 2017/04/19 14:05:

[Default] On Wed, 19 Apr 2017 13:45:54 +0200, Miroslav Lachman
<000.f...@quip.cz> wrote:


scratch65...@att.net wrote on 2017/04/19 12:45:

[Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
<000.f...@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

___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"


Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-19 Thread scratch65535
[Default] On Wed, 19 Apr 2017 13:45:54 +0200, Miroslav Lachman
<000.f...@quip.cz> wrote:

>scratch65...@att.net wrote on 2017/04/19 12:45:
>> [Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
>> <000.f...@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?
___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"


Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-19 Thread Miroslav Lachman

scratch65...@att.net wrote on 2017/04/19 12:45:

[Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
<000.f...@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*


Miroslav Lachman

___
freebsd-ports@freebsd.org mailing list
https://lists.freebsd.org/mailman/listinfo/freebsd-ports
To unsubscribe, send any mail to "freebsd-ports-unsubscr...@freebsd.org"


Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-19 Thread scratch65535
[Default] On Tue, 18 Apr 2017 21:45:47 +0200, Miroslav Lachman
<000.f...@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
>> 

Re: databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-04-18 Thread Miroslav Lachman

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: 

databases/mariadb101-client upgraded in wrong order, resulted in missing files

2017-03-31 Thread Miroslav Lachman
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