Saturday, 15 May 2010

Ruby Sequel memory leak? -



Ruby Sequel memory leak? -

i need read many sqlite databases, on 54,000 databases, generate statistics.

i created ruby application, running on ruby 1.8.7 patchlevel 371, using sequel 3.44.0 , sqlite 1.3.7.

i wrote code read databases:

for in databases db= sequel.sqlite(i) # db'query , other operation db.disconnect end

after while programme crashes no errors. looked @ memory's consumption while application runs, , increases until size of ram.

is garbage collection problem? or have mistakes? there methods reading lot of databases ruby?

edit:

i have 4gb ram. tried with:

databases.each { |i| }

but nil worked. when programme reaches 2gb of memory utilize stopped.

sequel caches databases connect in sequel::databases array. if connect/disconnect big number of databases should remove database objects sequel::databases array can garbage collected.

http://sequel.rubyforge.org/rdoc/classes/sequel.html

ruby memory-leaks sequel

No comments:

Post a Comment