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

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Confirmed Confirmed
          19m 27s 1 joao.inacio@ez.no 04/Sep/13 11:18 PM
          Confirmed Confirmed Closed Closed
          12d 19h 23m 1 André Rømcke 17/Sep/13 6:41 PM
          Reopened Reopened Confirmed Confirmed
          4s 1 joao.inacio@ez.no 17/Sep/13 7:10 PM
          Confirmed Confirmed InputQ InputQ
          21d 19h 1m 1 André Rømcke 09/Oct/13 2:11 PM
          Documentation Review done Documentation Review done Documentation Documentation
          1m 32s 1 damien.pobel@ez.no 06/Mar/14 5:29 PM
          Documentation Documentation InputQ InputQ
          4s 1 damien.pobel@ez.no 06/Mar/14 5:29 PM
          InputQ InputQ Development Development
          148d 4h 15m 2 damien.pobel@ez.no 06/Mar/14 5:29 PM
          Development Development Documentation Review done Documentation Review done
          41s 2 damien.pobel@ez.no 06/Mar/14 5:29 PM
          Documentation Review done Documentation Review done QA QA
          1d 9m 1 Joao Pingo (Inactive) 07/Mar/14 5:38 PM
          QA QA Closed Closed
          2d 23h 41m 1 Joao Pingo (Inactive) 10/Mar/14 5:20 PM
          Closed Closed Reopened Reopened
          32m 42s 2 Joao Pingo (Inactive) 10/Mar/14 5:25 PM
          Reopened Reopened Closed Closed
          1s 1 Joao Pingo (Inactive) 10/Mar/14 5:25 PM

            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