Forums

Covering OroCommerce, OroCRM, OroPlatform topics, including community updates and company announcements.

Forums OroCommerce Crush of 'oro:message-queue:consume' command

This topic contains 0 replies, has 1 voice, and was last updated by  irina.k.melnikova 3 months, 3 weeks ago.

  • Creator
    Topic
  • #33057

    irina.k.melnikova
    Participant

    Hello,

    There is an issue while running ‘oro:message-queue:consume’ command.

    [2018-05-23 20:44:16] console.ERROR: An error occurred while running command “–env=prod –no-debug ‘oro:message-queue:consume'”. Cannot run jobs in status stale, id: “1194325” {“exit_code”:0,”exception”:
    “[object] (Oro\\Component\\MessageQueue\\Exception\\StaleJobRuntimeException(code: 0): Cannot run jobs in status stale, id: \”1194325\” at /var/www/crm.int.portaone.com/vendor/oro/platform/src/Oro/Compone
    nt/MessageQueue/Job/JobRunner.php:141)”,”arguments”:{“command”:”oro:message-queue:consume”},”options”:{“env”:”prod”,”no-debug”:true}} []
    [2018-05-23 20:44:17] app.CRITICAL: Orphans were found and redelivered. consumerIds: “5b05a86f8c3452.47596808” [] {“extension”:”Oro\\Component\\MessageQueue\\Consumption\\Dbal\\Extension\\RedeliverOrphanM
    essagesDbalExtension”}
    [2018-05-23 21:27:02] app.ERROR: Cannot load the cache state date from the database. {“exception”:”[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occured in driver: SQLSTATE[H
    Y000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /var/www/crm.int.portaone.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOException(code: 2003): SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /var/www/crm.int.portaone.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOExceptio
    n(code: 2003): SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /var/www/crm.int.portaone.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)”} {“extension”
    :”Oro\\Bundle\\MessageQueueBundle\\Consumption\\Extension\\ResettableExtensionWrapper”}

    [2018-05-23 21:27:02] app.ERROR: Cannot save the cache state date into the database. {“exception”:”[object] (Doctrine\\DBAL\\Exception\\DriverException(code: 0): An exception occured in driver: SQLSTATE[H
    Y000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /var/www/crm.int.portaone.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\\DBAL\\Driver\\PDOExcep
    tion(code: 2003): SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /var/www/crm.int.portaone.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:47, PDOExceptio
    n(code: 2003): SQLSTATE[HY000] [2003] Can’t connect to MySQL server on ‘127.0.0.1’ (111) at /var/www/crm.int.portaone.com/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:43)”,”date”:”2018-
    05-23 18:27:02″} {“extension”:”Oro\\Bundle\\MessageQueueBundle\\Consumption\\Extension\\ConsumerHeartbeatExtension”}
    [2018-05-23 21:27:02] app.ERROR: Consuming interrupted by exception. “Expected numeric content. content:””” {“exception”:”[object] (LogicException(code: 0): Expected numeric content. content:\”\” at /var/
    www/crm.int.portaone.com/vendor/oro/platform/src/Oro/Component/MessageQueue/Consumption/Dbal/DbalPidFileManager.php:89)”} {“extension”:”Oro\\Component\\MessageQueue\\Consumption\\Dbal\\Extension\\Redelive
    rOrphanMessagesDbalExtension”}
    [2018-05-23 21:27:02] console.ERROR: An error occurred while running command “–env=prod –no-debug ‘oro:message-queue:consume'”. Expected numeric content. content:”” {“exit_code”:0,”exception”:”[object]
    (LogicException(code: 0): Expected numeric content. content:\”\” at /var/www/crm.int.portaone.com/vendor/oro/platform/src/Oro/Component/MessageQueue/Consumption/Dbal/DbalPidFileManager.php:89)”,”arguments
    “:{“command”:”oro:message-queue:consume”},”options”:{“env”:”prod”,”no-debug”:true}} []

    As I got the idea, database connection suddenly got lost. Now the last error message “Consuming interrupted by exception. “Expected numeric content. content:””” is displayed while running ‘oro:message-queue:consume’ command.

    Pid file with the same id as in message “app.CRITICAL: Orphans were found and redelivered. consumerIds: “5b05a86f8c3452.47596808” [] {“extension”:”Oro\\Component\\MessageQueue\\Consumption\\Dbal\\Extension\\RedeliverOrphanM
    essagesDbalExtension”}” is in “pid_file_dir”.

    How can I fix this?

    Thank you.

You must be logged in to reply to this topic.

You will be redirected to [title]. Would you like to continue?

Yes No
sso for www.magecore.comsso for oroinc.comsso for oroinc.desso for oroinc.frsso for marketplace.orocommerce.comsso for marketplace.orocrm.com