azure-cosmos-db-emulator-docker
azure-cosmos-db-emulator-docker copied to clipboard
Published
20 hours ago •
Azure
Azure
GROUP BY does not work in vnext
Because I was asked to open a new issue if this is still needed, here it is:
Unfortunately no.
Microsoft.Azure.Cosmos.CosmosException Response status code does not indicate success: InternalServerError (500); Substatus: 0; ActivityId: ff69192e-2a67-4fdb-a986-483d29586a7f; Reason: ({"code":"InternalServerError","message":"syntax error at or near \u0022AND\u0022 Cosmos query text: SELECT COUNT(1) AS Count, e.__indices.localDate FROM e WHERE e.__indices.localDate \u003E= @fromDate AND e.__indices.localDate \u003C= @toDate GROUP BY e.__indices.localDate -\u003E SELECT cosmos_build_jsonb_object(\u0027Count\u0027,cosmos_count(1),\u0027localDate\u0027,property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027)) FROM %s AS e WHERE cosmos_variant_as_bool(cosmos_and(cosmos_gte_v1(property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027),$1),cosmos_lte_v1(property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027),$2)))GROUP BY property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027)"} RequestUri: http://localhost:8081/dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394/docs; RequestMethod: POST; Header: Authorization Length: 86; Header: x-ms-date Length: 29; Header: x-ms-max-item-count Length: 4; Header: x-ms-documentdb-partitionkey Length: 12; Header: x-ms-documentdb-populatequerymetrics Length: 4; Header: x-ms-cosmos-sdk-supportedcapabilities Length: 1; Header: x-ms-cosmos-correlated-activityid Length: 36; Header: x-ms-cosmos-supported-serialization-formats Length: 21; Header: x-ms-cosmos-query-optimisticdirectexecute Length: 5; Header: x-ms-documentdb-query-iscontinuationexpected Length: 5; Header: x-ms-documentdb-isquery Length: 4; Header: x-ms-activity-id Length: 36; Header: Cache-Control Length: 8; Header: User-Agent Length: 93; Header: x-ms-version Length: 10; Header: Accept Length: 16; ActivityId: ff69192e-2a67-4fdb-a986-483d29586a7f, Request URI: /dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394/docs, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Darwin/10.20 cosmos-netstandard-sdk/3.37.9);; Diagnostics:{"Summary":{"GatewayCalls":{"(200, 0)":3,"(304, 0)":1,"(500, 0)":1}},"name":"Typed FeedIterator ReadNextAsync","start datetime":"2025-03-05T15:04:54.525Z","duration in milliseconds":158.8315,"data":{"Client Configuration":{"Client Created Time Utc":"2025-03-05T15:04:54.2282560Z","MachineId":"hashedMachineName:ba34ff62-f18d-0222-db38-a4917d2f38c4","NumberOfClientsCreated":1,"NumberOfActiveClients":1,"ConnectionMode":"Gateway","User Agent":"cosmos-netstandard-sdk/3.47.0|1|Arm64|Darwin 24.3.0 Darwin Kernel Ve|.NET 9.0.2|N|F 00000010|","ConnectionConfig":{"gw":"(cps:50, urto:6, p:False, httpf: True)","rntbd":"(cto: 5, icto: -1, mrpc: 30, mcpe: 65535, erd: True, pr: ReuseUnicastPort)","other":"(ed:False, be:False)"},"ConsistencyConfig":"(consistency: NotSet, prgns:[], apprgn: )","ProcessorCount":10},"Synchronization Context":"Xunit.Sdk.AsyncTestSyncContext","Query Correlated ActivityId":"2ec8a75e-c103-4e3a-a226-c0542b426813"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":118.6297,"children":[{"name":"Get Container Properties","duration in milliseconds":9.0234,"children":[{"name":"Get Collection Cache","duration in milliseconds":0.003},{"name":"Read Collection","duration in milliseconds":2.7123,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:04:54.5357610Z","DurationInMs":1.688,"RequestUri":"http://localhost:8081/dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"f10e4b8e-eccf-4f36-a2b2-a6ddd1f8168d","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":48.8077},{"name":"Gateway QueryPlan","duration in milliseconds":4.9738},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":2.7995,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":1.4836,"data":{"System Info":{"systemHistory":[{"dateUtc":"2025-03-05T15:04:54.2383470Z","cpu":"no info","memory":"no info","threadInfo":{"isThreadStarving":"no info","availableThreads":32763,"minThreads":10,"maxThreads":32767},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":1.4799,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":1.478,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":1.4716,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":1.4704,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":1.4156,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:04:54.6116680Z","DurationInMs":1.287,"RequestUri":"http://localhost:8081/dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"ff69192e-2a67-4fdb-a986-483d29586a7f","StatusCode":"OK"}]},"PointOperationStatisticsTraceDatum":{"Id":"PointOperationStatistics","ActivityId":"ff69192e-2a67-4fdb-a986-483d29586a7f","ResponseTimeUtc":"2025-03-05T15:04:54.6129870Z","StatusCode":200,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394","ErrorMessage":null,"RequestSessionToken":null,"ResponseSessionToken":"0:-1#1","BELatencyInMs":null}}}]}]}]}]}]}]},{"name":"Get Partition Key Ranges","duration in milliseconds":19.2653,"children":[{"name":"Try Get Overlapping Ranges","duration in milliseconds":16.6449,"data":{"PKRangeCache Info(#2025-03-05T15:04:54.6406120Z)":{"Previous Continuation Token":null,"Continuation Token":null}},"children":[{"name":"Read PartitionKeyRange Change Feed","duration in milliseconds":3.1767,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:04:54.6305120Z","DurationInMs":1.27,"RequestUri":"http://localhost:8081/dbs/MDAwNA==/colls/MDAwNA==/pkranges","ResourceType":"PartitionKeyRange","HttpMethod":"GET","ActivityId":"937a8289-bde4-49a5-a10d-0607f262b703","StatusCode":"OK"}]}}},{"name":"Read PartitionKeyRange Change Feed","duration in milliseconds":0.9952,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:04:54.6369750Z","DurationInMs":0.881,"RequestUri":"http://localhost:8081/dbs/MDAwNA==/colls/MDAwNA==/pkranges","ResourceType":"PartitionKeyRange","HttpMethod":"GET","ActivityId":"69899ec2-7fa0-44a2-9c46-d1684a9b858d","StatusCode":"NotModified","ReasonPhrase":"Not Modified"}]}}}]}]}]},{"name":"MoveNextAsync","duration in milliseconds":30.3642,"children":[{"name":"[,FF) move next","duration in milliseconds":25.8026,"children":[{"name":"Prefetch","duration in milliseconds":24.7166,"children":[{"name":"[,FF) move next","duration in milliseconds":24.5441,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":22.1395,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":18.2486,"data":{"System Info":{"systemHistory":[{"dateUtc":"2025-03-05T15:04:54.2383470Z","cpu":"no info","memory":"no info","threadInfo":{"isThreadStarving":"no info","availableThreads":32763,"minThreads":10,"maxThreads":32767},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":18.2385,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":18.2357,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":16.3666,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":16.3644,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":10.6341,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:04:54.6604900Z","DurationInMs":4.076,"RequestUri":"http://localhost:8081/dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"ff69192e-2a67-4fdb-a986-483d29586a7f","StatusCode":"InternalServerError","ReasonPhrase":"Internal Server Error"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"ff69192e-2a67-4fdb-a986-483d29586a7f","ResponseTimeUtc":"2025-03-05T15:04:54.6757150Z","StatusCode":500,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394","ErrorMessage":"Microsoft.Azure.Documents.DocumentClientException: {\"code\":\"InternalServerError\",\"message\":\"syntax error at or near \\u0022AND\\u0022 Cosmos query text: SELECT COUNT(1) AS Count, e.__indices.localDate FROM e WHERE e.__indices.localDate \\u003E= @fromDate AND e.__indices.localDate \\u003C= @toDate GROUP BY e.__indices.localDate -\\u003E SELECT cosmos_build_jsonb_object(\\u0027Count\\u0027,cosmos_count(1),\\u0027localDate\\u0027,property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027)) FROM %s AS e WHERE cosmos_variant_as_bool(cosmos_and(cosmos_gte_v1(property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027),$1),cosmos_lte_v1(property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027),$2)))GROUP BY property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027)\"}\nRequestUri: http://localhost:8081/dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394/docs;\nRequestMethod: POST;\nHeader: Authorization Length: 86;\nHeader: x-ms-date Length: 29;\nHeader: x-ms-max-item-count Length: 4;\nHeader: x-ms-documentdb-partitionkey Length: 12;\nHeader: x-ms-documentdb-populatequerymetrics Length: 4;\nHeader: x-ms-cosmos-sdk-supportedcapabilities Length: 1;\nHeader: x-ms-cosmos-correlated-activityid Length: 36;\nHeader: x-ms-cosmos-supported-serialization-formats Length: 21;\nHeader: x-ms-cosmos-query-optimisticdirectexecute Length: 5;\nHeader: x-ms-documentdb-query-iscontinuationexpected Length: 5;\nHeader: x-ms-documentdb-isquery Length: 4;\nHeader: x-ms-activity-id Length: 36;\nHeader: Cache-Control Length: 8;\nHeader: User-Agent Length: 93;\nHeader: x-ms-version Length: 10;\nHeader: Accept Length: 16;\n\nActivityId: ff69192e-2a67-4fdb-a986-483d29586a7f, Request URI: /dbs/TestDatabase-b993c384-a48f-466e-92d4-be5c298b335e/colls/TestContainer-8ee11fa4-de0f-4a49-b56f-a9a1ed07d394/docs, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Darwin/10.20 cosmos-netstandard-sdk/3.37.9\n at Microsoft.Azure.Cosmos.GatewayStoreClient.ParseResponseAsync(HttpResponseMessage responseMessage, JsonSerializerSettings serializerSettings, DocumentServiceRequest request)\n at Microsoft.Azure.Cosmos.GatewayStoreClient.InvokeAsync(DocumentServiceRequest request, ResourceType resourceType, Uri physicalAddress, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.Handlers.TransportHandler.ProcessMessageAsync(RequestMessage request, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.Handlers.TransportHandler.SendAsync(RequestMessage request, CancellationToken cancellationToken)","RequestSessionToken":null,"ResponseSessionToken":"0:-1#1","BELatencyInMs":null}}}]}]}]}]}]}]},{"name":"Get Cosmos Element Response","duration in milliseconds":0.5479}]}]}]}]},{"name":"Query Response Serialization","duration in milliseconds":0.276}]} at Microsoft.Azure.Cosmos.GatewayStoreClient.ParseResponseAsync(HttpResponseMessage responseMessage, JsonSerializerSettings serializerSettings, DocumentServiceRequest request) at Microsoft.Azure.Cosmos.GatewayStoreClient.InvokeAsync(DocumentServiceRequest request, ResourceType resourceType, Uri physicalAddress, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.Handlers.TransportHandler.ProcessMessageAsync(RequestMessage request, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.Handlers.TransportHandler.SendAsync(RequestMessage request, CancellationToken cancellationToken)And I also tried to remove the AND from my query completely (just for testing) and the error still persists:'
var query = new QueryDefinition( "SELECT COUNT(1) AS Count, e.__indices.localDate FROM e " + "WHERE e.__indices.localDate >= @fromDate " + "GROUP BY e.__indices.localDate") .WithParameter("@fromDate", from.ToString("yyyy-MM-dd")) .WithParameter("@toDate", to.ToString("yyyy-MM-dd")) ;Microsoft.Azure.Cosmos.CosmosException Response status code does not indicate success: InternalServerError (500); Substatus: 0; ActivityId: ff6e5c74-4ad2-4169-b652-0e71fe5e674e; Reason: ({"code":"InternalServerError","message":"syntax error at or near \u0022AND\u0022 Cosmos query text: SELECT COUNT(1) AS Count, e.__indices.localDate FROM e WHERE e.__indices.localDate \u003E= @fromDate GROUP BY e.__indices.localDate -\u003E SELECT cosmos_build_jsonb_object(\u0027Count\u0027,cosmos_count(1),\u0027localDate\u0027,property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027)) FROM %s AS e WHERE cosmos_variant_as_bool(cosmos_gte_v1(property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027),$1))GROUP BY property_ref_as_cosmos_variant(e.document, \u0027__indices/localDate\u0027)"} RequestUri: http://localhost:8081/dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001/docs; RequestMethod: POST; Header: Authorization Length: 80; Header: x-ms-date Length: 29; Header: x-ms-max-item-count Length: 4; Header: x-ms-documentdb-partitionkey Length: 12; Header: x-ms-documentdb-populatequerymetrics Length: 4; Header: x-ms-cosmos-sdk-supportedcapabilities Length: 1; Header: x-ms-cosmos-correlated-activityid Length: 36; Header: x-ms-cosmos-supported-serialization-formats Length: 21; Header: x-ms-cosmos-query-optimisticdirectexecute Length: 5; Header: x-ms-documentdb-query-iscontinuationexpected Length: 5; Header: x-ms-documentdb-isquery Length: 4; Header: x-ms-activity-id Length: 36; Header: Cache-Control Length: 8; Header: User-Agent Length: 93; Header: x-ms-version Length: 10; Header: Accept Length: 16; ActivityId: ff6e5c74-4ad2-4169-b652-0e71fe5e674e, Request URI: /dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001/docs, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Darwin/10.20 cosmos-netstandard-sdk/3.37.9);; Diagnostics:{"Summary":{"GatewayCalls":{"(200, 0)":3,"(304, 0)":1,"(500, 0)":1}},"name":"Typed FeedIterator ReadNextAsync","start datetime":"2025-03-05T15:06:14.689Z","duration in milliseconds":159.033,"data":{"Client Configuration":{"Client Created Time Utc":"2025-03-05T15:06:14.4083180Z","MachineId":"hashedMachineName:ba34ff62-f18d-0222-db38-a4917d2f38c4","NumberOfClientsCreated":1,"NumberOfActiveClients":1,"ConnectionMode":"Gateway","User Agent":"cosmos-netstandard-sdk/3.47.0|1|Arm64|Darwin 24.3.0 Darwin Kernel Ve|.NET 9.0.2|N|F 00000010|","ConnectionConfig":{"gw":"(cps:50, urto:6, p:False, httpf: True)","rntbd":"(cto: 5, icto: -1, mrpc: 30, mcpe: 65535, erd: True, pr: ReuseUnicastPort)","other":"(ed:False, be:False)"},"ConsistencyConfig":"(consistency: NotSet, prgns:[], apprgn: )","ProcessorCount":10},"Synchronization Context":"Xunit.Sdk.AsyncTestSyncContext","Query Correlated ActivityId":"1b0368fe-4d49-4a4d-a982-980e70693e66"},"children":[{"name":"Create Query Pipeline","duration in milliseconds":119.455,"children":[{"name":"Get Container Properties","duration in milliseconds":9.3725,"children":[{"name":"Get Collection Cache","duration in milliseconds":0.0024},{"name":"Read Collection","duration in milliseconds":2.96,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:06:14.7002970Z","DurationInMs":1.942,"RequestUri":"http://localhost:8081/dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001","ResourceType":"Collection","HttpMethod":"GET","ActivityId":"fd73a592-612b-411e-b174-24993777341f","StatusCode":"OK"}]}}}]},{"name":"Parse Query","duration in milliseconds":49.0165},{"name":"Gateway QueryPlan","duration in milliseconds":4.5938},{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":2.3495,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":1.1967,"data":{"System Info":{"systemHistory":[{"dateUtc":"2025-03-05T15:06:14.4146810Z","cpu":"no info","memory":"no info","threadInfo":{"isThreadStarving":"no info","availableThreads":32763,"minThreads":10,"maxThreads":32767},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":1.1925,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":1.1905,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":1.1839,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":1.1823,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":1.1253,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:06:14.7766850Z","DurationInMs":1.001,"RequestUri":"http://localhost:8081/dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"ff6e5c74-4ad2-4169-b652-0e71fe5e674e","StatusCode":"OK"}]},"PointOperationStatisticsTraceDatum":{"Id":"PointOperationStatistics","ActivityId":"ff6e5c74-4ad2-4169-b652-0e71fe5e674e","ResponseTimeUtc":"2025-03-05T15:06:14.7777160Z","StatusCode":200,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001","ErrorMessage":null,"RequestSessionToken":null,"ResponseSessionToken":"0:-1#1","BELatencyInMs":null}}}]}]}]}]}]}]},{"name":"Get Partition Key Ranges","duration in milliseconds":19.7102,"children":[{"name":"Try Get Overlapping Ranges","duration in milliseconds":17.1023,"data":{"PKRangeCache Info(#2025-03-05T15:06:14.8063470Z)":{"Previous Continuation Token":null,"Continuation Token":null}},"children":[{"name":"Read PartitionKeyRange Change Feed","duration in milliseconds":3.2028,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:06:14.7957010Z","DurationInMs":1.241,"RequestUri":"http://localhost:8081/dbs/MDAwNQ==/colls/MDAwNQ==/pkranges","ResourceType":"PartitionKeyRange","HttpMethod":"GET","ActivityId":"3f0bd18b-5d9e-4f74-b923-82a1a0f83fdb","StatusCode":"OK"}]}}},{"name":"Read PartitionKeyRange Change Feed","duration in milliseconds":1.251,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:06:14.8023670Z","DurationInMs":1.108,"RequestUri":"http://localhost:8081/dbs/MDAwNQ==/colls/MDAwNQ==/pkranges","ResourceType":"PartitionKeyRange","HttpMethod":"GET","ActivityId":"9041ef3e-541f-4bed-9d96-de8178922764","StatusCode":"NotModified","ReasonPhrase":"Not Modified"}]}}}]}]}]},{"name":"MoveNextAsync","duration in milliseconds":29.9534,"children":[{"name":"[,FF) move next","duration in milliseconds":25.353,"children":[{"name":"Prefetch","duration in milliseconds":24.2807,"children":[{"name":"[,FF) move next","duration in milliseconds":24.1049,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RequestInvokerHandler","duration in milliseconds":21.8045,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.DiagnosticsHandler","duration in milliseconds":17.8945,"data":{"System Info":{"systemHistory":[{"dateUtc":"2025-03-05T15:06:14.4146810Z","cpu":"no info","memory":"no info","threadInfo":{"isThreadStarving":"no info","availableThreads":32763,"minThreads":10,"maxThreads":32767},"numberOfOpenTcpConnection":0}]}},"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TelemetryHandler","duration in milliseconds":17.8826,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RetryHandler","duration in milliseconds":17.8792,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.RouterHandler","duration in milliseconds":15.9355,"children":[{"name":"Microsoft.Azure.Cosmos.Handlers.TransportHandler","duration in milliseconds":15.9331,"children":[{"name":"Microsoft.Azure.Cosmos.GatewayStoreModel Transport Request","duration in milliseconds":9.96,"data":{"Client Side Request Stats":{"Id":"AggregatedClientSideRequestStatistics","ContactedReplicas":[],"RegionsContacted":[],"FailedReplicas":[],"AddressResolutionStatistics":[],"StoreResponseStatistics":[],"HttpResponseStats":[{"StartTimeUTC":"2025-03-05T15:06:14.8258970Z","DurationInMs":3.101,"RequestUri":"http://localhost:8081/dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001/docs","ResourceType":"Document","HttpMethod":"POST","ActivityId":"ff6e5c74-4ad2-4169-b652-0e71fe5e674e","StatusCode":"InternalServerError","ReasonPhrase":"Internal Server Error"}]},"Point Operation Statistics":{"Id":"PointOperationStatistics","ActivityId":"ff6e5c74-4ad2-4169-b652-0e71fe5e674e","ResponseTimeUtc":"2025-03-05T15:06:14.8406510Z","StatusCode":500,"SubStatusCode":0,"RequestCharge":0,"RequestUri":"dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001","ErrorMessage":"Microsoft.Azure.Documents.DocumentClientException: {\"code\":\"InternalServerError\",\"message\":\"syntax error at or near \\u0022AND\\u0022 Cosmos query text: SELECT COUNT(1) AS Count, e.__indices.localDate FROM e WHERE e.__indices.localDate \\u003E= @fromDate GROUP BY e.__indices.localDate -\\u003E SELECT cosmos_build_jsonb_object(\\u0027Count\\u0027,cosmos_count(1),\\u0027localDate\\u0027,property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027)) FROM %s AS e WHERE cosmos_variant_as_bool(cosmos_gte_v1(property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027),$1))GROUP BY property_ref_as_cosmos_variant(e.document, \\u0027__indices/localDate\\u0027)\"}\nRequestUri: http://localhost:8081/dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001/docs;\nRequestMethod: POST;\nHeader: Authorization Length: 80;\nHeader: x-ms-date Length: 29;\nHeader: x-ms-max-item-count Length: 4;\nHeader: x-ms-documentdb-partitionkey Length: 12;\nHeader: x-ms-documentdb-populatequerymetrics Length: 4;\nHeader: x-ms-cosmos-sdk-supportedcapabilities Length: 1;\nHeader: x-ms-cosmos-correlated-activityid Length: 36;\nHeader: x-ms-cosmos-supported-serialization-formats Length: 21;\nHeader: x-ms-cosmos-query-optimisticdirectexecute Length: 5;\nHeader: x-ms-documentdb-query-iscontinuationexpected Length: 5;\nHeader: x-ms-documentdb-isquery Length: 4;\nHeader: x-ms-activity-id Length: 36;\nHeader: Cache-Control Length: 8;\nHeader: User-Agent Length: 93;\nHeader: x-ms-version Length: 10;\nHeader: Accept Length: 16;\n\nActivityId: ff6e5c74-4ad2-4169-b652-0e71fe5e674e, Request URI: /dbs/TestDatabase-ed37f45b-85ce-4495-a377-762f0888dacc/colls/TestContainer-04ae43b6-dfd5-4eb2-9e4a-0aba32952001/docs, RequestStats: Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, SDK: Darwin/10.20 cosmos-netstandard-sdk/3.37.9\n at Microsoft.Azure.Cosmos.GatewayStoreClient.ParseResponseAsync(HttpResponseMessage responseMessage, JsonSerializerSettings serializerSettings, DocumentServiceRequest request)\n at Microsoft.Azure.Cosmos.GatewayStoreClient.InvokeAsync(DocumentServiceRequest request, ResourceType resourceType, Uri physicalAddress, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.Handlers.TransportHandler.ProcessMessageAsync(RequestMessage request, CancellationToken cancellationToken)\n at Microsoft.Azure.Cosmos.Handlers.TransportHandler.SendAsync(RequestMessage request, CancellationToken cancellationToken)","RequestSessionToken":null,"ResponseSessionToken":"0:-1#1","BELatencyInMs":null}}}]}]}]}]}]}]},{"name":"Get Cosmos Element Response","duration in milliseconds":0.5515}]}]}]}]},{"name":"Query Response Serialization","duration in milliseconds":0.272}]} at Microsoft.Azure.Cosmos.GatewayStoreClient.ParseResponseAsync(HttpResponseMessage responseMessage, JsonSerializerSettings serializerSettings, DocumentServiceRequest request) at Microsoft.Azure.Cosmos.GatewayStoreClient.InvokeAsync(DocumentServiceRequest request, ResourceType resourceType, Uri physicalAddress, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.GatewayStoreModel.ProcessMessageAsync(DocumentServiceRequest request, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.Handlers.TransportHandler.ProcessMessageAsync(RequestMessage request, CancellationToken cancellationToken) at Microsoft.Azure.Cosmos.Handlers.TransportHandler.SendAsync(RequestMessage request, CancellationToken cancellationToken)
Originally posted by @snailcatcher in #149
