Ruby/mysql connection close problem


#1

Hello,

I am using the Ruby/mysql module installed from gems and everything is
working fine except the connections arent closing. I was under the
impression that upon completion of a script the database handle will
close automatically but regardless even by explicitly stating
dbh.close() at the end of the script I cant get the database to close
the connection. This is obviously a problem as the limit of connections
is eventually reached.

I am running apache2 on ubuntu 7.10, I am calling the ruby script (that
connects and queries the database) from embedded ruby in an .rhtml file.

I do not have the code available right now as I am posting from another
computer but can post the code if anyone thinks it will help.

Any help appreciated,

Thanks


#2

I am running apache2 on ubuntu 7.10, I am calling the ruby script (that
connects and queries the database) from embedded ruby in an .rhtml file.

I do not have the code available right now as I am posting from another
computer but can post the code if anyone thinks it will help.

Any help appreciated,

Thanks

I suppose if you got really desperate you could use mysqlplus then hard
force close the connection.

descriptor_number = conn.socket
a = IO.new(descriptor_number)
a.close
Maybe.
-=R