linux-traipu team mailing list archive
-
linux-traipu team
-
Mailing list archive
-
Message #01804
Re: [Bug 528410] Re: drizzle_state_packet_read:bad packet number
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
<528410@xxxxxxxxxxxxxxxxxx> 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
References
