strange sql-error i cant figure out

  • Howdy!

    i moved a site to another server. when i call the wp_adim.php, i get a blank page.

    the rror log shows this:

    [Wed Jan 17 13:04:33.407410 2018] [proxy_fcgi:error] [pid 5557] [client 136.243.60.133:33998] AH01071: Got error 'PHP message: WordPress-Datenbank-Fehler Deadlock found when trying to get lock; try restarting transaction f\xc3\xbcr Abfrage DELETE FROM wp_mp0001_blc_links\r\n\t\t\tUSING wp_mp0001_blc_links LEFT JOIN wp_mp0001_blc_instances \r\n\t\t\t\tON wp_mp0001_blc_instances.link_id = wp_mp0001_blc_links.link_id\r\n\t\t\tWHERE\r\n\t\t\t\twp_mp0001_blc_instances.link_id IS NULL von do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, wp_scheduled_delete, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted, blc_cleanup_links\nPHP message: WordPress-Datenbank-Fehler Deadlock found when trying to get lock; try restarting transaction f\xc3\xbcr Abfrage DELETE FROM wp_mp0001_blc_links\r\n\t\t\tUSING wp_mp0001_blc_links LEFT JOIN wp_mp0001_blc_instances \r\n\t\t\t\tON wp_mp0001_blc_instances.link_id = wp_mp0001_blc_links.link_id\r\n\t\t\tWHERE\r\n\t\t\t\twp_mp0001_blc_instances.link_id IS NULL von do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, wp_delete_auto_drafts, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted, blc_cleanup_links\nPHP message: WordPress-Datenbank-Fehler Deadlock found when trying to get lock; try restarting transaction f\xc3\xbcr Abfrage DELETE FROM wp_mp0001_blc_links\r\n\t\t\tUSING wp_mp0001_blc_links LEFT JOIN wp_mp0001_blc_instances \r\n\t\t\t\tON wp_mp0001_blc_instances.link_id = wp_mp0001_blc_links.link_id\r\n\t\t\tWHERE\r\n\t\t\t\twp_mp0001_blc_instances.link_id IS NULL von do_action_ref_array, WP_Hook->do_action, WP_Hook->apply_filters, wp_delete_auto_drafts, wp_delete_post, do_action('delete_post'), WP_Hook->do_action, WP_Hook->apply_filters, blcPostTypeOverlord->post_deleted, blc_cleanup_links\n', referer: https://mieterpartei.jetzt/wp-cron.php?doing_wp_cron=1516190597.6797819137573242187500

    what the heck is this and how can i fix that?

    Greetings from Berlin, Germany

    sigi

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

  • That looks like a server issue. Have you spoken to your hosts about it?

    Thread Starter sigiberlin

    (@sigiberlin)

    yes. they just answered. but this answer doesnt help me.

    answer is in german. Google translates that to

    Whenever row-based relational databases are used, deadlocks can occur. This is a perfectly normal, even desirable process. That’s just the joke about dataset locking. The program code has to be programmed so that it can handle it. This is certainly not a server error, but an inadequate source code. The simplest solution is to enclose the command in a try … catch block and execute it again in case of a deadlock. Here’s more information on InnoDB deadlocks: https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks.html. On the server side there is no way to prevent this because it is designed “by design” for the InnoDB database format.

    now that doesnt help me. the code comes from WordPress i think….

    Are there any active/installed plugins on the site? What theme is currently active?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘strange sql-error i cant figure out’ is closed to new replies.