PostgreSQL JDBC - JDBC locking on processResults

Author

JDBC locking on processResults

Mike Heath

2005-04-20, 8:24 pm

I'm using Postgresql 8.0.2 on SuSE Linux Professional 9.2. I'm using
Java version 1.5.0_02. I'm using The 8.0.311 build of the JDBC driver.

I've spent all day trying to debug this problem and the following is as
far as I've gotten. I've been stepping through the JDBC driver code and
when I get to org.postgresql.jdbc2. AbstractJdbc2Stateme
nt (object is
actually of type Jdbc3PreparedStateme
nt) in method int[] executeBatch()

Value in queries (as a string produced to toString() method) ="insert
into assets (report_id, create_date, modify_date, asset_name, parent_id,
asset_type_id, create_user_id, modify_user_id, account_id, disabled,
hidden, id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"

The value in parameterLists.SimpleParameterList =
"[java.lang.Object@19afdb9, 2005-04-20 16:36:01.566000-0600, 2005-04-20
16:36:01.566000-0600, Image test, java.lang.Object@19afdb9, 9, 1, 1, 1,
0, 0, 565]"

This all looks simple enough. At least, I can't see anything out of the
ordinary here.

However, when I trace down to
org.postgresql.core.V3.QueryExecutorImpl. processResults(Resut
lHandler,
int) (line 1122) it makes a call to pgStream.ReceiveChar() and just
locks. It appears as though it's waiting for something from the server
and the server isn't sending it. I don't see any errors in the server
logs.

I'm at the end of my rope. Any ideas or suggestions and what else I can
do to debug this? A great deal of other queries and updates run just
fine on this database. It's this particular case that is broken and I
can't figure it out.

-Mike

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Kris Jurka

2005-04-20, 8:24 pm

On Wed, 20 Apr 2005, Mike Heath wrote:

> I'm using Postgresql 8.0.2 on SuSE Linux Professional 9.2. I'm using
> Java version 1.5.0_02. I'm using The 8.0.311 build of the JDBC driver.
>
> However, when I trace down to
> org.postgresql.core.V3.QueryExecutorImpl. processResults(Resut
lHandler,
> int) (line 1122) it makes a call to pgStream.ReceiveChar() and just
> locks. It appears as though it's waiting for something from the server
> and the server isn't sending it. I don't see any errors in the server
> logs.

It is indeed waiting for a server response and I have no reason to believe
this is a problem with either the server or the driver. It is likely
waiting to acquire some kind of lock, you did mention there is lot of
other things going on.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Oliver Jowett

2005-04-20, 8:24 pm

Mike Heath wrote:

> However, when I trace down to
> org.postgresql.core.V3.QueryExecutorImpl. processResults(Resut
lHandler,
> int) (line 1122) it makes a call to pgStream.ReceiveChar() and just
> locks. It appears as though it's waiting for something from the server
> and the server isn't sending it. I don't see any errors in the server
> logs.

Can you set logLevel=2 as a URL parameter and send me the resulting
logs? (off-list if they're big)

-O

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Sponsored Links