N8n execute got error

I want to move my data from mysql A to mysql B, when I get to 20W rows

the error messages


Hi @liushengyi,

Do you mean 20M records? Are you creating insert string in function in one step? Probably this is the problem. String length is too large.

Limiting results by offset in first mysql node can do the job. And after, you need to generate insert string for the limited rows, and go ahead for next rows.

Hope this helps.

1 Like

Thanks a lot @Miquel_Colomer!

Yes totally agree. A large amount of data is very likely the problem here. In this case it would make sense to split it into multiple workflow runs.

1 Like

@Miquel_Colomer @jan thanks for reply . I chose to split the workflow and executed successfully.

1 Like

Glad to hear that you found a solution. Have fun!