Cubestore not receving

Hi,

We have setup cubejs in production mode with cubestore & redis all running as sperate containers in openshift. We have observed logs for cube js and it comes up with below message

"message":"Slow Query Warning"  
"warning":"Query is too slow to be renewed during the user request and was served from the cache. Please consider using low latency pre-aggregations."

and the logs for cubestore indicates,
INFO [cubestore::metastore] <pid:1> Persisting meta store snapshot: nothing to update
Redis is being utilized and verified in the logs.

We are using the following config-map

 CUBEJS_DB_PORT: '10001'
  CUBEJS_DB_HOST:  MSSQLDATABASE
  CUBEJS_REDIS_URL: //redis
  CUBEJS_DB_NAME: MSSQLDATABASE_NAME
  CUBEJS_DB_USER: MSSQLDATABASE_USER
  CUBEJS_DB_SSL: 'true'
  CUBEJS_JWK_URL: JWK_URL
  CUBEJS_DEV_MODE: 'false'
  CUBEJS_WEB_SOCKETS: 'true'
  CUBEJS_DB_TYPE: mssql
  CUBEJS_CUBESTORE_HOST: cubestore

And it seems pre-aggregation is not happening. Would appreciate your quick response on this.

Hi @MaximumQuasar :wave:

Could you please share the full docker-compose config and your data schema?

Hi antonrychkov,

We are hosting all the (cubejs, cubestore & redis)services in openshift.
The following are the details for resources used in openshift.

deployment-config.yaml – cubestore

<------------------------ Snipped --------------------------------------------->
    spec:
      containers:
        - image: image-registry.openshift-image-registry.svc:5000/namespace/cubejs-backend-service:latest
          imagePullPolicy: Always
          name: cubejs-backend-service
          env:
            - name: APPLICATION_CONFIG_CM_REF
              valueFrom:
                fieldRef:
                  fieldPath: metadata.annotations['appConfigConfigMapRef']
            - name: APPLICATION_CONFIG_SRT_REF
              valueFrom:
                fieldRef:
                  fieldPath: metadata.annotations['appConfigSecretRef']
          envFrom:
            - configMapRef:
                name: cubejs-backend-service-application-configs-cm
            - secretRef:
                name: cubejs-backend-service-application-configs-srt
          ports:
            - containerPort: 4000
              name: http
              protocol: TCP
<------------------------ Snipped --------------------------------------------->

Config-map & secret resource for cubejs

<------------------------ Snipped --------------------------------------------->
metadata:
  name: cubejs-backend-service-application-configs-cm
data:
  CUBEJS_DB_HOST: #MSSQLDATABASE		
  CUBEJS_DB_NAME: #MSSQLDATABASE_NAME	
  CUBEJS_DB_USER: #MSSQLDATABASE_USER	
  CUBEJS_WEB_SOCKETS: "true"
  CUBEJS_DEV_MODE: "false"
  CUBEJS_DB_TYPE: mssql
  CUBEJS_DB_PORT: "10001"
  CUBEJS_DB_SSL: "true"
  CUBEJS_JWK_URL: #JWT_RUL
  CUBEJS_CUBESTORE_HOST: cubestore
  CUBEJS_REDIS_URL: //redis

metadata:
  name: cubejs-backend-service-application-configs-srt
data:
  CUBEJS_DB_PASS: #PASSWORD
  CUBEJS_API_SECRET: #SECRET
<------------------------ Snipped --------------------------------------------->

Cubejs service & route

---service
metadata:
  annotations:
    description: The web server's http port.
  name: cubejs-backend-service
spec:
  ports:
    - name: 4000-tcp
      port: 4000
      protocol: TCP
      targetPort: 4000
  selector:
    deploymentConfig: cubejs-backend-service

---route
metadata:
  name: cubejs-backend-service
spec:
  host: cubejs-backend-service.ocp #host_address
  port:
    targetPort: 4000-tcp
  tls:
    insecureEdgeTerminationPolicy: Redirect
    termination: edge
  to:
    kind: Service
    name: cubejs-backend-service

Cubestore service.yaml

metadata:
  name: cubestore
spec:
  clusterIP: "None"
  ports:
    - name: 3030-tcp
      port: 3030
      protocol: TCP
      targetPort: 3030
  selector:
    app: cubejs-cubestore

The database is mssql on-premises resource.
As for schema i do not access to get that. If you could identify the issue from provided details.
Let me know if you still need the data schema.