Uploaded image for project: 'Ibexa IBX'
  1. Ibexa IBX
  2. IBX-1295

Command "jms-job-queue:run" throws table doesn't exist error

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: High High
    • None
    • 2.5.13, 3.3.10
    • Commerce

    Description

      Command "jms-job-queue:run" throws table doesn't exist error.

      Steps:

      1. 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).

      Designs

        Attachments

          Activity

            People

              Unassigned Unassigned
              michal.szoltysek@ibexa.co Michał Szołtysek
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: