Re: Handle DBI connection lost

Replies are listed 'Best First'.
Re^2: Handle DBI connection lost by bash (Scribe) on Feb 22, 2017 at 21:40 UTC
If you have many database requests per second then it's very hard to restart script and database synchronously, especially when you have many instances of this script spread across cluster.	[reply]
Re^3: Handle DBI connection lost by Laurent_R (Canon) on Feb 22, 2017 at 22:22 UTC
Still, it does not seem to make sense to let your script continue to run when the database is down.	[reply]
Re^4: Handle DBI connection lost by bash (Scribe) on Feb 23, 2017 at 01:40 UTC
Generally I agree. But in my situation i have some tasks for script that can take > 10 min, so it's not possible to stop it immediately. But it's ok to wait for several seconds while database restarts. And of course there can be networking problem, so script should handle connection lost.	[reply]