I'm using it with gearman. Here's the full error. Happy to help debug
and give you access to the box (it's isolated from production stuff)
if you think it'll help.
ERROR [ main ] drizzle_row_buffer:drizzle_state_packet_read:bad
packet number:4:110 ->
libgearman-server/plugins/queue/drizzle/queue.cc:552
Here's an strace:
fcntl(19, F_GETFL) = 0 (flags O_RDONLY)
fcntl(19, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
epoll_ctl(16, EPOLL_CTL_ADD, 19, {EPOLLIN, {u32=19, u64=19}}) = 0
mmap(NULL, 10489856, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS|MAP_32BIT, -1, 0) = 0x41ab3000
mprotect(0x41ab3000, 4096, PROT_NONE) = 0
clone(child_stack=0x424b3240,
flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID,
parent_tidptr=0x424b39d0, tls=0x424b3940, child_tidptr=0x424b39d0) =
19398
clock_gettime(CLOCK_MONOTONIC, {739459, 702088264}) = 0
clock_gettime(CLOCK_MONOTONIC, {739459, 702158264}) = 0
getuid() = 0
geteuid() = 0
getgid() = 0
getegid() = 0
epoll_create(32000) = 21
fcntl(21, F_SETFD, FD_CLOEXEC) = 0
socketpair(PF_FILE, SOCK_STREAM, 0, [22, 23]) = 0
fcntl(22, F_SETFD, FD_CLOEXEC) = 0
fcntl(23, F_SETFD, FD_CLOEXEC) = 0
fcntl(22, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
getuid() = 0
geteuid() = 0
getgid() = 0
getegid() = 0
pipe([24, 25]) = 0
fcntl(24, F_GETFL) = 0 (flags O_RDONLY)
fcntl(24, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
epoll_ctl(21, EPOLL_CTL_ADD, 24, {EPOLLIN, {u32=24, u64=24}}) = 0
mmap(NULL, 10489856, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS|MAP_32BIT, -1, 0) = 0x424b4000
mprotect(0x424b4000, 4096, PROT_NONE) = 0
clone(child_stack=0x42eb4240,
flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID,
parent_tidptr=0x42eb49d0, tls=0x42eb4940, child_tidptr=0x42eb49d0) =
19399
clock_gettime(CLOCK_MONOTONIC, {739459, 703731264}) = 0
clock_gettime(CLOCK_MONOTONIC, {739459, 703805264}) = 0
getuid() = 0
geteuid() = 0
getgid() = 0
getegid() = 0
epoll_create(32000) = 26
fcntl(26, F_SETFD, FD_CLOEXEC) = 0
socketpair(PF_FILE, SOCK_STREAM, 0, [27, 28]) = 0
fcntl(27, F_SETFD, FD_CLOEXEC) = 0
fcntl(28, F_SETFD, FD_CLOEXEC) = 0
fcntl(27, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
getuid() = 0
geteuid() = 0
getgid() = 0
getegid() = 0
pipe([29, 30]) = 0
fcntl(29, F_GETFL) = 0 (flags O_RDONLY)
fcntl(29, F_SETFL, O_RDONLY|O_NONBLOCK) = 0
epoll_ctl(26, EPOLL_CTL_ADD, 29, {EPOLLIN, {u32=29, u64=29}}) = 0
mmap(NULL, 10489856, PROT_READ|PROT_WRITE,
MAP_PRIVATE|MAP_ANONYMOUS|MAP_32BIT, -1, 0) = 0x42eb5000
mprotect(0x42eb5000, 4096, PROT_NONE) = 0
clone(child_stack=0x438b5240,
flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID,
parent_tidptr=0x438b59d0, tls=0x438b5940, child_tidptr=0x438b59d0) =
19400
sendto(3, "N\0\0\0\3SELECT
unique_key,function_name,priority,data,when_to_run FROM
gearman_queue5", 82, 0, NULL, 0) = 82
recvfrom(3, 0x1766888, 32768, 0, 0, 0) = -1 EAGAIN (Resource
temporarily unavailable)
poll([{fd=3, events=POLLIN}], 1, -1) = 1 ([{fd=3, revents=POLLIN}])
recvfrom(3,
"\1\0\0\1\5H\0\0\2\3def\2gm\16gearman_queue5\16gearman_queue5\nunique_key\nunique_key\f\10\0@\0\0\0\375\10@\0\0\0N\0\0\3\3def\2gm\16gearman_queue5\16gearman_queue5\rfunction_name\rfunction_name\f\10\0\377\0\0\0\375\0@\0\0\0D\0\0\4\3def\2gm\16gearman_queue5\16gearman_queue5\10priority\10priority\f?\0\v\0\0\0\3\0\0\0\0\0<\0\0\5\3def\2gm\16gearman_queue5\16gearman_queue5\4data\4data\f?\0\377\377\377\377\374\220\0\0\0\0J\0\0\6\3def\2gm\16gearman_queue5\16gearman_queue5\vwhen_to_run\vwhen_to_run\f?\0\24\0\0\0\10\0\0\0\0\0\5\0\0\7\376\0\0\2\0\5\0\0\10\376\0\0\2\0",
32768, 0, NULL, NULL) = 395
close(3) = 0
write(1, "ERROR [ main ]
drizzle_row_buffer:drizzle_state_packet_read:bad packet number:4:110
-> libgearman-server/plugins/queue/drizzle/queue.cc:552\n", 141ERROR [
main ] drizzle_row_buffer:drizzle_state_packet_read:bad packet
number:4:110 -> libgearman-server/plugins/queue/drizzle/queue.cc:552
) = 141
shutdown(7, 2 /* send and receive */) = 0
close(7) = 0
shutdown(8, 2 /* send and receive */) = 0
close(8) = 0
close(9) = 0
close(10) = 0
write(30, "\1", 1) = 1
futex(0x438b59d0, FUTEX_WAIT, 19400, NULL) = -1 EAGAIN (Resource
temporarily unavailable)
close(29) = 0
close(30) = 0
futex(0x1770824, FUTEX_WAKE_OP_PRIVATE, 1, 1, 0x1770820,
{FUTEX_OP_SET, 0, FUTEX_OP_CMP_GT, 1}) = 1
futex(0x17707f8, FUTEX_WAKE_PRIVATE, 1) = 1
close(27) = 0
close(28) = 0
close(26) = 0
write(25, "\1", 1) = 1
futex(0x42eb49d0, FUTEX_WAIT, 19399, NULL) = -1 EAGAIN (Resource
temporarily unavailable)
close(24) = 0
close(25) = 0
close(22) = 0
close(23) = 0
close(21) = 0
write(20, "\1", 1) = 1
futex(0x424b39d0, FUTEX_WAIT, 19398, NULL) = -1 EAGAIN (Resource
temporarily unavailable)
munmap(0x42eb5000, 10489856) = 0
close(19) = 0
close(20) = 0
close(17) = 0
close(18) = 0
close(16) = 0
write(15, "\1", 1) = 1
munmap(0x410b2000, 10489856) = 0
close(14) = 0
close(15) = 0
close(12) = 0
close(13) = 0
close(11) = 0
close(5) = 0
close(6) = 0
close(4) = 0
exit_group(1) = ?
and here's a view of the db table
mysql> describe gearman_queue5;
+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| unique_key | varchar(64) | YES | MUL | NULL | |
| function_name | varchar(255) | YES | | NULL | |
| priority | int(11) | YES | | NULL | |
| data | longblob | YES | | NULL | |
| when_to_run | bigint(20) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------+
5 rows in set (0.00 sec)
mysql> show indexes from gearman_queue5;
+----------------+------------+------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
| Table | Non_unique | Key_name | Seq_in_index |
Column_name | Collation | Cardinality | Sub_part | Packed | Null |
Index_type | Comment |
+----------------+------------+------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
| gearman_queue5 | 0 | unique_key | 1 | unique_key
| A | NULL | NULL | NULL | YES | BTREE |
|
| gearman_queue5 | 0 | unique_key | 2 |
function_name | A | NULL | NULL | NULL | YES |
BTREE | |
+----------------+------------+------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+
2 rows in set (0.00 sec)
mysql> select * from gearman_queue5;
Empty set (0.00 sec)
mysql>
On Tue, Sep 6, 2011 at 2:13 PM, Andrew Hutchings
<[email protected]> wrote:
> ok, this version should have all the fixes in, so the fact you are
> getting this is not good. Is it possible to give a test case that
> reproduces this?
>
> Can you also provide the exact error message you are seeing? The
> numbers at the end will help to diagnose this.
>
> --
> You received this bug notification because you are subscribed to the bug
> report.
> https://bugs.launchpad.net/bugs/528410
>
> Title:
> drizzle_state_packet_read:bad packet number
>
> Status in A Lightweight SQL Database for Cloud Infrastructure and Web
> Applications:
> Opinion
> Status in Drizzle Client & Protocol Library:
> Fix Released
>
> Bug description:
> I am getting the following error when using libdrizzle 0.7 together
> with MySQL Ver 14.14 Distrib 5.1.38. The error occurs when using
> “drizzle_result_buffer”:
>
> drizzle_state_packet_read:bad packet number:213:223
>
> The error is reproduceable; it always occurs on the same query. This
> query works just fine when running it with the “mysql” commandline
> client.
>
> To manage notifications about this bug go to:
> https://bugs.launchpad.net/drizzle/+bug/528410/+subscriptions
>
--
You received this bug notification because you are a member of UBUNTU -
AL - BR, which is subscribed to Drizzle.
https://bugs.launchpad.net/bugs/528410
Title:
drizzle_state_packet_read:bad packet number
Status in A Lightweight SQL Database for Cloud Infrastructure and Web
Applications:
Opinion
Status in Drizzle Client & Protocol Library:
Fix Released
Bug description:
I am getting the following error when using libdrizzle 0.7 together
with MySQL Ver 14.14 Distrib 5.1.38. The error occurs when using
“drizzle_result_buffer”:
drizzle_state_packet_read:bad packet number:213:223
The error is reproduceable; it always occurs on the same query. This
query works just fine when running it with the “mysql” commandline
client.
To manage notifications about this bug go to:
https://bugs.launchpad.net/drizzle/+bug/528410/+subscriptions
--
Mailing list: https://launchpad.net/~linux-traipu
Post to : [email protected]
Unsubscribe : https://launchpad.net/~linux-traipu
More help : https://help.launchpad.net/ListHelp
