5.51beta1: "No such table" for civicrm_user_job with drush cvupdb

Closed Issue created 2 years ago by JonGold
I tried updating a site from 5.49.5 to 5.51b1 this morning.
A web-UI upgrade failed with the issue in #3507 (closed).
Per that ticket, I tried drush cvsqlc but it failed fairly quickly (backtrace and full error below).
Using cv upgraded successfully.
Jun 10 10:38:05  [info] Running task: Cleanup old files

Jun 10 10:38:05  [error] $Fatal Error Details = Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => exceptionHandler
        )

    [code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] =>
        SELECT uj.id FROM civicrm_queue q
        INNER JOIN civicrm_user_job uj ON q.id = uj.queue_id
        WHERE q.name = 'CRM_Upgrade'
       [nativecode=1146 ** Table 'mysite_dev.civicrm_user_job' doesn't exist]
    [type] => DB_Error
    [user_info] =>
        SELECT uj.id FROM civicrm_queue q
        INNER JOIN civicrm_user_job uj ON q.id = uj.queue_id
        WHERE q.name = 'CRM_Upgrade'
       [nativecode=1146 ** Table 'mysite_dev.civicrm_user_job' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::exceptionHandler prefix="" info="
        SELECT uj.id FROM civicrm_queue q
        INNER JOIN civicrm_user_job uj ON q.id = uj.queue_id
        WHERE q.name = 'CRM_Upgrade'
       [nativecode=1146 ** Table 'mysite_dev.civicrm_user_job' doesn't exist]"]
)


Jun 10 10:38:05  [debug] $backTrace = #0 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Core/Error.php(954): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 /home/jon/local/mysite/web/vendor/pear/pear-core-minimal/src/PEAR.php(944): CRM_Core_Error::exceptionHandler(Object(DB_Error))
#2 /home/jon/local/mysite/web/vendor/pear/db/DB.php(997): PEAR_Error->__construct("DB Error: no such table", -18, 16, (Array:2), "\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...")
#3 /home/jon/local/mysite/web/vendor/pear/pear-core-minimal/src/PEAR.php(575): DB_Error->__construct(-18, 16, (Array:2), "\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...")
#4 /home/jon/local/mysite/web/vendor/pear/pear-core-minimal/src/PEAR.php(223): PEAR::_raiseError(Object(DB_mysqli), NULL, -18, 16, (Array:2), "\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...", "DB_Error", TRUE)
#5 /home/jon/local/mysite/web/vendor/pear/db/DB/common.php(1928): PEAR->__call("raiseError", (Array:7))
#6 /home/jon/local/mysite/web/vendor/pear/db/DB/mysqli.php(936): DB_common->raiseError(-18, NULL, NULL, "\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...", "1146 ** Table 'mysite_dev.civicrm_user_job' doesn't exist")
#7 /home/jon/local/mysite/web/vendor/pear/db/DB/mysqli.php(406): DB_mysqli->mysqliRaiseError()
#8 /home/jon/local/mysite/web/vendor/pear/db/DB/common.php(1234): DB_mysqli->simpleQuery("\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...")
#9 /home/jon/local/mysite/web/vendor/civicrm/civicrm-packages/DB/DataObject.php(2696): DB_common->query("\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...")
#10 /home/jon/local/mysite/web/vendor/civicrm/civicrm-packages/DB/DataObject.php(1829): DB_DataObject->_query("\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...")
#11 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(472): DB_DataObject->query("\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...")
#12 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Core/DAO.php(1709): CRM_Core_DAO->query("\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...", TRUE)
#13 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Core/BAO/UserJob.php(75): CRM_Core_DAO::singleValueQuery("\n        SELECT uj.id FROM civicrm_queue q\n        INNER JOIN civicrm_user_...", (Array:1))
#14 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Core/BAO/UserJob.php(37): CRM_Core_BAO_UserJob::findUserJobId("CRM_Upgrade")
#15 /home/jon/local/mysite/web/vendor/symfony/event-dispatcher/EventDispatcher.php(264): CRM_Core_BAO_UserJob::on_civi_queue_check(Object(Civi\Core\Event\GenericHookEvent), "civi.queue.check", Object(Civi\Core\CiviEventDispatcher))
#16 /home/jon/local/mysite/web/vendor/symfony/event-dispatcher/EventDispatcher.php(239): Symfony\Component\EventDispatcher\EventDispatcher->doDispatch((Array:1), "civi.queue.check", Object(Civi\Core\Event\GenericHookEvent))
#17 /home/jon/local/mysite/web/vendor/symfony/event-dispatcher/EventDispatcher.php(73): Symfony\Component\EventDispatcher\EventDispatcher->callListeners((Array:1), "civi.queue.check", Object(Civi\Core\Event\GenericHookEvent))
#18 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/Civi/Core/CiviEventDispatcher.php(198): Symfony\Component\EventDispatcher\EventDispatcher->dispatch(Object(Civi\Core\Event\GenericHookEvent), Object(Civi\Core\Event\GenericHookEvent))
#19 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Queue/Runner.php(277): Civi\Core\CiviEventDispatcher->dispatch("civi.queue.check", Object(Civi\Core\Event\GenericHookEvent))
#20 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Queue/Runner.php(213): CRM_Queue_Runner->runNext()
#21 /home/jon/local/mysite/web/vendor/civicrm/civicrm-core/CRM/Upgrade/Headless.php(49): CRM_Queue_Runner->runAll()
#22 /home/jon/local/mysite/web/modules/contrib/civicrm_drush/src/Commands/CivicrmDrushCommands.php(435): CRM_Upgrade_Headless->run()
#23 [internal function](): Drupal\civicrm_drush\Commands\CivicrmDrushCommands->drushCivicrmUpgradeDb((Array:20))
#24 /home/jon/local/mysite/web/vendor/consolidation/annotated-command/src/CommandProcessor.php(257): call_user_func_array((Array:2), (Array:1))
#25 /home/jon/local/mysite/web/vendor/consolidation/annotated-command/src/CommandProcessor.php(212): Consolidation\AnnotatedCommand\CommandProcessor->runCommandCallback((Array:2), Object(Consolidation\AnnotatedCommand\CommandData))
#26 /home/jon/local/mysite/web/vendor/consolidation/annotated-command/src/CommandProcessor.php(176): Consolidation\AnnotatedCommand\CommandProcessor->validateRunAndAlter((Array:3), (Array:2), Object(Consolidation\AnnotatedCommand\CommandData))
#27 /home/jon/local/mysite/web/vendor/consolidation/annotated-command/src/AnnotatedCommand.php(350): Consolidation\AnnotatedCommand\CommandProcessor->process(Object(Symfony\Component\Console\Output\ConsoleOutput), (Array:3), (Array:2), Object(Consolidation\AnnotatedCommand\CommandData))
#28 /home/jon/local/mysite/web/vendor/symfony/console/Command/Command.php(255): Consolidation\AnnotatedCommand\AnnotatedCommand->execute(Object(Drush\Symfony\DrushArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#29 /home/jon/local/mysite/web/vendor/symfony/console/Application.php(1027): Symfony\Component\Console\Command\Command->run(Object(Drush\Symfony\DrushArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#30 /home/jon/local/mysite/web/vendor/symfony/console/Application.php(273): Symfony\Component\Console\Application->doRunCommand(Object(Consolidation\AnnotatedCommand\AnnotatedCommand), Object(Drush\Symfony\DrushArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#31 /home/jon/local/mysite/web/vendor/symfony/console/Application.php(149): Symfony\Component\Console\Application->doRun(Object(Drush\Symfony\DrushArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#32 /home/jon/local/mysite/web/vendor/drush/drush/src/Runtime/Runtime.php(118): Symfony\Component\Console\Application->run(Object(Drush\Symfony\DrushArgvInput), Object(Symfony\Component\Console\Output\ConsoleOutput))
#33 /home/jon/local/mysite/web/vendor/drush/drush/src/Runtime/Runtime.php(49): Drush\Runtime\Runtime->doRun((Array:3), Object(Symfony\Component\Console\Output\ConsoleOutput))
#34 /home/jon/local/mysite/web/vendor/drush/drush/drush.php(72): Drush\Runtime\Runtime->run((Array:3))
#35 /home/jon/local/mysite/web/vendor/drush/drush/includes/preflight.inc(18): require("/home/jon/local/mysite/web/vendor/drush/drush/drush.php")
#36 phar:///usr/local/bin/drush-launcher/bin/drush.php(141): drush_main()
#37 /usr/local/bin/drush-launcher(10): require("phar:///usr/local/bin/drush-launcher/bin/drush.php")
#38 {main}
5.51beta1: "No such table" for civicrm_user_job with drush cvupdb

Linked items ... 0

Activity
