<div dir="auto"><div dir="auto">I already se cases where recovery finish his job when Ingres start raiser than he stop (because the failure conditions, lack of memory, something bad, is still here). <br></div><div dir="auto"><br></div><div dir="auto">After killing processes don't forget to clean memory segments. </div><div dir="auto"><br></div><div dir="auto">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. <div dir="auto"><br></div></div><div dir="auto">It is important to have a clean stop and then a clean start before release user activity ... <br><br>Regards, <br><div data-smartmail="gmail_signature" dir="auto">--<br>Jean-Pierre Zuate</div></div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">Le lun. 2 mars 2020 à 11:30, Martin Bowes <<a href="mailto:martin.bowes@ndph.ox.ac.uk">martin.bowes@ndph.ox.ac.uk</a>> a écrit :<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hi Steve,<br>
<br>
The message means that the recovery system is processing your transaction log file, trying to work out what it needs to do to the information to give you a graceful shutdown.<br>
<br>
It can be interrupted by for example killing the iircp with a UNIX kill signal. A subsequent restart will recognise that the shutdown was not graceful and simply recommence processing the transaction log file locking you out until it has completed.<br>
<br>
So don't do that unless you are really sure it's something you need to do.<br>
<br>
Your best option is to do a: tail -f $II_SYSTEM/ingres/files/iircp.log<br>
<br>
This will give you confirmation the recovery process is actually doing something rather than just spinning its wheels.<br>
<br>
Marty<br>
<br>
-----Original Message-----<br>
From: Steve <<a href="mailto:s.anderson.au@gmail.com" target="_blank" rel="noreferrer">s.anderson.au@gmail.com</a>> <br>
Sent: 02 March 2020 00:59<br>
To: <a href="mailto:info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">info-ingres@lists.planetingres.org</a><br>
Subject: [Info-ingres] Waiting indefinitely for the logging system to shut down<br>
<br>
The other day Ingres would not shutdown.<br>
<br>
Here are the messages in the error log when ingstop was issued:<br>
<br>
..., lgmisc.c:1582 ]: Tue Feb 18 00:32:19 2020 E_DMA469_P<br>
ROCESS_HAS_DIED Process (00002F36) has died. A process attached to the logging and locking system has exited without going through n ormal cleanup processing. The system will now perform cleanup processing on behalf of the failed process.<br>
<br>
..., lgkinit.c:1145 ]: Tue Feb 18 00:32:19 2020 E_DMA499_D<br>
EAD_PROCESS_INFO Process (00002F36) died with info '(DEFAULT)'.<br>
<br>
<br>
Some processes had shutdown, but the name server, archiver and recovery processes were still running.<br>
<br>
When ingstop was issued for the second time, the following message was displayed:<br>
<br>
"Waiting indefinitely for the logging system to shut down"<br>
<br>
Trying to understand what the above means. For example, could the logging system have been waiting on the already shutdown DBMS servers? <br>
<br>
Thanks<br>
Steve<br>
_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer noreferrer" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
_______________________________________________<br>
Info-ingres mailing list<br>
<a href="mailto:Info-ingres@lists.planetingres.org" target="_blank" rel="noreferrer">Info-ingres@lists.planetingres.org</a><br>
<a href="https://lists.planetingres.org/mailman/listinfo/info-ingres" rel="noreferrer noreferrer" target="_blank">https://lists.planetingres.org/mailman/listinfo/info-ingres</a><br>
</blockquote></div>