Hello,
This is a data export issue. It keeps running. Could you please help.
Unable to find any errors in celery log.
It says as below:
[2019-12-05 12:24:16,802: INFO/MainProcess] Received task: corehq.celery_monitoring.heartbeat.heartbeat__celery[7480a354-c3de-4e37-a3aa-cc0b913a2438]
[2019-12-05 12:24:16,807: INFO/ForkPoolWorker-2] Task corehq.celery_monitoring.heartbeat.heartbeat__celery[7480a354-c3de-4e37-a3aa-cc0b913a2438] succeeded in 0.00250764004886s: None
[2019-12-05 12:24:26,883: INFO/MainProcess] Received task: corehq.celery_monitoring.heartbeat.heartbeat__celery[1ddc2ad9-32e3-4bde-bf63-fa0a011dc46a]
[2019-12-05 12:24:26,888: INFO/ForkPoolWorker-1] Task corehq.celery_monitoring.heartbeat.heartbeat__celery[1ddc2ad9-32e3-4bde-bf63-fa0a011dc46a] succeeded in 0.00229972228408s: None
[2019-12-05 12:24:36,884: INFO/MainProcess] Received task: corehq.celery_monitoring.heartbeat.heartbeat__celery[6def08c0-7f66-457c-b1b7-92c1952bde0f]
[2019-12-05 12:24:36,888: INFO/ForkPoolWorker-2] Task corehq.celery_monitoring.heartbeat.heartbeat__celery[6def08c0-7f66-457c-b1b7-92c1952bde0f] succeeded in 0.00268108397722s: None
[2019-12-05 12:24:46,884: INFO/MainProcess] Received task: corehq.celery_monitoring.heartbeat.heartbeat__celery[80ca6221-74c1-453e-95a1-dc2f12c0758f]
[2019-12-05 12:24:46,888: INFO/ForkPoolWorker-1] Task corehq.celery_monitoring.heartbeat.heartbeat__celery[80ca6221-74c1-453e-95a1-dc2f12c0758f] succeeded in 0.00195582397282s: None
However, in webserver log, I see that the below URL is continuously polled
05/Dec/2019 12:23:32] “GET /a/commcare-test1/data/export/poll_custom_export_download/?form_or_case=form&download_id=dl-bd42efda148540b5b019f5b81f32f558 HTTP/1.0” 200 –
./manage.py check_services gives following output.
/commcare/chs-home/.virtualenvs/commcare-hq/local/lib/python2.7/site-packages/djangular/core/urlresolvers.py:6: RemovedInDjango20Warning: Importing from django.core.urlresolvers is deprecated in favor of django.urls.
from django.core.urlresolvers import (get_resolver, get_urlconf, resolve, reverse, NoReverseMatch)
FAILURE (Took 0.00s) celery : reminder_queue has been blocked for as long as we can see (max allowed is 0:15:00)
submission_reprocessing_queue has been blocked for as long as we can see (max allowed is 1:00:00)
sms_queue has been blocked for as long as we can see (max allowed is 0:05:00)
export_download_queue has been blocked for as long as we can see (max allowed is 0:00:30)
case_import_queue has been blocked for as long as we can see (max allowed is 0:01:00)
sumologic_logs_queue has been blocked for as long as we can see (max allowed is 6:00:00)
send_report_throttled has been blocked for as long as we can see (max allowed is 6:00:00)
repeat_record_queue has been blocked for as long as we can see (max allowed is 1:00:00)
saved_exports_queue has been blocked for as long as we can see (max allowed is 6:00:00)
email_queue has been blocked for as long as we can see (max allowed is 0:00:30)
reminder_rule_queue has been blocked for as long as we can see (max allowed is 0:15:00)
async_restore_queue has been blocked for as long as we can see (max allowed is 0:01:00)
analytics_queue has been blocked for as long as we can see (max allowed is 0:30:00)
reminder_case_update_queue has been blocked for as long as we can see (max allowed is 0:15:00)
SUCCESS (Took 0.05s) blobdb : Successfully saved a file to the blobdb
SUCCESS (Took 0.04s) elasticsearch : Successfully sent a doc to ES and read it back
SUCCESS (Took 0.00s) postgres : default:commcarehq:OK Successfully got a user from postgres
SUCCESS (Took 0.01s) formplayer : Formplayer returned a 200 status code
SUCCESS (Took 0.00s) heartbeat : OK
SUCCESS (Took 0.01s) couch : Successfully queried an arbitrary couch view
SUCCESS (Took 0.01s) redis : Redis is up and using 283.68M memory
SUCCESS (Took 0.00s) rabbitmq : RabbitMQ Not configured, but not needed
SUCCESS (Took 0.28s) kafka : Kafka seems to be in order
Is there anything we need to do to unblock the queues? We have done the installation and configuration as per
https://github.com/dimagi/commcare-hq/blob/master/DEV_SETUP.md
Thank you.