Contrib.social

AJAX HTTP 500 error occurred during update batch process

Open on Drupal.org →
Created on 21 September 2022, over 2 years ago
Updated 14 February 2023, over 2 years ago

The batch process crashes during the update with an obscure AJAX HTTP 500 error.

An AJAX HTTP error occurred.
HTTP Result Code: 500
Debugging information follows.
Path: /batch?id=12&op=do_nojs&op=do
StatusText: error
ResponseText: The website encountered an unexpected error. Please try again later.

I keep getting it whenever I try to update.
After briefly trying to debug it, I noticed that the batch process almost never goes to the "stage" step, it runs until the end of the "begin" step and then crashes. I've only ever seen the database updates prompt twice and it appears after I get the error and then revisit the Update page. But this was 2 in 20 tries. I also tried increasing the timeout value in the "begin" step but to no avail.

Nginx didn't log any errors and Drupal gave the following error:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 FROM information_schema.tables WHERE ("table_schema" = :db_condition_placeholder_0) AND ("table_name" = :db_condition_placeholder_1); Array ( [:db_condition_placeholder_0] => drupalcon22_web [:db_condition_placeholder_1] => queue ) in Drupal\Core\Queue\DatabaseQueue->catchException() (line 297 of /home/drupalcon22/web/dc22.tabsandspaces.agency/public_html/web/core/lib/Drupal/Core/Queue/DatabaseQueue.php).

Which hosting provider did you test Automatic Updates with? eg. BlueHost, SiteGround, etc.

I host this on a private cloud instance from Hetzner that is personally configured by our DevOps team.

What was your goal? For example, what versions of Drupal core were you trying to update from and to?

I was trying to update from version 9.4.0 to version 9.4.6

What were the steps you took, starting from when you added the Automatic Updates module to your Drupal project (see https://www.drupal.org/i/3275810#install-module → for instructions)? Include anything that seems relevant, including commands you ran, links you clicked on, output logs, relevant config files, screenshots, screen recordings, etc.

I did exactly what was layed out in the instructions here 🌱 Automatic updates 8.x-2.x testing guide for hosting environments Closed: outdated .

What was your environment like?
Please answer as many of the following questions as you can.
Are you using Lando, DDEV, or another Docker-based environment?:

No

What operating system were you using?

Ubuntu 20.04.4 LTS with kernel version 5.4.0-94-generic

What web server are you using?

Nginx version 1.23.1

What PHP version are you using (see https://www.drupal.org/i/3275810#confirm-php-version → )?

PHP 7.4.30 (fpm and cli)

What version of Composer are you using (see https://www.drupal.org/i/3275810#confirm-composer-version → )?

Composer version 2.4.2

Did you accomplish your goal? Were the instructions clear? Did you observe any bugs or errors, or other issues? Did you need to do any workarounds?

I did not. The instructions were clear. The only other issue I observed was the proc_open requirement that I had to enable to proceed.

Problem with these instructions? Anything else we should know?

None that I can think of.

🐛 Bug report
Status

Postponed: needs info

Version

3.0

Component

Code

Created by

🇨🇾Cyprus EliasPapa

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • Comment over 2 years ago →
    🇺🇸United States tedbow Ithaca, NY, USA
  • Comment about 1 month ago →
    🇺🇸United States adrianm6254

    I am unable to perform Automatic Updates

    Error:
    An AJAX HTTP error occurred.
    HTTP Result Code: 500
    Debugging information follows.
    Path: /batch?id=8&op=do_nojs&op=do
    StatusText: error
    ResponseText:

    System Makup:
    PHP 8.3
    MariaDB 10.6
    OS Debian 11
    Drupal 11.1.6
    Automatic Updates 3.1.7
    Hosting Cloudways

    I am attempting to do the updates on the Cloudways Server (not on local environment)

    Error Log Output:

    Type php
    Date Thursday, 24 April 2025 - 15:14
    User drupal cms admin
    Location https://xxx.xxx.xxx/batch?_format=json&id=10&op=do
    Referrer https://xxx.xxx.xxx/batch?id=10&op=start
    Message Drupal\package_manager\Exception\StageEventException: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 FROM information_schema.tables WHERE ("table_schema" = :db_condition_placeholder_4) AND ("table_name" = :db_condition_placeholder_5); Array ( [:db_condition_placeholder_4] => xctekrqpca [:db_condition_placeholder_5] => semaphore ) in Drupal\package_manager\StageBase->dispatch() (line 601 of /home/xxx.xxx.xxx/xctekrqpca/public_html/web/modules/contrib/automatic_updates/package_manager/src/StageBase.php).
    Severity Error
    Hostname xxx.xxx.xxx.xxx
    Operations
    Backtrace
    #0 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/modules/contrib/automatic_updates/package_manager/src/StageBase.php(360): Drupal\package_manager\StageBase->dispatch()
    #1 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/modules/contrib/automatic_updates/automatic_updates_extensions/src/ExtensionUpdateStage.php(97): Drupal\package_manager\StageBase->create()
    #2 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/modules/contrib/automatic_updates/automatic_updates_extensions/src/BatchProcessor.php(65): Drupal\automatic_updates_extensions\ExtensionUpdateStage->begin()
    #3 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/includes/batch.inc(297): Drupal\automatic_updates_extensions\BatchProcessor::begin()
    #4 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/includes/batch.inc(139): _batch_process()
    #5 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/includes/batch.inc(95): _batch_do()
    #6 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/system/src/Controller/BatchController.php(52): _batch_page()
    #7 [internal function]: Drupal\system\Controller\BatchController->batchPage()
    #8 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(123): call_user_func_array()
    #9 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Render/Renderer.php(593): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
    #10 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(121): Drupal\Core\Render\Renderer->executeInRenderContext()
    #11 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/EventSubscriber/EarlyRenderingControllerWrapperSubscriber.php(97): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext()
    #12 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/http-kernel/HttpKernel.php(183): Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
    #13 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/http-kernel/HttpKernel.php(76): Symfony\Component\HttpKernel\HttpKernel->handleRaw()
    #14 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/Session.php(53): Symfony\Component\HttpKernel\HttpKernel->handle()
    #15 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle()
    #16 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle()
    #17 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle()
    #18 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(116): Drupal\big_pipe\StackMiddleware\ContentLength->handle()
    #19 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(90): Drupal\page_cache\StackMiddleware\PageCache->pass()
    #20 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle()
    #21 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle()
    #22 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle()
    #23 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle()
    #24 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/DrupalKernel.php(709): Drupal\Core\StackMiddleware\StackedHttpKernel->handle()
    #25 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/index.php(19): Drupal\Core\DrupalKernel->handle()
    #26 {main}

    ========================

    Type php
    Date Thursday, 24 April 2025 - 15:14
    User drupal cms admin
    Location https://xxx.xxx.xxx/batch?_format=json&id=10&op=do
    Referrer https://xxx.xxx.xxx/batch?id=10&op=start
    Message Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away: SELECT 1 FROM information_schema.tables WHERE ("table_schema" = :db_condition_placeholder_6) AND ("table_name" = :db_condition_placeholder_7); Array ( [:db_condition_placeholder_6] => xctekrqpca [:db_condition_placeholder_7] => config ) in Drupal\Core\Config\DatabaseStorage->readMultiple() (line 120 of /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Config/DatabaseStorage.php)
    #0 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Database/Connection.php(661): Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException()
    #1 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Database/Schema.php(178): Drupal\Core\Database\Connection->query()
    #2 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Config/DatabaseStorage.php(120): Drupal\Core\Database\Schema->tableExists()
    #3 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Config/CachedStorage.php(95): Drupal\Core\Config\DatabaseStorage->readMultiple()
    #4 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Config/ConfigFactory.php(165): Drupal\Core\Config\CachedStorage->readMultiple()
    #5 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Config/ConfigFactory.php(104): Drupal\Core\Config\ConfigFactory->doLoadMultiple()
    #6 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/Config/ConfigFactory.php(89): Drupal\Core\Config\ConfigFactory->doGet()
    #7 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/modules/contrib/redirect/modules/redirect_404/src/EventSubscriber/Redirect404Subscriber.php(85): Drupal\Core\Config\ConfigFactory->get()
    #8 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Component/DependencyInjection/Container.php(259): Drupal\redirect_404\EventSubscriber\Redirect404Subscriber->__construct()
    #9 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Component/DependencyInjection/Container.php(177): Drupal\Component\DependencyInjection\Container->createService()
    #10 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Component/DependencyInjection/Container.php(454): Drupal\Component\DependencyInjection\Container->get()
    #11 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/event-dispatcher/EventDispatcher.php(243): Drupal\Component\DependencyInjection\Container->Drupal\Component\DependencyInjection\{closure}()
    #12 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/event-dispatcher/EventDispatcher.php(206): Symfony\Component\EventDispatcher\EventDispatcher::Symfony\Component\EventDispatcher\{closure}()
    #13 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/event-dispatcher/EventDispatcher.php(56): Symfony\Component\EventDispatcher\EventDispatcher->callListeners()
    #14 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/http-kernel/HttpKernel.php(241): Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
    #15 /home/xxx.xxx.xxx/xctekrqpca/public_html/vendor/symfony/http-kernel/HttpKernel.php(91): Symfony\Component\HttpKernel\HttpKernel->handleThrowable()
    #16 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/Session.php(53): Symfony\Component\HttpKernel\HttpKernel->handle()
    #17 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/KernelPreHandle.php(48): Drupal\Core\StackMiddleware\Session->handle()
    #18 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/ContentLength.php(28): Drupal\Core\StackMiddleware\KernelPreHandle->handle()
    #19 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/big_pipe/src/StackMiddleware/ContentLength.php(32): Drupal\Core\StackMiddleware\ContentLength->handle()
    #20 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(116): Drupal\big_pipe\StackMiddleware\ContentLength->handle()
    #21 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/modules/page_cache/src/StackMiddleware/PageCache.php(90): Drupal\page_cache\StackMiddleware\PageCache->pass()
    #22 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/ReverseProxyMiddleware.php(48): Drupal\page_cache\StackMiddleware\PageCache->handle()
    #23 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/NegotiationMiddleware.php(51): Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle()
    #24 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/AjaxPageState.php(36): Drupal\Core\StackMiddleware\NegotiationMiddleware->handle()
    #25 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/StackMiddleware/StackedHttpKernel.php(51): Drupal\Core\StackMiddleware\AjaxPageState->handle()
    #26 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/core/lib/Drupal/Core/DrupalKernel.php(709): Drupal\Core\StackMiddleware\StackedHttpKernel->handle()
    #27 /home/xxx.xxx.xxx/xctekrqpca/public_html/web/index.php(19): Drupal\Core\DrupalKernel->handle()
    #28 {main}
    .
    Severity Error
    Hostname xxx.xxx.xxx.xxx
    Operations

  • Comment 29 days ago →
    🇬🇧United Kingdom catch

    This probably needs ✨ Database ping, close, and reconnect capabilities Active - the problem is if operations take too long, by the time you get back to the main Drupal process, the server has gone away.

    Trying to optimize package_manager operations so they finish quicker would also not do any harm, but don't have any ideas for that.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024