n8n - 💡(How to fix) Fix Bug with Google Sheets Web Tryout [2 comments, 3 participants]

At certan hours it gives x quantity of null errors with 0 sec time execution and the error that appears in the pictures attached.

Describe the problem/error/question

What is the error message (if any)?

• error: all

TL;DR

The issue can be mitigated by adjusting the concurrency setting in the n8n configuration to a positive integer value to prevent overwhelming the system with simultaneous executions.

Guidance

• Review the concurrency setting in the n8n configuration, currently set to -1, which may be causing the system to execute an unbounded number of workflows concurrently, leading to null errors.
• Consider setting concurrency to a reasonable positive integer value to limit the number of simultaneous executions and prevent overloading the system.
• Monitor the system's performance and adjust the concurrency setting as needed to find a balance between throughput and error rate.
• Verify that the Google Sheets Node Trigger is properly configured and not causing unnecessary retries or concurrent executions.

Example

No code snippet is provided as the issue seems to be related to configuration rather than code.

Notes

The root cause of the issue is uncertain, but adjusting the concurrency setting is a plausible workaround. Further investigation into the system's performance and the Google Sheets Node Trigger configuration may be necessary to fully resolve the issue.

Recommendation

Apply workaround: Adjust the concurrency setting to a positive integer value to prevent overloading the system and mitigate the null errors. This change can help stabilize the system and reduce the error rate, but may require further tuning for optimal performance.