From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Rollback after "Connection timed out"?
Date: Fri, 27 Oct 2023 09:40:43 -0500
Message-ID: <f90c644c-790a-46a9-ae95-1a10f6423d37@gmail.com> (raw)
Pg 9.6.24
On Server_A, I ran:
psql --host=blarge mydb -c "ALTER TABLE blah ..."
After about 2 hours, it displayed this message:
Could not receive data from server: Connection timed out
Connection to server was lost
And yet the ALTER TABLE (it's heavily inheritance-partitioned) is still
running on blarge. Is it still working, or is it rolling back (which I'd
expect to be fast)?
--
Born in Arizona, moved to Babylonia.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Rollback after "Connection timed out"?
In-Reply-To: <f90c644c-790a-46a9-ae95-1a10f6423d37@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox