[QUESTION] CHProxy caching (v1.19.0)

[Tarkerro]

We used articles to set up local caching
https://www.chproxy.org/configuration/caching
https://github.com/ContentSquare/chproxy/blob/master/config/README.md

It appears to be active now

However all requests from chproxy still ignore caching and go directly to the clickhouse.

Tried different configurations, the last one:

caches:
  - name: "portfolio_cache"
    mode: "file_system"
    file_system:
      dir: "/opt/chproxy/cache"
      max_size: 50Gb
      max_payload_size: 50Gb
    expire: 1h
    grace_time: 20s
    shared_with_all_users: true

What could be the problem? Maybe we need additional parameters in the requests, or maybe we
have a configuration problem?

[mga-chka]

I don't know where the problem is but in case it helps, there is a tutorial here that shows how to use chproxy with cache. Can you check it to see if you spot the issue?

[Blokje5]

Did you associate the cache with the user? That could be a potential source of issues.

[Tarkerro]

Thanks for answers. Yes, the user was associated with the cache by name

With this settings it works perfectly fine:

caches:
  - name: "portfolio_cache"
    mode: "file_system"
    file_system:
      dir: "/opt/chproxy_1.19/cache"
      max_size: 20Gb
      max_payload_size: 20Gb
    expire: 1h
    grace_time: 1m
    
    ...
    
  users:
     max_execution_time: 1m
     cache: "portfolio_cache"

It looks like shared_with_all_users has only been added since version 1.20.х
We also set the grace_time equal to the max_execution_time.

[Blokje5]

@Tarkerro it looks like your question has been resolved. Can we close this issue?

[Tarkerro]

@Blokje5 Yes, thank you.