dimanche 19 avril 2015

Azure SQL Read timeout

The following code



var query = {
identifier: identifier,
state: commons.OTP_TOKEN_LIFECYCLE_STATES.UNUSED
};

this.store.where(query).take(1).read({
success: function(results){
console.log('Got some kickass randomness');
resolve(results);
},

error: function(err){
console.log("Error while reading the data");
console.error(err);
reject({});
}
});


Fails giving a timeout on azure mobile backend services. This.table is a reference to the table "otp tokens".


I have tried many things from changing the node.js version to updating the mssql driver installed on the server. But IT NEVER WORKS.


More intrestingly writes are extremely fast.


I also added a logger to log "read" from the "otp tokens" table, to my surprise it never fires.


Anybody got an insight in what is going on ?


Aucun commentaire:

Enregistrer un commentaire