Transition Technology: Ticket #286: Data loss on save, Cache Router issue?

ed — Thu, 30 Jun 2011 06:23:53 GMT

definitely worth a ticket!

NB: we may not have chris today if that's relevant - it's J30 strike day..

priority, status changed

jim — Thu, 30 Jun 2011 09:14:53 GMT

priority changed from critical to blocker
status changed from new to assigned

Don't need Chris for this one.

Cache router now disabled, and lo, the errors hath become quiet verily...

I reckon the update I made in late May from Cache Router RC1 -> RC2 caused all of the above issues we face and more.

I have doubts about the integrity of some of the system, especially stuff done in the last couple of weeks. For example, now seeing errors like:

Location	http://www.transitionnetwork.org/resources
Referrer
Message	Warning: Invalid argument supplied for foreach() in fivestar_views_value_display_handler() (line 1668 of /web/transitionnetwork.org/www/sites/all/modules/fivestar/fivestar.module).

And that line of code tries to access the site's data schema to connect nodes to their votes

    // Find the VotingAPI tag for this field.
    foreach ($field->query->table_queue[$field->relationship]['join']->extra as $votingapi_setting) {
      if ($votingapi_setting['field'] == 'tag') {
        $tag = $votingapi_setting['value'];
      }
    }

So we may have to re-install VotingAPI and FiveStar?. Will re-save the options forms first to see if that corrects the issue.

But the main thing is: We cannot use CacheRouter? in File mode any more. Varnish/Memcache? use it for different backends so they don't use file caching. I'll continue to add to this ticket as I close down other errors and get any joy on http://drupal.org/node/1152310

ed — Thu, 30 Jun 2011 09:26:15 GMT

good work that man!

milestone set

jim — Thu, 30 Jun 2011 09:26:38 GMT

milestone set to Phase 4

Duh.

priority changed

jim — Thu, 30 Jun 2011 10:16:58 GMT

priority changed from blocker to major

I've removed and re-installed Fivestart and VotingAPI but the errors were still appearing in Watchdog, one for each FiveStar? being shown.

So I've added the PHP code in a field I fixed the issue with in the Group Resources view and it's all cleared up.

Downgrading, but will keep open until something happens on http://drupal.org/node/1152310

jim — Fri, 01 Jul 2011 16:25:21 GMT

I noted as soon as we re-added CacheRouter? this morning, lots of settings were odd and old, plus Piwik hasnt' been getting any stats for a while.

I've since realised perhaps this is to do with the remaining files in the /sites/default/files/filecache folder being old and/or locked somehow still.

I've just completely wiped (sudo rm -R *) the contents of the folder and all the settings are magically back, and piwik works, as does the new /video page!

I now have even less faith in CR file engine, since when one 'clears all caches' it should wipe these files too... It appears it's not been. That is very dangerous.

I'll continue to keep an eye on things...

jim — Wed, 06 Jul 2011 16:47:15 GMT

OK, getting bored of: a) having to keep manually wiping the filecache folder, b) the lack of response to a critical issue by the CR people.

So I'm rolling back to a previous version (RC1) until we're ready to get Varnish going on LIVE.

Will update tonight out of hours.

chris — Thu, 07 Jul 2011 10:16:48 GMT

getting bored of: a) having to keep manually wiping the filecache folder ... rolling back to a previous version ... Will update tonight out of hours.

Did you roll back already? If not I could sort a cron job to delete the files that need deleting?

jim — Thu, 07 Jul 2011 11:32:56 GMT

Didn't have time or energy to do it last night...

Don't worry about it Chris, the file cache as of RC2 is fundamentally broken, RC1 worked and didn't cause file locking issues. A single process (request) can lock its own files and get confused!

Roll back will happen sometime today/tongight depending on other tickets.

jim — Fri, 08 Jul 2011 12:35:06 GMT

RC1 has the same obsolete data appearing issue as RC2.

The sooner we drop the file engine, the better. In the mean time I'll try RC2 back on DEV to compare to RC1 and then, once Chris is ready, push RC2 back to the server.

Next week, obviously.

ed — Tue, 12 Jul 2011 14:25:25 GMT

hoping that the varnish thing works...

jim — Wed, 13 Jul 2011 12:54:01 GMT

Since #224 is done we're no-longer using cache router's file cache, so this is closed.

status changed; resolution set

jim — Wed, 13 Jul 2011 12:54:07 GMT

status changed from assigned to closed
resolution set to fixed