Opened 10 years ago

Last modified 5 years ago

#44477 assigned defect

mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB'

Reported by: ora.et.labora@… Owned by:
Priority: Normal Milestone:
Component: ports Version: 2.3.1
Keywords: Cc:
Port: mysql56

Description (last modified by ryandesign (Ryan Carsten Schmidt))

$ mysql_client_test -p
[..]
#####################################
196 of (1/1): test_bug14169  
#####################################
GROUP_CONCAT() result type 253/opt/local/var/macports/build/_opt_local_var_macports_sources_rsync.macports.org_release_ports_databases_mysql56/mysql56/work/mysql-5.6.19/tests/mysql_client_test.c:15409: check failed: 'field[1].type == MYSQL_TYPE_BLOB'


$ type -a mysql_client_test 
mysql_client_test is /opt/local/bin/mysql_client_test

$ mysql_client_test --help

mysql_client_test  Ver 2.1 Distrib 5.6.19, for osx10.8 (x86_64)
By Monty, Venu, Kent and others
[..]

$ mysql --version
mysql  Ver 14.14 Distrib 5.6.19, for osx10.8 (x86_64) using  EditLine wrapper
root@lhasa:~
$ type -a mysql
mysql is /opt/local/bin/mysql

What I did:
I upgraded from mysql5 to 5.6 by doing:

$ /opt/local/lib/mysql5/bin/mysqldump --all-databases -p > mysql5dump.out

# remove mysql5 et cetera

$ sudo port install mysql56
$ sudo port install mysql56-server
$ sudo port select --set mysql mysql56
$ mysql_upgrade -p
$ sudo mysqld --user mysql # in other terminal (just for the record)
$ mysql_upgrade -p

Personal note:
MySQL and -- I'm afraid to say Mariadb as well -- are the source of never ending trouble.

Change History (6)

comment:1 Changed 10 years ago by ora.et.labora@…

Sorry, forgot to format code in "what I did section" .. how can I change after having submitted?

comment:2 Changed 10 years ago by ryandesign (Ryan Carsten Schmidt)

Description: modified (diff)
Owner: changed from macports-tickets@… to pixilla@…
Port: mysql56 added
Summary: check failed: 'field[1].type == MYSQL_TYPE_BLOB'mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB'

comment:3 Changed 10 years ago by pixilla (Bradley Giesbrecht)

This looks like a MySQL issue, is there something MacPorts is doing that you believe is the cause?

Were there issues loading mysql5dump.out into mysql56?

comment:4 Changed 10 years ago by pixilla (Bradley Giesbrecht)

All the MacPorts mysql database ports by default use a different "datadir". Did you run the mysql_install_db script as the mysql56-server notes suggest?

port notes mysql56-server

These steps should get you a functional mysql56 server:

$ sudo port install mysql56-server
$ sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db
$ sudo port load mysql56-server
$ /opt/local/lib/mysql56/bin/mysql
mysql> show databases;
mysql> quit;
Last edited 10 years ago by pixilla (Bradley Giesbrecht) (previous) (diff)

comment:5 Changed 10 years ago by murrayeisenberg@…

During second of above-recommended installation steps...

$ sudo port install mysql56-server
$ sudo -u _mysql /opt/local/lib/mysql56/bin/mysql_install_db

...get:

WARNING: Could not write to config file /opt/local/etc/mysql56/my-new.cnf: Permission denied

And then when the mysql_install_db command completes:

WARNING: Could not copy config file template /opt/local/share/mysql56/support-files/my-default.cnf to
/opt/local/etc/mysql56/my-new.cnf, may not have access rights to do so.

So is there some missing step one needs to do to change permissions?

comment:6 Changed 5 years ago by mf2k (Frank Schima)

Owner: pixilla deleted
Status: newassigned

See #57827

Note: See TracTickets for help on using tickets.