ruby-mysqlからruby-mysql2への移行

/usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:569:in `read' : invalid packet: sequence number mismatch(19 != 254(expected)) (Mysql::Protocol Error)
from /usr/lib/ruby/1.8/timeout.rb:48:in `timeout'
from /usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:  565:in `read'
from /usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql/protocol.rb:  335:in `retr_all_records'
from /usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:745:in `initialize'
from /usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:366:in `new'
from /usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:366:in `store_result'
from /usr/lib/ruby/gems/1.8/gems/ruby-mysql-2.9.4/lib/mysql.rb:348:in `query'
from ./db.rb:30:in `sqlToList'
from analyze.rb:31

gem install mysql2

require 'mysql'

require 'mysql2'

@db = Mysql::connect("hogehoge.jp","kaminogi","pass1234","dbname")

@db = Mysql2::Client.new(:host=> "hogehoge.jp",:username =>"kaminogi", :password=>"pass1234",:database=>"dbname")

def sqlToList(sql)
	rows = @db.query(sql)
	ret = Array.new()
	rows.each_hash do |row|
		ret.push(row)
	end
	return ret
end

def sqlToList(sql)
	rows = @db.query(sql,:cast => false)
	ret = Array.new()
	rows.each do |row|
		ret.push(row)
	end
	return ret
end