# Unpivot Causing Logstash Pipeline to Halt **URL:** \ **Category:** Logstash\ **Created:** [March 5, 2024, 4:46am UTC](https://discuss.elastic.co/t/unpivot-causing-logstash-pipeline-to-halt/354690 "2024-03-05T04:46:03Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Rushil\_Dewaskar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rushil_dewaskar/32/131213_2.png) [@Rushil\_Dewaskar](https://discuss.elastic.co/u/Rushil_Dewaskar)\ **Post date:** [March 5, 2024, 4:46am UTC](https://discuss.elastic.co/t/unpivot-causing-logstash-pipeline-to-halt/354690/1 "2024-03-05T04:46:03Z")
I am trying to create an Elasticsearch index from an SQL database. However, whenever our SQL query contains an unpivot operation, the process halts after processing a certain number of records. It then resumes after 30-40 minutes, but I am unsure why this is happening. Below is a screenshot showing what the pipeline displays after it gets halted. ![Screenshot 2024-03-05 at 10.13.03 AM](https://us1.discourse-cdn.com/elastic/original/3X/1/5/15e6e3c7b8ccf00616e8c0a24b5e424457e3b5a3.png) ---
**Author:** ![Rushil\_Dewaskar](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/rushil_dewaskar/32/131213_2.png) [@Rushil\_Dewaskar](https://discuss.elastic.co/u/Rushil_Dewaskar)\ **Post date:** [March 30, 2024, 8:01am UTC](https://discuss.elastic.co/t/unpivot-causing-logstash-pipeline-to-halt/354690/2 "2024-03-30T08:01:50Z")
Any Solution? ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [April 27, 2024, 8:02am UTC](https://discuss.elastic.co/t/unpivot-causing-logstash-pipeline-to-halt/354690/3 "2024-04-27T08:02:02Z")
Closed on April 27, 2024, 8:02am UTC This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.