When I change to MySQL database, there are some workflow run forever

Questions
1

When I change to MySQL (from SQLite), some my workflow non-stop
It seems duplicated and run forever

How could I solved this?

chrome_qZchFleacf
chrome_qZchFleacf1053×498 40.9 KB

When I tried to stop one of them, this error appeared

ERROR RESPONSE
Error: The execution ID "2" could not be found.
    at WaitTrackerClass.stopExecution (/usr/local/lib/node_modules/n8n/dist/src/WaitTracker.js:58:19)
    at processTicksAndRejections (internal/process/task_queues.js:93:5)
    at async /usr/local/lib/node_modules/n8n/dist/src/Server.js:1408:30
    at async /usr/local/lib/node_modules/n8n/dist/src/ResponseHelper.js:89:26
2

Hey @cmdntd987,

That seems a bit strange, do you have one instance of n8n or multiple workers? Do you also have just the one MySQL instance or is it clustered?

3

Not yet.
It is just still a single main n8n.

I just convert database, and it is absolutely the same like old one.

4

Well, I run webhook again to test.
Now you see exe from n8n and database not the same:

chrome_7IarTWBDsK
chrome_7IarTWBDsK1050×566 40.4 KB

And this is data (images of 6 rows of ID)

chrome_twr8Y6Pi5c
chrome_twr8Y6Pi5c1036×532 41.4 KB

chrome_xXoZcySnrE
chrome_xXoZcySnrE1099×528 52.8 KB

At first, it has 3 pending and 3 done, and data has only 3 done
At second, it has still 3 pending and 3 done, but data has more done

I see ID in database not duplicated, but in n8n they are duplicated…

5

What version of n8n is it?

6

I run the latest of docker
0.151.0