Error code 1 encountered an internal error while trying to execute a task

Question

Error code 1 encountered an internal error while trying to execute a task

Currently, I have this job set up to clear out unnecessary records. The code provided has been simplified for debugging purposes. However, almost 80% of the time when running it, it fails to find anything due to Error code 1 "internal error":

Parse.Cloud.job('cleanStories', function(request, status) {

  Parse.Cloud.useMasterKey();
  var counter = 0;

  var query = new Parse.Query('Story');
  query.doesNotExist("username");
  query.limit(1000);

  query.find({
    success: function(results) {
      counter += results.length;
      status.success(counter + " stories found.");
    },
    error: function(error) {
      status.error(counter + " stories found. Error: " + error.code + " " + error.message);
    }
  });
});

Currently, I have around 568k records. Initially, there were close to 800k records before I began running this job to clear them out. While it used to work fine, now it's consistently showing errors. What could be the issue here?

EDIT:

I've reduced the limit to 50 and noticed a higher success rate in execution. Even with the default limit of 100, it still fails frequently. Is there a way I can increase the limit back to 1000 to speed up processing through the remaining records?

javascript parse-platform

Answer 1

Answer №1

This approach is based on the concept that implementing smaller limits could potentially address timeout issues (assuming it is a per query timeout rather than a per job timeout). Here's a method to execute a large find operation using limit and skip:

function fetchResults(query, results) {
    results = results || [];
    query.skip(results.length);
    return query.find().then(function(findResults) {
        results = results.concat(findResults);
        return (findResults.length === 0)? results : fetchResults(query, results);
    });
}

// To utilize this method, create a query 
var query = new Parse.Query("MyClass");
// Refine the query according to your requirements
// Specify a limit up to 1000, but it's recommended to keep it small
query.limit(20);
var results = [];
fetchResults(query, results).then(function(r) {
    console.log("Total rows found: " + r.length);
    // The variable 'r' will hold all rows matching the query, fetched in batches of 20
});

Answer 2

This approach is based on the concept that implementing smaller limits could potentially address timeout issues (assuming it is a per query timeout rather than a per job timeout). Here's a method to execute a large find operation using limit and skip:

function fetchResults(query, results) {
    results = results || [];
    query.skip(results.length);
    return query.find().then(function(findResults) {
        results = results.concat(findResults);
        return (findResults.length === 0)? results : fetchResults(query, results);
    });
}

// To utilize this method, create a query 
var query = new Parse.Query("MyClass");
// Refine the query according to your requirements
// Specify a limit up to 1000, but it's recommended to keep it small
query.limit(20);
var results = [];
fetchResults(query, results).then(function(r) {
    console.log("Total rows found: " + r.length);
    // The variable 'r' will hold all rows matching the query, fetched in batches of 20
});

Error code 1 encountered an internal error while trying to execute a task

Answer №1

Similar questions

Issue encountered while submitting form on JQuery Mobile framework

How to send a global variable to an event callback function in JavaScript?

Use javascript/ajax to create a dynamic dropdown menu

conversion of markdown into a JSON object

Executing a function with a click, then undoing it with a second click

Sorting functionality malfunctioning after dynamically adding new content using AJAX

The router component in "react-router-dom" is not functioning properly

Having trouble getting the innerHTML update to be triggered by onchange

"Enhanced visuals with parallax scrolling feature implemented on various sections for an engaging

Is it possible in MongoDB to embed a collection within a document of another collection?

How can I transmit information to the model without relying on query string parameters in Express?

Failed to retrieve UI data from localstorage while performing an asynchronous action

Is there a way to execute a callback function once the page has finished loading through AJAX in

Reactjs, encountering a hitch in utilizing material UI: Incompatible hook call detected

Using anti-cache code in jQuery's getJson function

The functionality of the JavaScript click function is limited to a single execution

Is Ruby on Rails featured in Designmodo's Startup Framework Kit?

What could be causing the code to malfunction and prevent window.ethereum from working properly?

I'm encountering an issue with my API Key being undefined, despite having it saved in both an .env file and as a global variable

How to Implement Snap-Enabled Dragging in a Container Using jQuery UI