Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Tweak how we create indices to work better with cosmos db #2344

Open
carolynvs opened this issue Sep 7, 2022 · 0 comments
Open

Tweak how we create indices to work better with cosmos db #2344

carolynvs opened this issue Sep 7, 2022 · 0 comments
Labels
1 - 🍫 Eat chocolate _after_ emergency donuts bug Oops, sorry!

Comments

@carolynvs
Copy link
Member

carolynvs commented Sep 7, 2022 •
edited
Loading

Describe the bug

Cosmos DB with the mongo api has limitations when continuous backup is enabled that do not work with how we JIT create indices in Porter.

To Reproduce

  1. Create a cosmosdb with mongo enabled, with api version 4.0, and 7 day continous backup selected. Leave all other defaults alone.
  2. Update your porter config to use the cosmos db connection string, removing all options other than ssl=true from the end of the connection string
  3. Run porter list

I see an error about The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one.

Expected behavior

The command should work

We should keep in mind the existing performance issue in how we create indices with cosmos as that may impact how we solve this bug. See #1782

Porter Command and Output

$ porter list
Checking database schema
Selected configured plugin	{"plugin-key": "mongodb"}
Connecting to plugin	{"plugin-command": "/Users/carolynvs/.porter/porter plugin run storage.porter.mongodb"}
starting plugin
plugin started
waiting for RPC address
using plugin
plugin address
Initializing installation collection indices
invalid index specified: ([]mongo.IndexModel) (len=1 cap=1) {
 (mongo.IndexModel) {
  Keys: (primitive.D) (len=2 cap=2) {
   (primitive.E) {
    Key: (string) (len=9) "namespace",
    Value: (int64) 1
   },
   (primitive.E) {
    Key: (string) (len=4) "name",
    Value: (int64) 1
   }
  },
  Options: (*options.IndexOptions)(0x140005d4480)({
   Background: (*bool)(<nil>),
   ExpireAfterSeconds: (*int32)(<nil>),
   Name: (*string)(0x14000732e60)((len=18) "namespace_1_name_1"),
   Sparse: (*bool)(<nil>),
   StorageEngine: (interface {}) <nil>,
   Unique: (*bool)(0x1400011ef88)(true),
   Version: (*int32)(<nil>),
   DefaultLanguage: (*string)(<nil>),
   LanguageOverride: (*string)(<nil>),
   TextVersion: (*int32)(<nil>),
   Weights: (interface {}) <nil>,
   SphereVersion: (*int32)(<nil>),
   Bits: (*int32)(<nil>),
   Max: (*float64)(<nil>),
   Min: (*float64)(<nil>),
   BucketSize: (*int32)(<nil>),
   PartialFilterExpression: (interface {}) <nil>,
   Collation: (*options.Collation)(<nil>),
   WildcardProjection: (interface {}) <nil>,
   Hidden: (*bool)(<nil>)
  })
 }
}
: (BadValue) Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a; Reason: (Message: {"Errors":["The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one."]}
ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, Request URI: /apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, RequestStats:
RequestStartTime: 2022-09-07T21:38:20.5475497Z, RequestEndTime: 2022-09-07T21:38:20.5475497Z,  Number of regions attempted:1
{"systemHistory":[{"dateUtc":"2022-09-07T21:37:28.1076575Z","cpu":0.576,"memory":649223604.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0516,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:38.1176165Z","cpu":0.095,"memory":649233700.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0296,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:48.1275982Z","cpu":0.185,"memory":649252404.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0328,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:58.1375950Z","cpu":0.346,"memory":649099704.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0134,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:08.1475831Z","cpu":0.903,"memory":651786948.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0272,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:18.1575555Z","cpu":0.237,"memory":651790064.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0247,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100}]}
RequestStart: 2022-09-07T21:38:20.5475497Z; ResponseTime: 2022-09-07T21:38:20.5475497Z; StoreResult: StorePhysicalAddress: rntbd://10.0.1.5:11300/apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, LSN: 12, GlobalCommittedLsn: 12, PartitionKeyRangeId: , IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 1.67, ItemLSN: -1, SessionToken: -1#12, UsingLocalLSN: False, TransportException: null, BELatencyMs: 4.23, ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, RetryAfterInMs: , TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2022-09-07T21:38:20.5475497Z", "durationInMs": 0.0059},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2022-09-07T21:38:20.5475556Z", "durationInMs": 0.0025},{"event": "Pipelined", "startTimeUtc": "2022-09-07T21:38:20.5475581Z", "durationInMs": 0.2363},{"event": "Transit Time", "startTimeUtc": "2022-09-07T21:38:20.5477944Z", "durationInMs": 4.5456},{"event": "Received", "startTimeUtc": "2022-09-07T21:38:20.5523400Z", "durationInMs": 0.0662},{"event": "Completed", "startTimeUtc": "2022-09-07T21:38:20.5524062Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"False","callsPendingReceive":0,"lastSendAttempt":"2022-09-07T21:38:19.8575612Z","lastSend":"2022-09-07T21:38:19.8575612Z","lastReceive":"2022-09-07T21:38:19.8875594Z"},"requestSizeInBytes":2716,"requestBodySizeInBytes":2187,"responseMetadataSizeInBytes":171,"responseBodySizeInBytes":126};
 ResourceType: Collection, OperationType: Replace
, SDK: Microsoft.Azure.Documents.Common/2.14.0, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0);
invalid index specified: ([]mongo.IndexModel) (len=1 cap=1) {
 (mongo.IndexModel) {
  Keys: (primitive.D) (len=2 cap=2) {
   (primitive.E) {
    Key: (string) (len=9) "namespace",
    Value: (int64) 1
   },
   (primitive.E) {
    Key: (string) (len=4) "name",
    Value: (int64) 1
   }
  },
  Options: (*options.IndexOptions)(0x140005d4480)({
   Background: (*bool)(<nil>),
   ExpireAfterSeconds: (*int32)(<nil>),
   Name: (*string)(0x14000732e60)((len=18) "namespace_1_name_1"),
   Sparse: (*bool)(<nil>),
   StorageEngine: (interface {}) <nil>,
   Unique: (*bool)(0x1400011ef88)(true),
   Version: (*int32)(<nil>),
   DefaultLanguage: (*string)(<nil>),
   LanguageOverride: (*string)(<nil>),
   TextVersion: (*int32)(<nil>),
   Weights: (interface {}) <nil>,
   SphereVersion: (*int32)(<nil>),
   Bits: (*int32)(<nil>),
   Max: (*float64)(<nil>),
   Min: (*float64)(<nil>),
   BucketSize: (*int32)(<nil>),
   PartialFilterExpression: (interface {}) <nil>,
   Collation: (*options.Collation)(<nil>),
   WildcardProjection: (interface {}) <nil>,
   Hidden: (*bool)(<nil>)
  })
 }
}
: (BadValue) Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a; Reason: (Message: {"Errors":["The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one."]}
ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, Request URI: /apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, RequestStats:
RequestStartTime: 2022-09-07T21:38:20.5475497Z, RequestEndTime: 2022-09-07T21:38:20.5475497Z,  Number of regions attempted:1
{"systemHistory":[{"dateUtc":"2022-09-07T21:37:28.1076575Z","cpu":0.576,"memory":649223604.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0516,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:38.1176165Z","cpu":0.095,"memory":649233700.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0296,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:48.1275982Z","cpu":0.185,"memory":649252404.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0328,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:58.1375950Z","cpu":0.346,"memory":649099704.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0134,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:08.1475831Z","cpu":0.903,"memory":651786948.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0272,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:18.1575555Z","cpu":0.237,"memory":651790064.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0247,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100}]}
RequestStart: 2022-09-07T21:38:20.5475497Z; ResponseTime: 2022-09-07T21:38:20.5475497Z; StoreResult: StorePhysicalAddress: rntbd://10.0.1.5:11300/apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, LSN: 12, GlobalCommittedLsn: 12, PartitionKeyRangeId: , IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 1.67, ItemLSN: -1, SessionToken: -1#12, UsingLocalLSN: False, TransportException: null, BELatencyMs: 4.23, ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, RetryAfterInMs: , TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2022-09-07T21:38:20.5475497Z", "durationInMs": 0.0059},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2022-09-07T21:38:20.5475556Z", "durationInMs": 0.0025},{"event": "Pipelined", "startTimeUtc": "2022-09-07T21:38:20.5475581Z", "durationInMs": 0.2363},{"event": "Transit Time", "startTimeUtc": "2022-09-07T21:38:20.5477944Z", "durationInMs": 4.5456},{"event": "Received", "startTimeUtc": "2022-09-07T21:38:20.5523400Z", "durationInMs": 0.0662},{"event": "Completed", "startTimeUtc": "2022-09-07T21:38:20.5524062Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"False","callsPendingReceive":0,"lastSendAttempt":"2022-09-07T21:38:19.8575612Z","lastSend":"2022-09-07T21:38:19.8575612Z","lastReceive":"2022-09-07T21:38:19.8875594Z"},"requestSizeInBytes":2716,"requestBodySizeInBytes":2187,"responseMetadataSizeInBytes":171,"responseBodySizeInBytes":126};
 ResourceType: Collection, OperationType: Replace
, SDK: Microsoft.Azure.Documents.Common/2.14.0, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0);
rpc error: code = Unknown desc = invalid index specified: ([]mongo.IndexModel) (len=1 cap=1) {
 (mongo.IndexModel) {
  Keys: (primitive.D) (len=2 cap=2) {
   (primitive.E) {
    Key: (string) (len=9) "namespace",
    Value: (int64) 1
   },
   (primitive.E) {
    Key: (string) (len=4) "name",
    Value: (int64) 1
   }
  },
  Options: (*options.IndexOptions)(0x140005d4480)({
   Background: (*bool)(<nil>),
   ExpireAfterSeconds: (*int32)(<nil>),
   Name: (*string)(0x14000732e60)((len=18) "namespace_1_name_1"),
   Sparse: (*bool)(<nil>),
   StorageEngine: (interface {}) <nil>,
   Unique: (*bool)(0x1400011ef88)(true),
   Version: (*int32)(<nil>),
   DefaultLanguage: (*string)(<nil>),
   LanguageOverride: (*string)(<nil>),
   TextVersion: (*int32)(<nil>),
   Weights: (interface {}) <nil>,
   SphereVersion: (*int32)(<nil>),
   Bits: (*int32)(<nil>),
   Max: (*float64)(<nil>),
   Min: (*float64)(<nil>),
   BucketSize: (*int32)(<nil>),
   PartialFilterExpression: (interface {}) <nil>,
   Collation: (*options.Collation)(<nil>),
   WildcardProjection: (interface {}) <nil>,
   Hidden: (*bool)(<nil>)
  })
 }
}
: (BadValue) Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a; Reason: (Message: {"Errors":["The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one."]}
ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, Request URI: /apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, RequestStats:
RequestStartTime: 2022-09-07T21:38:20.5475497Z, RequestEndTime: 2022-09-07T21:38:20.5475497Z,  Number of regions attempted:1
{"systemHistory":[{"dateUtc":"2022-09-07T21:37:28.1076575Z","cpu":0.576,"memory":649223604.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0516,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:38.1176165Z","cpu":0.095,"memory":649233700.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0296,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:48.1275982Z","cpu":0.185,"memory":649252404.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0328,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:58.1375950Z","cpu":0.346,"memory":649099704.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0134,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:08.1475831Z","cpu":0.903,"memory":651786948.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0272,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:18.1575555Z","cpu":0.237,"memory":651790064.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0247,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100}]}
RequestStart: 2022-09-07T21:38:20.5475497Z; ResponseTime: 2022-09-07T21:38:20.5475497Z; StoreResult: StorePhysicalAddress: rntbd://10.0.1.5:11300/apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, LSN: 12, GlobalCommittedLsn: 12, PartitionKeyRangeId: , IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 1.67, ItemLSN: -1, SessionToken: -1#12, UsingLocalLSN: False, TransportException: null, BELatencyMs: 4.23, ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, RetryAfterInMs: , TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2022-09-07T21:38:20.5475497Z", "durationInMs": 0.0059},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2022-09-07T21:38:20.5475556Z", "durationInMs": 0.0025},{"event": "Pipelined", "startTimeUtc": "2022-09-07T21:38:20.5475581Z", "durationInMs": 0.2363},{"event": "Transit Time", "startTimeUtc": "2022-09-07T21:38:20.5477944Z", "durationInMs": 4.5456},{"event": "Received", "startTimeUtc": "2022-09-07T21:38:20.5523400Z", "durationInMs": 0.0662},{"event": "Completed", "startTimeUtc": "2022-09-07T21:38:20.5524062Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"False","callsPendingReceive":0,"lastSendAttempt":"2022-09-07T21:38:19.8575612Z","lastSend":"2022-09-07T21:38:19.8575612Z","lastReceive":"2022-09-07T21:38:19.8875594Z"},"requestSizeInBytes":2716,"requestBodySizeInBytes":2187,"responseMetadataSizeInBytes":171,"responseBodySizeInBytes":126};
 ResourceType: Collection, OperationType: Replace
, SDK: Microsoft.Azure.Documents.Common/2.14.0, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0);
rpc error: code = Unknown desc = invalid index specified: ([]mongo.IndexModel) (len=1 cap=1) {
 (mongo.IndexModel) {
  Keys: (primitive.D) (len=2 cap=2) {
   (primitive.E) {
    Key: (string) (len=9) "namespace",
    Value: (int64) 1
   },
   (primitive.E) {
    Key: (string) (len=4) "name",
    Value: (int64) 1
   }
  },
  Options: (*options.IndexOptions)(0x140005d4480)({
   Background: (*bool)(<nil>),
   ExpireAfterSeconds: (*int32)(<nil>),
   Name: (*string)(0x14000732e60)((len=18) "namespace_1_name_1"),
   Sparse: (*bool)(<nil>),
   StorageEngine: (interface {}) <nil>,
   Unique: (*bool)(0x1400011ef88)(true),
   Version: (*int32)(<nil>),
   DefaultLanguage: (*string)(<nil>),
   LanguageOverride: (*string)(<nil>),
   TextVersion: (*int32)(<nil>),
   Weights: (interface {}) <nil>,
   SphereVersion: (*int32)(<nil>),
   Bits: (*int32)(<nil>),
   Max: (*float64)(<nil>),
   Min: (*float64)(<nil>),
   BucketSize: (*int32)(<nil>),
   PartialFilterExpression: (interface {}) <nil>,
   Collation: (*options.Collation)(<nil>),
   WildcardProjection: (interface {}) <nil>,
   Hidden: (*bool)(<nil>)
  })
 }
}
: (BadValue) Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a; Reason: (Message: {"Errors":["The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one."]}
ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, Request URI: /apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, RequestStats:
RequestStartTime: 2022-09-07T21:38:20.5475497Z, RequestEndTime: 2022-09-07T21:38:20.5475497Z,  Number of regions attempted:1
{"systemHistory":[{"dateUtc":"2022-09-07T21:37:28.1076575Z","cpu":0.576,"memory":649223604.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0516,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:38.1176165Z","cpu":0.095,"memory":649233700.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0296,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:48.1275982Z","cpu":0.185,"memory":649252404.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0328,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:58.1375950Z","cpu":0.346,"memory":649099704.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0134,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:08.1475831Z","cpu":0.903,"memory":651786948.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0272,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:18.1575555Z","cpu":0.237,"memory":651790064.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0247,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100}]}
RequestStart: 2022-09-07T21:38:20.5475497Z; ResponseTime: 2022-09-07T21:38:20.5475497Z; StoreResult: StorePhysicalAddress: rntbd://10.0.1.5:11300/apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, LSN: 12, GlobalCommittedLsn: 12, PartitionKeyRangeId: , IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 1.67, ItemLSN: -1, SessionToken: -1#12, UsingLocalLSN: False, TransportException: null, BELatencyMs: 4.23, ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, RetryAfterInMs: , TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2022-09-07T21:38:20.5475497Z", "durationInMs": 0.0059},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2022-09-07T21:38:20.5475556Z", "durationInMs": 0.0025},{"event": "Pipelined", "startTimeUtc": "2022-09-07T21:38:20.5475581Z", "durationInMs": 0.2363},{"event": "Transit Time", "startTimeUtc": "2022-09-07T21:38:20.5477944Z", "durationInMs": 4.5456},{"event": "Received", "startTimeUtc": "2022-09-07T21:38:20.5523400Z", "durationInMs": 0.0662},{"event": "Completed", "startTimeUtc": "2022-09-07T21:38:20.5524062Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"False","callsPendingReceive":0,"lastSendAttempt":"2022-09-07T21:38:19.8575612Z","lastSend":"2022-09-07T21:38:19.8575612Z","lastReceive":"2022-09-07T21:38:19.8875594Z"},"requestSizeInBytes":2716,"requestBodySizeInBytes":2187,"responseMetadataSizeInBytes":171,"responseBodySizeInBytes":126};
 ResourceType: Collection, OperationType: Replace
, SDK: Microsoft.Azure.Documents.Common/2.14.0, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0);
could not list installations: rpc error: code = Unknown desc = invalid index specified: ([]mongo.IndexModel) (len=1 cap=1) {
 (mongo.IndexModel) {
  Keys: (primitive.D) (len=2 cap=2) {
   (primitive.E) {
    Key: (string) (len=9) "namespace",
    Value: (int64) 1
   },
   (primitive.E) {
    Key: (string) (len=4) "name",
    Value: (int64) 1
   }
  },
  Options: (*options.IndexOptions)(0x140005d4480)({
   Background: (*bool)(<nil>),
   ExpireAfterSeconds: (*int32)(<nil>),
   Name: (*string)(0x14000732e60)((len=18) "namespace_1_name_1"),
   Sparse: (*bool)(<nil>),
   StorageEngine: (interface {}) <nil>,
   Unique: (*bool)(0x1400011ef88)(true),
   Version: (*int32)(<nil>),
   DefaultLanguage: (*string)(<nil>),
   LanguageOverride: (*string)(<nil>),
   TextVersion: (*int32)(<nil>),
   Weights: (interface {}) <nil>,
   SphereVersion: (*int32)(<nil>),
   Bits: (*int32)(<nil>),
   Max: (*float64)(<nil>),
   Min: (*float64)(<nil>),
   BucketSize: (*int32)(<nil>),
   PartialFilterExpression: (interface {}) <nil>,
   Collation: (*options.Collation)(<nil>),
   WildcardProjection: (interface {}) <nil>,
   Hidden: (*bool)(<nil>)
  })
 }
}
: (BadValue) Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a; Reason: (Message: {"Errors":["The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one."]}
ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, Request URI: /apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, RequestStats:
RequestStartTime: 2022-09-07T21:38:20.5475497Z, RequestEndTime: 2022-09-07T21:38:20.5475497Z,  Number of regions attempted:1
{"systemHistory":[{"dateUtc":"2022-09-07T21:37:28.1076575Z","cpu":0.576,"memory":649223604.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0516,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:38.1176165Z","cpu":0.095,"memory":649233700.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0296,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:48.1275982Z","cpu":0.185,"memory":649252404.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0328,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:58.1375950Z","cpu":0.346,"memory":649099704.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0134,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:08.1475831Z","cpu":0.903,"memory":651786948.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0272,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:18.1575555Z","cpu":0.237,"memory":651790064.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0247,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100}]}
RequestStart: 2022-09-07T21:38:20.5475497Z; ResponseTime: 2022-09-07T21:38:20.5475497Z; StoreResult: StorePhysicalAddress: rntbd://10.0.1.5:11300/apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, LSN: 12, GlobalCommittedLsn: 12, PartitionKeyRangeId: , IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 1.67, ItemLSN: -1, SessionToken: -1#12, UsingLocalLSN: False, TransportException: null, BELatencyMs: 4.23, ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, RetryAfterInMs: , TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2022-09-07T21:38:20.5475497Z", "durationInMs": 0.0059},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2022-09-07T21:38:20.5475556Z", "durationInMs": 0.0025},{"event": "Pipelined", "startTimeUtc": "2022-09-07T21:38:20.5475581Z", "durationInMs": 0.2363},{"event": "Transit Time", "startTimeUtc": "2022-09-07T21:38:20.5477944Z", "durationInMs": 4.5456},{"event": "Received", "startTimeUtc": "2022-09-07T21:38:20.5523400Z", "durationInMs": 0.0662},{"event": "Completed", "startTimeUtc": "2022-09-07T21:38:20.5524062Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"False","callsPendingReceive":0,"lastSendAttempt":"2022-09-07T21:38:19.8575612Z","lastSend":"2022-09-07T21:38:19.8575612Z","lastReceive":"2022-09-07T21:38:19.8875594Z"},"requestSizeInBytes":2716,"requestBodySizeInBytes":2187,"responseMetadataSizeInBytes":171,"responseBodySizeInBytes":126};
 ResourceType: Collection, OperationType: Replace
, SDK: Microsoft.Azure.Documents.Common/2.14.0, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0);
could not list installations: rpc error: code = Unknown desc = invalid index specified: ([]mongo.IndexModel) (len=1 cap=1) {
 (mongo.IndexModel) {
  Keys: (primitive.D) (len=2 cap=2) {
   (primitive.E) {
    Key: (string) (len=9) "namespace",
    Value: (int64) 1
   },
   (primitive.E) {
    Key: (string) (len=4) "name",
    Value: (int64) 1
   }
  },
  Options: (*options.IndexOptions)(0x140005d4480)({
   Background: (*bool)(<nil>),
   ExpireAfterSeconds: (*int32)(<nil>),
   Name: (*string)(0x14000732e60)((len=18) "namespace_1_name_1"),
   Sparse: (*bool)(<nil>),
   StorageEngine: (interface {}) <nil>,
   Unique: (*bool)(0x1400011ef88)(true),
   Version: (*int32)(<nil>),
   DefaultLanguage: (*string)(<nil>),
   LanguageOverride: (*string)(<nil>),
   TextVersion: (*int32)(<nil>),
   Weights: (interface {}) <nil>,
   SphereVersion: (*int32)(<nil>),
   Bits: (*int32)(<nil>),
   Max: (*float64)(<nil>),
   Min: (*float64)(<nil>),
   BucketSize: (*int32)(<nil>),
   PartialFilterExpression: (interface {}) <nil>,
   Collation: (*options.Collation)(<nil>),
   WildcardProjection: (interface {}) <nil>,
   Hidden: (*bool)(<nil>)
  })
 }
}
: (BadValue) Error=2, Details='Response status code does not indicate success: BadRequest (400); Substatus: 0; ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a; Reason: (Message: {"Errors":["The unique index cannot be modified. To change the unique index, remove the collection and re-create a new one."]}
ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, Request URI: /apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, RequestStats:
RequestStartTime: 2022-09-07T21:38:20.5475497Z, RequestEndTime: 2022-09-07T21:38:20.5475497Z,  Number of regions attempted:1
{"systemHistory":[{"dateUtc":"2022-09-07T21:37:28.1076575Z","cpu":0.576,"memory":649223604.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0516,"availableThreads":32763,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:38.1176165Z","cpu":0.095,"memory":649233700.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0296,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:48.1275982Z","cpu":0.185,"memory":649252404.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0328,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:37:58.1375950Z","cpu":0.346,"memory":649099704.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0134,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:08.1475831Z","cpu":0.903,"memory":651786948.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0272,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100},{"dateUtc":"2022-09-07T21:38:18.1575555Z","cpu":0.237,"memory":651790064.000,"threadInfo":{"isThreadStarving":"False","threadWaitIntervalInMs":0.0247,"availableThreads":32764,"minThreads":64,"maxThreads":32767},"numberOfOpenTcpConnection":100}]}
RequestStart: 2022-09-07T21:38:20.5475497Z; ResponseTime: 2022-09-07T21:38:20.5475497Z; StoreResult: StorePhysicalAddress: rntbd://10.0.1.5:11300/apps/c23b7c9a-d4d4-461a-8749-a7b8c6f7b51d/services/76f8e001-0639-4ee8-9f6a-cc01f3006c30/partitions/4fbeaec2-2099-47af-a9ee-c38aff0f635f/replicas/133067664115768772p, LSN: 12, GlobalCommittedLsn: 12, PartitionKeyRangeId: , IsValid: True, StatusCode: 400, SubStatusCode: 0, RequestCharge: 1.67, ItemLSN: -1, SessionToken: -1#12, UsingLocalLSN: False, TransportException: null, BELatencyMs: 4.23, ActivityId: aa5b1005-e16b-4216-9b0a-8e044be1cf1a, RetryAfterInMs: , TransportRequestTimeline: {"requestTimeline":[{"event": "Created", "startTimeUtc": "2022-09-07T21:38:20.5475497Z", "durationInMs": 0.0059},{"event": "ChannelAcquisitionStarted", "startTimeUtc": "2022-09-07T21:38:20.5475556Z", "durationInMs": 0.0025},{"event": "Pipelined", "startTimeUtc": "2022-09-07T21:38:20.5475581Z", "durationInMs": 0.2363},{"event": "Transit Time", "startTimeUtc": "2022-09-07T21:38:20.5477944Z", "durationInMs": 4.5456},{"event": "Received", "startTimeUtc": "2022-09-07T21:38:20.5523400Z", "durationInMs": 0.0662},{"event": "Completed", "startTimeUtc": "2022-09-07T21:38:20.5524062Z", "durationInMs": 0}],"serviceEndpointStats":{"inflightRequests":1,"openConnections":1},"connectionStats":{"waitforConnectionInit":"False","callsPendingReceive":0,"lastSendAttempt":"2022-09-07T21:38:19.8575612Z","lastSend":"2022-09-07T21:38:19.8575612Z","lastReceive":"2022-09-07T21:38:19.8875594Z"},"requestSizeInBytes":2716,"requestBodySizeInBytes":2187,"responseMetadataSizeInBytes":171,"responseBodySizeInBytes":126};
 ResourceType: Collection, OperationType: Replace
, SDK: Microsoft.Azure.Documents.Common/2.14.0, Microsoft.Azure.Cosmos.Tracing.TraceData.ClientSideRequestStatisticsTraceDatum, Windows/10.0.17763 cosmos-netstandard-sdk/3.18.0);
received EOF, stopping recv loop
plugin process exited
plugin exited

Version

1.0.0-rc.1
@carolynvs carolynvs added the bug Oops, sorry! label Sep 7, 2022
@carolynvs carolynvs added 1 - 🍫 Eat chocolate _after_ emergency donuts v1.1.0 labels Sep 7, 2022
@carolynvs carolynvs added v1.2.0 and removed v1.1.0 labels Sep 29, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
1 - 🍫 Eat chocolate _after_ emergency donuts bug Oops, sorry!
Projects
No open projects
Upcoming Releases
Status: No status
Milestone
No milestone
Development

No branches or pull requests
2 participants
@carolynvs @kichristensen