[COMPASS-6273] "MongoServerSelectionError: connect ECONNREFUSED 127.0.0.1:27017" when running View on large collection Created: 03/Nov/22  Updated: 31/May/23  Resolved: 31/May/23

Status: Closed
Project: Compass
Component/s: Query
Affects Version/s: 1.33.1
Fix Version/s: No version

Type: Bug Priority: Major - P3
Reporter: Felicia Hsieh Assignee: Unassigned
Resolution: Won't Fix Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Mac 12.6
Compass 1.33.1


Attachments: File 636311e6ebe2dd0a023ea848_log.gz     PNG File Screen Shot 2022-11-02 at 7.40.07 PM.png     PNG File Screen Shot 2022-11-02 at 7.46.38 PM.png     PNG File Screen Shot 2022-11-02 at 7.52.38 PM.png    
Story Points: 8
Documentation Changes: Not Needed

 Description   

Problem Statement/Rationale

What is going wrong? What action would you like the Engineering team to take?

Saw "[MongoServerSelectionError:|#]connect ECONNREFUSED 127.0.0.1:27017" when running a View on a very large collection. Laptop is almost out of disk space also.

Please be sure to attach relevant logs with any sensitive data redacted.

Steps to Reproduce

How could an engineer replicate the issue you’re reporting?

"db.LimitView.aggregate([{$match:

{docNumber:1}

} ],{allowDiskUse:true})"

test.things collection has 131.3k documents / 1.27 GB of data

Expected Results

What do you expect to happen?

mongo shell can run this query with {allowDiskUse:true}. It found the 2 instances.

embedded mongosh generates the error described.

After this error in Compass, it's hard to navigate to the other (smaller) collections and databases. It's not behaving as expected. It's much slower and documents are not shown (blank content pane where documents would be). Would prefer graceful recovery from this event.

Actual Results

What do you observe is happening?

When the Compass log file can't be written to, a stacktrace is generated while logged into mongo shell.

MongoDB Enterprise > {"t":{"$date":"2022-11-02T18:45:16.918-07:00"},"s":"F",  "c":"CONTROL",  "id":4522200, "ctx":"conn66","msg":"Writing to log file failed, aborting application","attr":{"files":["/Users/felicia.hsieh/Test/./logs/mongod.log"]}}
BACKTRACE: {"backtrace":[{"a":"105032C33","b":"102406000","o":"2C2CC33","s":"_ZN5mongo18stack_trace_detail12_GLOBAL__N_119printStackTraceImplERKNS1_7OptionsEPNS_14StackTraceSinkE","s+":"123"},\{"a":"105033E7D","b":"102406000","o":"2C2DE7D","s":"_ZN5mongo15printStackTraceERNSt3__113basic_ostreamIcNS0_11char_traitsIcEEEE","s+":"3D"},\{"a":"104FFCF07","b":"102406000","o":"2BF6F07","s":"_ZN5mongo5logv214FileRotateSink7consumeERKN5boost3log12v2s_mt_posix11record_viewERKNSt3__112basic_stringIcNS8_11char_traitsIcEENS8_9allocatorIcEEEE","s+":"4F7"},\{"a":"105016998","b":"102406000","o":"2C10998","s":"_ZN5mongo5logv216CompositeBackendIJNS0_14FileRotateSinkENS0_10RamLogSinkES3_NS0_14UserAssertSinkEEE10consumeAllIJLm0ELm1ELm2ELm3EEEEvRKN5boost3log12v2s_mt_posix11record_viewERKNSt3__112basic_stringIcNSD_11char_traitsIcEENSD_9allocatorIcEEEENSD_16integer_sequenceImJXspT_EEEE","s+":"48"},\{"a":"10501679E","b":"102406000","o":"2C1079E","s":"_ZN5boost3log12v2s_mt_posix5sinks30basic_formatting_sink_frontendIcE11feed_recordINS1_3aux10fake_mutexEN5mongo5logv216CompositeBackendIJNS9_14FileRotateSinkENS9_10RamLogSinkESC_NS9_14UserAssertSinkEEEEEEvRKNS1_11record_viewERT_RT0_","s+":"DE"},\{"a":"105016646","b":"102406000","o":"2C10646","s":"_ZN5boost3log12v2s_mt_posix5sinks13unlocked_sinkIN5mongo5logv216CompositeBackendIJNS5_14FileRotateSinkENS5_10RamLogSinkES8_NS5_14UserAssertSinkEEEEE7consumeERKNS1_11record_viewE","s+":"26"},\{"a":"105012B2A","b":"102406000","o":"2C0CB2A","s":"_ZN5boost3log12v2s_mt_posix5sinks4sink11try_consumeERKNS1_11record_viewE","s+":"A"},\{"a":"105124EA5","b":"102406000","o":"2D1EEA5","s":"_ZN5boost3log12v2s_mt_posix4core16push_record_moveERNS1_6recordE","s+":"1B5"},\{"a":"105009D55","b":"102406000","o":"2C03D55","s":"_ZN5mongo5logv29LogSource11push_recordEON5boost3log12v2s_mt_posix6recordE","s+":"15"},\{"a":"1050098F5","b":"102406000","o":"2C038F5","s":"_ZN5mongo5logv26detail9doLogImplEiRKNS0_11LogSeverityERKNS0_10LogOptionsENS_10StringDataERKNS0_26TypeErasedAttributeStorageE","s+":"255"},\{"a":"103DDB93D","b":"102406000","o":"19D593D","s":"_ZN5mongo5CurOp23completeAndLogOperationEPNS_16OperationContextENS_5logv212LogComponentEN5boost8optionalImEENS6_IxEEb","s+":"78D"},\{"a":"10246BBB3","b":"102406000","o":"65BB3","s":"_ZN5mongo14future_details10statusCallIRZNS_23ServiceEntryPointCommon13handleRequestEPNS_16OperationContextERKNS_7MessageENSt3__110unique_ptrIKNS2_5HooksENS8_14default_deleteISB_EEEEE4$_39JNS_10DbResponseEEEEDaOT_DpOT0_","s+":"123"},\{"a":"102446E7A","b":"102406000","o":"40E7A","s":"_ZN5mongo23ServiceEntryPointCommon13handleRequestEPNS_16OperationContextERKNS_7MessageENSt3__110unique_ptrIKNS0_5HooksENS6_14default_deleteIS9_EEEE","s+":"5DA"},\{"a":"102443D02","b":"102406000","o":"3DD02","s":"_ZN5mongo23ServiceEntryPointMongod13handleRequestEPNS_16OperationContextERKNS_7MessageE","s+":"52"},\{"a":"102491057","b":"102406000","o":"8B057","s":"_ZN5mongo9transport19ServiceStateMachine4Impl14processMessageEv","s+":"207"},\{"a":"10249679D","b":"102406000","o":"9079D","s":"_ZZNO5mongo14future_details10FutureImplINS0_8FakeVoidEE4thenIZNS_9transport19ServiceStateMachine4Impl12startNewLoopERKNS_6StatusEE4$_10EEDaOT_ENKUlOS2_E_clESF_","s+":"2D"},\{"a":"1024920E0","b":"102406000","o":"8C0E0","s":"_ZN5mongo9transport19ServiceStateMachine4Impl12startNewLoopERKNS_6StatusE","s+":"110"},\{"a":"1024973DF","b":"102406000","o":"913DF","s":"_ZZN5mongo15unique_functionIFvNS_6StatusEEE8makeImplIZNS_9transport19ServiceStateMachine4Impl15scheduleNewLoopES1_E3$_7EEDaOT_EN12SpecificImpl4callEOS1_","s+":"5F"},\{"a":"104974590","b":"102406000","o":"256E590","s":"_ZZN5mongo15unique_functionIFvNS_6StatusEEE8makeImplIZNS_9transport26ServiceExecutorSynchronous18runOnDataAvailableERKNSt3__110shared_ptrINS5_7SessionEEES3_E3$_5EEDaOT_EN12SpecificImpl4callEOS1_","s+":"40"},\{"a":"104970ED9","b":"102406000","o":"256AED9","s":"_ZZN5mongo9transport15ServiceExecutor8scheduleENS_15unique_functionIFvNS_6StatusEEEEENUlvE_clEv","s+":"39"},\{"a":"10497423C","b":"102406000","o":"256E23C","s":"_ZZN5mongo15unique_functionIFvvEE8makeImplIZNS_9transport26ServiceExecutorSynchronous12scheduleTaskES2_NS4_15ServiceExecutor13ScheduleFlagsEE3$_4EEDaOT_EN12SpecificImpl4callEv","s+":"18C"},\{"a":"104975088","b":"102406000","o":"256F088","s":"_ZN5mongo12_GLOBAL__N_17runFuncEPv","s+":"18"},\{"a":"7FF81477D4E1","b":"7FF814777000","o":"64E1","s":"_pthread_start","s+":"7D"},\{"a":"7FF814778F6B","b":"7FF814777000","o":"1F6B","s":"thread_start","s+":"F"}],"processInfo":{"mongodbVersion":"5.0.5","gitVersion":"d65fd89df3fc039b5c55933c0f71d647a54510ae","compiledModules":["enterprise"],"uname":{"sysname":"Darwin","release":"21.6.0","version":"Darwin Kernel Version 21.6.0: Mon Aug 22 20:17:10 PDT 2022; root:xnu-8020.140.49~2/RELEASE_X86_64","machine":"x86_64"},"somap":[\{"path":"/Users/felicia.hsieh/mongodb-macos-x86_64-enterprise-5.0.5/bin/mongod","machType":2,"b":"102406000","vmaddr":"100000000","buildId":"A907A1E08B4232949CE0378D0BC9FE0B"},\{"path":"/usr/lib/system/libsystem_pthread.dylib","machType":6,"b":"7FF814777000","vmaddr":"7FF80031B000","buildId":"B5454E27E8C73FDBB77F714F1E82E70B"}]}}
  Frame: {"a":"105032C33","b":"102406000","o":"2C2CC33","s":"ZN5mongo18stack_trace_detail12_GLOBAL_N_119printStackTraceImplERKNS1_7OptionsEPNS_14StackTraceSinkE","s+":"123"}
  Frame: {"a":"105033E7D","b":"102406000","o":"2C2DE7D","s":"ZN5mongo15printStackTraceERNSt3_113basic_ostreamIcNS0_11char_traitsIcEEEE","s+":"3D"}
  Frame: {"a":"104FFCF07","b":"102406000","o":"2BF6F07","s":"ZN5mongo5logv214FileRotateSink7consumeERKN5boost3log12v2s_mt_posix11record_viewERKNSt3_112basic_stringIcNS8_11char_traitsIcEENS8_9allocatorIcEEEE","s+":"4F7"}
  Frame: {"a":"105016998","b":"102406000","o":"2C10998","s":"ZN5mongo5logv216CompositeBackendIJNS0_14FileRotateSinkENS0_10RamLogSinkES3_NS0_14UserAssertSinkEEE10consumeAllIJLm0ELm1ELm2ELm3EEEEvRKN5boost3log12v2s_mt_posix11record_viewERKNSt3_112basic_stringIcNSD_11char_traitsIcEENSD_9allocatorIcEEEENSD_16integer_sequenceImJXspT_EEEE","s+":"48"}
  Frame: {"a":"10501679E","b":"102406000","o":"2C1079E","s":"ZN5boost3log12v2s_mt_posix5sinks30basic_formatting_sink_frontendIcE11feed_recordINS1_3aux10fake_mutexEN5mongo5logv216CompositeBackendIJNS9_14FileRotateSinkENS9_10RamLogSinkESC_NS9_14UserAssertSinkEEEEEEvRKNS1_11record_viewERT_RT0","s+":"DE"}
  Frame: {"a":"105016646","b":"102406000","o":"2C10646","s":"_ZN5boost3log12v2s_mt_posix5sinks13unlocked_sinkIN5mongo5logv216CompositeBackendIJNS5_14FileRotateSinkENS5_10RamLogSinkES8_NS5_14UserAssertSinkEEEEE7consumeERKNS1_11record_viewE","s+":"26"}
  Frame: {"a":"105012B2A","b":"102406000","o":"2C0CB2A","s":"_ZN5boost3log12v2s_mt_posix5sinks4sink11try_consumeERKNS1_11record_viewE","s+":"A"}
  Frame: {"a":"105124EA5","b":"102406000","o":"2D1EEA5","s":"_ZN5boost3log12v2s_mt_posix4core16push_record_moveERNS1_6recordE","s+":"1B5"}
  Frame: {"a":"105009D55","b":"102406000","o":"2C03D55","s":"_ZN5mongo5logv29LogSource11push_recordEON5boost3log12v2s_mt_posix6recordE","s+":"15"}
  Frame: {"a":"1050098F5","b":"102406000","o":"2C038F5","s":"_ZN5mongo5logv26detail9doLogImplEiRKNS0_11LogSeverityERKNS0_10LogOptionsENS_10StringDataERKNS0_26TypeErasedAttributeStorageE","s+":"255"}
  Frame: {"a":"103DDB93D","b":"102406000","o":"19D593D","s":"_ZN5mongo5CurOp23completeAndLogOperationEPNS_16OperationContextENS_5logv212LogComponentEN5boost8optionalImEENS6_IxEEb","s+":"78D"}
  Frame: {"a":"10246BBB3","b":"102406000","o":"65BB3","s":"ZN5mongo14future_details10statusCallIRZNS_23ServiceEntryPointCommon13handleRequestEPNS_16OperationContextERKNS_7MessageENSt3110unique_ptrIKNS2_5HooksENS8_14default_deleteISB_EEEEE4$_39JNS_10DbResponseEEEEDaOT_DpOT0","s+":"123"}
  Frame: {"a":"102446E7A","b":"102406000","o":"40E7A","s":"ZN5mongo23ServiceEntryPointCommon13handleRequestEPNS_16OperationContextERKNS_7MessageENSt3_110unique_ptrIKNS0_5HooksENS6_14default_deleteIS9_EEEE","s+":"5DA"}
  Frame: {"a":"102443D02","b":"102406000","o":"3DD02","s":"_ZN5mongo23ServiceEntryPointMongod13handleRequestEPNS_16OperationContextERKNS_7MessageE","s+":"52"}
  Frame: {"a":"102491057","b":"102406000","o":"8B057","s":"_ZN5mongo9transport19ServiceStateMachine4Impl14processMessageEv","s+":"207"}
  Frame: {"a":"10249679D","b":"102406000","o":"9079D","s":"ZZNO5mongo14future_details10FutureImplINS0_8FakeVoidEE4thenIZNS_9transport19ServiceStateMachine4Impl12startNewLoopERKNS_6StatusEE4$_10EEDaOT_ENKUlOS2_E_clESF","s+":"2D"}
  Frame: {"a":"1024920E0","b":"102406000","o":"8C0E0","s":"_ZN5mongo9transport19ServiceStateMachine4Impl12startNewLoopERKNS_6StatusE","s+":"110"}
  Frame: {"a":"1024973DF","b":"102406000","o":"913DF","s":"ZZN5mongo15unique_functionIFvNS_6StatusEEE8makeImplIZNS_9transport19ServiceStateMachine4Impl15scheduleNewLoopES1_E3$_7EEDaOT_EN12SpecificImpl4callEOS1","s+":"5F"}
  Frame: {"a":"104974590","b":"102406000","o":"256E590","s":"ZZN5mongo15unique_functionIFvNS_6StatusEEE8makeImplIZNS_9transport26ServiceExecutorSynchronous18runOnDataAvailableERKNSt3110shared_ptrINS5_7SessionEEES3_E3$_5EEDaOT_EN12SpecificImpl4callEOS1","s+":"40"}
  Frame: {"a":"104970ED9","b":"102406000","o":"256AED9","s":"_ZZN5mongo9transport15ServiceExecutor8scheduleENS_15unique_functionIFvNS_6StatusEEEEENUlvE_clEv","s+":"39"}
  Frame: {"a":"10497423C","b":"102406000","o":"256E23C","s":"_ZZN5mongo15unique_functionIFvvEE8makeImplIZNS_9transport26ServiceExecutorSynchronous12scheduleTaskES2_NS4_15ServiceExecutor13ScheduleFlagsEE3$_4EEDaOT_EN12SpecificImpl4callEv","s+":"18C"}
  Frame: {"a":"104975088","b":"102406000","o":"256F088","s":"ZN5mongo12_GLOBAL_N_17runFuncEPv","s+":"18"}
  Frame: {"a":"7FF81477D4E1","b":"7FF814777000","o":"64E1","s":"_pthread_start","s+":"7D"}
  Frame: {"a":"7FF814778F6B","b":"7FF814777000","o":"1F6B","s":"thread_start","s+":"F"}

Additional Notes

Any additional information that may be useful to include.


Generated at Wed Feb 07 22:42:31 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.