[SERVER-58697] A specific query on an indexed field breaks the server Created: 20/Jul/21  Updated: 22/Jul/21  Resolved: 22/Jul/21

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Сергей Панарин Assignee: Eric Sedor
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Steps To Reproduce:

1. run mongodb in docker image 4.1.13 and call in mongo shell

db.tests.insertOne({ status: 'test' })
db.tests.createIndex({ status: 1})
db.tests.find({ 'status': { '$nin': [null,''] }})

Participants:

 Description   

2021-07-20T15:03:20.017+0000 F  -        [conn1] Got signal: 6 (Aborted).
 0x561518d43161 0x561518d4295e 0x561518d429f6 0x7f9c8fb7f890 0x7f9c8f7bae97 0x7f9c8f7bc801 0x56151728e442 0x5615171fb2b0 0x5615188f69eb 0x5615188c4ae1 0x5615188c7119 0x5615188c739e 0x5615188e19f8 0x561517b78790 0x561517b79a89 0x561517b79c56 0x561517b79d2f 0x56151797dfc2 0x5615176ce1b1 0x5615176cfbe4 0x5615176d0a8e 0x5615176d1360 0x5615176bf34c 0x5615176cb0fc 0x5615176c691f 0x5615176c9ccc 0x5615184745f2 0x5615176c434d 0x5615176c76fd 0x5615176c5a17 0x5615176c687b 0x5615176c9ccc 0x561518474a5b 0x561518ad4624 0x7f9c8fb746db 0x7f9c8f89d88f
----- BEGIN BACKTRACE -----
{"backtrace":[{"b":"5615165FE000","o":"2745161","s":"_ZN5mongo15printStackTraceERSo"},{"b":"5615165FE000","o":"274495E"},{"b":"5615165FE000","o":"27449F6"},{"b":"7F9C8FB6D000","o":"12890"},{"b":"7F9C8F77C000","o":"3EE97","s":"gsignal"},{"b":"7F9C8F77C000","o":"40801","s":"abort"},{"b":"5615165FE000","o":"C90442","s":"_ZN5mongo22invariantFailedWithMsgEPKcRKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES1_j"},{"b":"5615165FE000","o":"BFD2B0"},{"b":"5615165FE000","o":"22F89EB","s":"_ZN5mongo18IndexBoundsBuilder9translateEPKNS_15MatchExpressionERKNS_11BSONElementERKNS_10IndexEntryEPNS_19OrderedIntervalListEPNS0_15BoundsTightnessE"},{"b":"5615165FE000","o":"22C6AE1","s":"_ZN5mongo18QueryPlannerAccess12makeLeafNodeERKNS_14CanonicalQueryERKNS_10IndexEntryEmPKNS_15MatchExpressionEPNS_18IndexBoundsBuilder15BoundsTightnessE"},{"b":"5615165FE000","o":"22C9119","s":"_ZN5mongo18QueryPlannerAccess23_buildIndexedDataAccessERKNS_14CanonicalQueryEPNS_15MatchExpressionESt10unique_ptrIS4_St14default_deleteIS4_EERKSt6vectorINS_10IndexEntryESaISB_EERKNS_18QueryPlannerParamsE"},{"b":"5615165FE000","o":"22C939E","s":"_ZN5mongo18QueryPlannerAccess22buildIndexedDataAccessERKNS_14CanonicalQueryESt10unique_ptrINS_15MatchExpressionESt14default_deleteIS5_EERKSt6vectorINS_10IndexEntryESaISA_EERKNS_18QueryPlannerParamsE"},{"b":"5615165FE000","o":"22E39F8","s":"_ZN5mongo12QueryPlanner4planERKNS_14CanonicalQueryERKNS_18QueryPlannerParamsE"},{"b":"5615165FE000","o":"157A790"},{"b":"5615165FE000","o":"157BA89","s":"_ZN5mongo11getExecutorEPNS_16OperationContextEPNS_10CollectionESt10unique_ptrINS_14CanonicalQueryESt14default_deleteIS5_EENS_12PlanExecutor11YieldPolicyEm"},{"b":"5615165FE000","o":"157BC56"},{"b":"5615165FE000","o":"157BD2F","s":"_ZN5mongo15getExecutorFindEPNS_16OperationContextEPNS_10CollectionESt10unique_ptrINS_14CanonicalQueryESt14default_deleteIS5_EEbm"},{"b":"5615165FE000","o":"137FFC2"},{"b":"5615165FE000","o":"10D01B1"},{"b":"5615165FE000","o":"10D1BE4"},{"b":"5615165FE000","o":"10D2A8E"},{"b":"5615165FE000","o":"10D3360","s":"_ZN5mongo23ServiceEntryPointCommon13handleRequestEPNS_16OperationContextERKNS_7MessageERKNS0_5HooksE"},{"b":"5615165FE000","o":"10C134C","s":"_ZN5mongo23ServiceEntryPointMongod13handleRequestEPNS_16OperationContextERKNS_7MessageE"},{"b":"5615165FE000","o":"10CD0FC","s":"_ZN5mongo19ServiceStateMachine15_processMessageENS0_11ThreadGuardE"},{"b":"5615165FE000","o":"10C891F","s":"_ZN5mongo19ServiceStateMachine15_runNextInGuardENS0_11ThreadGuardE"},{"b":"5615165FE000","o":"10CBCCC"},{"b":"5615165FE000","o":"1E765F2","s":"_ZN5mongo9transport26ServiceExecutorSynchronous8scheduleESt8functionIFvvEENS0_15ServiceExecutor13ScheduleFlagsENS0_23ServiceExecutorTaskNameE"},{"b":"5615165FE000","o":"10C634D","s":"_ZN5mongo19ServiceStateMachine22_scheduleNextWithGuardENS0_11ThreadGuardENS_9transport15ServiceExecutor13ScheduleFlagsENS2_23ServiceExecutorTaskNameENS0_9OwnershipE"},{"b":"5615165FE000","o":"10C96FD","s":"_ZN5mongo19ServiceStateMachine15_sourceCallbackENS_6StatusE"},{"b":"5615165FE000","o":"10C7A17","s":"_ZN5mongo19ServiceStateMachine14_sourceMessageENS0_11ThreadGuardE"},{"b":"5615165FE000","o":"10C887B","s":"_ZN5mongo19ServiceStateMachine15_runNextInGuardENS0_11ThreadGuardE"},{"b":"5615165FE000","o":"10CBCCC"},{"b":"5615165FE000","o":"1E76A5B"},{"b":"5615165FE000","o":"24D6624"},{"b":"7F9C8FB6D000","o":"76DB"},{"b":"7F9C8F77C000","o":"12188F","s":"clone"}],"processInfo":{ "mongodbVersion" : "4.1.13", "gitVersion" : "441714bc4c70699950f3ac51a5cac41dcd413eaa", "compiledModules" : [], "uname" : { "sysname" : "Linux", "release" : "5.10.25-linuxkit", "version" : "#1 SMP Tue Mar 23 09:27:39 UTC 2021", "machine" : "x86_64" }, "somap" : [ { "b" : "5615165FE000", "elfType" : 3, "buildId" : "673453B816C9E12323AE90344284FDBDD575F62A" }, { "b" : "7FFCD7575000", "path" : "linux-vdso.so.1", "elfType" : 3, "buildId" : "934C1CA8868CD26C1CE992EAA04B3E7E960CE834" }, { "b" : "7F9C910C1000", "path" : "/usr/lib/x86_64-linux-gnu/libcurl.so.4", "elfType" : 3, "buildId" : "20310A72634F3373FA7BCAB64DFB64CC204554B2" }, { "b" : "7F9C90EA6000", "path" : "/lib/x86_64-linux-gnu/libresolv.so.2", "elfType" : 3, "buildId" : "390E9CC4C215314B6D8ADE6D6E28F8518418039C" }, { "b" : "7F9C909DB000", "path" : "/usr/lib/x86_64-linux-gnu/libcrypto.so.1.1", "elfType" : 3, "buildId" : "CB6876717C83B0CC01C3C919B9B6E86D8554F546" }, { "b" : "7F9C9074E000", "path" : "/usr/lib/x86_64-linux-gnu/libssl.so.1.1", "elfType" : 3, "buildId" : "439A262CC0127BA401707DEC7A28884D617550E0" }, { "b" : "7F9C9054A000", "path" : "/lib/x86_64-linux-gnu/libdl.so.2", "elfType" : 3, "buildId" : "25AD56E902E23B490A9CCDB08A9744D89CB95BCC" }, { "b" : "7F9C90342000", "path" : "/lib/x86_64-linux-gnu/librt.so.1", "elfType" : 3, "buildId" : "9826FBDF57ED7D6965131074CB3C08B1009C1CD8" }, { "b" : "7F9C8FFA4000", "path" : "/lib/x86_64-linux-gnu/libm.so.6", "elfType" : 3, "buildId" : "A33761AB8FB485311B3C85BF4253099D7CABE653" }, { "b" : "7F9C8FD8C000", "path" : "/lib/x86_64-linux-gnu/libgcc_s.so.1", "elfType" : 3, "buildId" : "41BDC55C07D5E5B1D8AB38E2C19B1F535855E084" }, { "b" : "7F9C8FB6D000", "path" : "/lib/x86_64-linux-gnu/libpthread.so.0", "elfType" : 3, "buildId" : "28C6AADE70B2D40D1F0F3D0A1A0CAD1AB816448F" }, { "b" : "7F9C8F77C000", "path" : "/lib/x86_64-linux-gnu/libc.so.6", "elfType" : 3, "buildId" : "B417C0BA7CC5CF06D1D1BED6652CEDB9253C60D0" }, { "b" : "7F9C91340000", "path" : "/lib64/ld-linux-x86-64.so.2", "elfType" : 3, "buildId" : "64DF1B961228382FE18684249ED800AB1DCEAAD4" }, { "b" : "7F9C8F557000", "path" : "/usr/lib/x86_64-linux-gnu/libnghttp2.so.14", "elfType" : 3, "buildId" : "4F00E5207693FDC249DA42EC6472ACA6A7B929AE" }, { "b" : "7F9C8F33A000", "path" : "/usr/lib/x86_64-linux-gnu/libidn2.so.0", "elfType" : 3, "buildId" : "BA5BF9A5C44F48C647E9D8270A5421AE81CCAD61" }, { "b" : "7F9C8F11E000", "path" : "/usr/lib/x86_64-linux-gnu/librtmp.so.1", "elfType" : 3, "buildId" : "69465D8AA6B19086ABF2455A703F9168BF82A69F" }, { "b" : "7F9C8EF10000", "path" : "/usr/lib/x86_64-linux-gnu/libpsl.so.5", "elfType" : 3, "buildId" : "CDAF1F1946846941F9D06414EC8C812D131A168E" }, { "b" : "7F9C8ECC5000", "path" : "/usr/lib/x86_64-linux-gnu/libgssapi_krb5.so.2", "elfType" : 3, "buildId" : "00F419F64B0E70D8C5EEF7050369AA40B2A6E090" }, { "b" : "7F9C8EA73000", "path" : "/usr/lib/x86_64-linux-gnu/libldap_r-2.4.so.2", "elfType" : 3, "buildId" : "E8A505FFF184C54BB6652424E44B852FBE27AACD" }, { "b" : "7F9C8E865000", "path" : "/usr/lib/x86_64-linux-gnu/liblber-2.4.so.2", "elfType" : 3, "buildId" : "51B4F4B81488AADD19CC5817B9ABBB5B94BDE07F" }, { "b" : "7F9C8E648000", "path" : "/lib/x86_64-linux-gnu/libz.so.1", "elfType" : 3, "buildId" : "EF3E006DFE3132A41D4D4DC0E407D6EA658E11C4" }, { "b" : "7F9C8E2CA000", "path" : "/usr/lib/x86_64-linux-gnu/libunistring.so.2", "elfType" : 3, "buildId" : "0E2784298E7D3F4D894FE130ACEFA77C3E624F72" }, { "b" : "7F9C8DF65000", "path" : "/usr/lib/x86_64-linux-gnu/libgnutls.so.30", "elfType" : 3, "buildId" : "E5AE5C31F804BE96532D0DB2091F19E472F2D4A0" }, { "b" : "7F9C8DD31000", "path" : "/usr/lib/x86_64-linux-gnu/libhogweed.so.4", "elfType" : 3, "buildId" : "842BDF0B0EAAB82E19F1EABFC38769F4040FBE31" }, { "b" : "7F9C8DAFB000", "path" : "/usr/lib/x86_64-linux-gnu/libnettle.so.6", "elfType" : 3, "buildId" : "C20D4B3BA13FCDCC3BF6857689BA9FC70BE3F6A5" }, { "b" : "7F9C8D87A000", "path" : "/usr/lib/x86_64-linux-gnu/libgmp.so.10", "elfType" : 3, "buildId" : "D40EA9B5EC5BC46799E4A412319617BD38BE9341" }, { "b" : "7F9C8D5A4000", "path" : "/usr/lib/x86_64-linux-gnu/libkrb5.so.3", "elfType" : 3, "buildId" : "69FBCF425EE6DF03DE93B82FBC2FC33790E68A96" }, { "b" : "7F9C8D372000", "path" : "/usr/lib/x86_64-linux-gnu/libk5crypto.so.3", "elfType" : 3, "buildId" : "F400D5D643A7F9696DF0E6148FA99BEE6C1BDDF7" }, { "b" : "7F9C8D16E000", "path" : "/lib/x86_64-linux-gnu/libcom_err.so.2", "elfType" : 3, "buildId" : "C0CB7E35A4566A443F99DFBC1A54D3A0677C8A10" }, { "b" : "7F9C8CF63000", "path" : "/usr/lib/x86_64-linux-gnu/libkrb5support.so.0", "elfType" : 3, "buildId" : "D78D71E8E016A534281B25B97CD7E5E9DB5FE00A" }, { "b" : "7F9C8CD48000", "path" : "/usr/lib/x86_64-linux-gnu/libsasl2.so.2", "elfType" : 3, "buildId" : "ABB7E3F40302E6509DAD1F91DFB1F04B6A5FD072" }, { "b" : "7F9C8CB07000", "path" : "/usr/lib/x86_64-linux-gnu/libgssapi.so.3", "elfType" : 3, "buildId" : "A1A98DB481968073636BBAECB561A3EA8ED198AE" }, { "b" : "7F9C8C7D8000", "path" : "/usr/lib/x86_64-linux-gnu/libp11-kit.so.0", "elfType" : 3, "buildId" : "8DBD451EA5651283905E16FA7DFA9908688893A3" }, { "b" : "7F9C8C5C5000", "path" : "/usr/lib/x86_64-linux-gnu/libtasn1.so.6", "elfType" : 3, "buildId" : "6036B89A3BB671B32E01464C0C82BFA016186352" }, { "b" : "7F9C8C3C1000", "path" : "/lib/x86_64-linux-gnu/libkeyutils.so.1", "elfType" : 3, "buildId" : "F463E107B099910463BC32E837C73D341A52C27B" }, { "b" : "7F9C8C1B8000", "path" : "/usr/lib/x86_64-linux-gnu/libheimntlm.so.0", "elfType" : 3, "buildId" : "C2376C5B831991591F1A67B976758185F86896D8" }, { "b" : "7F9C8BF2B000", "path" : "/usr/lib/x86_64-linux-gnu/libkrb5.so.26", "elfType" : 3, "buildId" : "69BDEE5FA0FEEDF317308BE850F78761861D520A" }, { "b" : "7F9C8BC89000", "path" : "/usr/lib/x86_64-linux-gnu/libasn1.so.8", "elfType" : 3, "buildId" : "315D74995AAA32DE4D15BA25F335066988B1B230" }, { "b" : "7F9C8BA53000", "path" : "/usr/lib/x86_64-linux-gnu/libhcrypto.so.4", "elfType" : 3, "buildId" : "6673972A1C24A89EBAFBAE696188A4CB26C6DDEB" }, { "b" : "7F9C8B83D000", "path" : "/usr/lib/x86_64-linux-gnu/libroken.so.18", "elfType" : 3, "buildId" : "430827C33259C12248CF44B91A9A9821114376F5" }, { "b" : "7F9C8B635000", "path" : "/usr/lib/x86_64-linux-gnu/libffi.so.6", "elfType" : 3, "buildId" : "3555B5F599C9787DFDDBF9E8DF6F706B9044D985" }, { "b" : "7F9C8B40C000", "path" : "/usr/lib/x86_64-linux-gnu/libwind.so.0", "elfType" : 3, "buildId" : "93A0931B1C2818F0EA224CE6FE5E31E84A9B55BB" }, { "b" : "7F9C8B1FD000", "path" : "/usr/lib/x86_64-linux-gnu/libheimbase.so.1", "elfType" : 3, "buildId" : "669D4CCE42FA4382796EFFCF0C16F459F4382C4C" }, { "b" : "7F9C8AFB3000", "path" : "/usr/lib/x86_64-linux-gnu/libhx509.so.5", "elfType" : 3, "buildId" : "4B80C543356EE0AF9039EFE7C9EA1CC1F74C426A" }, { "b" : "7F9C8ACAA000", "path" : "/usr/lib/x86_64-linux-gnu/libsqlite3.so.0", "elfType" : 3, "buildId" : "BCE351987CF42B3D258B09F0CAC867758D935086" }, { "b" : "7F9C8AA72000", "path" : "/lib/x86_64-linux-gnu/libcrypt.so.1", "elfType" : 3, "buildId" : "810686AF0D5FD350A4FB1CC4B5AFF44A05C102CB" } ] }}
 mongod(_ZN5mongo15printStackTraceERSo+0x41) [0x561518d43161]
 mongod(+0x274495E) [0x561518d4295e]
 mongod(+0x27449F6) [0x561518d429f6]
 libpthread.so.0(+0x12890) [0x7f9c8fb7f890]
 libc.so.6(gsignal+0xC7) [0x7f9c8f7bae97]
 libc.so.6(abort+0x141) [0x7f9c8f7bc801]
 mongod(_ZN5mongo22invariantFailedWithMsgEPKcRKNSt7__cxx1112basic_stringIcSt11char_traitsIcESaIcEEES1_j+0x0) [0x56151728e442]
 mongod(+0xBFD2B0) [0x5615171fb2b0]
 mongod(_ZN5mongo18IndexBoundsBuilder9translateEPKNS_15MatchExpressionERKNS_11BSONElementERKNS_10IndexEntryEPNS_19OrderedIntervalListEPNS0_15BoundsTightnessE+0x1B) [0x5615188f69eb]
 mongod(_ZN5mongo18QueryPlannerAccess12makeLeafNodeERKNS_14CanonicalQueryERKNS_10IndexEntryEmPKNS_15MatchExpressionEPNS_18IndexBoundsBuilder15BoundsTightnessE+0x1E1) [0x5615188c4ae1]
 mongod(_ZN5mongo18QueryPlannerAccess23_buildIndexedDataAccessERKNS_14CanonicalQueryEPNS_15MatchExpressionESt10unique_ptrIS4_St14default_deleteIS4_EERKSt6vectorINS_10IndexEntryESaISB_EERKNS_18QueryPlannerParamsE+0x219) [0x5615188c7119]
 mongod(_ZN5mongo18QueryPlannerAccess22buildIndexedDataAccessERKNS_14CanonicalQueryESt10unique_ptrINS_15MatchExpressionESt14default_deleteIS5_EERKSt6vectorINS_10IndexEntryESaISA_EERKNS_18QueryPlannerParamsE+0x3E) [0x5615188c739e]
 mongod(_ZN5mongo12QueryPlanner4planERKNS_14CanonicalQueryERKNS_18QueryPlannerParamsE+0x1F98) [0x5615188e19f8]
 mongod(+0x157A790) [0x561517b78790]
 mongod(_ZN5mongo11getExecutorEPNS_16OperationContextEPNS_10CollectionESt10unique_ptrINS_14CanonicalQueryESt14default_deleteIS5_EENS_12PlanExecutor11YieldPolicyEm+0x89) [0x561517b79a89]
 mongod(+0x157BC56) [0x561517b79c56]
 mongod(_ZN5mongo15getExecutorFindEPNS_16OperationContextEPNS_10CollectionESt10unique_ptrINS_14CanonicalQueryESt14default_deleteIS5_EEbm+0x6F) [0x561517b79d2f]
 mongod(+0x137FFC2) [0x56151797dfc2]
 mongod(+0x10D01B1) [0x5615176ce1b1]
 mongod(+0x10D1BE4) [0x5615176cfbe4]
 mongod(+0x10D2A8E) [0x5615176d0a8e]
 mongod(_ZN5mongo23ServiceEntryPointCommon13handleRequestEPNS_16OperationContextERKNS_7MessageERKNS0_5HooksE+0x540) [0x5615176d1360]
 mongod(_ZN5mongo23ServiceEntryPointMongod13handleRequestEPNS_16OperationContextERKNS_7MessageE+0x3C) [0x5615176bf34c]
 mongod(_ZN5mongo19ServiceStateMachine15_processMessageENS0_11ThreadGuardE+0xEC) [0x5615176cb0fc]
 mongod(_ZN5mongo19ServiceStateMachine15_runNextInGuardENS0_11ThreadGuardE+0x17F) [0x5615176c691f]
 mongod(+0x10CBCCC) [0x5615176c9ccc]
 mongod(_ZN5mongo9transport26ServiceExecutorSynchronous8scheduleESt8functionIFvvEENS0_15ServiceExecutor13ScheduleFlagsENS0_23ServiceExecutorTaskNameE+0x182) [0x5615184745f2]
 mongod(_ZN5mongo19ServiceStateMachine22_scheduleNextWithGuardENS0_11ThreadGuardENS_9transport15ServiceExecutor13ScheduleFlagsENS2_23ServiceExecutorTaskNameENS0_9OwnershipE+0x10D) [0x5615176c434d]
 mongod(_ZN5mongo19ServiceStateMachine15_sourceCallbackENS_6StatusE+0x96D) [0x5615176c76fd]
 mongod(_ZN5mongo19ServiceStateMachine14_sourceMessageENS0_11ThreadGuardE+0x2E7) [0x5615176c5a17]
 mongod(_ZN5mongo19ServiceStateMachine15_runNextInGuardENS0_11ThreadGuardE+0xDB) [0x5615176c687b]
 mongod(+0x10CBCCC) [0x5615176c9ccc]
 mongod(+0x1E76A5B) [0x561518474a5b]
 mongod(+0x24D6624) [0x561518ad4624]
 libpthread.so.0(+0x76DB) [0x7f9c8fb746db]
 libc.so.6(clone+0x3F) [0x7f9c8f89d88f]
-----  END BACKTRACE  -----
Aborted



 Comments   
Comment by Eric Sedor [ 22/Jul/21 ]

Got it serpan911@gmail.com, thanks. I'll close this ticket. Check out this documentation. We wouldn't expect it to be useful to be running test environments in 4.1, 4.3, etc. You may end up seeing errors that are part of the development cycle.

Comment by Сергей Панарин [ 21/Jul/21 ]

Hi, on other version(4.2.12) problem not found. Found this problem on one from test server with mongodb 4.1.13, decided this problem update to 4.2.12

I decided to inform you just in case)

Comment by Eric Sedor [ 20/Jul/21 ]

Hi serpan911@gmail.com, and thanks. 4.1.13 is a development version of MongoDB, and am not able to reproduce this on MongoDB 4.2.0+. Have you noticed this issue occurring on any release versions?

Gratefully,
Eric

Generated at Thu Feb 08 05:45:11 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.