I just created new releases for four of my projects (nodes 2560103–9), and each time except on the last one I got, after a longer load, a "504 Gateway Timeout" response when trying to save the new release node.
Refreshing the page (and re-sending the POST data) yields the node edit form with an error message that a release node for that version has already been created. (I then just had to wait a few minutes to see them, because they aren't listed on the project page until a tarball is created for them.)

Since this is on specific pages, not "on random requests", I didn't want to reopen #2319567: 504 Gateway Timeout on random requests, but it might of course be related.

Comments

drunken monkey created an issue. See original summary.

drumm’s picture

I happened to catch a failed release packaging job from one of these. The error was:

9:19:54 PDOException: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction: UPDATE {views_content_cache} SET timestamp=:db_update_placeholder_0
19:19:54 WHERE ( (c2 = :db_condition_placeholder_0) AND (c3 = :db_condition_placeholder_1) ); Array
19:19:54 (
19:19:54     [:db_update_placeholder_0] => 1440962343
19:19:54     [:db_condition_placeholder_0] => project_release
19:19:54     [:db_condition_placeholder_1] => node_changed
19:19:54 )
19:19:54  in views_content_cache_update_set() (line 128 of /var/www/drupal.org/htdocs/sites/all/modules/views_content_cache/views_content_cache.module).

Depending on how quickly you made the releases, all of them could have been waiting on the same lock.

drumm’s picture

Status: Active » Fixed
Related issues: +#2560181: 504 when deleting nodes

I believe #2560181: 504 when deleting nodes was the root cause. node_delete_multiple() is wrapped in a DB transaction; in the middle of that is when ApacheSolr module sends delete requests, which were slow and timing out, prolonging the DB transactions. Creating nodes hits a lot of the same lockable tables.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.