Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-21510

'Clear View cache from here' action ignores CacheThreshold setting, performance issues/db deadlocks

    Details

      Description

      Expiring view cache using the 'Delete view cache from here' menu option ignores the [ContentSettings],CacheThreshold setting.
      This can cause performance issues, and possibly even db deadlocks on sites with very large content trees and/or load.

      Steps to reproduce:
      • In site.ini, ContentSettings group, specify a low value for CacheThreshold (such as 25)
      • Enable kernel-content-edit condition in debug.ini
      • In the administration interface, click to view the root node; click class icon for the popup menu, and choose the 'Delete view cache from here' option.
      Result:

      The content objects will be cleared one by one, as can be verified in the debug log. sample:

      [ Sep 04 2013 20:01:50 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      2
      [ Sep 04 2013 20:01:50 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      2
      [ Sep 04 2013 20:01:50 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      3
      [ Sep 04 2013 20:01:50 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      2
      [ Sep 04 2013 20:01:50 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      2
      [ Sep 04 2013 20:01:50 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      5
      ... (repeated for the number of objects)
      

      Expected Result:

      The CacheThreshold should be met, and a 'global' expiry issued. sample debug:

      [ Sep 04 2013 20:02:37 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      2
      [ Sep 04 2013 20:02:38 ] [192.168.56.1] count in nodeList <kernel-content-edit>:
      44
      [ Sep 04 2013 20:02:38 ] [192.168.56.1] eZContentCacheManager::clearObjectViewCacheArray:
      Expiring all view cache since list of nodes(44) exceeds site.ini\[ContentSettings]\CacheThreshold
      

        Issue Links

          Activity

          Joao Pingo (Inactive) logged work - 07/Mar/14 6:01 PM
          • Time Spent:
            1 hour
             

            Testing

          Joao Pingo (Inactive) logged work - 10/Mar/14 1:00 AM
          • Time Spent:
            7 hours
             

            Closed

            People

            • Assignee:
              Unassigned
              Reporter:
              Joao Inacio (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 1 day
                1d