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

Hot Standy introduced problem with query cancel behavior

From: Kris Jurka <books(at)ejurka(dot)com>
To: simon(at)2ndquadrant(dot)com
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Hot Standy introduced problem with query cancel behavior
Date: 2009-12-27 01:15:01
Message-ID: alpine.BSO.2.00.0912261948550.5784@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-hackers
The JDBC driver's regression test suite has revealed a change in behavior 
introduced by the hot standy patch.  Previously when a client sent a 
cancel request on an idle connection, nothing happened.  Now it sends an 
error message "ERROR: canceling statement due to user request".  This 
confuses the driver's protocol handling and it thinks that the error 
message is for the next statement issued.

Attached is a test case.

Kris Jurka

Attachment: Cancel.java
Description: text/plain (377 bytes)

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2009-12-27 14:52:43
Subject: Re: Removing pg_migrator limitations
Previous:From: Andres FreundDate: 2009-12-26 21:47:12
Subject: Re: Hot Standby and cancelling idle queries

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