API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2020
109
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 9.00 KB | None | 0 0
raw download clone embed print report
  1. [2020-01-23 16:31:22] slow.NOTICE: 4.1612241268158 Shopsys\FrameworkBundle\Controller\Admin\ProductController::editAction /admin/product/edit/1084 [] []
  2. [2020-01-23 16:33:50] request.INFO: Matched route "admin_product_edit". {"route":"admin_product_edit","route_parameters":{"_controller":"Shopsys\\FrameworkBundle\\Controller\\Admin\\ProductController::editAction","id":"1084","_route":"admin_product_edit"},"request_uri":"https://cloud-sexshop51cz.shopsys-test.com/admin/product/edit/1084","method":"POST"} []
  3. [2020-01-23 16:33:50] security.DEBUG: Read existing security token from the session. {"key":"_security_administration","token_class":"Symfony\\Component\\Security\\Core\\Authentication\\Token\\UsernamePasswordToken"} []
  4. [2020-01-23 16:33:50] security.DEBUG: User was reloaded from a user provider. {"provider":"Shopsys\\FrameworkBundle\\Model\\Administrator\\Security\\AdministratorUserProvider","username":"ondrej.belohlavek"} []
  5. 127.0.0.1 -  23/Jan/2020:15:33:50 +0000 "POST /admin/product/edit/1084" 500
  6. [2020-01-23 16:33:57] request.CRITICAL: Uncaught PHP Exception Doctrine\DBAL\Exception\DeadlockException: "An exception occurred while executing 'UPDATE                 product_visibilities AS pv             SET                              calculated_ordering_priority = ROUND(                     ((CASE WHEN p.stock_quantity > 0 THEN 1 ELSE 0 END) *20)                     +                     ((CASE WHEN f.flag_id IS NULL THEN 0 ELSE 1 END) *50)                     +                     (COALESCE(p.stock_quantity, 0) *2)                     +                     (pd.sold_quantity*3)                     +                     (pd.ordering_priority*1)                     +                     (COALESCE(pmip.profit_margin_percent, 0)*2)                     +                     COALESCE(bd.product_ordering_priority_boost, 0)                            ),                 calculated_ordering_priority_log = CONCAT(                     '(je_skladem*20)',                     '+',                     '(je_novinka*50)',                     '+',                                         '(množství_skladem*2)',                     '+',                     '(množství_prodáno*3)',                     '+',                     '(manuální_priorita*1)',                     '+'                     '(marže*2)',                     '+',                     'priorita_značky',                     ' --------------------------- ',                     '(', (CASE WHEN p.stock_quantity > 0 THEN '1' ELSE '0' END), '*20)',                     '+',                     '(', (CASE WHEN f.flag_id IS NULL THEN '0' ELSE '1' END), '*50)',                     '+',                     '(', COALESCE(p.stock_quantity, 0),'*2)',                     '+',                     '(', pd.sold_quantity,'*3)',                     '+',                     '(', pd.ordering_priority,'*1)',                     '+',                     '(', COALESCE(pmip.profit_margin_percent, 0),'*2)'                     '+',                     COALESCE(bd.product_ordering_priority_boost, 0)                 ),                 last_ordering_priority_calculation_at = ?             FROM                 products AS p             JOIN                 product_domains AS pd ON pd.product_id = p.id             LEFT JOIN                 product_manual_input_prices AS pmip ON pmip.product_id = p.id AND pmip.pricing_group_id = ?             LEFT JOIN                 brands AS b ON b.id = p.brand_id              LEFT JOIN                 brand_domains AS bd ON bd.brand_id = p.brand_id AND bd.domain_id = ?             LEFT JOIN                 product_flags AS f ON f.product_id = p.id AND f.flag_id = ?                 WHERE                 p.id = pv.product_id                 AND pv.domain_id = ?                 AND pv.domain_id = pd.domain_id                 AND pv.pricing_group_id = ?              AND p.recalculate_visibility = TRUE' with params ["2020-01-23 16:33:56", 1, 1, 1, 1, 1]:  SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected DETAIL:  Process 10549 waits for ShareLock on transaction 354576220; blocked by process 10006. Process 10006 waits for ShareLock on transaction 354576174; blocked by process 10549. HINT:  See server log for query details. CONTEXT:  while updating tuple (49,29) in relation "product_visibilities"" at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php line 35 {"exception":"[object] (Doctrine\\DBAL\\Exception\\DeadlockException(code: 0): An exception occurred while executing 'UPDATE\n                product_visibilities AS pv\n            SET             \n                calculated_ordering_priority = ROUND(\n                    ((CASE WHEN p.stock_quantity > 0 THEN 1 ELSE 0 END) *20)\n                    +\n                    ((CASE WHEN f.flag_id IS NULL THEN 0 ELSE 1 END) *50)\n                    +\n                    (COALESCE(p.stock_quantity, 0) *2)\n                    +\n                    (pd.sold_quantity*3)\n                    +\n                    (pd.ordering_priority*1)\n                    +\n                    (COALESCE(pmip.profit_margin_percent, 0)*2)\n                    +\n                    COALESCE(bd.product_ordering_priority_boost, 0)           \n                ),\n                calculated_ordering_priority_log = CONCAT(\n                    '(je_skladem*20)',\n                    '+',\n                    '(je_novinka*50)',\n                    '+',                    \n                    '(množství_skladem*2)',\n                    '+',\n                    '(množství_prodáno*3)',\n                    '+',\n                    '(manuální_priorita*1)',\n                    '+'\n                    '(marže*2)',\n                    '+',\n                    'priorita_značky',\n                    '\n---------------------------\n',\n                    '(', (CASE WHEN p.stock_quantity > 0 THEN '1' ELSE '0' END), '*20)',\n                    '+',\n                    '(', (CASE WHEN f.flag_id IS NULL THEN '0' ELSE '1' END), '*50)',\n                    '+',\n                    '(', COALESCE(p.stock_quantity, 0),'*2)',\n                    '+',\n                    '(', pd.sold_quantity,'*3)',\n                    '+',\n                    '(', pd.ordering_priority,'*1)',\n                    '+',\n                    '(', COALESCE(pmip.profit_margin_percent, 0),'*2)'\n                    '+',\n                    COALESCE(bd.product_ordering_priority_boost, 0)\n                ),\n                last_ordering_priority_calculation_at = ?\n            FROM\n                products AS p\n            JOIN\n                product_domains AS pd ON pd.product_id = p.id\n            LEFT JOIN\n                product_manual_input_prices AS pmip ON pmip.product_id = p.id AND pmip.pricing_group_id = ?\n            LEFT JOIN\n                brands AS b ON b.id = p.brand_id \n            LEFT JOIN\n                brand_domains AS bd ON bd.brand_id = p.brand_id AND bd.domain_id = ?\n            LEFT JOIN\n                product_flags AS f ON f.product_id = p.id AND f.flag_id = ?    \n            WHERE\n                p.id = pv.product_id\n                AND pv.domain_id = ?\n                AND pv.domain_id = pd.domain_id\n                AND pv.pricing_group_id = ?\n             AND p.recalculate_visibility = TRUE' with params [\"2020-01-23 16:33:56\", 1, 1, 1, 1, 1]:\n\nSQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\nDETAIL:  Process 10549 waits for ShareLock on transaction 354576220; blocked by process 10006.\nProcess 10006 waits for ShareLock on transaction 354576174; blocked by process 10549.\nHINT:  See server log for query details.\nCONTEXT:  while updating tuple (49,29) in relation \"product_visibilities\" at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:35, Doctrine\\DBAL\\Driver\\PDOException(code: 40P01): SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\nDETAIL:  Process 10549 waits for ShareLock on transaction 354576220; blocked by process 10006.\nProcess 10006 waits for ShareLock on transaction 354576174; blocked by process 10549.\nHINT:  See server log for query details.\nCONTEXT:  while updating tuple (49,29) in relation \"product_visibilities\" at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:119, PDOException(code: 40P01): SQLSTATE[40P01]: Deadlock detected: 7 ERROR:  deadlock detected\nDETAIL:  Process 10549 waits for ShareLock on transaction 354576220; blocked by process 10006.\nProcess 10006 waits for ShareLock on transaction 354576174; blocked by process 10549.\nHINT:  See server log for query details.\nCONTEXT:  while updating tuple (49,29) in relation \"product_visibilities\" at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"} []
  7. [2020-01-23 16:33:57] slow.NOTICE: 7.3445088863373 Shopsys\FrameworkBundle\Controller\Admin\ProductController::editAction /admin/product/edit/1084 [] []
  8. [2020-01-23 16:33:57] slow.NOTICE: 7.3445088863373 Shopsys\FrameworkBundle\Controller\Admin\ProductController::editAction /admin/product/edit/1084 [] []
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!