[wp-trac] [WordPress Trac] #14254: update_meta_cache fails; query too large?

[WordPress Trac]

#14254: update_meta_cache fails; query too large?
-----------------------------------+-----------------------------
 Reporter:  newpixel               |       Owner:
     Type:  defect (bug)           |      Status:  reopened
 Priority:  normal                 |   Milestone:  Future Release
Component:  Cache API              |     Version:  2.9.2
 Severity:  normal                 |  Resolution:
 Keywords:  has-patch 2nd-opinion  |     Focuses:
-----------------------------------+-----------------------------

Comment (by GaryJ):

 I've got a meal plan CPT, where each meal is linked to multiple recipe
 CPTs (and that in turn, to multiple ingredient CPTs) with Posts 2 Posts
 plugin. When trying to show the list of meal plans
 (edit.php?post_type=mp_mealplan), I'm getting a fatal error due to memory
 allocation. It points to
 https://core.trac.wordpress.org/browser/tags/3.9.1/src/wp-
 includes/meta.php#L747 as being the initial issue (array mapping of intval
 over all object IDs). Hacking WP to echo a count of `$object_ids` gives a
 value of 13847 objects for the instance where the fatal error happens.

 There are 2600+ meal plans, each with a guestimate average of 6-10
 recipes. Each recipe has 6-10 ingredients on average.

 It's on Synthesis hosting, with W3TC (the `wp-content/advanced-cache.php`
 references W3TC too).

 I can temporarily get around it by bumping the WP memory constants to
 512M, but if there was a chunking option, or a way to smooth out or avoid
 this caching, then it would definitely help the extreme cases.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/14254#comment:12>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform