js : 112 : 3 )Īt C :\Users\Administrator\Desktop\note_text\node_modules\express\lib\router\index. dispatch ( C :\Users\Administrator\Desktop\note_text\node_modules\express\lib\router\route. js : 95 : 5 )Īt next ( C :\Users\Administrator\Desktop\note_text\node_modules\express\lib\router\route. handle ( C :\Users\Administrator\Desktop\note_text\node_modules\express\lib\router\layer. js : 198 : 25 )Īt C :\Users\Administrator\Desktop\note_text\app. query ( C :\Users\Administrator\Desktop\note_text\node_modules\mysql\lib\Connection. _enqueue ( C :\Users\Administrator\Desktop\note_text\node_modules\mysql\lib\protocol\Protocol.
jsĮrror ,result ,fields Error : Cannot enqueue Query after invoking quit.
get(function(req, res, next) ) Ĭonn.end() // causes the described errorĬonsole.PS C :\Users\Administrator\Desktop\note_text > node. If you're using the node-mysql module by felixge then you can call connection.end () at any point after you've made all of the connection.query () calls, since it will wait for all of the queries to finish before it terminates the connection.
#Cannot enqueue quit 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. Since NodeJS asynchronize connection.end () will fire before execute the database call. Routes/dashboard.js - route where I put conn.end()Ĭopy Code var express = require( ' express') ĭashboard. 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. skipping app.post/app.get code for /login & /logout & isLoggedIn middlewareĪpp.use( ' /', dashboard) // issue on that You'll have to do a lot of refactoring to correct that (I wouldn't have enough time to rewrite your code), but that's the reason. query() method chronologically after you called the. routes/dashboard.js') // in this route I apply conn.end() var router = require( '. Thanks So the issue is that in your code, line 139 you are calling the. * MySQL connection*/ var connection = require( ' express-myconnection'), I am trying to insert into MYSQL table some data recieved from AJAX post. Error: Cannot enqueue Quit after invoking quit. NodeJS Cannot enqueue Handshake after already enqueuing a Handshake. skipping code about static files, bodyparser, expressValidator, session, passport Error: Cannot enqueue Quit after invoking quit Publicado 5 anos atrs, em. Fixing Node Mysql 'Error: Cannot enqueue Handshake after invoking quit.': TL DR createConnection. You need to call database.getConnection all over your code when you need a connection to query, not just once at the start. `Event.js` is not a part of my working files, probably is a file from `./node_modules`Įvents.js: 183 throw er // Unhandled 'error' eventĮrror: Cannot enqueue Quit after invoking quit.Īt Protocol._validateEnqueue (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\Protocol.js: 204: 16)Īt Protocol._enqueue (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\Protocol.js: 139: 13)Īt Protocol.quit (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\Protocol.js: 92: 23)Īt Connection.end (E:\NodeJS\Project-Change\node_modules\mysql\lib\Connection.js: 249: 18)Īt (E:\NodeJS\Project-Change\node_modules\express-myconnection\lib\express-myconnection.js: 114: 54)Īt nd (E:\NodeJS\Project-Change\node_modules\express\lib\response.js: 191: 8)Īt fn (E:\NodeJS\Project-Change\node_modules\express\lib\response.js: 896: 10)Īt (E:\NodeJS\Project-Change\node_modules\ejs\lib\ejs.js: 323: 3)Īt View.render (E:\NodeJS\Project-Change\node_modules\express\lib\view.js: 76: 8)Īt (E:\NodeJS\Project-Change\node_modules\express\lib\application.js: 527: 10)Īt (E:\NodeJS\Project-Change\node_modules\express\lib\response.js: 900: 7)Īt Query._callback (E:\NodeJS\Project-Change\routes\dashboard.js: 39: 17)Īt (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\sequences\Sequence.js: 88: 24)Īt Query._handleFinalResultPacket (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\sequences\Query.js: 139: 8)Īt Query.EofPacket (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\sequences\Query.js: 123: 8)Īt Protocol._parsePacket (E:\NodeJS\Project-Change\node_modules\mysql\lib\protocol\Protocol.js: 279: 23)Ĭopy Code var express = require( ' express'),ĮxpressValidator = require( ' express-validator'), From your example code, you are not using the connection pooling you are just acquiring a single connection forever, in which case you may as well not even use the pool at all.
0 kommentar(er)
