Skip site navigation (1) Skip section navigation (2)

Re: Weird pause when running statements

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Grant Quimby <grant_quimby(at)dialog(dot)com(dot)au>
Cc: "pgsql-jdbc(at)postgresql(dot)org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Weird pause when running statements
Date: 2008-08-06 01:07:10
Message-ID: 4898F93E.9080104@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Grant Quimby wrote:
> Hi,
> 
> I've done some research and this appears to be a unique problem.
> 
> During an ETL process using the 8.3-603 JDBC3 driver with Pentaho Data Integration the transactions and everything stops processing. No disk access, No process activity, Nothing. The Postgres processes are still present.
> 
> After reloading the server configuration the processes just start off where they stopped and continue normally. Sometimes they stop again, the same workaround sets the process running again. However trying to deploy this process to a server means that those pauses are unacceptable. This appears to be a problem with the driver and/or the server. Anybody have any suggestions? I'd rather not have to port everything to another DBMS.

First step would be to work out which half is getting stuck. Try a 
thread dump on the Java side and a strace on the backend side.

What do you mean by "reloading the server configuration"?

-O

In response to

Responses

pgsql-jdbc by date

Next:From: Grant QuimbyDate: 2008-08-06 02:56:14
Subject: Re: Weird pause when running statements
Previous:From: Grant QuimbyDate: 2008-08-06 00:56:38
Subject: Weird pause when running statements

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group