Description
Command "jms-job-queue:run" throws table doesn't exist error.
Steps:
- Execute php bin/console jms-job-queue:run.
Actual result:
2.5
In AbstractMySQLDriver.php line 61: An exception occurred while executing 'SELECT j0_.id AS id_0, j0_.state AS state_1, j0_.queue AS queue_2, j0_.priority AS priority_3, j0_.createdAt AS createdAt_4, j0_.startedAt AS startedAt_5, j0_.checkedAt AS checkedAt_6, j0_.workerName AS workerName_7, j0_.execu teAfter AS executeAfter_8, j0_.closedAt AS closedAt_9, j0_.command AS command_10, j0_.args AS args_11, j0_.output AS output_12, j0_.errorOutput AS errorOutput_13, j0_.exitCode AS exitCode_14, j0_.maxRuntime AS maxRuntime_15, j0_.maxRetries AS maxRetries_16, j0_.sta ckTrace AS stackTrace_17, j0_.runtime AS runtime_18, j0_.memoryUsage AS memoryUsage_19, j0_.memoryUsageReal AS memoryUsageReal_20, j0_.originalJob_id AS originalJob_id_21 FROM jms_jobs j0_ WHERE j0_.state = ? AND (j0_.workerName = ? OR j0_.workerName IS NULL)' with params ["running", "Michas-MBP.fritz.box-84663"]: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ez9.jms_jobs' doesn't exist In Exception.php line 18: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ez9.jms_jobs' doesn't exist In PDOStatement.php line 112: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ez9.jms_jobs' doesn't exist
3.3
In AbstractPostgreSQLDriver.php line 82: An exception occurred while executing 'SELECT j0_.id AS id_0, j0_.state AS state_1, j0_.queue AS queue_2, j0_.priority AS priority_3, j0_.createdAt AS createdat_4, j0_.startedAt AS startedat_5, j0_.checkedAt AS checkedat_6, j0_.workerName AS workername_7, j0_.execu teAfter AS executeafter_8, j0_.closedAt AS closedat_9, j0_.command AS command_10, j0_.args AS args_11, j0_.output AS output_12, j0_.errorOutput AS erroroutput_13, j0_.exitCode AS exitcode_14, j0_.maxRuntime AS maxruntime_15, j0_.maxRetries AS maxretries_16, j0_.sta ckTrace AS stacktrace_17, j0_.runtime AS runtime_18, j0_.memoryUsage AS memoryusage_19, j0_.memoryUsageReal AS memoryusagereal_20, j0_.originalJob_id AS originaljob_id_21 FROM jms_jobs j0_ WHERE j0_.state = ? AND (j0_.workerName = ? OR j0_.workerName IS NULL)' with params ["running", "Michas-MBP.fritz.box-84719"]: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "jms_jobs" does not exist LINE 1: ..._20, j0_.originalJob_id AS originaljob_id_21 FROM jms_jobs j... ^ In Exception.php line 18: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "jms_jobs" does not exist LINE 1: ..._20, j0_.originalJob_id AS originaljob_id_21 FROM jms_jobs j... ^ In PDOStatement.php line 117: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "jms_jobs" does not exist LINE 1: ..._20, j0_.originalJob_id AS originaljob_id_21 FROM jms_jobs j...
Remarks: Apparently this is the root cause of econtent tasks not working (EC-336).