# MSSQL input hanging after update

**URL:** <https://discuss.elastic.co/t/mssql-input-hanging-after-update/292742>\
**Category:** Logstash\
**Created:** [December 22, 2021, 9:41pm UTC](https://discuss.elastic.co/t/mssql-input-hanging-after-update/292742 "2021-12-22T21:41:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tobias\_c](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/tobias_c/32/99449_2.png) [@tobias\_c](https://discuss.elastic.co/u/tobias_c)\
**Post date:** [December 22, 2021, 9:41pm UTC](https://discuss.elastic.co/t/mssql-input-hanging-after-update/292742/1 "2021-12-22T21:41:45Z")

</div>

Hi all

After updating from logstash 7.5.1 to 7.16.2 and updating from mssql.jdbc.4.2.jar to mssql.jdbc.9.4 (for jdk11 as the bundled jdk version) I cannot transfer my mssql data to Elasticsearch anymore.  
Logstash jdbc imput plugin connects to the database and I can see the select statement in the logstash logs and in the process list of the database. But then nothing happens anymore in the logstash console, it just seems to be waiting for the database answer forever...  
and in the database process list I see that the statement is received but in the state suspended. But it really worked with the old version. So do you know what I could change/try to get it running?  
Db  
Thanks and kind regards Tobias

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [January 19, 2022, 9:42pm UTC](https://discuss.elastic.co/t/mssql-input-hanging-after-update/292742/2 "2022-01-19T21:42:17Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.