[Info-ingres] Waiting indefinitely for the logging system to shut down

Laframboise, André (BAC/LAC) andre.laframboise at canada.ca
Tue Nov 17 15:01:14 UTC 2020


I've had to kill ingres processes a few times in my career. 
Just check the last few lines of iircp.log to make sure everything cleaned up ok.

I remember there was a time when the recovery server lost access to the transaction log a few years ago due to disk failure. Good times :)

André Laframboise

Conseiller Principal Base de Données, Direction générale de la gestion de l'information et Technologie de l'information
Bibliothèque et Archives Canada / Gouvernement du Canada
andre.laframboise at canada.ca / Tél. : 613-298-1346

Senior Database Advisor, Information Management and Information Technology Branch
Library and Archives Canada / Government of Canada
andre.laframboise at canada.ca / Tel: 613-298-1346
-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org <info-ingres-bounces at lists.planetingres.org> On Behalf Of Roy Hann
Sent: Tuesday, November 17, 2020 9:38 AM
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Waiting indefinitely for the logging system to shut down

Steve wrote:

> On Tuesday, March 3, 2020 at 8:42:08 PM UTC+11, jpz... at gmail.com wrote:

>> And if your Ingres installation fail to stop gracefully and you need 
>> to kill processes and clean memory, once it start again and recovery 
>> finish his job without pain, don't forget to stop/start Ingres again.

> Thanks Jean-Pierre, your advice came in handy last night.

That suggestion is harmless but I refuse to believe it is useful.

If you don't trust the undo/redo recovery to work properly you are either being superstitious or you have some incidents you should have reported to tech support to be fixed properly.

I'm going with superstitious. Ingres is not fragile.

Roy
_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres



More information about the Info-ingres mailing list