Warning about 7.26 update if you have LOTS of unpublished nodes

We encourage users to post events happening in the community to the community events group on https://www.drupal.org.
mikeytown2's picture
Posted by mikeytown2 on January 15, 2014 at 11:37pm

taxonomy_update_7011 runs out of memory and once that is fixed it can take up to 15 minutes to run.
https://drupal.org/node/2174551

Comments

From what I understand, it's

Posted by Garrett Albright on January 16, 2014 at 6:21pm
Garrett Albright's picture

From what I understand, it's a problem if you have a lot of unpublished nodes and use taxonomy extensively, right? Maybe not so much a problem for sites that have a lot of nodes but don't keep too many unpublished ones sticking around in the database and/or don't use taxonomy much.

The Boise Drupal Guy!

for what it's worth

Posted by ben.hamelin on January 16, 2014 at 7:08pm
ben.hamelin's picture

we ran into an issue a few weeks back when testing a view of unpublished nodes we were prepping for a production site. Term relationships were NOT maintained in the taxonomy_index table. Likely affects the lookup and of these unpublished nodes without having the fast lookup with indexes on that main relational table.

bh

http://www.adworkshop.com/

Patch proposed at

Posted by hswong3i on January 17, 2014 at 8:26am
hswong3i's picture

Patch proposed at https://drupal.org/comment/8383389#comment-8383389, please feel free to give a try.

Edison Wong
CEO, Co-founder
PantaRei Design Limited

I can confirm Garrett's statement

Posted by philosurfer on January 17, 2014 at 7:06pm
philosurfer's picture

I can confirm #2 is the scenario.

I have 2 clients that are showing a painful update process where they have several thousand unpublished nodes.

I would recommend the patch handle 100+ nodes, as 50 seems a little low :D (call me aggressive!)

          "we are the cult of personality."

n/a

Posted by philosurfer on January 17, 2014 at 7:13pm
philosurfer's picture

-

          "we are the cult of personality."