Cosmos DB out of Memory exception while executing stored procedure
I am using Azure Cosmos DB SQL API . I have written stored procedure will get the data and keeps in response API feed .
Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Out of memory\r\nStack trace:
undefined\"]rnActivityId: c286cbb6-34c1-4929-a148-915544b20ce6,
Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T05:46:36.4852333Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"c286cbb6-34c1-4929-a148-915544b20ce6"
My stored procedure is very simple one I just wanted to see how many records i can fetch from cosmos DB at given time and send as response.
// SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();
// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data FROM root r',
function (err, feed, options) );
if (!isAccepted) throw new Error('The query was not accepted by the server.');
azure azure-cosmosdb azure-cosmosdb-sqlapi edited Nov 12 at 3:00
Jay Gong
7,9461512
asked Nov 10 at 5:52
Amjath Khan
488
add a comment |
I am using Azure Cosmos DB SQL API . I have written stored procedure will get the data and keeps in response API feed .
Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Out of memory\r\nStack trace:
undefined\"]rnActivityId: c286cbb6-34c1-4929-a148-915544b20ce6,
Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T05:46:36.4852333Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"c286cbb6-34c1-4929-a148-915544b20ce6"
My stored procedure is very simple one I just wanted to see how many records i can fetch from cosmos DB at given time and send as response.
// SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();
// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data FROM root r',
function (err, feed, options) );
if (!isAccepted) throw new Error('The query was not accepted by the server.');
edited Nov 12 at 3:00
Jay Gong
7,9461512
asked Nov 10 at 5:52
Amjath Khan
488
Possible duplicate of Azure Cosomos DB stored procedure response size too large
– Josh
Nov 11 at 23:20
Hi,Amjath,does my answer helps you?
– Jay Gong
Nov 16 at 6:45
add a comment |
I am using Azure Cosmos DB SQL API . I have written stored procedure will get the data and keeps in response API feed .
Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Out of memory\r\nStack trace:
undefined\"]rnActivityId: c286cbb6-34c1-4929-a148-915544b20ce6,
Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T05:46:36.4852333Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"c286cbb6-34c1-4929-a148-915544b20ce6"
My stored procedure is very simple one I just wanted to see how many records i can fetch from cosmos DB at given time and send as response.
// SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();
// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data FROM root r',
function (err, feed, options) );
if (!isAccepted) throw new Error('The query was not accepted by the server.');
edited Nov 12 at 3:00
Jay Gong
7,9461512
asked Nov 10 at 5:52
Amjath Khan
488
I am using Azure Cosmos DB SQL API . I have written stored procedure will get the data and keeps in response API feed .
Failed to execute stored procedure testProcedure for collection
iotcollection:
"code":400,"body":""code":"BadRequest","message":"Message:
\"Errors\":[\"Encountered exception while executing function.
Exception = Error: Out of memory\r\nStack trace:
undefined\"]rnActivityId: c286cbb6-34c1-4929-a148-915544b20ce6,
Request URI:
/apps/59d3b9ef-17ca-4bbf-8a11-39d0199a8d29/services/1b26e00f-1f51-4d34-88ec-4090b8e7db00/partitions/45a313b7-2cf2-419e-9885-48bf9cfe6277/replicas/131862936473830809p/,
RequestStats: rnRequestStartTime: 2018-11-10T05:46:36.4852333Z,
Number of regions attempted: 1rn, SDK:
Microsoft.Azure.Documents.Common/2.1.0.0"","activityId":"c286cbb6-34c1-4929-a148-915544b20ce6"
My stored procedure is very simple one I just wanted to see how many records i can fetch from cosmos DB at given time and send as response.
// SAMPLE STORED PROCEDURE
function sample(prefix)
var collection = getContext().getCollection();
// Query documents and take 1st item.
var isAccepted = collection.queryDocuments(
collection.getSelfLink(),
'SELECT r.data FROM root r',
function (err, feed, options) );
if (!isAccepted) throw new Error('The query was not accepted by the server.');
edited Nov 12 at 3:00
Jay Gong
7,9461512
asked Nov 10 at 5:52
Amjath Khan
488
edited Nov 12 at 3:00
Jay Gong
7,9461512
asked Nov 10 at 5:52
Amjath Khan
488
edited Nov 12 at 3:00
Jay Gong
7,9461512
edited Nov 12 at 3:00
Jay Gong
7,9461512
edited Nov 12 at 3:00
Jay Gong
7,9461512
7,9461512
asked Nov 10 at 5:52
Amjath Khan
488
asked Nov 10 at 5:52
Amjath Khan
488
asked Nov 10 at 5:52
Amjath Khan
488
488
Possible duplicate of Azure Cosomos DB stored procedure response size too large
– Josh
Nov 11 at 23:20
Hi,Amjath,does my answer helps you?
– Jay Gong
Nov 16 at 6:45
add a comment |
Possible duplicate of Azure Cosomos DB stored procedure response size too large
– Josh
Nov 11 at 23:20
Hi,Amjath,does my answer helps you?
– Jay Gong
Nov 16 at 6:45
Possible duplicate of Azure Cosomos DB stored procedure response size too large
– Josh
Nov 11 at 23:20
Possible duplicate of Azure Cosomos DB stored procedure response size too large
– Josh
Nov 11 at 23:20
Hi,Amjath,does my answer helps you?
– Jay Gong
Nov 16 at 6:45
Hi,Amjath,does my answer helps you?
– Jay Gong
Nov 16 at 6:45
add a comment |
1 Answer
1
active
oldest
votes
I'm sure the reason of Out-Of-Memoryerror is the str string is too long during your loop. It seems that the str string is useless for your test which is not added into response.
Please remove it and the sample stored procedure will work fine.
answered Nov 12 at 7:52
Jay Gong
7,9461512
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53236362%2fcosmos-db-out-of-memory-exception-while-executing-stored-procedure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I'm sure the reason of Out-Of-Memoryerror is the str string is too long during your loop. It seems that the str string is useless for your test which is not added into response.
Please remove it and the sample stored procedure will work fine.
answered Nov 12 at 7:52
Jay Gong
7,9461512
add a comment |
I'm sure the reason of Out-Of-Memoryerror is the str string is too long during your loop. It seems that the str string is useless for your test which is not added into response.
Please remove it and the sample stored procedure will work fine.
answered Nov 12 at 7:52
Jay Gong
7,9461512
add a comment |
I'm sure the reason of Out-Of-Memoryerror is the str string is too long during your loop. It seems that the str string is useless for your test which is not added into response.
Please remove it and the sample stored procedure will work fine.
answered Nov 12 at 7:52
Jay Gong
7,9461512
I'm sure the reason of Out-Of-Memoryerror is the str string is too long during your loop. It seems that the str string is useless for your test which is not added into response.
Please remove it and the sample stored procedure will work fine.
answered Nov 12 at 7:52
Jay Gong
7,9461512
answered Nov 12 at 7:52
Jay Gong
7,9461512
answered Nov 12 at 7:52
Jay Gong
7,9461512
answered Nov 12 at 7:52
Jay Gong
7,9461512
7,9461512
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53236362%2fcosmos-db-out-of-memory-exception-while-executing-stored-procedure%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Possible duplicate of Azure Cosomos DB stored procedure response size too large
– Josh
Nov 11 at 23:20
Hi,Amjath,does my answer helps you?
– Jay Gong
Nov 16 at 6:45