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

ezcache.php --expiry parameter does not clear template-block cache in 'ezdfsfile' table

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: High High
    • Resolution: Invalid
    • Affects Version/s: 4.6.0
    • Fix Version/s: Customer request
    • Component/s: Caching, Database related
    • Labels:
      None
    • Environment:

      eZ Publish 4.6

      Description

      Steps to reproduce:

      1. Prepared test eZ Publish 4.6 installation, fully patched and in DFS cluster mode;
      2. Checked, on MySQL, on 'ezdfsfile' table, for entries of type 'template-block':

      mysql> SELECT name, scope, size, mtime, expired, status FROM ezdfsfile WHERE scope = 'template-block';
      +-----------------------------------------------------------------------------+----------------+-------+------------+---------+--------+
      | name                                                                        | scope          | size  | mtime      | expired | status |
      +-----------------------------------------------------------------------------+----------------+-------+------------+---------+--------+
      | var/ezflow_site/cache/template-block/2/8/5/2859411665.cache                 | template-block |  5496 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/9/5/2955925459.cache                 | template-block |  7217 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/3/9/1398572066.cache                 | template-block |  6583 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/4/3/1438254985.cache                 | template-block |  6328 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/3/0/2300869659.cache                 | template-block |  5487 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/2/9/2293492698.cache                 | template-block | 32592 | 1426779794 |       0 |      0 |
      | var/ezflow_site/cache/template-block/3/1/8/3183201049.cache                 | template-block |  6328 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/9/3/1930838277.cache                 | template-block |  2237 | 1426779798 |       0 |      0 |
      | var/ezflow_site/cache/template-block/3/4/5/3455341314.cache                 | template-block |  6234 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/4/9/249011351.cache                  | template-block | 11828 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/8/4/5/845575050.cache                  | template-block |  3399 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/5/8/8/588402353.cache                  | template-block |    68 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/7/2/172356483.cache                  | template-block |  9223 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/3/1/2/3125769188.cache                 | template-block |  3410 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/subtree/1/cache/2/4/4/2448327855.cache | template-block |  1064 | 1426780008 |       0 |      0 |	-> Thu, 19 Mar 2015 15:46:48 GMT
      +-----------------------------------------------------------------------------+----------------+-------+------------+---------+--------+
      15 rows in set (0.00 sec)
      

      3. Ran ezcache.php::

      $ php bin/php/ezcache.php --clear-all --expiry="20150319, 1600"
      Clearing All cache: 
      Content view cache, Global INI cache, INI cache, Codepage cache, Class identifier cache, Sort key cache, URL alias cache, Character transformation cache, Image alias, Template cache, Template block cache, Template override cache, Text to image cache, RSS cache, User info cache, Content tree menu (browser cache), State limitations cache, Design base cache, Active extensions cache, TS Translation cache, REST Application cache, REST Routes memory cache, eZJSCore Public Packer cache
      

      4. Checked results:

      mysql> SELECT name, scope, size, mtime, expired, status FROM ezdfsfile WHERE scope = 'template-block';
      +-----------------------------------------------------------------------------+----------------+-------+------------+---------+--------+
      | name                                                                        | scope          | size  | mtime      | expired | status |
      +-----------------------------------------------------------------------------+----------------+-------+------------+---------+--------+
      | var/ezflow_site/cache/template-block/2/8/5/2859411665.cache                 | template-block |  5496 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/9/5/2955925459.cache                 | template-block |  7217 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/3/9/1398572066.cache                 | template-block |  6583 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/4/3/1438254985.cache                 | template-block |  6328 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/3/0/2300869659.cache                 | template-block |  5487 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/2/9/2293492698.cache                 | template-block | 32592 | 1426779794 |       0 |      0 |
      | var/ezflow_site/cache/template-block/3/1/8/3183201049.cache                 | template-block |  6328 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/9/3/1930838277.cache                 | template-block |  2237 | 1426779798 |       0 |      0 |
      | var/ezflow_site/cache/template-block/3/4/5/3455341314.cache                 | template-block |  6234 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/2/4/9/249011351.cache                  | template-block | 11828 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/8/4/5/845575050.cache                  | template-block |  3399 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/5/8/8/588402353.cache                  | template-block |    68 | 1426780007 |       0 |      0 |
      | var/ezflow_site/cache/template-block/1/7/2/172356483.cache                  | template-block |  9223 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/3/1/2/3125769188.cache                 | template-block |  3410 | 1426779793 |       0 |      0 |
      | var/ezflow_site/cache/template-block/subtree/1/cache/2/4/4/2448327855.cache | template-block |  1064 | 1426780008 |       0 |      0 |
      +-----------------------------------------------------------------------------+----------------+-------+------------+---------+--------+
      15 rows in set (0.00 sec)
      

      No caches of type template-block were expired.

        Issue Links

          Activity

          Hide
          Gunnstein Lye added a comment -

          In my test I confirm that entires in the DB are not marked as expired in the DB, the expired columns stays at 0. But I do not see any actual bug here - the template blocks in my test are regenerated. I use this template code as a test:

          {cache-block keys=array( $module_result.uri )}TEST {currentdate()|l10n('time')}{/cache-block}
          

          The result is that the time is updated, so the cache block is regenerated.

          Show
          Gunnstein Lye added a comment - In my test I confirm that entires in the DB are not marked as expired in the DB, the expired columns stays at 0. But I do not see any actual bug here - the template blocks in my test are regenerated. I use this template code as a test: {cache-block keys=array( $module_result.uri )}TEST {currentdate()|l10n('time')}{/cache-block} The result is that the time is updated, so the cache block is regenerated.
          Hide
          Gunnstein Lye added a comment -

          Closing as invalid. Steps to reproduce do not describe a bug, and testing shows template blocks are expired and regenerated. See previous comment.

          Show
          Gunnstein Lye added a comment - Closing as invalid. Steps to reproduce do not describe a bug, and testing shows template blocks are expired and regenerated. See previous comment.

            People

            • Assignee:
              Unassigned
              Reporter:
              Nuno Oliveira (Inactive)
            • Votes:
              0 Vote for this issue
              Watchers:
              4 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 - 5 hours, 45 minutes
                5h 45m