# While moving data from sql sever to elastic search taking moretime(logstash)
**URL:** https://discuss.elastic.co/t/while-moving-data-from-sql-sever-to-elastic-search-taking-moretime-logstash/201775
**Category:** Logstash
**Created:** [October 1, 2019, 10:29am UTC](https://discuss.elastic.co/t/while-moving-data-from-sql-sever-to-elastic-search-taking-moretime-logstash/201775 "2019-10-01T10:29:41Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@rameshkr1994](https://discuss.elastic.co/u/rameshkr1994)
#### Post date: [October 1, 2019, 10:29am UTC](https://discuss.elastic.co/t/while-moving-data-from-sql-sever-to-elastic-search-taking-moretime-logstash/201775/1 "2019-10-01T10:29:41Z")
Dear All.
while moving data from sql server to elastic search using logstash taking more time why.
i have 25 crores records in sql server side and i am trying to move but its taking more time and giving some error.
indent preformatted text by 4 spaces
note:- this 25crs data records moving from yesterday but still i only moved 2.4crs records only .
`<[2019-10-01T13:38:56,969][ERROR][logstash.outputs.elasticsearch] Attempted to send a bulk request to elasticsearch' but Elasticsearch appears to be unreachable or down! {:error_message=>"Elasticsearch Unreachable: [http://wwww9200/][Manticore::SocketTimeout] Read timed out", :class=>"LogStash::Outputs::ElasticSearch::HttpClient::Pool::HostUnreachableError", :will_retry_in_seconds=>2} [2019-10-01T13:38:56,985][ERROR][logstash.outputs.elasticsearch] Attempted to send a bulk request to elasticsearch, but no there are no living connections in the connection pool. Perhaps Elasticsearch is unreachable or down? {:error_message=>"No Available connections", :class=>"LogStash::Outputs::ElasticSearch::HttpClient::Pool::NoConnectionAvailableError", :will_retry_in_seconds=>2} [2019-10-01T13:38:57,105][ERROR][logstash.outputs.elasticsearch] Attempted to send a bulk request to elasticsearch, but no there are no living connections in the connection pool. Perhaps Elasticsearch is unreachable or down? {:error_message=>"No Available connections", :class=>"LogStash::Outputs::ElasticSearch::HttpClient::Pool::NoConnectionAvailableError", :will_retry_in_seconds=>2} [2019-10-01T13:38:57,107][ERROR][logstash.outputs.elasticsearch] Attempted to send a bulk request to elasticsearch, but no there are no living connections in the connection pool. Perhaps Elasticsearch is unreachable or down? {:error_message=>"No Available connections", :class=>"LogStash::Outputs::ElasticSearch::HttpClient::Pool::NoConnectionAvailableError", :will_retry_in_seconds=>2} [2019-10-01T13:38:57,239][WARN][logstash.outputs.elasticsearch] Restored connection to ES instance {:url=>"http://wwww5:9200/"}/>`.
PLEASE help for this issue.
Thanks
HadoopHelp
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 29, 2019, 10:29am UTC](https://discuss.elastic.co/t/while-moving-data-from-sql-sever-to-elastic-search-taking-moretime-logstash/201775/2 "2019-10-29T10:29:42Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.