Packets out of order error... and test fails

Hi,

i have a strange problem with DBD::mysql-3.0007 and MySQL 5.0.24. I am
using Gentoo 2006.1 on x86 architecture.

I wrote a stored procedure, and call it from perl. If i call it once it
works, no problems. But when i call it multiple times i randomly lose
the mysql connection. 

Doing further investigation a activated mysql debug trace which revealed
the following : 

>mysql_real_query
| enter: handle: 8ef1e6c
| query: Query = 'call
insert_bookmark('http://www.heise.de/one','2006-06-25
10:32:49','Rallee','german news ticker computer','Heise Info Dienst');'
| >mysql_send_query
| | enter: rpl_parse: 0  rpl_pivot: 1
| <mysql_send_query
| >cli_advanced_command
| | >net_clear
| | <net_clear
| | >net_write_command
| | | enter: length: 129
| | <net_write_command
| | >net_flush
| | | >vio_is_blocking
| | | | exit: 1
| | | <vio_is_blocking
| | | >net_real_write
| | | | >vio_write
| | | | | enter: sd: 14, buf: 0x0x8ef6d78, size: 134
| | | | | exit: 134
| | | | <vio_write
| | | <net_real_write
| | <net_flush
| | exit: result: 0
| <cli_advanced_command
<mysql_real_query
>cli_read_query_result
| >vio_is_blocking
| | exit: 1
| <vio_is_blocking
| >vio_read_buff
| | enter: sd: 14, buf: 0x0x8ef6d78, size: 4
| <vio_read_buff
| packet_header: Memory: 0x8ef6d78  Bytes: (4)
07 00 00 06
| error: Packets out of order (Found: 6, expected 1)
| error: Wrong connection or packet. fd: socket (14)  len: -1
| >end_server
| | info: Net: socket (14)
| | >vio_close
| | <vio_close
| | >_myfree
| | | enter: ptr: 0x8ef2d58
| | <_myfree
| | >_myfree
| | | enter: ptr: 0x8ec0650
| | <_myfree
| | >net_end
| | | >_myfree
| | | | enter: ptr: 0x8ef6d78
| | | <_myfree
| | <net_end
| | >free_old_query
| | | >init_alloc_root
| | | | enter: root: 0x8ef2104
| | | <init_alloc_root
| | <free_old_query
| <end_server
| >set_mysql_error
| | enter: error :2013 'Lost connection to MySQL server during query'

i might have to add that i am using the multi-statements patch
( https://rt.cpan.org/Public/Bug/Display.html?id=12322 ) to be able to
get results back from the stored procedure. I was not able to recreate
the error above using the mysql command line client.

i know it says in the documentation that multiple result sets are
supported since DBD::mysql-3.0002 but when i try witout the patch i
get : DBD::mysql::st execute failed: PROCEDURE test.my_proc can't return
a result set in the given context ...

another thought was to look if my installation is right. I tried to run
the DBD::mysql-3.0007 test ( witout the patch ) . They finished with
fails :

t/40bindparam.t
not ok 23
Query returned id = 4, name = Andreas K, ref = ARRAY(0x8323038), 2

t/40bindparam2.t
not ok 11
Test 11: DBI error 0

t/insertid.t
not ok 5
not ok 8
not ok 9

Has anyone an idea what is going wrong? 

regards
Lutz Lange


-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]