thread hang on execute call - Mailing list pgsql-jdbc
From | Pavan Kumar |
---|---|
Subject | thread hang on execute call |
Date | |
Msg-id | 1144141469.16392.18.camel@pavan.psmw Whole thread Raw |
Responses |
Re: thread hang on execute call
Re: thread hang on execute call |
List | pgsql-jdbc |
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. ------------------------------------------------------------------------
pgsql-jdbc by date: