Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-61040

create index is not completing even after 20 minutes

    XMLWordPrintable

Details

    • Untriaged
    • 0
    • Yes
    • March-June 24

    Description

      We don't see this locally but this job has hit this issue twice

      http://qa.sc.couchbase.com/job/test_suite_executor/688507/console
      as far as i can tell the job is only loading travel-sample and the default bucket then creating the index ( the travel-sample indexes are also taking extremely long to load in this test, the test is taking ~ 54 mins to run when usually it should take like 5 minutes)

      Create index idx1 on default(job_title,join_day,join_mo)

      http://qa.sc.couchbase.com/job/test_suite_executor/688507/console

      2024-03-05 11:54:45 | INFO | MainProcess | test_thread | [tuq.run_cbq_query] RUN QUERY Create index idx1 on default(job_title,join_day,join_mo)
      2024-03-05 11:54:45 | INFO | MainProcess | test_thread | [on_prem_rest_client.query_tool] query params : statement=Create+index+idx1+on+default%28job_title%2Cjoin_day%2Cjoin_mo%29&scan_consistency=REQUEST_PLUS
      2024-03-05 12:16:25 | ERROR | MainProcess | test_thread | [on_prem_rest_client._http_request] socket error while connecting to http://172.23.218.58:8093/query?statement=Create+index+idx1+on+default%28job_title%2Cjoin_day%2Cjoin_mo%29&scan_consistency=REQUEST_PLUS error timed out 
      2024-03-05 12:16:25 | ERROR | MainProcess | test_thread | [on_prem_rest_client._http_request] Giving up due to timed out! Tried http://172.23.218.58:8093/query?statement=Create+index+idx1+on+default%28job_title%2Cjoin_day%2Cjoin_mo%29&scan_consistency=REQUEST_PLUS connect 1 times.
       
      Exception error:  unable to reach the host @ 172.23.218.58
       
      api:  http://172.23.218.58:8093/query?statement=Create+index+idx1+on+default%28job_title%2Cjoin_day%2Cjoin_mo%29&scan_consistency=REQUEST_PLUS
       
      headers:  {'Authorization': 'Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA=='}
      

      attaching logs, hopefully the logs shed some light on what happened here

      Attachments

        Issue Links

          Activity

            People

              ajay.bhullar Ajay Bhullar
              ajay.bhullar Ajay Bhullar
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

              Dates

                Created:
                Updated:

                PagerDuty