Hi,

Updated to Views 3.8 some time ago without any trouble. However, we recently ran into a big problem when cloning a view of "Type: Aggregator item": our site would crash after the cloned view was saved and other pages were loaded. I tested cloning the other types, most of which did the same, though cloning a view of "Type: Content" (90% of what we use) worked as usual.

The problem specifically is that after the view saves, on every page load Drupal starts running a large query looking at all the revisions of all of our 50,000+ nodes. This quickly brings down our site. The query in question looks a lot like the one found in issue #1003788: PostgreSQL: PDOException:Invalid text representation when attempting to load an entity with a string or non-scalar ID but my issue is definitely related to Views. If my site has crashed, I just revert back to Views 3.7 and I am back online.

In any case, here is the what the query looks like (formatting may be off in my copy):

SELECT revision.vid AS vid, base.uid AS uid, revision.title AS title, revision.log AS log, revision.status AS status, revision.comment AS comment, revision.promote AS promote, revision.sticky AS sticky, base.nid AS nid, base.type AS type, base.language AS language, base.created AS created, base.changed AS changed, base.tnid AS tnid, base.translate AS translate, revision.timestamp AS revision_timestamp, revision.uid AS revision_uid
FROM
node base
INNER JOIN node_revision revision ON revision.vid = base.vid WHERE  (base.nid IN  ('61590', '142853', '172526', '172533', '55398', '172607', '172617', '172652', '172690', '172694', '172699', '172700', '172711', '172722', '172556', '173168', '174456', '174457', '174458', '174459', '174460', '174461', '174462', '174463', '174464', '174465', '174466', '174467', '174468', '174469', '174470', '174471', '174472', '174498', '174499', '174500', '174501', '174502', '174503', '174504', '174505', '174506', '174507', '174508', '174509', '174510', '174511', '174512', '174513', '174514', '174515', '174516', '174517', '174518', '174519', '174520', '174521', '174522', '174523', '174524', '174525', '174526', '174527', '174528', '174529', '174530', '174531', '174532', '174533', '174534', '174535', '174536', '174537', '174538', '174539', '174540', '174541', '174542', '174543', '174544', '174545', '174546', '174547' ...

Any ideas? For the moment I'm staying with Views 3.7, but am wary because of the security issues.

Comments

mxwright’s picture

Title: Cloning problem in 7.x-3.8 » Massive query after cloning aggregator views crashes site

Title change for clarity.

mxwright’s picture

Version: 7.x-3.8 » 7.x-3.11
Status: Active » Closed (fixed)

I've updated to Views 3.11 and tested it at length against the trouble I reported above. Everything now seems resolved. Without further information I'll have to attribute this to various seemingly-related things mentioned in the release notes: