On 03/30/18 07:39, Laurenz Albe wrote:
psql:testing/test.pg_sql:41: NOTICE: Connection busy: 1
psql:testing/test.pg_sql:41: NOTICE: Last error: OK
psql:testing/test.pg_sql:41: NOTICE: Cancel query: OK
psql:testing/test.pg_sql:41: NOTICE: Connection busy: 0
psql:testing/test.pg_sql:41: NOTICE: could not send query: another
command is already in progress
Has anyone an idea?
The cause of the error message is clear; as the documentation says:
Not to me. As mentioned in my first post, originally I did no cancelling
and error checking and had the same error. Trying to cancelling did not
alter behaviour. It boils down to: Why do I get the "another command is
already in progress" when dblink_is_busy acknowledges the dblink to not
be busy by returning 0?
the query will fail soon. You must still complete the normal query protocol,
for example by calling dblink_get_result.
Ah, maybe this is the underlying problem. If dblink requires that
results get retrieved by dblink_get_result before the dblink is actually
ready to receive another query, it would explain the error I get.
However, I feel than the result of dblink_is_busy is faulty,
counter-intuitive or just useless in that context. Or I just
misinterpreted documentation: "checks if connection is busy with an
async query"
My understand there is that the actual query is still being processed,
the gathering of the results. I did not count the keeping of the result
as part of the query.
I hope I can check on that today and get back with my findings.
--
SIP/iptel.org: thiemo.kellner
Öffentlicher PGP-Schlüssel:
http://pgp.mit.edu/pks/lookup?op=get&search=0xCA167FB0E717AFFC
begin:vcard
fn:Thiemo Kellner
n:Kellner;Thiemo
adr:;;Landstr. 34;Weilheim-Bannholz;BW;79809;Deutschland
email;internet:thiemo@xxxxxxxxxxxxxxxxxxxx
tel;work:+49 1578 772 37 37
tel;cell:+41 78 947 36 21
note;quoted-printable:Auf Gelassene Pferde kann man bauen!=0D=0A=
+49 (0)1578-772 37 37 (Mo, Di)=0D=0A=
+41 (0)78 947 36 21 (Mi - Fr)=0D=0A=
sip: thiemo.kellner@xxxxxxxxx=0D=0A=
Skype: thiemo.kellner=0D=0A=
http://www.gelassene-pferde.biz=0D=0A=
Mitglied bei http://www.keep-it-natural.org=0D=0A=
=C3=96ffentlicher PGP-Schl=C3=BCssel: http://pgp.mit.edu/pks/lookup?op=3D=
get&search=3D0x8F70EFD2D972CBEF
x-mozilla-html:FALSE
url:http://www.gelassene-pferde.biz
version:2.1
end:vcard
