wp_blc_links deadlocked

well, I’ve had to disable the plugin since I don’t want my blog to become unusable due to this error that lock me out from the admin.

My IT told me that these two queries

ALTER TABLE wp_blc_instances MODIFY COLUMN container_id int(10) unsigned NOT NULL
ALTER TABLE wp_blc_instances MODIFY COLUMN instance_id int(10) unsigned NOT NULL AUTO_INCREMENT

are done multiple times causing the error.

Hi @shiftsrl,

Sorry to know that you are experiencing this issue.

I checked this on a test website but could not replicate the issue. Can you please share the exact error you noticed so we can look closely into this?

We look forward to hearing back from you.

Kind Regards,
Nebu John

Hello Nebu I’m using your plugin from the very start, almost 3 year ago, and I’ve never had any problem. Probably something gone wrong and created this problem. My idea is to completely remove all the tables and the plugin and reinstall it from scratch.

Anyway the error was

*Warning*: mysqli_real_connect(): (HY000/1203): User tuttoit_ublog already has more than ‘max_user_connections’ active connections in */home/******/public_html/blog/wp-includes/wp-db.php* on line *1753* User tuttoit_ublog already has more than ‘max_user_connections’ active connections Errore

• This reply was modified 2 years, 4 months ago by andreamarucci.

We are seeing the same thing. Plugin was updated on our site yesterday and broke everything.

Waiting for table metadata lock
ALTER TABLE wp_blc_links MODIFY COLUMN link_id int(20) unsigned NOT NULL AUTO_INCREMENT
ALTER TABLE wp_blc_links MODIFY COLUMN url text CHARACTER SET utf8 COLLATE utf8_bin NOT NULL

• This reply was modified 2 years, 4 months ago by teamcrisis.

We have dozens of sites with the same problem, to the point that MySQL 8 is no longer functional, and we have to reboot it.

At the moment we have uninstalled the plugin in all our installations.

Happy (not too much though) to see that I’m not alone with this problem. By now the plugin is removed but I’d like to have it fixed.

Hello all!

Apologies for the inconvenience caused by this issue!

Our team is preparing a fix for release, however it will take a few days for it to be publicly available here. In the meantime we’ve prepared a patched version of the file that seems to be causing the issue in this case. If you’d like to use it, here are the steps:

– take a backup just in case, as a general precaution
– please find the file here: https://pastebin.com/raw/5sFsMnpf
– save the code as init.php
– upload the file to wp-content/plugins/broken-link-checker/core/ replacing the previously existing file

Once that’s done, the issue should be fixed.

Once again, apologies for the hassle here!

Kind regards,
Pawel

Thanks Pawel but I’ll wait for the new release. In the meantime do you think it’s ok to completely remove all the tables and install it from scratch the new release?

Hi @shiftsrl,

I would like to update you that this is already fixed; please do update the plugin to version 1:11.21 and let us know if you still face any further anomalies.

Kind Regards,
Nithin

I can confirm v1.11.21 seems to have fixed the issue for us.