Querying db using node-mysql hangs, no error

Question

After creating a simple connection and making sure it works (give it wrong info and it throws an error) I went ahead and tried to query but upon doing so, the server just hangs, no error.

Here is the snippet:

var db = mysql.createConnection({
  host     : config.host,
  user     : config.user,
  password : config.password,
  port     : config.port,
  database : config.database
});

db.connect();

db.query("SELECT 1", function(err, rows) {
  console.log(rows);
});

Is there an error with the connection? How could I catch it if so?

risyasin · Accepted Answer · 2014-12-17 21:16:33Z

1

You probably have an uncaught exception. try this:

process.on('uncaughtException', function (error) {
   console.log(error.stack);
});

answered Dec 17, 2014 at 21:16

risyasin

1,32114 silver badges24 bronze badges

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

2 Comments

ZekeDroid Over a year ago

I did, still just hangs. I assume this should go after the db.query call, right? Not inside the callback

risyasin Over a year ago

Yes. it's only related with nodejs internal (process module) so you can call it on top. and not in any callbacks.

ZekeDroid · Accepted Answer · 2014-12-18 13:01:11Z

1

Turns out, it was the connection after all. In case someone else gets this weird error, there are none to report because it's the connection to the server which hangs. It happens that the password had gotten turned into an integer instead of a string and this plus the "port" field make it hang. If I remove the port field, it immediately throws a connection denied error.

So, for future reference, if the connection hangs, try connecting using a db string instead and if that works, check that every field in this object is a string.

answered Dec 18, 2014 at 13:01

ZekeDroid

7,2095 gold badges36 silver badges59 bronze badges

Comments

ZygD · Accepted Answer · 2015-04-09 20:43:10Z

0

You can check like this:

connection.connect(function (err) {
    if (!err)
        console.log("conncetd");
    else
        console.log(err + "There is problem");
});

edited Apr 9, 2015 at 20:43

ZygD

24.8k41 gold badges106 silver badges144 bronze badges

answered Apr 9, 2015 at 20:00

Piyush

1

Collectives™ on Stack Overflow

Querying db using node-mysql hangs, no error

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related