Can't install: ERROR 2013 (HY000)

[Jay Hannah]

Howdy --

I'm trying to install Q4M and hitting the error below. Any idea what
I'm doing wrong?

ERROR 2013 (HY000): Lost connection to MySQL server during query

Thanks!

j

----------------------
q4m-0.3-linux-i386

SLES 10 (SUSE Linux Enterprise Server version 10)

$ uname -a
Linux cac-dev 2.6.16.54-0.2.3-default #1 Thu Nov 22 18:32:07 UTC 2007
i686 i686 i386 GNU/Linux
$ cat /proc/version
Linux version 2.6.16.54-0.2.3-default (geeko@buildhost) (gcc version
4.1.2 20070115 (prerelease) (SUSE Linux)) #1 Thu Nov 22 18:32:07 UTC
2007
$ mysql -V
mysql Ver 14.14 Distrib 5.1.23-rc, for pc-linux (i686) using readline
5.1

$ mysql -u root -p
Server version: 5.1.23-rc SUSE MySQL RPM
mysql> INSTALL PLUGIN queue SONAME 'libqueue_engine.so';
ERROR 2013 (HY000): Lost connection to MySQL server during query

[Kazuho Oku]

Hi,

Can you paste the configuration parameter of your mysql server? (can
be found in bin/mysqlbug script of your mysql installation)

I have only tested the binary version of Q4M
(q4m-0.3-linux-i386.tar.gz) with binary distribution of mysql server
provided by MySQL AB, and your installation might be using different
(binary incompatible) configuration parameters.

If that is the case, you should either 1) use a binary distribution of
mysql server provided by MySQL AB, or, 2) install Q4M from source code
with appropriate configuration options (that matches the settings
found in bin/mysqlbug script).

2008/3/25, Jay Hannah <j...@jays.net>:

--
Kazuho Oku

[Jay Hannah]

Kazuho Oku wrote:
> Can you paste the configuration parameter of your mysql server? (can
> be found in bin/mysqlbug script of your mysql installation)
>

$ grep -i CONFIGURE /usr/bin/mysqlbug
# This is set by configure
CONFIGURE_LINE="../configure '--enable-assembler' '--without-readline'
'--enable-large-files' '--infodir=/usr/share/info' '--libdir=/usr/lib'
'--libexecdir=/usr/sbin' '--localstatedir=/var/lib/mysql'
'--mandir=/usr/share/man' '--prefix=/usr' '--sysconfdir=/etc'
'--with-mysqld-user=mysql' '--with-isam' '--without-debug'
'--datadir=/usr/share' '--includedir=/usr/include'
'--with-extra-charsets=complex'
'--with-unix-socket-path=/var/lib/mysql/mysql.sock'
'--enable-thread-safe-client' '--with-comment=SUSE MySQL RPM'
'--with-libwrap' '--with-server-suffix='
'--with-ssl=/usr/include/openssl'
'--with-plugins=partition,example,federated,innobase,ndbcluster'
'HOSTNAME=/bin/hostname -f' '--with-embedded-server' 'CFLAGS=-march=i586
-mtune=i686 -fmessage-length=0 -D_FORTIFY_SOURCE=2 -O2 -DPIC -fPIC
-DUNDEF_HAVE_INITGROUPS -DFORCE_INIT_OF_VARS -fno-strict-aliasing'
'CXXFLAGS=-march=i586 -mtune=i686 -fmessage-length=0 -D_FORTIFY_SOURCE=2
-O2 -DPIC -fPIC -DUNDEF_HAVE_INITGROUPS -DFORCE_INIT_OF_VARS
-fno-strict-aliasing -fno-exceptions -fno-rtti'"
`test -n "$CONFIGURE_LINE" && echo "Configure command: $CONFIGURE_LINE"`

Did that help somehow? :)

> I have only tested the binary version of Q4M
> (q4m-0.3-linux-i386.tar.gz) with binary distribution of mysql server
> provided by MySQL AB, and your installation might be using different
> (binary incompatible) configuration parameters.
>
> If that is the case, you should either 1) use a binary distribution of
> mysql server provided by MySQL AB, or, 2) install Q4M from source code
> with appropriate configuration options (that matches the settings
> found in bin/mysqlbug script).
>

-ponder-

We try to stick with the SUSE package management system to keep our
credit card security compliance folks happy. So I think this MySQL 5.1
came from an RPM straight from SUSE.

I can bounce those other options off our admin here... -ponder-

Thanks!

j

[Kazuho Oku]

Thank you for pasting the mysqlbug script.

It seems that the SuSE distribution is not ABI-compatible with the
MySQL AB distribution of MySQL, since it does not have the
``--with-fast-mutex'' configuration option set.

The flag alters the definition of pthread_mutex_t. For Q4M to operate
correctly, it is a requirement that the definition of pthread_mutex_t
matches with the definition of mysql server. And the difference is
causing a crash.

So the bottom line is that you should either install Q4M from source
or use a binary distribution of MySQL with ``--with-fast-mutex''
option set.

2008/3/25, Jay Hannah <j...@jays.net>:

--
Kazuho Oku

[Kazuho Oku]

The problem has been identified as a bug of MySQL.
http://bugs.mysql.com/bug.php?id=35544

I hope it would be fixed soon. Meanwhile I might add a workaround in
the next release.

2008/3/25, Kazuho Oku <kazu...@gmail.com>:

--
Kazuho Oku