Merge Node is not waitng for the 2nd input

Questions
1

Describe the problem/error/question

Merge does not wait for the execution of the second input. I tried adding a pause before the first input, but it didn’t help.

t only works after the workflow ends with an error, and I manually restart from the merge node. I can’t break it into 2 workflows as a workaround, so I remained stuck with this.

It’s been the same issue before I upgraded from 1.6 something (like 4-5 versions ago)

Relevant park of the workflow is below.

Please share your workflow

it’s part that causes the issue. JS code removed but it’s basically just data parsing from the previous merge node.

Information on your n8n setup

1.65.2
PostgreSQL 16.4
main
Docker
Ubuntu 24.04 LTS

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @ramblingnate , the SQL in the Merge node appears to be invalid. Could you recheck and share the actual SQL (or generally node configuration). Currently the node is configured with just Left Join, which cannot work like that. What is the merge logic here?

4

it’s left join as it get (I don’t want to spend 20 minutes randomizing data). So the workaround I found was to add do nothing node from the start of execution to google sheet node. This solved the issue but boy it doesn’t make sense.

5

I’m glad you sorted out the issue for your workflow. Having said that your Merge node’s SQL doesn’t make sense to me either and I do not expect it to work.

6

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.