Node.JS Azure MySQL { [Error: Cannot enqueue Query after fatal error.] code: 'PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR', fatal: false }

Question

I have app which connects to free Azure MySQL service and make queries in a loop. I use single connection to make those queries (I am limited to 4 connections), and process takes usually ~5 seconds. When I run app locally, it works perfectly fine, but after deployment do azure I get

{ [Error: Cannot enqueue Query after fatal error.] code: 'PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR', fatal: false }

In my logs. How can I prevent this, and why does it work correctly locally, but not on Azure?

Do you have 'express-sql-session' or 'express-mysql-session' in your proeject? Try to remove it and deploy to azure again. — Alex Chen-WX, Apr 13 '16 at 02:19
Here is my code snippet, I do not use Express, it's plain node.js application: http://pastebin.com/j0wZqm7P — Jakub Pastuszuk, Apr 14 '16 at 10:48

score 0 · Answer 1 · edited May 23 '17 at 12:22

0

There was an answered SO thread as the same issue as yours, you can refer to Node JS Mysql PROTOCOL ENQUEUE AFTER FATAL ERROR and try to solve the issue.

edited May 23 '17 at 12:22

Community

1
1

answered Apr 13 '16 at 06:34

Peter Pan

23,476
4
25
43

Node.JS Azure MySQL { [Error: Cannot enqueue Query after fatal error.] code: 'PROTOCOL_ENQUEUE_AFTER_FATAL_ERROR', fatal: false }

1 Answers1