From: | Sam Jas <samjas33(at)yahoo(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org, Đỗ Ngọc Trí Cường <seminoob(at)gmail(dot)com> |
Subject: | Re: Connection Problems! |
Date: | 2009-11-03 17:21:10 |
Message-ID: | 392546.85482.qm@web95012.mail.in2.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
>> "java.lang.Exception: DB Error: org.postgresql.util.PSQLException: An I/O error
occured while sending to the backend."
This error is about the JVM has run out of all the memory that has been
allocated to it.
You can overcome this by increasing java memory parameter. Your Java application really needs a lot of memory (more than 128
MB by default!).
--
Thanks
Sam Jas
--- On Tue, 3/11/09, Đỗ Ngọc Trí Cường <seminoob(at)gmail(dot)com> wrote:
From: Đỗ Ngọc Trí Cường <seminoob(at)gmail(dot)com>
Subject: [GENERAL] Connection Problems!
To: pgsql-general(at)postgresql(dot)org
Date: Tuesday, 3 November, 2009, 9:55 AM
Dear all,
I have an problems with my postgresql database. My Database is 8.2.5 and size is ~10GB with a lot of simple select,update,insert statement using indexes.
My programs was built base on Java Environment using JDBC. In normal, there is no problem, the program run well, all transaction is complete, but sometimes, it dropped out connection in the middle of transaction and it threw this log:
"java.lang.Exception: DB Error: org.postgresql.util.PSQLException: An I/O error occured while sending to the backend."
In server's log, there isn't any notice about that errors. That transaction contain about 3 insert query to 3 table and 1 update to another table.
Besides, I'm sure that in my code, I've already set Autocommit to false. But when it dropped connection as that case, it was still insert/update into table, of course the remain query wasn't executed.
Do you know why? Or do you have any suggestion for me?
Thanks so much,
Best Regard,
Đỗ Ngọc Trí Cường.
-- Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From cricket scores to your friends. Try the Yahoo! India Homepage! http://in.yahoo.com/trynew
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2009-11-03 17:23:33 | Re: Problem with database performance, Debian 4gb ram ? |
Previous Message | Chris Barnes | 2009-11-03 17:19:31 | postgres logs indicate errors with prepared statements, since pgbouncer was installed. |