[Ruby-DBI-devel] methods disappearing in ruby-mysql-2.4.2a

[Brad H. <bh...@vp...>]

Hello,

Sorry to cross-post to ruby-dbi-devel, but I wasn't sure which list
might be more appropriate for a problem I'm having.  In one of my
programs I am using ruby-dbi/ruby-dbd-mysql 0.0.13 and ruby-mysql 2.4.2a
on a FreeBSD 4.5 box running ruby 1.6.7 (2002-05-01).

I am inserting thousands of rows on a daily basis, and *sometimes* (I
can't reproduce the problem on demand) the script dies with messages
like these:

usr/local/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:321:in `finish':
undefined method `free' for #<Mysql:0x81a9d44> (NameError)
        from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:701:in
`finish'

or:

/usr/local/lib/ruby/site_ruby/1.6/DBD/Mysql/Mysql.rb:368:in
`column_info': undefined method `fetch_fields' for #<Mysql:0x81a8d44>
(NameError)
        from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:714:in
`column_names'
        from /usr/local/lib/ruby/site_ruby/1.6/dbi/dbi.rb:695:in
`execute'

-----------------------------

The strange thing is, the same exact command succeeds thousands of times
prior to this error.  How could the Mysql object not contain the methods
"fetch_fields" and "free"?  They are compiled in to the mysql.so file
which is necessary to create the Mysql object in the first place.  How
could those methods just disappear?

It is like the Mysql object had all of its methods removed somehow.

Does anyone have any suggestions?

Thanks,
-Brad