All,
I'm hoping for some help on trying to figure out what is going on with
our postgres implementation. We have an application that uses Hibernate
to persist objects into a Postgres database. We've run into a
semi-repeatable problem (every other or every third test run) where we
issue an update SQL command to update a single row in a table and that
update just hangs (we've let it go for more than 12hrs to see if it
would eventually complete and it did not) While the update is hung the
system has a negligible CPU load (with postgres not even showing up in a
top listing)
We've dumped the locks and it shows that all locks have been granted so
it appears that it is not a lock that is standing in our way. We've
also gone in via psql while the update is hung and were able to perform
an update on the offending table without issue. Finally, we have also
enabled the statement_timeout and set it to five minutes and it does
timeout the hung update and return to normal processing by rolling back
the offending transaction but that's not a viable solution for us.
Anyone have any words of wisdom on how to track this down?
Thanks,
-Craig