bcgov / nr-spar-data-sync

Engine to sync data for SPAR application (from Postgres to Oracle)
Apache License 2.0
2 stars 0 forks source link

[Data Sync] Add database health check #11

Closed thiagosanchezenc closed 12 months ago

thiagosanchezenc commented 12 months ago

Any database error that happens in the loading phase won´t stop the process - it will log the record that was being processed and move to the next one. That works fine for almost every database error, but if there is a connection issue (such as a lost/closed connection) then the process should handle the error properly. It could either stop the process and mark it as failed or try to reconnect. Adding a database health check and proper error handling for this situation would improve the performance of the engine.