# Logstash - JDBC input timeout error

**URL:** <https://discuss.elastic.co/t/logstash-jdbc-input-timeout-error/357206>\
**Category:** Logstash\
**Created:** [April 11, 2024, 12:46pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-timeout-error/357206 "2024-04-11T12:46:53Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![baskarcyber](https://avatars.discourse-cdn.com/v4/letter/b/ce7236/32.png) [@baskarcyber](https://discuss.elastic.co/u/baskarcyber)\
**Post date:** [April 11, 2024, 12:46pm UTC](https://discuss.elastic.co/t/logstash-jdbc-input-timeout-error/357206/1 "2024-04-11T12:46:53Z")

</div>

Hi,  
Logstash -version-7.6.1  
I am tring to move 10 million rows from Azure SQL to Elasticsearch using logstash JDBC plugin.  
I haven't set the querytimeout in the connectionstring. it should be infinitie. But after 10 to 15 mins, i am getting the below exception.  
[2024-04-11T04:30:27,910][WARN][logstash.inputs.jdbc][main] Exception when executing JDBC query {:exception=\>#\<Sequel::DatabaseError: Java::ComMicrosoftSqlserverJdbc::SQLServerException: Connection timed out (Read failed)\>}

Could you please let me know how to fix this issue?