Ticket #12 (closed defect: fixed)

Opened 9 years ago

Last modified 8 years ago

After an update or save sometimes old/stale data/vaules are shown

Reported by: Gavin Owned by: Gavin
Priority: major Milestone: 0.4 - Functionality and integration
Component: gnuMims - application general Version: trunk
Keywords: Cc:

Description (last modified by Gavin) (diff)

A browser refresh causes the new data to be shown, so the data is persisted but just not fetched in time to show updated values after redirect.

This is not due to query caching, as previously believed. (Higher level caching is on in the global config but still needs to be turned on for each case where it is wanted).

The solution is to add flush:true to save(), implemented in r178 as per http://jira.codehaus.org/browse/GRAILS-5111

Change History

comment:1 Changed 9 years ago by Gavin

  • Description modified (diff)

comment:2 Changed 9 years ago by Gavin

  • Version set to trunk

comment:3 Changed 9 years ago by Gavin

So far this has only shown up in development mode, the deployed war running an in memory hsqldb does not appear to have this problem.

comment:4 Changed 8 years ago by Gavin

  • Milestone set to 0.3 - Asset management

comment:5 Changed 8 years ago by Gavin

  • Owner set to Gavin
  • Status changed from new to accepted

This is most likely due to caching in hibernate and if problem persists can be turned off in DataSource?.groovy

comment:6 Changed 8 years ago by Gavin

  • Status changed from accepted to closed
  • Resolution set to fixed
  • Description modified (diff)

comment:7 Changed 8 years ago by Gavin

  • Status changed from closed to reopened
  • Resolution fixed deleted
  • Summary changed from After an update or save sometimes the old data/vaules are shown to After an update or save sometimes old/stale data/vaules are shown

Turning off query caching appears to improve things in dev environment but when run in prod environment against MySQL with InnoDB problem is still there and more common.

comment:8 Changed 8 years ago by Gavin

  • Milestone changed from 0.3 - Asset management to 0.4 - Functionality and integration

comment:9 Changed 8 years ago by Gavin

  • Priority changed from minor to major
  • Status changed from reopened to closed
  • Resolution set to fixed
  • Description modified (diff)
Note: See TracTickets for help on using tickets.