Live query not working

[c0sm1cdus7]

New Issue Checklist

• I am not disclosing a vulnerability.
• I am not just asking a question.
• I have searched through existing issues.
• I can reproduce the issue with the latest version of Parse Server.

Issue Description

I'm facing an issue with live queries.
The client receives the "open" event but doesn't receive the "create" or "update" events.

Server setup:

var app = express();
app.use(compression());
app.enable('trust proxy');
app.use(bodyParser.json({limit: '50mb'}));
app.use(compression());
app.use(cookieParser());
app.use(device.capture());

app.use('/parse', new ParseServer({
    databaseURI: DATABASE_URI,
    appId: APP_ID,
    masterKey: MASTER_KEY,
    serverURL: 'http://localhost/parse',
    cloud: __dirname + '/cloud/main.js',
    liveQuery: {
        classNames: ['Order', 'Sale']
    }
}));

app.set('view engine', 'ejs');
app.use('/', routes);

const httpServer = require('http').createServer(app);
httpServer.listen(80);
var parseLiveQueryServer = ParseServer.createLiveQueryServer(httpServer);

Client setup:

Parse.initialize(APP_ID);
Parse.serverURL = 'http://localhost/parse';

var query = new Parse.Query('Sale');
query.equalTo('status','pending');
var subscription = await query.subscribe();

subscription.on('open', () => {
    console.log('subscription opened');
});

subscription.on('create', (object) => {
    console.log('object created',object);
});

subscription.on('update', (object) => {
    console.log('object updated',object);
});

Environment

"axios": "^0.21.1",
"body-parser": "^1.19.0",
"card-validator": "^8.1.1",
"compression": "^1.7.4",
"cookie-parser": "^1.4.5",
"coordenadas-do-cep": "^1.2.0",
"ejs": "^3.1.5",
"excel4node": "^1.7.2",
"express": "^4.17.1",
"express-device": "^0.4.2",
"fs": "0.0.1-security",
"http": "0.0.1-security",
"https": "^1.0.0",
"image-search-google": "^1.3.0",
"parse-dashboard": "^2.1.0",
"parse-server": "^4.5.0",
"path": "^0.12.7",
"request": "^2.88.2",
"serve-favicon": "^2.5.0",
"shelljs": "^0.8.4"

Server

• Parse Server version: ^4.5.0
• Operating system: Windows & Linux
• Local or remote host: localhost

Database

• System : MongoDB
• Database version: v4.4.6
• Local or remote host: Google Cloud

Client

• SDK: JavaScript
• SDK version: 3.3.0

Logs

info: Create new client: 3e332475-fabe-488c-9a9c-fd6b69cc3ce6

[mtrezza]

Thanks for reporting. Can you try to reproduce this in a PR with a failing test?

[c0sm1cdus7]

I think my problem is with scalability. I'm running my parse server on multiple cores so how would I go on about doing this?

I've created a redis server on my local machine running on port :6379

Server:

app.use('/parse', new ParseServer({
    databaseURI: DATABASE_URI,
    appId: APP_ID,
    masterKey: MASTER_KEY,
    serverURL: 'http://localhost/parse',
    cloud: __dirname + '/cloud/main.js',
    liveQuery: {
        classNames: ['Order', 'Sale'],
        redisURL: 'redis://localhost:6379'
    }
}));

var httpServer = require('http').createServer(app);
httpServer.listen(80);
var parseLiveQueryServer = ParseServer.createLiveQueryServer(httpServer,{
    redisURL: 'redis://localhost:6379'
});

Client:

Parse.initialize(APP_ID);
Parse.serverURL = 'http://localhost/parse';

However I only receive events when running in single core. Am I missing something?

[mtrezza]

I'm closing this as it does not seem to be a Parse Server issue.

For help with Parse Server, here are some resources you can try:

• For code-level questions we recommend Stack Overflow using the parse-platform tag.
• For network and server questions we recommend ServerFault using the parse-server tag
• For questions that are not appropriate for the above mentioned sites we recommend our community forum.

Feel free to comment if you have any questions and we can re-open this issue.

[ckarmy]

@franalt you resolve this issue? I have the same problem with pm2 cluster mode

[MaidaShahid]

@franalt How did you resolve this issue?
"I'm facing an issue with live queries.
The client receives the "open" event but doesn't receive the "create" or "update" events."

I'm facing the same issue.. is there a solution without the redis server?

[MaidaShahid]

@ckarmy were you able to resolve your issue?

[ckarmy]

@ckarmy were you able to resolve your issue?

No :( I couldn't figure out how to make it work!

[mtrezza]

Is it the same issue as in the description? If so, we can re-open the issue, otherwise please open a new issue.

[MaidaShahid]

@mtrezza Yes, its the same issue.. kindly reopen it..

[MaidaShahid]

Is it the same issue as in the description? If so, we can re-open the issue, otherwise please open a new issue.

i even tried with redis server to scale it. but i got the same issue. i'm able to trigger the subscription open event. But the subscription create, update, delete etc events are not triggered..

[MaidaShahid]

@ckarmy were you able to resolve your issue?

No :( I couldn't figure out how to make it work!

So, what was the work around that you did, instead of using live query..?? Kindly can you tell..