Standby GEOSCADA server shut down suddenly

[BGedco2022]

Hello Everyone,

We've client with hot-stand by GEO SCADA partner where the stand by server found shut down suddenly.

What could causes such behavior?

Thanks in advance

[sbeadle]

Many reasons - disk space being one.

Check your server log files. Contact support line for help.

Steve

[BGedco2022]

Thanks @sbeadle but the disk space is not an issue.

We checked the log files, watchdog  exception was found...
*** Exception Database watchdog timed out. at 00007FF85D989319 occurred **  

How can we detect the cause/solve it?

[AndrewScott]

That message indicates that the database watchdog has detected that the server has stalled and so has shut it down.

See System Administration > Server Administration > Logging and Monitoring > Configure the Database Watc... 

To investigate what caused the server to stall you need to examine the DB logs in the minutes prior to the watchdog being triggered (default 4 minutes), or contact customer support and supply the DB log files and the dump file created by the watchdog.

[BGedco2022]

what are the prospects could cause that?

[AndrewScott]

There are many possible reasons, for example oversized historic granules in the historian or poorly designed/optimised SQL queries.