Thread: Transaction is read-only in auto commit mode
Hi,
My application based on Java servlets was running fine with version PostgreSQL 7.x, but started giving error: "transaction is read-only", in version 8.0 and 8.1. I am using Suse Linux 9.3/PostgreSQL 8.0 or Suse Linux 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers and all connections are in auto-commit mode. Could you please tell me what's going wrong. Strangely, I looked through all the postings in all the forums but could not find a mention of this problem. Am I doing something exttremely stupid or has something changed in version 8 onwards that's causing this problem? The error appears sporadically, not always but quite frequently. I am using the standard postgresql.conf, except that I had increased the shared buffers and working memory sizes.
I'd really appreciate if anyone could suggest a pointer for further investigation, if not an outright solution.
Thanks in advance..
Asok
On Sep 26, 2006, at 3:26 PM, Asok Chattopadhyay wrote: > My application based on Java servlets was running fine with version > PostgreSQL 7.x, but started giving error: "transaction is read- > only", in version 8.0 and 8.1. I am using Suse Linux 9.3/PostgreSQL > 8.0 or Suse Linux 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers > and all connections are in auto-commit mode. Could you please tell > me what's going wrong. Strangely, I looked through all the postings > in all the forums but could not find a mention of this problem. Am > I doing something exttremely stupid or has something changed in > version 8 onwards that's causing this problem? The error appears > sporadically, not always but quite frequently. I am using the > standard postgresql.conf, except that I had increased the shared > buffers and working memory sizes. Something is creating transactions in a read-only mode, though it's not clear why that would change from 7.4 to 8.0 (or were you using something even older?) I suspect it's an abstraction layer trying to be cute and getting things wrong, but that's just a guess. Turning on query logging should provide insight. -- Jim Nasby jim@nasby.net EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
Thanks Jim. I dowloaded the latest version of the JDBC drivers and installed them on the affected sites. So far, there were no error reported in the last12 hours. Hope it works!
Thanks again.
Asok
Jim Nasby <jim@nasby.net> wrote:
Jim Nasby <jim@nasby.net> wrote:
On Sep 26, 2006, at 3:26 PM, Asok Chattopadhyay wrote:
> My application based on Java servlets was running fine with version
> PostgreSQL 7.x, but started giving error: "transaction is read-
> only", in version 8.0 and 8.1. I am using Suse Linux 9.3/PostgreSQL
> 8.0 or Suse Linux 10.1/PostgreSQL 8.1. I am using JDBC 3 drivers
> and all connections are in auto-commit mode. Could you please tell
> me what's going wrong. Strangely, I looked through all the postings
> in all the forums but could not find a mention of this problem. Am
> I doing something exttremely stupid or has something changed in
> version 8 onwards that's causing this problem? The error appears
> sporadically, not always but quite frequently. I am using the
> standard postgresql.conf, except that I had increased the shared
> buffers and working memory sizes.
Something is creating transactions in a read-only mode, though it's
not clear why that would change from 7.4 to 8.0 (or were you using
something even older?) I suspect it's an abstraction layer trying to
be cute and getting things wrong, but that's just a guess. Turning on
query logging should provide insight.
--
Jim Nasby jim@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)