Transient Cache Deletion Fails WordPress 4.2.2
-
I’m seeing errors in my log whenever something tries to delete the transient cache (at least that’s what I think it’s doing). Here’s an example error:
[14-Jun-2015 11:21:36 UTC] WordPress database error Table ‘spstreet_global.wp_296_options’ doesn’t exist for query DELETE a, b FROM wp_296_options a, wp_296_options b
WHERE a.option_name LIKE ‘\\_transient\\_%’
AND a.option_name NOT LIKE ‘\\_transient\\_timeout\\_%’
AND b.option_name = CONCAT( ‘_transient_timeout_’, SUBSTRING( a.option_name, 12 ) )
AND b.option_value < 1434280896 made by wp_upgrade, upgrade_all, populate_options, SharDB->queryThe reason the error is occurring is because whatever is trying to delete the transient cache is trying to do it in the global database for every site in our multi-site installation, rather than going to the database for the particular site. We have sharded our database into 256 separate databases using the SharDB plugin, so the tables for each of our sites are stored in different databases. Whatever is trying to delete the transient cache doesn’t realize this, and is assuming that all of our sites have tables in the global database.
- The topic ‘Transient Cache Deletion Fails WordPress 4.2.2’ is closed to new replies.