Open ear-dev opened 4 years ago
@shubhsherl Sorry it has taken me so long to get you this error message. This is what I am seeing on the server side when I try to do a spotlight search. I hope it helps. I'm not sure how my user got into this bad state.
server.js:204 Meteor ➔ method spotlight -> userId: rTQJN7BthzWFDp6iE, arguments: ["tet",{"0":{"name":"eric","username":"eric","_id":"rTQJN7BthzWFDp6iE"}},{"users":true,"rooms":true}]
Exception while invoking method 'spotlight' MongoError: error processing query: ns=rocketchat.users limit=5Tree: $and
$or
settings.preferences.discoverability $eq "all"
$not
settings.preferences exists
$or
email regex /tet/i
TEXT : query=tet, language=none, caseSensitive=0, diacriticSensitive=0, tag=NULL
active $eq true
username exists
$not
username $eq { name: "eric", username: "eric", _id: "rTQJN7BthzWFDp6iE" }
Sort: { username: 1 }
Proj: { username: 1, name: 1, status: 1, statusText: 1 }
No query solutions
at Connection.
@ear-dev Can you confirm if notablescan
is disabled in Viasat deployment.
https://dba.stackexchange.com/a/223232
@shubhsherl confirmed. notablescan is false
@ear-dev The issue might occur after the version change of mongo while upstream catchup in develop_pwa. https://jira.mongodb.org/browse/SERVER-38309?focusedCommentId=2105325&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-2105325
@shubhsherl I dumped and restored our db on the dev server and that issue went away. Awesome!! Thanks for looking into that. It's good to understand and to know that we have an easy fix if we get into that state again. I'm hoping that those, "internal server error" messages will also go away.
This has happened to me twice. For some reason my user gets into a bad state where search does nothing at all. Logging in with a different user works fine.
I'm not sure how to debug this. Is there some database value that got messed up that might cause this?