From: HEMPLEMAN Matthew <matthew.hempleman@alstom.com>
To: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Locking: PostgreSQL Vs. Oracle
Date: Mon, 19 Oct 2015 23:55:06 +0000
Message-ID: <8538b4e2251545379a2e081f68f2b53d@DB4PR48MB0124.041d.mgd.msft.net> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Hi all,
I'm in the process of migrating a web application from Oracle to PostgreSQL and, after quite a few headaches, it's almost there. The last step (I hope) is getting to the bottom of an intermittent locking issue I see when I run integration tests. Most of the time, all tests are passing, but occasionally a test will fail with a stale state exception. Another developer ran a few IT tests and said one run stalled and never finished. Based on a cursory look at the internal PG tables, he said it looked like too many tables were locked due locks propagating out via foreign keys. I'm not sure how this could be possible.
I've been looking into the differences between PostgreSQL and Oracle locking behavior, but nothing has jumped out at me so far. I'm not a dba so hopefully I'm missing something obvious. Any advice would be greatly appreciated! Thanks.
Additional information;
Isolation Level: read committed for both dbs
JBoss 6.1 eap
PostgreSQL 9.4
Hibernate 3.64
________________________________
CONFIDENTIALITY : This e-mail and any attachments are confidential and may be privileged. If you are not a named recipient, please notify the sender immediately and do not disclose the contents to another person, use it for any purpose or store or copy the information in any medium.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: matthew.hempleman@alstom.com
Subject: Re: Locking: PostgreSQL Vs. Oracle
In-Reply-To: <8538b4e2251545379a2e081f68f2b53d@DB4PR48MB0124.041d.mgd.msft.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox