[Info-ingres] Restarting Ingres

[Adrian Williamson]

Hi,

I have one customer where we reboot the Windows server  each week  (it is
one box solution : OpenROAD & Ingres running on Terminal Services ) .

I do that as it means that any minor leaks from any software do not
snowball.

Not that I've witnessed memory leaks, but it gives me the warm feeling that
it reboots itself rather than me getting a call out cause the server has
stopped.

Gives me the illusion of being in control.

Twelve years now and no outages.*

Cheers

Adrian

*Well apart from when the 'employees' of the Multinational services company
which runs the infrastructure decide to just pull the power on the VM
causing ''The last shutdown was unexpected' message to appear in the event
log. We have educated them to the benefits of an orderly shutdown on
windows.

-----Original Message-----
From: info-ingres-bounces at lists.planetingres.org
<info-ingres-bounces at lists.planetingres.org> On Behalf Of Martin Bowes
Sent: 14 June 2021 07:29
To: Steve <s.anderson.au at gmail.com>; info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Restarting Ingres

We very occasionally get a situation which we call a stuck lock list where a
session has exited but the lock list remains. The only way out is to restart
the installation. It is rare, and I would guess of the 50+ installations
that we field, that such an event would happened just a few times annually.

Marty

-----Original Message-----
From: Steve <s.anderson.au at gmail.com> 
Sent: 14 June 2021 04:28
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Restarting Ingres

On Monday, June 14, 2021 at 2:48:09 AM UTC+10, Martin Bowes wrote:

> We tend to restart only when the situation demands. This means we would
normally achieve uptime measured in months. I've not seen a compelling
argument to stop and restart more often than that. 

Thanks Marty. 

Can I ask what situations, apart from patching or upgrading, might cause you
to restart Ingres?

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