S
S
Sergey Vasiliev2015-10-05 07:44:13
MySQL
Sergey Vasiliev, 2015-10-05 07:44:13

Translation plugin for WordPress?

I installed a plugin on the site that translates all the information on the site into several languages, since then the site has been loading slowly. The following problem was found in the database logs:
============================
The WordPress database returned an error Deadlock found when trying to get lock; try restarting transaction on INSERT INTO wp_translations_log (original, translated, lang, translated_by, source, timestamp) SELECT original, translated, lang, translated_by, source, timestamp FROM wp_translations WHERE (original ='Continuing our monthly column' AND lang= 'he') OR (original ='Oil prices' AND lang='he') OR (original ='Our editors' AND lang='he') OR (original ='together with' AND lang='he') OR (original ='news project of the country's energy industry' AND lang='he') OR (original ='prepared a short note on the dynamics of oil prices' AND lang='he') OR (original ='
The WordPress database returned an error Deadlock found when trying to get lock; try restarting transaction in response to a request INSERT INTO wp_translations_log (original, translated, lang, translated_by, source, timestamp) SELECT original, translated, lang, translated_by, source, timestamp FROM wp_translations WHERE (original = '0YHRgtC40YXQuNGPINGD0YHQv9C10LvQsCDQvdCw0L3QtdGB0YLQuCDQvtGB0YLRgNC-0LLRgyDRgdC10YDRjNC10LfQvdGL0Lkg0YPRidC10YDQsQ ,,' AND lang ='mr') OR (original ='0YPQvdC10YHRjyDQttC40LfQvdC4' AND lang='mr') OR (original ='0JrRgNC-0LzQtSDRgtC-0LPQvg,,' AND lang='mr') OR (original ='
The WordPress database returned an error Deadlock found when trying to get lock; try restarting transaction in response to the INSERT INTO wp_translations request (original, translated, lang, translated_by, source) VALUES ( '0K3RgtCwINC40L3QvdC-0LLQsNGG0LjRjyDQv9C-0LfQstC-0LvQuNGCINGA0LDQt9GA0LDQsdC-0YLQsNGC0Ywg0Y3RhNGE0LXQutGC0LjQstC90YPRjiDRgdGC0YDQsNGC0LXQs9C40Y4g0L_QviDRgdC-0YXRgNCw0L3QtdC90LjRjiDRjdC60L7Qu9C-0LPQuNC4INC4INC_0YDQtdC00L7RgtCy0YDQsNGJ0LXQvdC40Y4g0L3QtdGE0YLRj9C90YvRhSDQt9Cw0LPRgNGP0LfQvdC10L3QuNC5', 'இந்த கண்டுபிடிப்பு சூழல் மற்றும் எண்ணெய் மாசு தடுப்பு பாதுகாக்க ஒரு சிறப்பான செயல்திட்டத்தை உருவாக்க ',' Ta ',' 1 ',' 1 '), (' 0jgg0l3qsnc60l7qvdc10yy, ',' இறுதியாக ',' ta ',' 1 ',' 1 '), ('
The WordPress database returned an error Deadlock found when trying to get lock; try restarting transaction in response to the INSERT INTO wp_translations_log request (original, translated, lang, translated_by, source, timestamp) SELECT original, translated, lang, translated_by, source, timestamp FROM wp_translations WHERE (original = '0JIg0YHRgNCw0LLQvdC10L3QuNC4INGBINC70Y7QvNC40L3QtdGB0YbQtdC90YLQvdGL0LzQuCDQu9Cw0LzQv9Cw0LzQuCDQuCDRgdCy0LXRgtC40LvRjNC90LjQutCw0LzQuCDRgdCy0LXRgtC-0LTQuNC-0LTQvdGL0LUg0LLQsNGA0LjQsNC90YLRiyDQsdC-0LvQtdC1INC_0YDQsNC60YLQuNGH0L3RiyDQuCDRjdC60L7QvdC- 0LzQuNGH0L3Riw ,, 'AND lang =' zh-tw ') OR (original =' 0L7QvdC4INC-0LHQu9Cw0LTQsNGO0YIg0LTQu9C40YLQtdC70YzQvdGL0Lwg0Y3QutGB0L_Qu9GD0LDRgtCw0YbQuNC-0L3QvdGL0Lwg0YHRgNC-0LrQvtC8 'AND lang =' zh-tw ') OR (original ='
The WordPress database returned an error Deadlock found when trying to get lock; try restarting transaction in response to the INSERT INTO wp_translations_log request (original, translated, lang, translated_by, source, timestamp) SELECT original, translated, lang, translated_by, source, timestamp FROM wp_translations WHERE (original = '0KHQstC-0LXQuSDQstC10YDRgdC40LXQuSDQv9GA0L7QuNGB0YXQvtC00Y_RidC10LPQviDRgdC-INCh0JzQmCDQv9C-0LTQtdC70LjQu9GB0Y8g0Lgg0KDRg9GB0LvQsNC9INCR0LDQu9GM0LHQtdC6' AND lang='mt') OR (original ='0LfQsNC80L_RgNC10LTRgdC10LTQsNGC0LXQu9GPINCh0L7QstC80LjQvdCwINCg0Jo,' AND lang='mt') OR (original ='0J7QvSDQv9C-0LvQsNCz0LDginQtdGC' AND lang='morital') = langOR (lang='morital')
The WordPress database returned an error Deadlock found when trying to get lock; try restarting transaction in response to a request DELETE FROM wp_translations WHERE (original = '0KHQstC-0LXQuSDQstC10YDRgdC40LXQuSDQv9GA0L7QuNGB0YXQvtC00Y_RidC10LPQviDRgdC-INCh0JzQmCDQv9C-0LTQtdC70LjQu9GB0Y8g0Lgg0KDRg9GB0LvQsNC9INCR0LDQu9GM0LHQtdC6' AND lang = 'sl') OR (original = '0LfQsNC80L_RgNC10LTRgdC10LTQsNGC0LXQu9GPINCh0L7QstC80LjQvdCwINCg0Jo,' AND lang = 'sl') OR (original = ' 0J7QvSDQv9C-0LvQsNCz0LDQtdGC 'AND lang =' sl ') OR (original =' 0YfRgtC-INCU0LbQtdC80LjQu9C10LIg0Lgg0KfRg9Cx0LDRgNC-0LIg0YDRg9C60L7QstC-0LTRgdGC0LLRg9GO0YLRgdGPINGB0L7QsdGB0YLQstC10L3QvdGL0LzQuCDRg9GJ0LXQvNC70LXQvdC90YvQvNC4INC40L3RgtC10YDQtdGB0LDQvNC4 'AND lang =' sl ') OR (original ='
==========
Who can tell me how to fix it?
Thanks to all.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
O
Oleh Smirnov, 2016-12-23
@myxomatoziss

Show the output of SHOW ENGINE INNODB STATUS; in mysql console.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question