#Cannot enqueue query after invoking quit. code#

The code is posted at the very bottom but if I comment out the small section directly below, which is attempting the mysql insert there are no errors when running. Estou tomando o erro 'Error: Cannot enqueue Quit after invoking quit.' que pelo pesquisei em outro tpico, causado pelo fluxo assincrono no node que pode estar executando o connection.end() antes mesmo da conexo ser aberta. (/Users/Work/immersion/database-test/node_modules/mysql/lib/Connection.js:526:10)Īt Query._callback (/Users/Work/immersion/database-test/node_modules/mysql/lib/Connection.js:488:16)Īt (/Users/Work/immersion/database-test/node_modules/mysql/lib/protocol/sequences/Sequence.js:83:24)Īt /Users/Work/immersion/database-test/node_modules/mysql/lib/protocol/Protocol.js:236:14Īt processTicksAndRejections (internal/process/task_queues. I often get the following app crash error: 'Cannot enqueue quit after invoking quit.' My kluge solution, which doesnt work very well, is to put a setTimeout function at the end of the route to wait to give the MySQL processes enough time to finish before the connection.end() (or, in this case, pool.end()). I tried to query the MySQL database in Node.js but I dont know where to end the connection. Publius Asks: Insert failing with 'Error: Cannot enqueue Query after invoking quit.' I have a javascript file that is attempting to insert just two static values into a mysql table. During this time, users can invoke the following built-in playback. After removing the connection.end () from that query, it works fine now. It was because I was trying to close the connection using connection.end () (during the creation of table) and after that, I was running the MySQL query for fetching the data. (/Users/Work/immersion/database-test/app.js:22:19)Īt Query. Note: If your skill uses the AudioPlayer directives, you cannot extend the above. This will make sure all previously enqueued queries are still before sending a COMQUIT packet to the MySQL server. 1 Answer Sorted by: 5 Finally, I understood the problem. Error: Cannot enqueue Quit after invoking quit.Īt Protocol._validateEnqueue (/Users/Work/immersion/database-test/node_modules/mysql/lib/protocol/Protocol.js:215:16)Īt Protocol._enqueue (/Users/Work/immersion/database-test/node_modules/mysql/lib/protocol/Protocol.js:138:13)Īt Protocol.quit (/Users/Work/immersion/database-test/node_modules/mysql/lib/protocol/Protocol.js:91:23)Īt Connection.end (/Users/Work/immersion/database-test/node_modules/mysql/lib/Connection.js:239:18)Īt Query.