ERROR 1126 (HY000) at line 1: Can't open shared library

[ThomasTL]

Hello,

I am trying to install Q4M the following configuration:
+ CentOS 5.5
+ Arch: x86_64
+ MySQL compilation option: -DMY_PTHREAD_FASTMUTEX=1, e.g. with-fast-
mutexes
+ MySQL 5.5

I have downloaded the binary tarball from Q4M website and followed the
instructions for the installation as below:
+ I copied q4m-forward file in /usr/bin/ directory which is the
directory where mysql resides.
+ I copied libqueue_engine.so file in /usr/lib64/mysql/plugin/
+ Additionally, i also changed the access rights to 755, same as the
other libraries in the directory.

Now, when i run: mysql -u root -p -f mysql < support-files/install.sql

I have the following error for each line in install.sql script:

ERROR 1126 (HY000) at line 1: Can't open shared library '/usr/lib64/
mysql/plugin/libqueue_engine.so' (errno: 2 undefined symbol:
_ZN7handler26get_dynamic_partition_infoEP14PARTITION_INFOj)

Still the library is in the right directory.

Do you know where did i do wrong?
Do you know how could i fix this issue?

Thanks and regards,

Thomas

[Kazuho Oku]

Hi,

Sorry Q4M does not support MySQL 5.5 for now. Please use MySQL 5.1
(and if you are going to use the binary version of Q4M please use
mysqld with the same bugfix version number (xx of 5.1.xx) as the
tar.gz filename of q4m).

2011/3/27 ThomasTL <thomas...@gmail.com>:

> --
> You received this message because you are subscribed to the Google Groups "Q4M - a Message Queue for MySQL" group.
> To post to this group, send email to q4m-g...@googlegroups.com.
> To unsubscribe from this group, send email to q4m-general...@googlegroups.com.
> For more options, visit this group at http://groups.google.com/group/q4m-general?hl=en.
>
>

--
Kazuho Oku

[ThomasTL]

Hello,

Thank you for your reply.
I have now installed MySQL 5.1.55.
I have built MySQL from SRPM and installed it.
Then i have built Q4M from the source and installed it.
I had no errors when i ran the installation script (install.sql).
I tried to run the test suite and have some errors as follow:

1. t/02-queue:
# Failed test in t/02-queue.t at line 33.
t/02-queue................................NOK 9# Structures begin
differing at:
# $got->[0][0] = '0'
# $expected->[0][0] = '1'

# Failed test in t/02-queue.t at line 33.
t/02-queue................................NOK 12# Structures begin
differing at:
# $got->[0][0] = '0'
# $expected->[0][0] = '2'

The error happens for each iteration of the loop.
Except for the last one which gives me the following error:
t/02-queue................................NOK
3077
# Failed test in t/02-queue.t at line 40.
# Structures begin differing at:
# $got->[0] = ARRAY(0x2631bd0)
# $expected->[0] = Does not exist
# Looks like you failed 1024 tests of 3077.


2. t/03-queue-error-wait
# Failed test in t/03-queue-error-wait.t at line 25.
t/03-queue-error-wait.....................NOK 6# Structures begin
differing at:
# $got->[0] = ARRAY(0x1d318e0)
# $expected->[0] = Does not exist

# Failed test in t/03-queue-error-wait.t at line 40.
t/03-queue-error-wait.....................NOK 12# Structures begin
differing at:
# $got->[0] = ARRAY(0x1d32410)
# $expected->[0] = Does not exist

3. t/03-queue-error
t/03-queue-error..........................NOK 5# Failed test in t/03-
queue-error.t at line 29.
# Structures begin differing at:
# $got->[0][0] = '1'
# $expected->[0][0] = '2'

t/03-queue-error..........................NOK
6
# Failed test in t/03-queue-error.t at line 33.
# Structures begin differing at:
# $got->[1] = ARRAY(0xbca4d0)
# $expected->[1] = Does not exist
DBD::mysql::db do failed: Can't initialize function 'queue_abort';
queue_abort(): not in owner mode at t/03-queue-error.t line 37.

Can you help me understand the issues i am having during the test?

Thanks and regards,

Thomas

On Mar 30, 5:43 pm, Kazuho Oku <kazuho...@gmail.com> wrote:
> Hi,
>
> Sorry Q4M does not support MySQL 5.5 for now.  Please use MySQL 5.1
> (and if you are going to use the binary version of Q4M please use
> mysqld with the same bugfix version number (xx of 5.1.xx) as the
> tar.gz filename of q4m).
>

> 2011/3/27 ThomasTL <thomas.tar...@gmail.com>:

[Kazuho Oku]

Hi,

To where did you set the --with-mysql option of the configure script
of Q4M? It should point to the directory of a mysql source
distribution compiled with the same options as the one installed on
your machine.

2011/3/31 ThomasTL <thomas...@gmail.com>:

[ThomasTL]

Hello,

Here is the configure options:
./configure --with-mysql=~/redhat/BUILD/mysql-5.1.55/ --prefix=/usr/

Where ~/redhat/BUILD/mysql-5.1.55/ is the base directory of MySQL
source code distribution used to compile mysql* rpm packages that have
been installed on my machine.

Thanks for your support,

Thomas

On Mar 31, 2:27 pm, Kazuho Oku <kazuho...@gmail.com> wrote:
> Hi,
>

> To where did you set the --with-mysql option of the configure script
> of Q4M?  It should point to the directory of a mysql source
> distribution compiled with the same options as the one installed on
> your machine.
>

> 2011/3/31 ThomasTL <thomas.tar...@gmail.com>: