Getting an unknown error on retrieval while deleting in batches

0
Question: I need help resolving an issue with deleting records from a table in batches. While some batches are deleted successfully, others fail during the retrieval activity with the following error message: "ERROR - Entrypoint: error during command execution, signal: killed". This issue occurs even when not using batching. Context: The issue persists despite previous attempts to resolve it. Error Message: "ERROR - Entrypoint: error during command execution, signal: killed" Example:
asked
1 answers
-1

The error could be related to resource limitations, particularly memory or execution time. This might happen if the batch size is too large or if the database query takes too long to execute.

Solution:

  • Reduce batch size: Try decreasing the number of records being processed in each batch. This can help alleviate memory or resource constraints.
  • Optimize queries: Ensure that the database queries are efficient. Index the table properly and make sure there are no unnecessary joins or operations that can slow down the query.
  • Increase timeout limits: Check the timeout settings for your database or the Mendix platform. If the query takes longer than the allowed time, it might be killed. You can increase the timeout setting for database queries or on the server if applicable.

You can follow these Solution

  • Commit in smaller batches: Ensure that each batch is properly committed after the deletion to avoid large, uncommitted transactions. Commit every few thousand records if necessary.
  • Use microflows with limited records: In a microflow, retrieve only the necessary records to avoid pulling large data sets into memory.

By optimizing the deletion process, reducing the size of each batch, reviewing server and database settings, and ensuring that proper indexing is in place, you should be able to resolve the problem.

answered