Unix Technical Forum

Re: SQL query never ends

This is a discussion on Re: SQL query never ends within the pgsql Interfaces jdbc forums, part of the PostgreSQL category; --> I've done some more tests and I think that I can say that a same connection is not used ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces jdbc

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-16-2008, 12:13 AM
James Im
 
Posts: n/a
Default Re: SQL query never ends

I've done some more tests and I think that I can say that a same
connection is not used by several thread at the same time.
However different connections are being used by several threads at the
same time.

>Can you capture the network traffic between the server and JDBC driver?

I don't know how to do that on Windows. Wireshark cannot listen to the
windows loopback interface.

Have you seen the thread dump? Does it helps you at all?

__________________________________________________ _______________
Ta' på udsalg året rundt på MSN Shopping: http://shopping.msn.dk - her
finder du altid de bedste priser


---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 04-16-2008, 12:13 AM
Dave Cramer
 
Posts: n/a
Default Re: SQL query never ends

James,

Change the connection so that it connects to the ethernet device on
the box, then Wireshark can listen to it.

--dc--
On 10-Aug-06, at 6:45 AM, James Im wrote:

> I've done some more tests and I think that I can say that a same
> connection is not used by several thread at the same time.
> However different connections are being used by several threads at the
> same time.
>
>> Can you capture the network traffic between the server and JDBC
>> driver?

> I don't know how to do that on Windows. Wireshark cannot listen to the
> windows loopback interface.
>
> Have you seen the thread dump? Does it helps you at all?
>
> __________________________________________________ _______________
> Ta' på udsalg året rundt på MSN Shopping: http://shopping.msn.dk
> - her finder du altid de bedste priser
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 04-16-2008, 12:14 AM
Oliver Jowett
 
Posts: n/a
Default Re: SQL query never ends

James Im wrote:

> Have you seen the thread dump? Does it helps you at all?


Unfortunately the thread dump just says what the logging says -- that
the driver is waiting for a message from the server that never comes.

-O

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 08:57 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com