#44477: mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB' ------------------------------+----------------------- Reporter: ora.et.labora@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: mysql56 | ------------------------------+----------------------- Changes (by ryandesign@…): * owner: macports-tickets@… => pixilla@… * port: => mysql56 Old description:

{{{ $ 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.

New description: {{{ $ 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: [[br]] 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: [[br]] MySQL and -- I'm afraid to say Mariadb as well -- are the source of never ending trouble. -- -- Ticket URL: <https://trac.macports.org/ticket/44477#comment:2> MacPorts <http://www.macports.org/> Ports system for OS X

#44477: mysql56: check failed: 'field[1].type == MYSQL_TYPE_BLOB' ------------------------------+----------------------- Reporter: ora.et.labora@… | Owner: pixilla@… Type: defect | Status: new Priority: Normal | Milestone: Component: ports | Version: 2.3.1 Resolution: | Keywords: Port: mysql56 | ------------------------------+----------------------- Comment (by pixilla@…): All the MacPorts mysql database ports by default use different a "datadir". Did you create the mysql56 datadir by running 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; }}} -- Ticket URL: <https://trac.macports.org/ticket/44477#comment:4> MacPorts <http://www.macports.org/> Ports system for OS X