"Canceling authentication due to timeout" with idle transaction and reindex

From: s19n <mailbox(at)s19n(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: "Canceling authentication due to timeout" with idle transaction and reindex
Date: 2017-09-15 10:25:58
Message-ID: 20170915102558.3auk2bav5tyca5zn@hekla
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I am experiencing the following while using PostgreSQL
9.6.3-1.pgdg16.04+1 (deb package from official repository):

1. with "\set AUTOCOMMIT off" in my psqlrc, issue a
"SELECT * FROM pg_stat_activity;" and leave it there

2. in a different connection, issue a database REINDEX (of any database
different from 'postgres')

* Any further attempt to create new connections to the server, to any
database, does not succeed and leads to a "FATAL: canceling authentication
due to timeout" in the server logs.

* The REINDEX doesn't actually complete unless I end the transaction
started at point 1.

Is this expected? I am failing to see the relation between an idle
transaction in the 'postgres' database, a reindex operation and
subsequent logins.

Thank you very much for your attention,
Best regards

--
https://s19n.net

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-09-15 11:27:03 Re: "Canceling authentication due to timeout" with idle transaction and reindex
Previous Message Rafal Pietrak 2017-09-15 09:03:19 Re: looking for a globally unique row ID