Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-1760

Don't attempt to change "CachedUrls" table for units, that are not used in Mod-Rewrite URLs

    XMLWordPrintable

    Details

    • Type: Bug Report
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.2.2-B3
    • Component/s: Url Processing
    • Labels:
      None
    • Change Log Group:
      Fixed
    • Change Log Message:
      Fixes inability to access website's Front-End, when data is changed in parallel in the Admin Console.
    • Story Points:
      1
    • Copy Issue Key:
    • Patch Instructions:

      Patches must be submitted through Phabricator.

      Description

      1. add "adm:OnPopulateUrlUnitCacheScheduledTask" event, that would: - 0.5h
        • be a scheduled task, that runs once per hour
        • get values from "Prefixes" column of "CachedUrls" table of each database table record:
          • parse it's value (see "\kRewriteUrlProcessor::_setCachedUrl") to get unit config prefixes (ids doesn't matter)
          • collect list of unique unit config prefixes
        • store collected prefixes (even if it's an empty array) in "cached_urls_unit_prefixes" memcache key with 1 hour expiration
      1. in the "\kCacheManager::incrementCacheSerial" method: - 0.5h
        • get value of "cached_urls_unit_prefixes" memcache key
        • if it's empty (either key is missing or an empty array is received), then consider it as array of commonly used unit config prefixes (e.g. "c", "lang", "theme", etc.)
        • if value of "$prefix" method parameter isn't within above retrieved/build array, then don't delete record from "CachedUrls" table

      Quote: 1h*1.4 = 1.5h

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
                Developer:
                Erik Snarski [Intechnic]
                Reviewer:
                Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1.5h Original Estimate - 1.5h
                  1.5h
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 2h 10m
                  2h 10m