Query cancellation in JDBC

From: rsmogura <rsmogura(at)softperience(dot)eu>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Query cancellation in JDBC
Date: 2011-01-25 12:05:39
Message-ID: 888e9bb6bedd76e0621704f217984086@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I done in JDBC driver barrier preventing of execution of query until
the cancel will not return, but future queries after cancellation are
occasionally terminated.

The query cancel sends following 16, 123456789, pid, key, flush, after
this it tries to read EOF, I got and ignore exception "Connection reset"
- probably OK, so query cancel finishes. The next query will not be
executed until cancellation will end.

I think problem can be in backend, it can signal process but it doesn't
wait till signal is processed. I saw this on Windows 7.

If you want I can only try to attach Wireshark frames.

Kind regards,
Radosław Smogura
http://www.softperience.eu

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2011-01-25 12:21:26 Re: Moving from SQL Anywhere to PostGres - First Time
Previous Message Albretch Mueller 2011-01-24 22:12:28 Re: Separating the ro directory of the DB engine itself from the rw data areas . . .