Hello, I’m facing a problem that I haven’t been able to identify yet. The PGVECTOR node that inserts information into Postgress simply freezes after 90 to 100 pieces of data.
What has already been done:
Adjustments to Postgress connections. As a test, I set them to 10,000, even though the database only shows one connection.
The Postgress timeout and buffer settings are absurdly high.
In BOTH cases, there is a lot of RAM and CPU left over.
I’ve come to the conclusion that Postgres is not crashing on the server side.
I’ve changed the NODE in different ways. I tested it by sending EVERYTHING, and also by sending files one at a time and 10 at a time.
The Node simply freezes. It doesn’t generate any errors, not even the debug generates an error. It just keeps showing up (when running the node).
I would like to point out that it works perfectly well up to 90~100 pieces of data on average, but afterwards it simply looks like the attached image.
I would appreciate it if you could tell me where my mistake is in this case.
Information on your n8n setup
- n8n version: 1.76.1
- Database (default: SQLite): default
- n8n EXECUTIONS_PROCESS setting (default: own, main): default
- Running n8n via (Docker, npm, n8n cloud, desktop app): docker
- Operating system: ubuntu 22