apiVersion: apps/v1
kind: StatefulSet
metadata:
  labels:
    app: diagnosis-query
  name: diagnosis-query
  namespace: observability
spec:
  replicas: 1
  selector:
    matchLabels:
      app: diagnosis-query
  template:
    metadata:
      labels:
        app: diagnosis-query
    spec:
      containers:
      - args:
        - -vendor
        - alicloud
        - -region
        - ap-southeast-1
        - -duckDBSwitchAllEnabled=true
        - -duckDBSwitchTime
        - "1748736001"
        command:
        - /diagnosis-query
        env:
        - name: TOPSQL_OLD_CLUSTERS
          value: ""
        - name: POD_MEMORY_LIMITS_MB
          valueFrom:
            resourceFieldRef:
              containerName: diagnosis-query
              resource: limits.memory
              divisor: 1Mi
        - name: DUCKDB_MEMORY_PERCENTAGE
          value: "80"
        - name: AWS_ACCESS_KEY_ID
          valueFrom:
            secretKeyRef:
              name: o11y-regional-ram-credentials
              key: AWS_ACCESS_KEY_ID
        - name: AWS_SECRET_ACCESS_KEY
          valueFrom:
            secretKeyRef:
              name: o11y-regional-ram-credentials
              key: AWS_SECRET_ACCESS_KEY
        - name: AWS_REQUEST_CHECKSUM_CALCULATION
          value: "WHEN_REQUIRED"
        - name: AWS_RESPONSE_CHECKSUM_VALIDATION
          value: "WHEN_REQUIRED"
        image: o11-dev-staging-repo-registry.ap-southeast-1.cr.aliyuncs.com/dev/diagnosis-query:v111
        imagePullPolicy: Always
        name: diagnosis-query
        ports:
        - containerPort: 8081
          protocol: TCP
        resources:
          limits:
            cpu: "2"
            memory: 4Gi
          requests:
            cpu: "1"
            memory: 2Gi
        volumeMounts:
        - mountPath: /cache
          name: diagnosis-query-cache
      serviceAccount: regional-server-controller-manager
      serviceAccountName: regional-server-controller-manager
  volumeClaimTemplates:
  - apiVersion: v1
    kind: PersistentVolumeClaim
    metadata:
      labels:
        app: diagnosis-query
      name: diagnosis-query-cache
    spec:
      accessModes:
      - ReadWriteOnce
      resources:
        requests:
          storage: 20Gi
      storageClassName: vmcluster-storage
      volumeMode: Filesystem

---
apiVersion: v1
kind: Service
metadata:
  labels:
    app: diagnosis-query
  name: diagnosis-query
  namespace: observability
spec:
  selector:
    app: diagnosis-query
  ports:
    - protocol: TCP
      port: 8081
      targetPort: 8081

---
apiVersion: monitoring.coreos.com/v1
kind: ServiceMonitor
metadata:
  labels:
    release: self-monitoring
  name: diagnosis-query-monitor
  namespace: self-monitoring
spec:
  endpoints:
    - path: /metrics
      targetPort: 8081
  namespaceSelector:
    matchNames:
      - observability
  selector:
    matchLabels:
      app: diagnosis-query