Hi all !
I use a jdbc input plugin to get MS SQL data. Everything works fine, but when my SQL server reboots for maintenance, the queries don't work anymore, and I have the following error:
[ERROR][logstash.inputs.jdbc ] Java::ComMicrosoftSqlserverJdbc::SQLServerException: The connection is broken and recovery is not possible. The connection is marked by the client driver as unrecoverable. No attempt was made to restore the connection.: sql query here
I have this message everytime the query is executed. The only way to retrieve my connection is to restart logstash service.
I tried several parameters, just as:
use_column_value => true tracking_column => "id" tracking_column_type => "numeric"
clean_run => true
connection_retry_attempts => 0
and all of them in one configuration.
I don't know how to deal with this error, and I can't find a lot of mention of it. Do you have some solution?