Unable to get unique rows using GET function

Questions
,
1

Describe the problem/error/question

ONE WORD EXPLANATION: REPETITION

repetition
repetition828Ă—701 48.6 KB

What i tried?

Tried with Supabase using RETURN ALL. Server would stop after a bit of time possibly because of repetition/infinite loop. Tried on two different n8n self hosted setups:

  1. server: 233MB availabl
  2. server: 1.1GB available

encountered same thing across both. Then i thought might be something with supabase, tried google sheets, worked only once. Then i shifted to native data tables and encountering the same issue but this time “REPETITION” is pretty clear.

As far as my data table is concerned, I have 1000 unique rows with 7 columns adding up to almost 7000 data points (size around 0.26mb) which i believe should not be heavy on the server.

Table with thousand unique rows

image
image1230Ă—160 11.6 KB

Information on your n8n setup

  • n8n version: Version 1.115.3
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker (cloud self-hosted)
2

RESOLVED. The previous node had 1000 items as output so it was running once for each :slight_smile:

1 Like