{"id":13451315,"date":"2020-09-24T21:03:42","date_gmt":"2020-09-24T21:03:42","guid":{"rendered":"https:\/\/wordpress.org\/support\/topic\/database-transactions\/"},"modified":"2020-09-24T22:42:17","modified_gmt":"2020-09-24T22:42:17","slug":"database-transactions","status":"publish","type":"topic","link":"https:\/\/wordpress.org\/support\/topic\/database-transactions\/","title":{"rendered":"Database transactions"},"content":{"rendered":"

Howdy all. So I’ve been fighting this weird 404 issue relating to AMP and another plugin I have (Directories Pro). Seems everyday both plugins go 404. I thought it was WP-Rocket at first but now I am not so sure.<\/p>\n

Anyway, twice a day AMP and Directories stop serving their pages. I am going to test turning AMP off for a while and see if the problem stops but in trying to diagnose this issue I run across some very strange SQL query behavior.<\/p>\n

I recorded 2 minutes of SQL dump from my server and while I do have a big\/busy site, this seems excessive. I see this query:<\/p>\n

DELETE FROM mml_wp_options<\/code> WHERE option_name<\/code> = ‘_transient_ampforwp_get_taxonomies’<\/p>\n

About 100 times a minute<\/strong>. Further, the reason I feel these may be related, here are some more logs:<\/p>\n

2020-09-24T18:14:26.936228Z 1428351 Query SELECT option_value FROM mml_wp_options WHERE option_name = ‘_transient_ampforwp_get_taxonomies’ LIMIT 1
\n2020-09-24T18:14:26.936771Z 1428354 Query SELECT option_value FROM mml_wp_options WHERE option_name = ‘_transient_ampforwp_get_taxonomies’ LIMIT 1
\n2020-09-24T18:14:26.936790Z 1428351 Query INSERT INTO mml_wp_options<\/code> (option_name<\/code>, option_value<\/code>, autoload<\/code>) VALUES (‘_transient_ampforwp_get_taxonomies’, ‘a:7:{s:16:\\”event-categories\\”;s:14:\\”Event Category\\”;s:20:\\”dining_guide_dir_cat\\”;s:23:\\”Dining Guide – Category\\”;s:16:\\”listings_dir_cat\\”;s:29:\\”Directory Listings – Category\\”;s:20:\\”dining_guide_dir_tag\\”;s:18:\\”Dining Guide – Tag\\”;s:16:\\”listings_dir_tag\\”;s:24:\\”Directory Listings – Tag\\”;s:20:\\”dining_guide_loc_loc\\”;s:23:\\”Dining Guide – Location\\”;s:16:\\”listings_loc_loc\\”;s:29:\\”Directory Listings – Location\\”;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name<\/code> = VALUES(option_name<\/code>), option_value<\/code> = VALUES(option_value<\/code>), autoload<\/code> = VALUES(autoload<\/code>)
\n2020-09-24T18:14:26.937542Z 1428354 Query INSERT INTO mml_wp_options<\/code> (option_name<\/code>, option_value<\/code>, autoload<\/code>) VALUES (‘_transient_ampforwp_get_taxonomies’, ‘a:7:{s:16:\\”event-categories\\”;s:14:\\”Event Category\\”;s:20:\\”dining_guide_dir_cat\\”;s:23:\\”Dining Guide – Category\\”;s:16:\\”listings_dir_cat\\”;s:29:\\”Directory Listings – Category\\”;s:20:\\”dining_guide_dir_tag\\”;s:18:\\”Dining Guide – Tag\\”;s:16:\\”listings_dir_tag\\”;s:24:\\”Directory Listings – Tag\\”;s:20:\\”dining_guide_loc_loc\\”;s:23:\\”Dining Guide – Location\\”;s:16:\\”listings_loc_loc\\”;s:29:\\”Directory Listings – Location\\”;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name<\/code> = VALUES(option_name<\/code>), option_value<\/code> = VALUES(option_value<\/code>), autoload<\/code> = VALUES(autoload<\/code>)
\n2020-09-24T18:14:27.333675Z 1428352 Query SELECT autoload FROM mml_wp_options WHERE option_name = ‘_transient_ampforwp_get_taxonomies’
\n2020-09-24T18:14:27.335178Z 1428352 Query DELETE FROM mml_wp_options<\/code> WHERE option_name<\/code> = ‘_transient_ampforwp_get_taxonomies’
\n2020-09-24T18:14:27.343437Z 1428352 Query SELECT option_value FROM mml_wp_options WHERE option_name = ‘_transient_ampforwp_get_taxonomies’ LIMIT 1
\n2020-09-24T18:14:27.344059Z 1428352 Query INSERT INTO mml_wp_options<\/code> (option_name<\/code>, option_value<\/code>, autoload<\/code>) VALUES (‘_transient_ampforwp_get_taxonomies’, ‘a:7:{s:16:\\”event-categories\\”;s:14:\\”Event Category\\”;s:20:\\”dining_guide_dir_cat\\”;s:23:\\”Dining Guide – Category\\”;s:16:\\”listings_dir_cat\\”;s:29:\\”Directory Listings – Category\\”;s:20:\\”dining_guide_dir_tag\\”;s:18:\\”Dining Guide – Tag\\”;s:16:\\”listings_dir_tag\\”;s:24:\\”Directory Listings – Tag\\”;s:20:\\”dining_guide_loc_loc\\”;s:23:\\”Dining Guide – Location\\”;s:16:\\”listings_loc_loc\\”;s:29:\\”Directory Listings – Location\\”;}’, ‘yes’) ON DUPLICATE KEY UPDATE option_name<\/code> = VALUES(option_name<\/code>), option_value<\/code> = VALUES(option_value<\/code>), autoload<\/code> = VALUES(autoload<\/code>)<\/p>\n

The AMP plugin is grabbing those taxonomies from the Directories plugin, and I’m not sure why.<\/p>\n

I cannot find a system cron or a WP cron at the hours of 11:15 am and 11:15 pm (twice daily) but this is when amp and Directories stop working and go 404. The fix is to run WordPress optimize database and it all comes back.<\/p>\n

Any ideas? Any nudges in the right direction would be helpful, losing sleep over this one.<\/p>\n","protected":false},"template":"","class_list":["post-13451315","topic","type-topic","status-publish","hentry"],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13451315","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic"}],"about":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/types\/topic"}],"version-history":[{"count":1,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13451315\/revisions"}],"predecessor-version":[{"id":13451328,"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/topic\/13451315\/revisions\/13451328"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/support\/wp-json\/wp\/v2\/media?parent=13451315"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}