GMAN_DO always returns NULL

Bug #1380773 reported by Swany
8
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Gearman MySQL UDF
Invalid
Undecided
Unassigned

Bug Description

mysql> select gman_servers_set('127.0.0.1:7001');
+------------------------------------+
| gman_servers_set('127.0.0.1:7001') |
+------------------------------------+
| 127.0.0.1:7001 |
+------------------------------------+
1 row in set (0.00 sec)

mysql> select gman_do('shard_query_worker','{"sql":"show databases","schema_name":"default"}');
+----------------------------------------------------------------------------------+
| gman_do('shard_query_worker','{"sql":"show databases","schema_name":"default"}') |
+----------------------------------------------------------------------------------+
| NULL |
+----------------------------------------------------------------------------------+
1 row in set (0.00 sec)

Gearman has 'shard_query_worker' workers waiting for jobs:
status
custom_function 0 0 72
shard_query_worker 0 0 24
loader 1164 24 24
store_resultset 0 0 24
.

I don't know why GMAN_DO is returning NULL. No error messages are written to the log.

Revision history for this message
Swany (greenlion) wrote :

I tried MySQL 5.5, MariaDB 5.5, MySQL 5.6 all have same behavior on this box.
# uname -a
Linux bm-smtwin-b01 3.13.0-33-generic #58-Ubuntu SMP Tue Jul 29 16:45:05 UTC 2014 x86_64 x86_64 x86_64 GNU/Linux

Revision history for this message
Swany (greenlion) wrote :

This appears to be a problem with ubuntu libgearman-dev package. When I compiled my own gearmand and pointed configure to it, the issue resolved itself.

So probably not a gearman-mysql-udf bug, sorry.

Changed in gearman-mysql-udf:
status: New → Invalid
Revision history for this message
cam (green-field) wrote :

"This appears to be a problem with ubuntu libgearman-dev package. When I compiled my own gearmand and pointed configure to it, the issue resolved itself."

how to do,please!

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.