Clearing Cache

Squiz Matrix Installation
1

Hi Folks


Was going to make the jump to the 3.22.x branch and following the upgrade guide it tells me to clear the system cache. When I went to do this squid freaks out as 'Zero Bytes' are returned. Looking at the cache dir it still has files/folders.



Is there an alternative method to clear the cache from the shell?



K

2

You can remove the files and also truncate the sq_cache table at the same time. To do this consistently, I recommend something like this:

    cd /path/to/system_root
    mv cache cache.old && mkdir cache && chown apache cache
    psql -U matrix -d matrix_db -c 'TRUNCATE sq_cache;'
    rm -rf cache.old


The above code will move the cache directory out the way, create a new one and truncate the cache table in the database in quick succession. It then removes the old cache directory (this can often take some time if the cache is large).

Btw the reason your clear cache HIPO is probably returning a Squid error, is that Matrix is preparing to run the job but hitting Squid's timeouts for returning data. This sometimes happens if the Matrix cache is really large.

Hope this helps.
3

[quote]You can remove the files and also truncate the sq_cache table at the same time. To do this consistently, I recommend something like this:

    cd /path/to/system_root
    mv cache cache.old && mkdir cache && chown apache cache
    psql -U matrix -d matrix_db -c 'TRUNCATE sq_cache;'
    rm -rf cache.old


The above code will move the cache directory out the way, create a new one and truncate the cache table in the database in quick succession. It then removes the old cache directory (this can often take some time if the cache is large).

Btw the reason your clear cache HIPO is probably returning a Squid error, is that Matrix is preparing to run the job but hitting Squid's timeouts for returning data. This sometimes happens if the Matrix cache is really large.

Hope this helps.[/quote]

perfect - thanks.

K