Update and error (2)

  • Resolved almendron

    (@almendron)


    6 years ago

    After updating to version 1.11.13: error message in admin

    Error en la base de datos de WordPress: [Deadlock found when trying to get lock; try restarting transaction]

DELETE synch.* FROM wp_blc_synch AS synch WHERE synch.container_id NOT IN

    Note: The plugin seems to work correctly

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Plugin Support Dimitris – WPMU DEV Support

    (@wpmudev-support6)

    6 years ago

    Hello there @almendron

    Could you please share the complete error message, as I can’t reproduce it in my end.

    Also, please let me know if there’s a specific URL that triggers it.

    Thank you,
    Dimitris

    Thread Starter almendron

    (@almendron)

    6 years ago

    I’m very sorry, but I can’t share the full error message. This message has only appeared in the admin just after updating the plugin. It has not appeared more times.

    Links were being checked at the time of the update.

    I don’t dare to deactivate and then activate because there are 165,576 links.

    Note: The plugin seems to work correctly

    Thread Starter almendron

    (@almendron)

    6 years ago

    Found the error message

    apache.error.log

    [Sun May 31 11:08:53.496646 2020] [proxy_fcgi:error] [pid 23709] [client 85.251.108.148:65007] AH01071: Got error 'PHP message: Error Deadlock found when trying to get lock; try restarting transaction de la base de datos de WordPress para la consulta DELETE synch.* FROM wp_blc_synch AS synch WHERE synch.container_id NOT IN ('130166', '130165', '130164', '130163', '130162', '130160', '130159', '130158', '130157', '130156', '130155', '130154', '130152', '130151', '130150', '130148', '130146', '130144', '130127', '130070', '130111', '130114', '130113', '130112', '130110', '130106', '130104', '130103', '130102', '130101', '130099', '130098', '130096', '130094', '130093', '130092', '130091', '130089', '130087', '130086', '130083', '130080', '130074', '130049', '130066', '130032', '130065', '130063', '130061', '130059', '130057', '130034', '130033', '130048', '130047', '130045', '130044', '130043', '130041', '130040', '130039', '130037', '130036', '130035', '130029', '130027', '130024', '130023', '130022', '130020', '130019', '130017', '130015', '130014', '130013', '129996', '129995', '129994', '129993', '129991', '129989',...', referer: https://www.almendron.com/tribuna/wp-admin/plugins.php?plugin_status=upgrade
[Sun May 31 11:09:05.981246 2020] [proxy_fcgi:error] [pid 23709] [client 85.251.108.148:65007] AH01071: Got error 'PHP message: PHP Warning:  Cannot modify header information - headers already sent by (output started at /usr/home/almendron/www/tribuna/wp-includes/wp-db.php:1491) in /usr/home/almendron/www/tribuna/wp-includes/functions.php on line 6224PHP message: PHP Warning:  Cannot modify header information - headers already sent by (output started at /usr/home/almendron/www/tribuna/wp-includes/wp-db.php:1491) in /usr/home/almendron/www/tribuna/wp-admin/includes/misc.php on line 1259PHP message: PHP Warning:  Cannot modify header information - headers already sent by (output started at /usr/home/almendron/www/tribuna/wp-includes/wp-db.php:1491) in /usr/home/almendron/www/tribuna/wp-admin/admin-header.php on line 9', referer: https://www.almendron.com/tribuna/wp-admin/plugins.php?plugin_status=upgrade
    Plugin Support Amin – WPMU DEV Support

    (@wpmudev-support2)

    6 years ago

    Hello @almendron ,

    Thank you for the full log. Can you provide me with more information? What PHP version, what are the MySQL version and WordPress version you have on your site?

    kind regards,
    Kasia

    Thread Starter almendron

    (@almendron)

    6 years ago

    PHP: 7.3.18

    MySQL: 5.7

    Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    6 years ago

    Hello @almendron

    I trust you’re doing well!

    The Error Deadlock found when trying to get lock usually happens in large tables, it may not be related to plugins directly. If a database is heavy it is normal to happen from time to time. Please have a look at this explanation:
    https://stackoverflow.com/a/2596101

    Please let us know if the Bricen link Checker plugin was scanning your site at the time you went to upgrade the plugin’s version?

    Kind regards,
    Nastia

    Thread Starter almendron

    (@almendron)

    6 years ago

    Please let us know if the Bricen link Checker plugin was scanning your site at the time you went to upgrade the plugin’s version?

    Affirmative. The plugin was scanning my site at the time I updated.

    Notes

    1) ¿Bricen link Checker? I guess it is “Broken Link Checker”

    2) The plugin seems to work correctly.

    Plugin Support Imran – WPMU DEV Support

    (@wpmudev-support9)

    6 years ago

    Hello @almendron

    I trust you’re doing well!

    I apologize for the typo, you guessed right, it is Broken Link Checker”.

    Glad to know that all is well now. I’ve marked this ticket as resolved. If you do have any followup questions or require further assistance feel free to reopen it and let us know here.

    Kind regards,
    Nastia

    Thread Starter almendron

    (@almendron)

    6 years ago

    Alright!

    Kind regards,
    Miguel.

Viewing 9 replies - 1 through 9 (of 9 total)

The topic ‘Update and error (2)’ is closed to new replies.