下载链接：
gateway：
https://offline-build.oss-cn-hangzhou.aliyuncs.com/tmp/nova/0.0.18/can-gateway-202606092009.tar.gz?OSSAccessKeyId=LTAI5tAgXDXHmeJ919pZtJCM&Expires=1817257984&Signature=gxRLP5WqQrhjQD9UGWEgtCvmqTo%3D

Nova：
https://offline-build.oss-cn-hangzhou.aliyuncs.com/tmp/nova/0.0.18/nova-0.3.0.tar.gz?OSSAccessKeyId=LTAI5tAgXDXHmeJ919pZtJCM&Expires=1817258018&Signature=ZtJuv5s%2FZMMb%2FH%2F2pxrbLcVH01M%3D

jdk：
https://offline-build.oss-cn-hangzhou.aliyuncs.com/tmp/nova/tools/jdk-21.0.2-x86.tar.gz?OSSAccessKeyId=LTAI5tAgXDXHmeJ919pZtJCM&Expires=1817258036&Signature=qS25mQhXi4dln5BzEgmdEGcGH1g%3D

Docker安装包：
https://offline-build.oss-cn-hangzhou.aliyuncs.com/tmp/nova/tools/docker-py.tar.gz?OSSAccessKeyId=LTAI5tAgXDXHmeJ919pZtJCM&Expires=2141258314&Signature=K4EgM55ROJhtKzCNfctKnMiJqKc%3D

Python环境镜像包：
https://offline-build.oss-cn-hangzhou.aliyuncs.com/tmp/nova/images/nova-sandbox-latest.tar.gz?OSSAccessKeyId=LTAI5tAgXDXHmeJ919pZtJCM&Expires=1817258060&Signature=vZkg4bdDVuG3YlTlEl4b9f5bJ9g%3D

https://offline-build.oss-cn-hangzhou.aliyuncs.com/package/grab-can-poc/2.3.25/offline_deployment_2.3.25.tar.gz?Expires=1781608452&OSSAccessKeyId=LTAI5tLTaggXp2FPUwpEPZyh&Signature=7cE%2BAd%2FX795CkXoY%2FSXcBltzM5E%3D



SELECT
      1                                                    AS value,
      CAST(ti.id AS VARCHAR)                               AS label,
      ti.task_id                                           AS task_id,
      ti.name                                              AS task_name,
      ti.tenant_id                                         AS tenant_id,
      ti.error_type                                        AS error_type,
      ti.status                                            AS status,
      FORMATDATETIME(ti.gmt_finish, 'yyyy-MM-dd HH:mm:ss') AS finish_time
  FROM task_instance ti
  WHERE ti.status IN ('FAILED', 'TIMEOUT', 'HALF_SUCCESS')
    AND ti.gmt_finish >= DATEADD('MINUTE', -30, CURRENT_TIMESTAMP)


SELECT
      COUNT(*) AS "value",
      'recent_build_exception_batch' AS alert_key,
      COALESCE(
          LISTAGG(
              '[' || FORMATDATETIME(gmt_update, 'yyyy-MM-dd HH:mm:ss') || '] '
              || 'tenant=' || COALESCE(tenant_id, '-') || ', '
              || 'task_id=' || COALESCE(task_id, '-') || ', '
              || 'instance_id=' || CAST(id AS VARCHAR) || ', '
              || 'name=' || COALESCE(NULLIF(name, ''), NULLIF(temp_mt_name, ''), '-') || ', '
              || 'status=' || COALESCE(status, '-') || ', '
              || 'error_type=' || COALESCE(error_type, '-') || ', '
              || 'engine=' || COALESCE(engine_type, '-') || ', '
              || 'owner=' || COALESCE(create_operator, '-'),
              CHAR(10)
          ) WITHIN GROUP (ORDER BY gmt_update DESC, id DESC),
          '最近5分钟无构建异常'
      ) AS exception_list
  FROM task_instance
  WHERE status IN ('FAILED', 'TIMEOUT', 'HALF_SUCCESS')
    AND gmt_update >= DATEADD('MINUTE', -5, CURRENT_TIMESTAMP)
    AND gmt_update < CURRENT_TIMESTAMP

http://122.224.131.43:8081/tmp/can-admin-dashboard-1.0-SNAPSHOT.jar?token=A194J921eTNO4P7x6Ov687M08

  SELECT
      1                                                    AS value,
      CAST(ti.id AS VARCHAR)                               AS task_id,
      ti.name                                              AS 物化方案名称,
      ti.tenant_id                                         AS tenant_id,
      o.owner_name                                         AS 负责人,
      FORMATDATETIME(ti.gmt_finish, 'yyyy-MM-dd HH:mm:ss') AS finish_time
  FROM task_instance ti
  LEFT JOIN task_owner o ON o.task_id = ti.task_id
  WHERE ti.status IN ('FAILED', 'TIMEOUT', 'HALF_SUCCESS')
    AND ti.gmt_finish >= DATEADD('MINUTE', -30, CURRENT_TIMESTAMP)