From: Silvio Brandani <silvio.brandani@tech.sdb.it>
To: pgsql-admin@postgresql.org
Subject: PANIC killing vacuum process
Date: Wed, 03 Nov 2010 17:06:04 +0100
Message-ID: <4CD1886C.5000503@tech.sdb.it> (raw)
Alls,
we have develop a script to execute the vacuum full on all tables of our
very big database , since it is a 24 x 7 available system we have not a
timeframe to exec the vacuum full.
so we try with this script running the vauum full table by table and if
the vacuum generate the waiting status for other connections we kill the
vacuum .
But we encounter following problem:
with kill command:
2010-11-03 14:25:27 CET [19324]: [4-1] FATAL: terminating connection
due to administrator command
2010-11-03 14:25:27 CET [19324]: [5-1] STATEMENT: vacuum full analyze
verbose tracking.as_history_status ;
2010-11-03 14:25:27 CET [19324]: [6-1] PANIC: cannot abort transaction
75073917, it was already committed
with pg_cancel_backend(pid) command:
CPU 0.18s/0.26u sec elapsed 3.79 sec.
ERROR: canceling statement due to user request
PANIC: cannot abort transaction 75081452, it was already committed
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
!> quit
-> \q
the server crash and we have a service unavailiability on our production
system.
Is it possible to softly kill a vacuum process without risk a panic ?????
thanks a lot
Silvio Brandani
---
Utilizziamo i dati personali che la riguardano esclusivamente per nostre finalità amministrative e contabili, anche quando li comunichiamo a terzi. Informazioni dettagliate, anche in ordine al Suo diritto di accesso e agli altri Suoi diritti, sono riportate alla pagina http://www.savinodelbene.com/privacy.html
Se avete ricevuto questo messaggio per errore Vi preghiamo di ritornarlo al mittente eliminandolo assieme agli eventuali allegati, ai sensi art. 616 codice penale http://www.savinodelbene.com/privacy/codice_penale_616.html
L'Azienda non si assume alcuna responsabilità giuridica qualora pervengano da questo indirizzo messaggi estranei all'attività lavorativa o contrari a norme.
--
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: silvio.brandani@tech.sdb.it
Subject: Re: PANIC killing vacuum process
In-Reply-To: <4CD1886C.5000503@tech.sdb.it>
* 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