Re: implementing query timeout

As has been noted on this list before, query timeouts are not implemented
in pgsql-jdbc (see

http://archives.postgresql.org/pgsql-bugs/2000-12/msg00093.php

). This is currently causing a problem for me, and I might (no
promises) be interested in implementing it. So I'm testing the waters. If
I did submit a patch for this, would the developers here be interested?

j

Jessica,

Yes we would be interested

Thanks,

Dave

-----Original Message-----
From: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org] On Behalf Of Jessica Perry
Hekman
Sent: Friday, March 08, 2002 5:06 PM
To: pgsql-jdbc(at)postgresql(dot)org
Subject: [JDBC] implementing query timeout

As has been noted on this list before, query timeouts are not
implemented in pgsql-jdbc (see

http://archives.postgresql.org/pgsql-bugs/2000-12/msg00093.php

). This is currently causing a problem for me, and I might (no
promises) be interested in implementing it. So I'm testing the waters.
If I did submit a patch for this, would the developers here be
interested?

j

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

http://www.postgresql.org/users-lounge/docs/faq.html

Jessica Perry Hekman wrote:
> As has been noted on this list before, query timeouts are not implemented
> in pgsql-jdbc (see
>
> http://archives.postgresql.org/pgsql-bugs/2000-12/msg00093.php
>
> ). This is currently causing a problem for me, and I might (no
> promises) be interested in implementing it. So I'm testing the waters. If
> I did submit a patch for this, would the developers here be interested?

[ Hackers list added.]

You bet, but it would be done in the backend, not in jdbc. Is that OK?

I have some ideas that should make it pretty easy. If you set an
alarm() in the backend on transaction start, then call the query
cancel() code if the alarm() goes off, that should do it. Of course,
you reset the alarm if the query finishes before the timeout.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

Jessica Perry Hekman wrote:
> As has been noted on this list before, query timeouts are not implemented
> in pgsql-jdbc (see
>
> http://archives.postgresql.org/pgsql-bugs/2000-12/msg00093.php
>
> ). This is currently causing a problem for me, and I might (no
> promises) be interested in implementing it. So I'm testing the waters. If
> I did submit a patch for this, would the developers here be interested?

Let me also add that Cancel now works in the CVS copy of the jdbc
driver.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

On Wed, 13 Mar 2002, Bruce Momjian wrote:

> You bet, but it would be done in the backend, not in jdbc. Is that OK?

Theoretically this is okay. I am more comfortable in Java than in C and I
hadn't looked at the backend code at all, but I'll take a peek and see if
it looks like something I'd feel comfortable doing.

> I have some ideas that should make it pretty easy. If you set an
> alarm() in the backend on transaction start, then call the query
> cancel() code if the alarm() goes off, that should do it. Of course,
> you reset the alarm if the query finishes before the timeout.

Sounds straightforward enough. Hopefully I'll get a chance to look at this
before the end of this week.

Thanks!

Jessica

Hi friends,
I have problems with postgres.jar and tomcat. I have de follow exception :

- Excepcion de persistencia:
com.kristinaIbs.persistence.ExceptionPersistence: ManagerPersistencePool
(getConnection).Connection refused. Check that the hostname and port is
correct, and that the postmaster is running with the -i flag, which enables
TCP/IP networking.
at
com.kristinaIbs.persistence.ManagerPersistencePool.getConnection(ManagerPers
istencePool.java:112)
at
com.kristinaIbs.user.UserManager.getUserByLogin(UserManager.java:314)

I have the follows parameters :
driver = org.postgresql.Driver
url = jdbc:postgresql://192.168.0.7:5432/easysite
user = postgres
password =

Do you can Help please!!!!!

-----Mensaje original-----
De: pgsql-jdbc-owner(at)postgresql(dot)org
[mailto:pgsql-jdbc-owner(at)postgresql(dot)org]En nombre de Bruce Momjian
Enviado el: miercoles 13 de marzo de 2002 21:23
Para: Jessica Perry Hekman
CC: pgsql-jdbc(at)postgresql(dot)org; PostgreSQL-development
Asunto: Re: [JDBC] implementing query timeout

Jessica Perry Hekman wrote:
> As has been noted on this list before, query timeouts are not implemented
> in pgsql-jdbc (see
>
> http://archives.postgresql.org/pgsql-bugs/2000-12/msg00093.php
>
> ). This is currently causing a problem for me, and I might (no
> promises) be interested in implementing it. So I'm testing the waters. If
> I did submit a patch for this, would the developers here be interested?

Let me also add that Cancel now works in the CVS copy of the jdbc
driver.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)

Hi friend ;P

The first problem that I can see is a clear "Connection refused".
Befor investigate if the cause is Tomcat or something else, correct this
error! Be sure that the postmaster is running with the -i

p.s. usually my run.sh is like:
"./postmaster -i -D /home/me/postgresql/data > logfile 2>&1 &"

Ciao, Auri

On Thu, 14 Mar 2002, Jose Javier Gutierrez wrote:

> Hi friends,
> I have problems with postgres.jar and tomcat. I have de follow exception :
>
> - Excepcion de persistencia:
> com.kristinaIbs.persistence.ExceptionPersistence: ManagerPersistencePool
> (getConnection).Connection refused. Check that the hostname and port is
> correct, and that the postmaster is running with the -i flag, which enables
> TCP/IP networking.
> at
> com.kristinaIbs.persistence.ManagerPersistencePool.getConnection(ManagerPers
> istencePool.java:112)
> at
> com.kristinaIbs.user.UserManager.getUserByLogin(UserManager.java:314)
>
> I have the follows parameters :
> driver = org.postgresql.Driver
> url = jdbc:postgresql://192.168.0.7:5432/easysite
> user = postgres
> password =
>
> Do you can Help please!!!!!

"Jose Javier Gutierrez" <jgutierrez(at)kristina(dot)es> writes:

> com.kristinaIbs.persistence.ExceptionPersistence: ManagerPersistencePool
> (getConnection).Connection refused. Check that the hostname and port is
> correct, and that the postmaster is running with the -i flag, which enables
> TCP/IP networking.

Is the postmaster indeed listening on a TCP/IP port, (usually 5432) or
just on the Unix-domain socket? You have to specifically turn on
TCP/IP for security reasons--it's not enabled by default.

-Doug
--
Doug McNaught Wireboard Industries http://www.wireboard.com/

Custom software development, systems and network consulting.
Java PostgreSQL Enhydra Python Zope Perl Apache Linux BSD...