Ilya Bazylchuk <ilya.bazylc...@gmail.com> wrote: > Hey Guys, > > We have problems with DB connection in unicorn. When workers work some > hours we see in Postgres activity stucks connections with query > "COMMIT". After restart unicorn it work fine some time, then > connections stucks again. > > database.yml > > adapter: postgis > postgis_extension: true > schema_search_path: public,postgis > encoding: utf8 > pool: 5 > checkout_timeout: 10 > > unicorn 4.8.2 > pg 0.17.1 > rails 3.2.17
I'm not familiar with postgis. Is there any sort of idle timeout on the database side? Is this high or low traffic when things get stuck? I think the postgis/pg adapter guys might be able to help, too, since unicorn doesn't do anything with the DB connections itself. Some generic, DB-independent thoughts/questions: Sometimes, tiny socket buffer sizes with the DB connection might hit this. Any non-standard kernel/socket knobs or tuning? Also, if running Linux, which kernel version are you running? If it's 3.7, make sure commit 8fb74b9fb2b182d54beee592350d9ea1f325917a (mm: compaction: partially revert capture of suitable high-order page) got backported. _______________________________________________ Unicorn mailing list - mongrel-unicorn@rubyforge.org http://rubyforge.org/mailman/listinfo/mongrel-unicorn Do not quote signatures (like this one) or top post when replying