The progress that is displayed when processing contacts in batch stops updating after reaching this point:

Completed 0 of 1.
Processed 1050 of 95653

I can see the script is still running by running sql queries against but eventually times out with a HTTP 500 error.

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=142934&op=do StatusText: Internal Server Error ResponseText: {"status":true,"percentage":"1","message":"Completed 0 of 1.\u003Cbr \/\u003EProcessed 1100 of 95653"}

The apache error log reads:

... PHP Fatal error: Maximum execution time of 240 seconds exceeded in /home/dennis/democratsabroad/drupal/includes/database/database.inc on line 445, referer: ..._qf_Builder_display=true&qfKey=156bb2498623e6c00e46ebcf4999b78d_8410

php.ini has the maximum execution time set to more than twice 240.

Comments

dalin’s picture

dalin
he/him
Primary language English
Location 🇨🇦, 🇲🇽, 🌍
commented
Status: Active » Postponed (maintainer needs more info)

I'd recommend giving it another go. This procedure is just adding all contacts to the queue to have their CDs determined. (Basically adding the contacts to the `cd_sunlight_cron` table).

You should also ensure that debugging is off since that adds a huge load of extra information to that table that won't be necessary unless you're actually trying to find a problem.

Vietyank’s picture

Vietyank commented

I just retried it with debugging turned off. It still times out, this time the progress bar displays only 300 records processed.