worker processes are keeping the database open

[abh]

While checking which domain my backup process had gotten to I noticed that the worker processes are keeping the sqlite database open, is that intentional/needed?

# lsof -nP | grep tank | grep db.sqlite
ruby1.9.1 18933       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 18933       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21428       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21428       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21431       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21431       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21434       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21434       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21437       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21437       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21440       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21440       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21443       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21443       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21446       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21446       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21449       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21449       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21452       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21452       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21455       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21455       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21458       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21458       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21461       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21461       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21464       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21464       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21467       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21467       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21470       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21470       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21473       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21473       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21476       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21476       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21479       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21479       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21482       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21482       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21485       root    3u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 21485       root    4u      REG               0,47 11999232          7 /tank/mogile/us-prod-media/db.sqlite
ruby1.9.1 26776       root    3u      REG               0,40 34985984          7 /tank/mogile/ca-prod-logs/db.sqlite
ruby1.9.1 26776       root    4u      REG               0,40 34985984          7 /tank/mogile/ca-prod-logs/db.sqlite
ruby1.9.1 26821       root    3u      REG               0,40 34985984          7 /tank/mogile/ca-prod-logs/db.sqlite
ruby1.9.1 26821       root    4u      REG               0,40 34985984          7 /tank/mogile/ca-prod-logs/db.sqlite

[jesseangell]

No it's not intentional and isn't needed. Originally I was trying to come up with a good way of letting the children report their results directly in the database. I ran into too many locking issues and finally moved that work to the parent process. So it's basically left-over from that.