executeQuery hangs my application

From: "Stefano B(dot)" <stefano(dot)bonnin(at)comai(dot)to>
To: <pgsql-jdbc(at)postgresql(dot)org>
Subject: executeQuery hangs my application
Date: 2005-12-13 13:52:53
Message-ID: 005801c5ffec$83c779a0$0501a8c0@comai04
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,

I have a problem with the PostgreSQL JDBC drivers 8.1+.

In my code I call the executeQuery method and sometimes it seems to lock my application.
I tried to update the driver to the newer 8.2 version but I obtained the same result ...

The database server version is 8.1 for Windows (but I am not the administrator)
I have found this problem (for now) only on this server ...

the jdbc log is the following:

*****************************************************
14:09:10.171 (2) PostgreSQL 8.2devel JDBC3 with SSL (build 500)
14:09:10.171 (2) Trying to establish a protocol version 3 connection to <_the_server_IP_>:5432
14:09:10.265 (2) FE=> StartupPacket(user=postgres, database=barricalla, client_encoding=UNICODE,

DateStyle=ISO)
14:09:10.390 (2) <=BE AuthenticationReqMD5(salt=be98c8a8)
14:09:10.390 (2) FE=> Password(md5digest=md5724bad3aac24aa6aed8dfebfe9eafcfa)
14:09:10.468 (2) <=BE AuthenticationOk
14:09:10.468 (2) <=BE ParameterStatus(client_encoding = UNICODE)
14:09:10.468 (2) <=BE ParameterStatus(DateStyle = ISO, MDY)
14:09:10.468 (2) <=BE ParameterStatus(integer_datetimes = off)
14:09:10.468 (2) <=BE ParameterStatus(is_superuser = on)
14:09:10.468 (2) <=BE ParameterStatus(server_encoding = UTF8)
14:09:10.468 (2) <=BE ParameterStatus(server_version = 8.1.1)
14:09:10.468 (2) <=BE ParameterStatus(session_authorization = postgres)
14:09:10.468 (2) <=BE ParameterStatus(standard_conforming_strings = off)
14:09:10.468 (2) <=BE ParameterStatus(TimeZone = CET)
14:09:10.468 (2) <=BE BackendKeyData(pid=1664,ckey=1388535757)
14:09:10.468 (2) <=BE ReadyForQuery(I)
14:09:10.468 (2) compatible = 8.2
14:09:10.468 (2) loglevel = 2
14:09:10.468 (2) prepare threshold = 5
getConnection returning driver[className=org.postgresql.Driver,org(dot)postgresql(dot)Driver(at)15fc672]
14:09:10.468 (2) simple execute,

handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)9770a3, maxRows=0, fetchSize=0,

flags=17
14:09:10.468 (2) FE=> Parse(stmt=null,query="SELECT max("fulldate"),min("fulldate") FROM "data_cab_a"

",oids={})
14:09:10.484 (2) FE=> Bind(stmt=null,portal=null)
14:09:10.484 (2) FE=> Describe(portal=null)
14:09:10.484 (2) FE=> Execute(portal=null,limit=0)
14:09:10.484 (2) FE=> Sync
14:09:10.687 (2) <=BE ParseComplete [null]
14:09:10.687 (2) <=BE BindComplete [null]
14:09:10.687 (2) <=BE RowDescription(2)
14:09:10.687 (2) <=BE DataRow
14:09:10.687 (2) <=BE CommandStatus(SELECT)
14:09:10.828 (2) <=BE ReadyForQuery(I)
14:09:11.187 (2) simple execute,

handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)4298e, maxRows=0, fetchSize=0,

flags=17
14:09:11.187 (2) FE=> Parse(stmt=null,query="SELECT * FROM "data_cab_a" WHERE "fulldate" < timestamp

'2005-11-11 00:00:00' AND "fulldate" >= timestamp '2005-10-12 00:00:00'",oids={})
14:09:11.187 (2) FE=> Bind(stmt=null,portal=null)
14:09:11.187 (2) FE=> Describe(portal=null)
14:09:11.187 (2) FE=> Execute(portal=null,limit=0)
14:09:11.187 (2) FE=> Sync
14:09:11.578 (2) <=BE ParseComplete [null]
14:09:11.578 (2) <=BE BindComplete [null]
14:09:11.578 (2) <=BE RowDescription(13)
14:09:11.578 (2) <=BE DataRow
14:09:11.578 (2) <=BE DataRow
14:09:11.578 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow
14:09:11.593 (2) <=BE DataRow

...
...
... other ~5000 lines
...
...

14:10:06.109 (2) <=BE CommandStatus(SELECT)
14:10:06.109 (2) <=BE ReadyForQuery(I)

14:10:42.515 (2) simple execute,

handler=org(dot)postgresql(dot)jdbc2(dot)AbstractJdbc2Statement$StatementResultHandler(at)11ed166, maxRows=0,

fetchSize=0, flags=17
14:10:42.515 (2) FE=> Parse(stmt=null,query="SELECT * FROM "data_cab_a" WHERE "fulldate" < timestamp

'2005-12-11 00:00:00' AND "fulldate" >= timestamp '2005-11-11 00:00:00'",oids={})
14:10:42.515 (2) FE=> Bind(stmt=null,portal=null)
14:10:42.515 (2) FE=> Describe(portal=null)
14:10:42.515 (2) FE=> Execute(portal=null,limit=0)
14:10:42.515 (2) FE=> Sync
14:10:42.859 (2) <=BE ParseComplete [null]
14:10:42.859 (2) <=BE BindComplete [null]
14:10:42.859 (2) <=BE RowDescription(13)
14:10:42.859 (2) <=BE DataRow
14:10:42.859 (2) <=BE DataRow
14:10:42.859 (2) <=BE DataRow
14:10:42.859 (2) <=BE DataRow

...
... other ~5000 lines
...

14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
14:11:21.140 (2) <=BE DataRow
******************************************************************************

at this point no other log messages are printed and the application seems locked on the executeQuery method.
The database connection is opened (even if I wait for 2 or 3 hours ...)

Any hints?
Thanks in advance.

Stefano

Browse pgsql-jdbc by date

  From Date Subject
Next Message kbforge 2005-12-13 20:12:08 New release: - kbforge 1.20 Free desktop search application with PGSQL database option
Previous Message Heikki Linnakangas 2005-12-12 19:29:37 Re: pgsql XA with weblogic 8.1?