[Info-ingres] How to automate monitoring Ingres for errors

[Terry White]

On 19/09/2014 13:17, Ingres Forums wrote:
>
> I'd like to build a C# application to hopefully query some kind of
> Ingres system table for DBMS system errors vs parsing errlog.log.   Is
> there any query I can use to do this?
>
> Also, would like to do similar thing for the iivdb.log, checking it via
> queries for errors...
>
> Let me know your thoughts.
>
>
But if the Ingres DBMS has a serious error it probably won't respond to 
your process trying to look in the table.   Looking at the errlog.log is 
better really  (and more lightweight).

What we do is have a "test" transaction that we execute every minute or 
so that tests access to various live databases and important tables.  If 
that fails / times out etc.  it fires a script that captures logs / ps 
listings / dumps etc.  that we can the analyse later.   The test 
transaction is actually a ASP.NET webpage that we call periodically via 
NAGIOS (also has the benefit of testing the website is up too),  Nagios 
raises an alert if the whole thing fails / timesout.