Re: [Ruby-DBI-devel] "Commands out of sync" error from MySQL

[Paul D. <pa...@sn...>]

At 22:06 +0100 6/30/02, Matthew Bloch wrote:
>Hello: using Ruby 1.6.7 with mysql-ruby 2.4.2a and ruby-dbi 0.14, am I safe
>trying to use the same database handle from multiple Ruby threads?  Only I'm
>getting a "Commands out of sync error" from MySQL, detailed here:
>
>   http://www.mysql.com/doc/C/o/Commands_out_of_sync.html
>
>and wondered whether particular sequences of commands etc. would be unsafe. 
>For instance if I use a select_all statement with a supplied block, can I
>still issue further queries inside the block?  Will delve into the source
>tonight, but I assume this is a bug, or at least there is some undocumented
>'unsafe' use of the mysql module?

This is probably related to use of the mysql_use_result attribute rather
than mysql_store_result.  Does that provide any clues to what's going on
or why you're seeing the problems you're seeing?

>
>cheers,
>
>--
>Matthew Bloch                 Bytemark Computer Consulting
>                                 http://www.bytemark.co.uk/
>                                   tel. +44 (0) 8707 455026
>