keboola / db-extractor-mssql

MIT License
1 stars 2 forks source link

Add long retry for problematic random error #186

Closed michaljurecko closed 3 years ago

michaljurecko commented 3 years ago

Jira: https://keboola.atlassian.net/browse/COM-419

The client receives a random error (~3x per week) Client unable to establish connection because an error was encountered during handshakes before login. Common causes include client attempting to connect to an unsupported version of SQL Server, server too busy to accept new connections or a resource limitation (memory or maximum allowed connections) on the server.

Job after short retry fails.

There is probably a problem with the server ... but the client can't fix it, so we add longer retry for this error.

This error is now retried 15min with 60s interval.