问题描述

在使用 Java 代码调用虚拟机（VM）API获取指标数据时，出现时间格式解析错误。

错误信息：

'{ "code": "BadRequest", "message": "Detected invalid time interval input: 2024-03-13T13:33:05.123 15:00/2024-03-13T13:48:05.233 15:00, supported Iso 8601 time interval format: (Datetime/Datetime, Datetime/Duration, Duration/Datetime, Duration)" }'

JAVA 代码：

static void query() 
 {
     MetricsQueryClient metricsQueryClient = new MetricsQueryClientBuilder()
        .endpoint("https://management.chinacloudapi.cn")
        .credential(new DefaultAzureCredentialBuilder().build())
        .buildClient();

    String resourceId = "<resource id>";
    Response<MetricsQueryResult> metricsResponse = metricsQueryClient
        .queryResourceWithResponse(resourceId, 
                                    Arrays.asList("CpuTime", "Requests"), new MetricsQueryOptions()
                                        .setGranularity(Duration.ofHours(1))
                                        .setTimeInterval(new QueryTimeInterval(OffsetDateTime.now().minusDays(1), OffsetDateTime.now()))
                                        .setAggregations(Arrays.asList(AggregationType.AVERAGE, AggregationType.COUNT)),
                                    Context.NONE);

    MetricsQueryResult metricsQueryResult = metricsResponse.getValue(); for (MetricResult metric : metricsQueryResult.getMetrics()) 
    {
        System.out.println("Metric name " + metric.getMetricName()); for (TimeSeriesElement timeSeriesElement : metric.getTimeSeries()) 
        {
            System.out.println("Dimensions " + timeSeriesElement.getMetadata()); for (MetricValue metricValue : timeSeriesElement.getValues()) 
            {
                System.out.println(metricValue.getTimeStamp() + " " + metricValue.getTotal());
            }
        }
    }
}

这个会是什么原因导致的呢？

问题解答

添加日志，对比代码生成的时间格式字符串后，发现问题根源于本地执行环境的时区设置相关！

因为 Java SDK中timespan参数仅支持UTC的ZoneOffset。如果本地环境设置为非UTC的时区，例如：export TZ="/usr/share/zoneinfo/Hongkong" 就可以复现此问题。

鉴于此种情况，如果不修改本地电脑环境的情况下，可以在代码中进行指定时间为UTC时区。

添加代码：ZoneOffset zoneOffsetUTC = ZoneOffset.ofHours(0);， 然后在设置 setTimeInterval 中指定时区  OffsetDateTime.now().withOffsetSameInstant(zoneOffsetUTC)。这样就可以解决时间格式因时区不同而产生的问题！

修改后的代码为：

 static void query() 
 {
     MetricsQueryClient metricsQueryClient = new MetricsQueryClientBuilder()
        .endpoint("https://management.chinacloudapi.cn")
        .credential(new DefaultAzureCredentialBuilder().build())
        .buildClient();

    String resourceId = "<resource id>";

 ZoneOffset zoneOffsetUTC = ZoneOffset.ofHours(0);

    Response<MetricsQueryResult> metricsResponse = metricsQueryClient
        .queryResourceWithResponse(resourceId, 
                                    Arrays.asList("CpuTime", "Requests"), new MetricsQueryOptions()
                                        .setGranularity(Duration.ofHours(1))
                                        .setTimeInterval(new QueryTimeInterval(OffsetDateTime.now().minusDays(1).withOffsetSameInstant(zoneOffsetUTC), OffsetDateTime.now().withOffsetSameInstant(zoneOffsetUTC)))
                                        .setAggregations(Arrays.asList(AggregationType.AVERAGE, AggregationType.COUNT)),
                                    Context.NONE);

    MetricsQueryResult metricsQueryResult = metricsResponse.getValue(); for (MetricResult metric : metricsQueryResult.getMetrics()) 
    {
        System.out.println("Metric name " + metric.getMetricName()); for (TimeSeriesElement timeSeriesElement : metric.getTimeSeries()) 
        {
            System.out.println("Dimensions " + timeSeriesElement.getMetadata()); for (MetricValue metricValue : timeSeriesElement.getValues()) 
            {
                System.out.println(metricValue.getTimeStamp() + " " + metricValue.getTotal());
            }
        }
    }
}

参考资料

Azure Resource Metrics - List ：https://learn.microsoft.com/en-us/rest/api/monitor/metrics/list?view=rest-monitor-2023-10-01&tabs=HTTP

timespan :The timespan of the query. It is a string with the following format 'startDateTime_ISO/endDateTime_ISO'.

当在复杂的环境中面临问题，格物之道需：浊而静之徐清，安以动之徐生。 云中，恰是如此!