Rollback after "Connection timed out"?

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Rollback after "Connection timed out"?
Date: 2023-10-27 14:40:43
Message-ID: f90c644c-790a-46a9-ae95-1a10f6423d37@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Arjan Saly Consultancy (EU) 2023-10-27 14:42:48 Re: ORDER BY DESC and NULLS LAST by default
Previous Message Ron 2023-10-27 14:19:38 Re: Progress of ALTER TABLE on inheritance-partitioned table?