CloudSQL connection issues with deployed Bookshelf tutorial app (App Engine/NodeJS)

Question

I deployed my code on app engine with node js (flex environment).

config.json

{
  "GCLOUD_PROJECT": "XXXXXX",
  "DATA_BACKEND": "cloudsql",
  "MYSQL_USER": "XXXX",
  "MYSQL_PASSWORD": "XXXXX",
  "INSTANCE_CONNECTION_NAME": "XXXXXX:us-central1:XXXXX"
}

model-cloudsql.js

const options = {
  user: config.get('MYSQL_USER'),
  password: config.get('MYSQL_PASSWORD'),
  database: 'XXXXX'
};

if (config.get('INSTANCE_CONNECTION_NAME') && config.get('NODE_ENV') === 'production') {
  options.socketPath = `/cloudsql/${config.get('INSTANCE_CONNECTION_NAME')}`;
}
const connection = mysql.createConnection(options);

I am getting below error:

"Cannot enqueue Query after fatal error."

please provides any feedback on it.

As per snakecharmerb's linked question, this is usually related to improper connection management. Have you been able to solve this? Are you getting this error on every run? — LundinCast
– LundinCast, Commented Apr 5, 2018 at 15:50

kurtisvg · Accepted Answer · 2018-05-09 20:53:38Z

0

It looks like the error "Cannot enqueue Query after fatal error." happens when you try to query a connection that encounter a fatal error during create. If we check out the mysqljs documentation, it recommends connecting with the following:

var mysql      = require('mysql');
var connection = mysql.createConnection({
  host     : 'example.org',
  user     : 'bob',
  password : 'secret'
});

connection.connect(function(err) {
  if (err) {
    console.error('error connecting: ' + err.stack);
    return;
  }

  console.log('connected as id ' + connection.threadId);
});

As you can see, you need to pass along a callback function to handle any errors that may arise while you are attempting to connect. This callback function will print the error encountered to give you more info on why it failed to connect.

Additionally, you may be interested in this section on handling errors.

answered May 9, 2018 at 20:53

kurtisvg

3,5851 gold badge10 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Dinesh Kumar Over a year ago

thanks , but question is based on google cloud (App Engine/NodeJS)

kurtisvg Over a year ago

@DineshKumar Nothing about the problem described in your question is specific to Google Cloud (or App Engine). You are trying to perform an operation on a connection that failed - if you want to find out why the connection failed, you will need to handle the failure as described above.

Collectives™ on Stack Overflow

CloudSQL connection issues with deployed Bookshelf tutorial app (App Engine/NodeJS)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related