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
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 |