I have strange problem with this setup. Strangely it occurs only when using owncloud from one specific computer.
Problem is when user click on "Activities" an "document" icons one after another sometimes postgresql starts to use insane amount of cpu and site stops working (504) but only for this one specific client, other computers still can use the site. First thing what helps is restarting nginx.
But after I learn how to reproduce this error and noticed that postgresql is using 100% of one of cpu cores. I figured out that restarting only postgresql helps too. So it must be postgres related error. But I got no trace of cause in any log files I checked
- nginx-(nginx/error.log) log connection timed out to upstream (php5-fpm I assume)
- php5-fpm log(log/php5-fpm.log ) is clear - no entries besides starting a service
- postgresql logs(postgresql-9.1-main.log) - the same
I tried update the browser on the client with no effect. Can you point where else should I look for the cause? Maybe I can set it up to kill/restart the database connection that is causing the problem? I'm really out of ideas
Tried reproduce this on other computers with same Firefox and Windows 7 versions(same updates) with no success.
How can I check what postgresql is trying to do when it's working so hard and endlessly?
Configs are pretty much all defaults besides increasing
php5-fpm and add a
pm.max_requests = 5000 to it - that was before I notice database behaviour.
Nginxn config is straight from ownCloud docs.
Server is running Ubuntu 12.04