обновление до shop-script 8

при обновлении сайта до shop-script 8 появилась ошибка 502 Bad Gateway

Служба поддержки пишет:

у вас генерируются запросы вида:

| 1987 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '245' WHERE code = '627626410e4edac4cc417b78db8e8439' | 0.000 |
| 1990 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '241' WHERE code = 'cf67d896a2df5ad6281ff999d24fdf2a' | 0.000 |
| 1995 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '211' WHERE code = 'ecdb7c3d7779092acad973748f421717' | 0.000 |
| 1997 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 1 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '207' WHERE code = 'b1acff846a951717fad4a5b958339868' | 0.000 |
| 1999 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '180' WHERE code = '73a3b72710d2ca3789ea38a5a5a85aeb' | 0.000 |
| 2007 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '130' WHERE code = '59364a6ccf288764068e9b12c2f33736' | 0.000 |
| 2028 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '108' WHERE code = '7ced496ec6f6cbdd05212f80675bad89' | 0.000 |
| 2039 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '98' WHERE code = 'f128f5815ae63e7f1aee7b23ebfb1a25' | 0.000 |
| 2041 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '93' WHERE code = '1f918d4bb0272843a7554cb2916e56aa' | 0.000 |
| 2044 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '88' WHERE code = '17d50df8d16bf9507ce4fa10a223a43f' | 0.000 |
| 2047 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 1 | updating | UPDATE shop_carts_plugin_log SET storefront_id = '89' WHERE code = 'e59db84af996f1cebc555ca12ea1aa91' | 0.000 |
| 2050 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '82' WHERE code = 'b89162d0761ef3559181f075ab5a41b6' | 0.000 |
| 2057 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '62' WHERE code = '995e81eaad215d7a588f7650f52972cc' | 0.000 |
| 2074 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '38' WHERE code = '8ecb18a366bd07119262568b18bb49ce' | 0.000 |
| 2090 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '25' WHERE code = '11f63123d45ed3bce3f455c2abf53cc8' | 0.000 |
| 2091 | root | localhost | ivtex_ss5 | Query | 0 | init | show full processlist | 0.000 |
| 2107 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 1 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '14' WHERE code = 'ce88b1a3e9ee8d8db3aa8092e4f44f2b' | 0.000 |
| 2116 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '10' WHERE code = 'a734cf38c311bedf8a411287c5cbd1bc' | 0.000 |
| 2122 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '4' WHERE code = '11fcbc30990ebde1a6aebf612ffe5c19' | 0.000 |
| 2123 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '5' WHERE code = '522e084e20ad44ac8e2742a8f904e478' | 0.000 |
| 2126 | ivtex_ss5 | localhost | ivtex_ss5 | Sleep | 9 | | NULL | 0.000 |
| 2128 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '4' WHERE code = '11fcbc30990ebde1a6aebf612ffe5c19' | 0.000 |
| 2131 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '2' WHERE code = 'd435bd3e73959b6a2e7c3db63224717f' | 0.000 |

В базе, при открытии сайта, либо необходимо попробовать поменять ENGINE=MyISAM для таблицы shop_carts_plugin_log на innodb, возможно это поможет, или обратится к разработчику вашего сайта.

На сервере еще два сайта, они уже обновлены до 8 версии и работают корректно. что можно сделать???

3 ответа

  • 1

    Так вам же написали... Пробовали?

  • 1
    Татьяна Калабина 27 декабря 2018 20:23 #

    да, не помогло, выдает запросы 

    | 57 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 21 | Waiting for table level lock | UPDATE shop_carts_plugin_log SET storefront_id = '39' WHERE code = '794be49955017c61c011c37cc40dc4eb' | 0.000 |
    | 58 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 21 | Waiting for table metadata lock | OPTIMIZE TABLE shop_carts_plugin_log | 0.000 |
    | 59 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 21 | Waiting for table level lock | OPTIMIZE TABLE shop_carts_plugin_log | 0.000 |
    | 60 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 20 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 61 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 20 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 62 | root | localhost | NULL | Query | 0 | init | show full processlist | 0.000 |
    | 63 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 18 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 64 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 18 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 66 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 17 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 68 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 15 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 70 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 12 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 80 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 5 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 82 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 2 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |
    | 84 | ivtex_ss5 | localhost | ivtex_ss5 | Query | 0 | Waiting for table metadata lock | DELETE FROM shop_carts_plugin_log WHERE sent < (NOW() - interval 30 day) | 0.000 |

Добавить ответ

Чтобы добавить комментарий, зарегистрируйтесь или войдите