Info

Auto-completion after `db.` sends a listCollection to the server, which may be blocked on locks. In 4.0, the lifespan of a lock could be much longer than before due to transactions. When a 'dropDatabase' is waiting on the global lock in X mode which is acquired by an inactive transaction in IX mode, listCollection will be blocked. The behavior is expected, but when a user notices the blocking dropDatabase and wants to inspect and kill the current operation, the user cannot use auto-completion. Otherwise, the shell hangs after the > db.cur Using maxTimeMS with listCommand could fix the usability issue.

Top User Comments

xgen-internal-githook commented on Fri, 26 Apr 2019 19:18:25 +0000: Author: {'name': 'A. Jesse Jiryu Davis', 'username': 'ajdavis', 'email': 'jesse@mongodb.com'} Message: SERVER-35638 Short timeout to autocomplete collection names Also resolves SERVER-40736, test autocompletion of collection names for users without the listCollections permission. Branch: master https://github.com/mongodb/mongo/commit/b6cc1fb89f8fbf92c66ef6274a1de1ad310b2fb1 xgen-internal-githook commented on Wed, 24 Apr 2019 18:42:39 +0000: Author: {'email': 'justin.seyster@mongodb.com', 'name': 'Justin Seyster', 'username': 'jseyster'} Message: Revert "SERVER-35638 Short timeout to autocomplete collection names" This reverts commit f202c4c1ba24b9f561e8b11dac5b04fa0eeb4919. Branch: master https://github.com/mongodb/mongo/commit/0e9dcfbff4846e848b82e9c99f0d950dd7eaeae1 xgen-internal-githook commented on Wed, 24 Apr 2019 14:49:10 +0000: Author: {'name': 'A. Jesse Jiryu Davis', 'username': 'ajdavis', 'email': 'jesse@mongodb.com'} Message: SERVER-35638 Short timeout to autocomplete collection names Also resolves SERVER-40736, test autocompletion of collection names for users without the listCollections permission. Branch: master https://github.com/mongodb/mongo/commit/f202c4c1ba24b9f561e8b11dac5b04fa0eeb4919 jesse commented on Fri, 19 Apr 2019 18:25:36 +0000: alyson.cabral see SERVER-40736. alyson.cabral commented on Fri, 19 Apr 2019 03:18:03 +0000: I think doing this ticket is valuable. But yes, I think we should also open another ticket. jesse commented on Wed, 17 Apr 2019 21:29:37 +0000: alyson.cabral I'm just reading this ticket for the first time. Can you explain what the list collections privilege has to do with this ticket? I thought this ticket's issue was concerned with transactions blocking listCollections, but not anything to do with privileges. Are you suggesting we should open a separate ticket? That ticket would be to enable, for auto-completion, the same privilege workaround we implemented for "show dbs" and "show collections". alyson.cabral commented on Wed, 23 Jan 2019 01:30:35 +0000: Many users in atlas do not have the list collections privilege. I'm more interested in getting this to work for all of our users in the same way we got show dbs and show collections working. greg.mckeon commented on Mon, 18 Jun 2018 18:39:25 +0000: Assigning this to neweng to determine if we can just fix this with maxtimems. siyuan.zhou@10gen.com commented on Sat, 16 Jun 2018 05:39:53 +0000: CC'ing max.hirschhorn for the shell issue.

Steps to Reproduce