Re: thread hang on execute call - Mailing list pgsql-jdbc

Pavan,

You cannot share connections across threads without locking. Is it
possible that you are doing this ?

Dave
On 4-Apr-06, at 5:04 AM, Pavan Kumar wrote:

> Hi
> i have some worker threads that perform some database intensive
> operation after each fixed interval.so they keeps running.
>  after 2 days all threads got hang on execute call on jdbc driver.
> there are around 60000 rows in table.
> i get no response and following is
>
>
> here is stack trace of postgres process
>
> #0  0x003437a2 in _dl_sysinfo_int80 () from /lib/ld-linux.so.2
> #1  0x00424451 in recv () from /lib/tls/libc.so.6
> #2  0x08145aae in secure_read ()
> #3  0x0814c062 in pq_recvbuf ()
> #4  0x0814c121 in pq_getbyte ()
> #5  0x081ad5fc in PostgresMain ()
> #6  0x0818765d in ServerLoop ()
> #7  0x0818904f in PostmasterMain ()
> #8  0x0814dd18 in main ()
>
>
> and following is stack trace of java thread
>
>
> Thread 12912: (state = IN_NATIVE)
>  - java.net.SocketInputStream.socketRead0(java.io.FileDescriptor,
> byte[], int, int, int) @bci=0 (Compiled frame; information may be
> imprecise)
>  - java.net.SocketInputStream.read(byte[], int, int) @bci=84, line=129
> (Compiled frame)
>  - java.io.BufferedInputStream.fill() @bci=175, line=218 (Compiled
> frame)
>  - java.io.BufferedInputStream.read() @bci=12, line=235 (Compiled
> frame)
>  - org.postgresql.core.PGStream.ReceiveChar() @bci=4, line=254
> (Compiled
> frame)
>  -
> org.postgresql.core.v3.QueryExecutorImpl.execute
> (org.postgresql.core.Query, org.postgresql.core.ParameterList,
> org.postgresql.core.ResultHandler, int, int, int) @bci=129,
> line=188 (Interpreted frame)
>  -
> org.postgresql.jdbc2.AbstractJdbc2Statement.execute
> (org.postgresql.core.Query, org.postgresql.core.ParameterList, int)
> @bci=199, line=430 (Interpreted frame)
>  - org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(int)
> @bci=14, line=346 (Compiled frame)
>  - org.postgresql.jdbc2.AbstractJdbc2Statement.execute() @bci=2,
> line=339 (Interpreted frame)
>  - org.apache.commons.dbcp.DelegatingPreparedStatement.execute()
> @bci=8,
> line=168 (Interpreted frame)
>
>
>
> ----------------------------------------------------------------------
> --
> Netcore Solutions Pvt. Ltd.
> Website:  http://www.netcore.co.in
> Spamtraps: http://cleanmail.netcore.co.in/directory.html
>
> Support FAQ : http://support.netcore.co.in/
>
> This e-mail contains confidential and/or privileged information. If
>   you are not the intended recipient (or have received this e-mail in
>   error)  please notify the sender immediately and delete this e-
> mail. Any
>   unauthorized copying, disclosure, use or distribution of the
> material in
>   this e-mail is strictly forbidden.
>
> ----------------------------------------------------------------------
> --
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>                http://archives.postgresql.org
>