Unable to process GET request to elasticsearch URL 'http://zammad-elasticsearch:9200/zammad_production_ticket/_search'

Technical assistance
1
  • Used Zammad version: Kubernetes gcp setup
  • Used Zammad installation type: using the help setup

Expected behavior:

Actual behavior:

  • StatusCode: 500
Unable to process GET request to elasticsearch URL 'http://zammad-elasticsearch:9200/zammad_production_ticket/_search'. Elasticsearch is not reachable. It's possible that it's not running. Please check whether it is installed.

Response:
#<UserAgent::Result:0x00007c2b4fd9e8a0 @success=false, @body=nil, @data=nil, @code=0, @content_type=nil, @error="#<Errno::ECONNREFUSED: Failed to open TCP connection to zammad-elasticsearch:9200 (Connection refused - connect(2) for \"zammad-elasticsearch\" port 9200)>", @header=nil>

Payload:
{"size":0,"query":{"bool":{"must":[{"range":{"created_at":{"from":"2023-12-31T18:30:00Z","to":"2024-12-31T18:29:59Z"}}},{"bool":{"must":[{"bool":{"must":[{"terms":{"type.keyword":["Request","Incident","Problem"]}}]}},{"bool":{"must":[{"terms":{"category.keyword":["InfoSec"]}}]}},{"bool":{"must_not":[{"term":{"state.name.keyword":"merged"}}]}}]}}]}},"aggs":{"time_buckets":{"date_histogram":{"field":"created_at","calendar_interval":"month","time_zone":"Asia/Calcutta"}}},"sort":[{"updated_at":{"order":"desc"}},"_score"]}

Payload size: 0M

Steps to reproduce the behavior:

2

Your log file does tell you everything you need to know.

3

hello sir, can you tell me if there somehting i have to configure or elastisearch configuration which i need to do please let me know

4

hello the issue is different here, now when i tried searching the ticket it is not showing there is some issue with the Elasticsearch configuration , please do not close the ticket without understanding the concern or issue, we are stuck and need help so we raise the support ticket here