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

[Steve]

On Wednesday, November 18, 2020 at 1:38:25 AM UTC+11, Roy Hann wrote:
> 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

For my situation, Ingres continued to fail to shutdown and only did so gracefully after I ran ipcclean, after killing it.

That said, you're right Roy, there was something up with the database whose transactions the recovery process was supposedly working through. Even when Ingres was up and running, I could not open a session to that database, so something went awry at some point. This was our DR environment and that particular database is static, so I could simply recovery it from its latest production checkpoint.

Steve