we have java application connects postgres database. java application runs out of memory , dies because waiting on response transaction sent database never returned.
i enabled logging of pg_locks , transactions on 1 minute interval time period problem has been occurring. found transaction causing problem, appears hung.
it's doing simple update statement on table no more 10 records, sits there in transaction hours. there nothing in pg_locks view indicate transaction waiting on lock, don't know why gets hung up. kill java application , restart it, transaction clears out , business continues normal. question is, can cause transaction hung?
Comments
Post a Comment