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

    XMLWordPrintable

Details

    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.

      Attachments

        Activity

          People

            Unassigned Unassigned
            nuno.oliveira-obsolete@ez.no 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