Identical DB updates every few seconds

yea, this is odd… not sure why’d you’d get that. Could you try resetting the plugin? Under Dashboard, there’s an option to delete settings upon deactivation. Could you tick that, and deactivate? Then reactivate?

Could double-check that the queries are at least identical for some of them? WordPress wouldn’t actually run updates if the value isn’t the same.

Under the main plugin folder, there’s a folder called “flags”, could you tell me what files are in there also?

Thanks.

Hi, query is identical, I checked now, and it is done sometimes every 5 seconds, sometimes every 30 seconds. I have a plugin to show me DB queries and every time I reload the WP cockpit I see it as recently executed.
I marked that option, deactivated, reactivated and it is happening as well with the default settings. There is just a simple index.html in the flags directory.

ok, what’s your plugin you’re using to track queries and I’ll investigate further

Hi Paul,
I use next-level-cache – it is a DB plugin and it shows the last update/insert query which caused the cache to reset (it can also read also the hit/miss queries).
It shows that very frequently there is the same update query being sent to the DB. I currently managed to enter the option name into write whitelist of next-level-cache and it doesn’t reset the cache, but I would appreciate if you could check it.

I was originally relying on the WordPress option update code to not update a WordPress option when it is identical to the existing value.

But, it seems, in this case, perhaps because it is a serialized PHP object, it’s not working quite as it should.

So, I’ve built-in a system into the plugin so it’ll only attempt to update the options in the event that there is any difference in the value.

This will be released in the next major version. If I were you, I would ultimately remove your white list for this option. The performance penalty for this isn’t really significant.

If you’d like to get the beta of the latest version with this fix, and other changes, please go here:
https://github.com/FernleafSystems/wp-simple-firewall/tree/release/4.17.0

Thanks for reporting this!

I think I’ll wait for the official update, I hope it will happen soon. And then of course I will remove that entry from the whitelist.

Thanks for looking into it and fixing it. Great plugin and fantastic support!

No problem! I can’t say when I’ll be releasing the latest version yet… possibly next week sometime. It’s quite stable at the moment and I’m running it on most of my sites.

Thanks again!

Paul,

Not sure if it was really fixed. I downloaded the latest version from github, but it is still updating the DB with identical query every 5-10 seconds.

What’s the query exactly?

It was the same query, but I can’t reproduce it now. I checked just seconds after the upgrade and maybe somehow the server was still using the old php file?
Now whatever I do I don’t see those repeated queries. Sorry for false alarm, I hope.

The query is still there, but less frequently. I still have lots of identical queries:

UPDATE wp_options SET option_value = ‘O:8:\”stdClass\”:2:{s:11:\”plugin_spec\”;a:8:{s:10:\”properties\”;a:10:{s:7:\”version\”;s:12:\”4.17.0-beta1\”;s:11:\”slug_parent\”;s:4:\”icwp\”;s:11:\”slug_plugin\”;s:4:\”wpsf\”;s:10:\”human_name\”;s:27:\”WordPress Security Firewall\”;s:10:\”menu_title\”;s:17:\”Security Firewall\”;s:11:\”text_domain\”;s:18:\”wp-simple-firewall\”;s:16:\”base_permissions\”;s:14:\”manage_options\”;s:23:\”wpms_network_admin_only\”;b:1;s:15:\”logging_enabled\”;b:1;s:10:\”autoupdate\”;s:4:\”pass\”;}s:12:\”requirements\”;a:2:{s:3:\”php\”;s:5:\”5.2.4\”;s:9:\”wordpress\”;s:5:\”3.5.0\”;}s:5:\”paths\”;a:6:{s:6:\”source\”;s:3:\”src\”;s:6:\”assets\”;s:9:\”resources\”;s:9:\”languages\”;s:9:\”languages\”;s:5:\”views\”;s:9:\”templates\”;s:9:\”templates\”;s:9:\”templates\”;s:5:\”flags\”;s:5:\”flags\”;}s:8:\”includes\”;a:3:{s:5:\”admin\”;a:1:{s:3:\”css\”;a:1:{i:0;s:13:\”global-plugin\”;}}s:12:\”plugin_admin\”;a:2:{s:3:\”css\”;a:3:{i:0;s:24:\”bootstrap-wpadmin-legacy\”;i:1;s:23:\”bootstrap-wpadmin-fixes\”;i:2;s:6:\”plugin\”;}s:2:\”js\”;a:2:{i:0;s:13:\”bootstrap.min\”;i:1;s:12:\”icwp-options\”;}}s:8:\”frontend\”;a:1:{s:3:\”css\”;N;}}s:4:\”menu\”;a:7:{s:4:\”show\”;b:1;s:5:\”title\”;s:17:\”Security Firewall\”;s:9:\”top_level\”;b:1;s:14:\”do_submenu_fix\”;b:1;s:8:\”callback\”;s:16:\”onDisplayTopMenu\”;s:10:\”icon_image\”;s:20:\”pluginlogo_16x16.png\”;s:11:\”has_submenu\”;b:1;}s:6:\”labels\”;a:9:{s:4:\”Name\”;s:27:\”WordPress Security Firewall\”;s:11:\”Description\”;s:85:\”Secure Your Sites With The World\’s Most Powerful WordPress Security Protection System\”;s:5:\”Title\”;s:27:\”WordPress Security Firewall\”;s:6:\”Author\”;s:10:\”iControlWP\”;s:10:\”AuthorName\”;s:10:\”iControlWP\”;s:9:\”PluginURI\”;s:19:\”https://icwp.io/home\”;s:9:\”AuthorURI\”;s:19:\”https://icwp.io/home\”;s:14:\”icon_url_16x16\”;s:20:\”pluginlogo_16x16.png\”;s:14:\”icon_url_32x32\”;s:20:\”pluginlogo_32x32.png\”;}s:11:\”plugin_meta\”;a:1:{i:0;a:2:{s:4:\”name\”;s:26:\”5✩ Rate This Plugin\”;s:4:\”href\”;s:21:\”https://icwp.io/wpsf29\”;}}s:12:\”action_links\”;a:2:{s:6:\”remove\”;N;s:3:\”add\”;a:1:{i:0;a:2:{s:4:\”name\”;s:9:\”Dashboard\”;s:15:\”url_method_name\”;s:26:\”getPluginUrl_AdminMainPage\”;}}}}s:12:\”rebuild_time\”;i:1455094267;}’ WHERE option_name = ‘icwp_wpsf_plugin_controller’

Sometimes a few times in one minute, sometimes every couple of minutes. So it is definitely less frequent, but it is still there.

The system was designed to “rebuild” the core plugin options every 5 minutes to ensure that it’s always up-to-date, but I’ve changed this to now update a little more dynamically.
Please do give the latest beta a try:
https://github.com/FernleafSystems/wp-simple-firewall/tree/release/4.17.0

Should be OK, I am waiting for the final release. Thanks for all the support!

Cheers

Recently install the plugin on my site , however hosting administrator lock it, saying the inquiry and repeated requests ( looks for upgrade ) that performs the plugin.

According to some previous answers I understand that the plugin is pre-configured for it.

You can limit requests to the database?

Logs of Query
UPDATE wp_options SET option_value = ‘a:11:{s:31:\”enable_admin_access_restriction\”;s:1:\”N\”;s:22:\”current_plugin_version\”;s:5:\”5.0.0\”;s:20:\”admin_access_timeout\”;i:30;s:16:\”admin_access_key\”;s:0:\”\”;s:29:\”admin_access_restrict_plugins\”;a:95656:{i:0;s:16:\”activate_plugins\”;i:1;s:15:\”install_plugins\”;i:2;s:14:\”update_plugins\”;i:3;s:14:\”delete_plugins\”;i:4;s:15:\”install_plugins\”;i:5;s:14:\”update_plugins\”;i:6;s:14:\”delete_plugins\”;i:7;s:15:\”install_plugins\”;i:8;s:14:\”update_plugins\”;i:9;s:14:\”delete_plugins\”;i:10;s:15:\”install_plugins\”;i:11;s:14:\”update_plugins\”;i:12;s:14:

That query doesn’t look valid/correct… it’s got lots of stuff in it relating to plugins which isn’t our query. Something else appears to be going on there.