Page MenuHomePhabricator

Fix "max execution timeout" failures locally when applying CiviCRM Database update
Closed, ResolvedPublic

Description

I've run into this a few times and it happened again today when reviewing a patch for Eileen. When pulling the latest down for CiviCRM and then being told by the dashboard alert popup that my database was out of date, I went through the web upgrader process, which looked like it was working fine until I hit the Max executions Timeout 30 seconds error. I then clicked what looked like the fast forward / next icon, and it picked up where it left off and seemed to complete successfully.

Let's find this stray annoying max execution time setting, which is setting it to 30 seconds locally, and set it to zero so that we don't have to worry about partial upgrades or broken db states when working locally.

Details

ReferenceSource BranchDest BranchAuthorTitle
repos/releng/dev-images!61executionTimeoutmainejeggSet max_execution_timeout to 0 for fundraising images
Customize query in GitLab

Event Timeline

jgleeson updated the task description. (Show Details)
greg triaged this task as Medium priority.Oct 30 2023, 8:22 PM

@Eileenmcnaughton sounds like this is on the db upgrade queue screen. Any idea if & where that 'max execution timeout' is configurable? I'm not seeing that exact string in the codebase.

That is configured in php.ini - if this is on local then we should alter our dev set up

Looks like we'd have to override it in the image:

docker@civicrm:/etc/php/7.4$ grep -r max_execution
cli/php.ini:max_execution_time = 30
apache2/php.ini:max_execution_time = 30

Mentioned in SAL (#wikimedia-releng) [2024-02-12T19:53:33Z] <dancy> Updating development images on contint primary for T349201

Ejegg claimed this task.
Ejegg moved this task from Pending Deployment to Done on the Fundraising Tech - Chaos Crew board.
Ejegg set Final Story Points to 2.