CODEWITHSUNDEEP
node.jsazureguidazure-storageazure-table-storage
Bitsian
Bitsian

Reputation: 2256

Not able to add entities to a azure storage table in node.js when deployed to cloud?

I am using socket.io in node.js to implement chat functionality in my azure cloud project. In it i have been adding the user chat history to tables using node.js. It works fine when i run it on my local emulator, but strangely when i deploy to my azure cloud it doesnt work and it doesnt throw up any error either so its really mind boggling. Below is my code.

 var app = require('express')()
  , server = require('http').createServer(app)
  , sio = require('socket.io')
 , redis = require('redis');

var client = redis.createClient();
var io = sio.listen(server,{origins: '*:*'});

io.set("store", new sio.RedisStore);

process.env.AZURE_STORAGE_ACCOUNT = "account";
process.env.AZURE_STORAGE_ACCESS_KEY = "key";

var azure = require('azure');
var chatTableService = azure.createTableService();

createTable("ChatUser");

server.listen(4002);

 socket.on('privateChat', function (data) {        
    var receiver = data.Receiver;
    console.log(data.Username);

    var chatGUID1 = 'xxxxxxxx-xxxx-4xxx-yxxx-xxxxxxxxxxxx'.replace(/[xy]/g, function(c) {
        var r = Math.random()*16|0, v = c == 'x' ? r : (r&0x3|0x8);
        return v.toString(16);
    });

 var chatRecord1 = {
        PartitionKey: data.Receiver,
        RowKey: data.Username,
        ChatID: chatGUID2,
        Username: data.Receiver,
        ChattedWithUsername: data.Username,
        Timestamp: new Date(new Date().getTime())
    };
    console.log(chatRecord1.Timestamp);

    queryEntity(chatRecord1);
}

function queryEntity(record1) {
chatTableService.queryEntity('ChatUser'
, record1.PartitionKey
, record1.RowKey
, function (error, entity) {
    if (!error) {
        console.log("Entity already exists")
    }
    else {
        insertEntity(record1);            
    }
})    
}

function insertEntity(record) {
chatTableService.insertEntity('ChatUser', record, function (error) {
    if (!error) {
        console.log("Entity inserted");
    }        
});
}

Its working on my local emulator but not on cloud and I came across a reading that DateTime variable of an entity should not be null when creating a record on cloud table. But am pretty sure the way am passing timestamp is fine, it is right? any other ideas why it might be working on local but not on cloud?

EDIT:

I hav also been getting this error when am running the socket.io server, but in spite of this error the socket.io functionality is working fine so i didnt bother to care about it. I have no idea what the error means in the first place.

{ [Error: connect ECONNREFUSED]
  code: 'ECONNREFUSED',
  errno: 'ECONNREFUSED',
  syscall: 'connect' }

Upvotes: 1

Views: 634

Answers (1)

Larry Franks
Larry Franks

Reputation: 431

Couple things:

  • You shouldn't need to set Timestamp, the service should be populating that automatically when you insert a record.

  • When running it locally you can set the environment variables to the Windows Azure storage account settings and see if it will successfully write to the table when running on your developer box. Instead of running in the emulator, just set the environment variables and run the app directly with node.exe.

Are you running in a web role or worker role? I'm assuming it's a cloud service since you mentioned the emulator. If it's a worker role, maybe add some instrumentation to log to file to assist in debugging. If it's a web role you can add an iisnode.yml file in the root of the application, with the following line in the file to enable logging of stdout/stderr:

loggingEnabled: true

This will capture stdout/stderr to an iislog folder under the approot folder on e: or f: of the web role instance. You can remote desktop to the instance and look at the logs to see if the logs you have for successful insertion are occurring.

Otherwise, it's not obvious from the code above what's going on. Similar code worked fine for me. Relevant bits for my test code can be found at https://gist.github.com/Blackmist/5326756.

Hope this helps.

Upvotes: 2

Related Questions