Segmentation fault

[hbontempo-cw]

When trying to access the database I'm receiving a Segmentation fault. Tried to reinstall the gem, libpq, and the ruby itself. Not sure how to proceed here. Can anyone help me figure it out what is going on?

System

OS: MacOS Ventura (13.4) Chip: Apple M1 Ruby: 3.2.2 ruby-pg: 1.5.3

Behaviour

/Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:690: [BUG] Segmentation fault at 0x00000001066c0a96
ruby 3.2.2 (2023-03-30 revision e51014f9c0) [arm64-darwin22]

-- Crash Report log information --------------------------------------------
   See Crash Report log file in one of the following locations:             
     * ~/Library/Logs/DiagnosticReports                                     
     * /Library/Logs/DiagnosticReports                                      
   for more details.                                                        
Don't forget to include the above Crash Report log file in bug reports.     

-- Control frame information -----------------------------------------------
c:0071 p:---- s:0474 e:000473 CFUNC  :connect_poll
c:0070 p:0358 s:0470 e:000469 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:690
c:0069 p:0265 s:0457 e:000456 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:824
c:0068 p:0007 s:0446 e:000445 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/pg-1.5.3/lib/pg/connection.rb:759
c:0067 p:0012 s:0440 e:000439 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/pg-1.5.3/lib/pg.rb:63
c:0066 p:0006 s:0434 e:000433 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/activerecord-7.0.5/lib/active_record/connection_adap
c:0065 p:0079 s:0428 e:000426 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/activerecord-7.0.5/lib/active_record/connection_adap [FINISH]
c:0064 p:---- s:0420 e:000419 CFUNC  :public_send
c:0063 p:0014 s:0414 e:000413 METHOD /Users/xxx/.asdf/installs/ruby/3.2.2/lib/ruby/gems/3.2.0/gems/activerecord-7.0.5/lib/active_record/connection_adap
...

[hbontempo-cw]

Contents of ~/Library/Logs/DiagnosticReports:

{"app_name":"ruby","timestamp":"2023-06-14 12:55:51.00 -0300","app_version":"","slice_uuid":"4669e8c1-1e9d-3999-9b43-09560cfb7717","build_version":"","platform":1,"share_with_app_devs":0,"is_first_party":1,"bug_type":"309","os_version":"macOS 13.4 (22F66)","roots_installed":0,"incident_id":"BDD36114-9C10-4537-83B5-F4C8DC1C48B1","name":"ruby"}
{
  "uptime" : 34000,
  "procRole" : "Unspecified",
  "version" : 2,
  "userID" : 501,
  "deployVersion" : 210,
  "modelCode" : "MacBookAir10,1",
  "coalitionID" : 1362,
  "osVersion" : {
    "train" : "macOS 13.4",
    "build" : "22F66",
    "releaseType" : "User"
  },
  "captureTime" : "2023-06-14 12:55:49.8980 -0300",
  "incident" : "BDD36114-9C10-4537-83B5-F4C8DC1C48B1",
  "pid" : 53392,
  "translated" : false,
  "cpuType" : "ARM-64",
  "roots_installed" : 0,
  "bug_type" : "309",
  "procLaunch" : "2023-06-14 12:55:49.4244 -0300",
  "procStartAbsTime" : 825711065776,
  "procExitAbsTime" : 825721239647,
  "procName" : "ruby",
  "procPath" : "\/Users\/USER\/*\/ruby",
  "parentProc" : "ruby",
  "parentPid" : 18757,
  "coalitionName" : "com.jetbrains.rubymine",
  "crashReporterKey" : "090D6E1B-B1A5-8328-B2BE-FACB0E6DAB26",
  "responsiblePid" : 2092,
  "responsibleProc" : "rubymine",
  "codeSigningID" : "ruby",
  "codeSigningTeamID" : "",
  "codeSigningFlags" : 570556929,
  "codeSigningValidationCategory" : 10,
  "codeSigningTrustLevel" : 0,
  "sip" : "enabled",
  "vmRegionInfo" : "0x1066c0a96 is not in any region.  Bytes after previous region: 2711  Bytes before following region: 62826\n      REGION TYPE                    START - END         [ VSIZE] PRT\/MAX SHRMOD  REGION DETAIL\n      VM_ALLOCATE                 1066b0000-1066c0000    [   64K] rw-\/rwx SM=PRV  \n--->  GAP OF 0x10000 BYTES\n      VM_ALLOCATE                 1066d0000-1066e0000    [   64K] rw-\/rwx SM=PRV  ",
  "exception" : {"codes":"0x0000000000000001, 0x00000001066c0a96","rawCodes":[1,4402711190],"type":"EXC_BAD_ACCESS","signal":"SIGABRT","subtype":"KERN_INVALID_ADDRESS at 0x00000001066c0a96"},
  "vmregioninfo" : "0x1066c0a96 is not in any region.  Bytes after previous region: 2711  Bytes before following region: 62826\n      REGION TYPE                    START - END         [ VSIZE] PRT\/MAX SHRMOD  REGION DETAIL\n      VM_ALLOCATE                 1066b0000-1066c0000    [   64K] rw-\/rwx SM=PRV  \n--->  GAP OF 0x10000 BYTES\n      VM_ALLOCATE                 1066d0000-1066e0000    [   64K] rw-\/rwx SM=PRV  ",
  "asi" : {"CoreFoundation":["*** multi-threaded process forked ***"],"libsystem_c.dylib":["crashed on child side of fork pre-exec"]},
  "extMods" : {"caller":{"thread_create":0,"thread_set_state":0,"task_for_pid":0},"system":{"thread_create":0,"thread_set_state":0,"task_for_pid":0},"targeted":{"thread_create":0,"thread_set_state":0,"task_for_pid":0},"warnings":0},
  "faultingThread" : 0,
  "threads" : [{"triggered":true,"id":592832,"threadState":{"x":[{"value":0},{"value":0},{"value":0},{"value":0},{"value":20680267530240},{"value":4410931412992},{"value":144},{"value":0},{"value":3615186984159208569},{"value":3615186988714703481},{"value":2},{"value":4294967293},{"value":1099511627776},{"value":0},{"value":0},{"value":0},{"value":328},{"value":8427081568},{"value":0},{"value":6},{"value":8348294656,"symbolLocation":0,"symbol":"_main_thread"},{"value":771},{"value":8348294880,"symbolLocation":224,"symbol":"_main_thread"},{"value":4345916973,"symbolLocation":33915,"symbol":"hex_table"},{"value":110},{"value":0},{"value":0},{"value":0},{"value":0}],"flavor":"ARM_THREAD_STATE64","lr":{"value":6821575720},"cpsr":{"value":1073745920},"fp":{"value":6129039248},"sp":{"value":6129039216},"esr":{"value":1442840704,"description":" Address size fault"},"pc":{"value":6821349156,"matchesCrashFrame":1},"far":{"value":15523938304}},"queue":"com.apple.main-thread","frames":[{"imageOffset":38692,"symbol":"__pthread_kill","symbolLocation":8,"imageIndex":61},{"imageOffset":27688,"symbol":"pthread_kill","symbolLocation":288,"imageIndex":62},{"imageOffset":486120,"symbol":"abort","symbolLocation":180,"imageIndex":63},{"imageOffset":556268,"symbol":"die","symbolLocation":12,"imageIndex":1},{"imageOffset":556716,"symbol":"rb_bug_for_fatal_signal","symbolLocation":448,"imageIndex":1},{"imageOffset":1792672,"symbol":"sigsegv","symbolLocation":96,"imageIndex":1},{"imageOffset":14884,"symbol":"_sigtramp","symbolLocation":56,"imageIndex":64},{"imageOffset":18052,"symbol":"_os_log_preferences_refresh","symbolLocation":36,"imageIndex":65},{"imageOffset":20748,"symbol":"os_log_type_enabled","symbolLocation":712,"imageIndex":65},{"imageOffset":44020,"symbol":"_xpc_connection_activate_if_needed","symbolLocation":152,"imageIndex":66},{"imageOffset":54464,"symbol":"xpc_connection_resume","symbolLocation":92,"imageIndex":66},{"imageOffset":51716,"symbol":"get_primary_name","symbolLocation":152,"imageIndex":37},{"imageOffset":50416,"symbol":"api_macos_ptcursor_next","symbolLocation":240,"imageIndex":37},{"imageOffset":38812,"symbol":"krb5_cccol_cursor_next","symbolLocation":76,"imageIndex":37},{"imageOffset":39556,"symbol":"krb5_cccol_have_content","symbolLocation":92,"imageIndex":37},{"imageOffset":88220,"symbol":"acquire_cred_context","symbolLocation":1664,"imageIndex":36},{"imageOffset":86436,"symbol":"acquire_cred_from","symbolLocation":688,"imageIndex":36},{"imageOffset":29064,"symbol":"gss_add_cred_from","symbolLocation":624,"imageIndex":36},{"imageOffset":28112,"symbol":"gss_acquire_cred_from","symbolLocation":400,"imageIndex":36},{"imageOffset":27700,"symbol":"gss_acquire_cred","symbolLocation":36,"imageIndex":36},{"imageOffset":92784,"symbol":"pg_GSS_have_cred_cache","symbolLocation":60,"imageIndex":35},{"imageOffset":23600,"symbol":"PQconnectPoll","symbolLocation":4500,"imageIndex":35},{"imageOffset":17156,"symbol":"gvl_PQconnectPoll_skeleton","symbolLocation":24,"imageIndex":34},{"imageOffset":2034044,"symbol":"rb_nogvl","symbolLocation":268,"imageIndex":1},{"imageOffset":17116,"symbol":"gvl_PQconnectPoll","symbolLocation":44,"imageIndex":34},{"imageOffset":42988,"symbol":"pgconn_connect_poll","symbolLocation":48,"imageIndex":34},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2363020,"symbol":"vm_call_symbol","symbolLocation":572,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":2383264,"symbol":"rb_call0","symbolLocation":764,"imageIndex":1},{"imageOffset":2382356,"symbol":"send_internal","symbolLocation":684,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":2387808,"symbol":"invoke_block_from_c_bh","symbolLocation":932,"imageIndex":1},{"imageOffset":2299452,"symbol":"rb_yield","symbolLocation":180,"imageIndex":1},{"imageOffset":67932,"symbol":"rb_ary_all_p","symbolLocation":220,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2369940,"symbol":"vm_sendish","symbolLocation":1160,"imageIndex":1},{"imageOffset":2252444,"symbol":"vm_exec_core","symbolLocation":7876,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":998828,"symbol":"load_iseq_eval","symbolLocation":248,"imageIndex":1},{"imageOffset":990508,"symbol":"require_internal","symbolLocation":892,"imageIndex":1},{"imageOffset":987748,"symbol":"rb_f_require","symbolLocation":56,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2346048,"symbol":"vm_call_alias","symbolLocation":112,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":998828,"symbol":"load_iseq_eval","symbolLocation":248,"imageIndex":1},{"imageOffset":990508,"symbol":"require_internal","symbolLocation":892,"imageIndex":1},{"imageOffset":987748,"symbol":"rb_f_require","symbolLocation":56,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2346048,"symbol":"vm_call_alias","symbolLocation":112,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":998828,"symbol":"load_iseq_eval","symbolLocation":248,"imageIndex":1},{"imageOffset":990508,"symbol":"require_internal","symbolLocation":892,"imageIndex":1},{"imageOffset":987748,"symbol":"rb_f_require","symbolLocation":56,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2342364,"symbol":"vm_call_method_each_type","symbolLocation":568,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":2387808,"symbol":"invoke_block_from_c_bh","symbolLocation":932,"imageIndex":1},{"imageOffset":2299452,"symbol":"rb_yield","symbolLocation":180,"imageIndex":1},{"imageOffset":20176,"symbol":"rb_ary_each","symbolLocation":64,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2369940,"symbol":"vm_sendish","symbolLocation":1160,"imageIndex":1},{"imageOffset":2252444,"symbol":"vm_exec_core","symbolLocation":7876,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":998828,"symbol":"load_iseq_eval","symbolLocation":248,"imageIndex":1},{"imageOffset":990508,"symbol":"require_internal","symbolLocation":892,"imageIndex":1},{"imageOffset":987748,"symbol":"rb_f_require","symbolLocation":56,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2346048,"symbol":"vm_call_alias","symbolLocation":112,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":998828,"symbol":"load_iseq_eval","symbolLocation":248,"imageIndex":1},{"imageOffset":987200,"symbol":"rb_load_internal","symbolLocation":132,"imageIndex":1},{"imageOffset":992596,"symbol":"rb_f_load","symbolLocation":184,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":2387808,"symbol":"invoke_block_from_c_bh","symbolLocation":932,"imageIndex":1},{"imageOffset":2299452,"symbol":"rb_yield","symbolLocation":180,"imageIndex":1},{"imageOffset":606632,"symbol":"rb_protect","symbolLocation":356,"imageIndex":1},{"imageOffset":1455828,"symbol":"rb_f_fork","symbolLocation":144,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2369940,"symbol":"vm_sendish","symbolLocation":1160,"imageIndex":1},{"imageOffset":2252444,"symbol":"vm_exec_core","symbolLocation":7876,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":2387808,"symbol":"invoke_block_from_c_bh","symbolLocation":932,"imageIndex":1},{"imageOffset":2385632,"symbol":"loop_i","symbolLocation":112,"imageIndex":1},{"imageOffset":605944,"symbol":"rb_vrescue2","symbolLocation":368,"imageIndex":1},{"imageOffset":605536,"symbol":"rb_rescue2","symbolLocation":44,"imageIndex":1},{"imageOffset":2310848,"symbol":"rb_f_loop","symbolLocation":72,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2369940,"symbol":"vm_sendish","symbolLocation":1160,"imageIndex":1},{"imageOffset":2252444,"symbol":"vm_exec_core","symbolLocation":7876,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":998828,"symbol":"load_iseq_eval","symbolLocation":248,"imageIndex":1},{"imageOffset":990508,"symbol":"require_internal","symbolLocation":892,"imageIndex":1},{"imageOffset":987748,"symbol":"rb_f_require","symbolLocation":56,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2346048,"symbol":"vm_call_alias","symbolLocation":112,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":603088,"symbol":"rb_ec_exec_node","symbolLocation":300,"imageIndex":1},{"imageOffset":602684,"symbol":"ruby_run_node","symbolLocation":96,"imageIndex":1},{"imageOffset":16180,"symbol":"main","symbolLocation":104,"imageIndex":0},{"imageOffset":24360,"symbol":"start","symbolLocation":2236,"imageIndex":67}]},{"id":592836,"frames":[{"imageOffset":38964,"symbol":"poll","symbolLocation":8,"imageIndex":61},{"imageOffset":2074516,"symbol":"timer_pthread_fn","symbolLocation":172,"imageIndex":1},{"imageOffset":28584,"symbol":"_pthread_start","symbolLocation":148,"imageIndex":62},{"imageOffset":7584,"symbol":"thread_start","symbolLocation":8,"imageIndex":62}]},{"id":592837,"name":"reaper.rb:40","frames":[{"imageOffset":38964,"symbol":"poll","symbolLocation":8,"imageIndex":61},{"imageOffset":2022444,"symbol":"rb_sigwait_sleep","symbolLocation":560,"imageIndex":1},{"imageOffset":2029436,"symbol":"native_sleep","symbolLocation":520,"imageIndex":1},{"imageOffset":2032428,"symbol":"sleep_hrtime","symbolLocation":304,"imageIndex":1},{"imageOffset":1457056,"symbol":"rb_f_sleep","symbolLocation":168,"imageIndex":1},{"imageOffset":2360868,"symbol":"vm_call_cfunc_with_frame","symbolLocation":232,"imageIndex":1},{"imageOffset":2252700,"symbol":"vm_exec_core","symbolLocation":8132,"imageIndex":1},{"imageOffset":2325444,"symbol":"rb_vm_exec","symbolLocation":2092,"imageIndex":1},{"imageOffset":2319556,"symbol":"vm_invoke_proc","symbolLocation":768,"imageIndex":1},{"imageOffset":2071936,"symbol":"thread_do_start_proc","symbolLocation":688,"imageIndex":1},{"imageOffset":2070080,"symbol":"thread_start_func_2","symbolLocation":1192,"imageIndex":1},{"imageOffset":2068360,"symbol":"thread_start_func_1","symbolLocation":344,"imageIndex":1},{"imageOffset":28584,"symbol":"_pthread_start","symbolLocation":148,"imageIndex":62},{"imageOffset":7584,"symbol":"thread_start","symbolLocation":8,"imageIndex":62}]}],
  "usedImages" : [
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4337811456,
    "size" : 16384,
    "uuid" : "4669e8c1-1e9d-3999-9b43-09560cfb7717",
    "path" : "\/Users\/USER\/*\/ruby",
    "name" : "ruby"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4342661120,
    "size" : 3309568,
    "uuid" : "a6eab3e2-2bdc-39ea-b5a1-d9b3bdb6e330",
    "path" : "\/Users\/USER\/*\/libruby.3.2.dylib",
    "name" : "libruby.3.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4338597888,
    "size" : 360448,
    "uuid" : "ffdb51eb-c794-3871-a77e-08e4951a7de0",
    "path" : "\/opt\/homebrew\/*\/libgmp.10.dylib",
    "name" : "libgmp.10.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4339269632,
    "size" : 16384,
    "uuid" : "73fbc5a4-d255-33b1-9850-69bdbd0596a3",
    "path" : "\/Users\/USER\/*\/encdb.bundle",
    "name" : "encdb.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4339400704,
    "size" : 16384,
    "uuid" : "ff8763ea-e4ec-307a-a985-9fe388cb4dae",
    "path" : "\/Users\/USER\/*\/transdb.bundle",
    "name" : "transdb.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4339531776,
    "size" : 16384,
    "uuid" : "3aad19f8-257a-37c5-a11c-1a661f90ddf7",
    "path" : "\/Users\/USER\/*\/monitor.bundle",
    "name" : "monitor.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4386897920,
    "size" : 147456,
    "uuid" : "b479e5ea-588d-3491-b9a3-223207e0c470",
    "path" : "\/Users\/USER\/*\/socket.bundle",
    "name" : "socket.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4386652160,
    "size" : 32768,
    "uuid" : "dd56433b-9130-3e31-b0d8-251275892254",
    "path" : "\/Users\/USER\/*\/pathname.bundle",
    "name" : "pathname.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4339662848,
    "size" : 16384,
    "uuid" : "91eb0e99-bbf6-3215-9f9b-67e6fe571e5f",
    "path" : "\/Users\/USER\/*\/pty.bundle",
    "name" : "pty.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4390797312,
    "size" : 65536,
    "uuid" : "d84233e5-d80b-3453-8c31-91cd527bb798",
    "path" : "\/Users\/USER\/*\/msgpack.bundle",
    "name" : "msgpack.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4339793920,
    "size" : 16384,
    "uuid" : "3a613828-de05-3507-a62c-0d1598ffdc8b",
    "path" : "\/Users\/USER\/*\/bootsnap.bundle",
    "name" : "bootsnap.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4391698432,
    "size" : 49152,
    "uuid" : "91f4a316-9491-36d5-9738-004fbd983ba0",
    "path" : "\/Users\/USER\/*\/zlib.bundle",
    "name" : "zlib.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4339924992,
    "size" : 16384,
    "uuid" : "a1074080-037d-35cb-93d2-b3c129c16446",
    "path" : "\/Users\/USER\/*\/psych.bundle",
    "name" : "psych.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4391960576,
    "size" : 98304,
    "uuid" : "6b991f7c-cad3-33fd-b2f9-7bc9be5b0b03",
    "path" : "\/opt\/homebrew\/*\/libyaml-0.2.dylib",
    "name" : "libyaml-0.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4391813120,
    "size" : 32768,
    "uuid" : "7812bca2-d024-3ee3-a1ff-a6ccd6c65b10",
    "path" : "\/Users\/USER\/*\/stringio.bundle",
    "name" : "stringio.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4392632320,
    "size" : 196608,
    "uuid" : "77fa2ad2-90d3-3937-ab51-953809e4dfd3",
    "path" : "\/Users\/USER\/*\/date_core.bundle",
    "name" : "date_core.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340056064,
    "size" : 16384,
    "uuid" : "3288dec7-2fe6-3248-bb3b-05bc5a177c1b",
    "path" : "\/Users\/USER\/*\/parser.bundle",
    "name" : "parser.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4392353792,
    "size" : 32768,
    "uuid" : "7a69a636-d913-339e-a56e-421e8066059d",
    "path" : "\/Users\/USER\/*\/generator.bundle",
    "name" : "generator.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340187136,
    "size" : 16384,
    "uuid" : "e64289c6-a72a-38f1-aad5-45585846e22a",
    "path" : "\/Users\/USER\/*\/escape.bundle",
    "name" : "escape.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340318208,
    "size" : 16384,
    "uuid" : "78731b1a-ee3e-396d-82ea-a1b1cb5d02a2",
    "path" : "\/Users\/USER\/*\/wait.bundle",
    "name" : "wait.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4394565632,
    "size" : 262144,
    "uuid" : "c4422d85-2ee2-3d19-8607-cf2c6b6ad7fc",
    "path" : "\/Users\/USER\/*\/openssl.bundle",
    "name" : "openssl.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4395073536,
    "size" : 311296,
    "uuid" : "6d28d494-f7da-3688-a9ca-d5b7e14a9008",
    "path" : "\/opt\/homebrew\/*\/libssl.1.1.dylib",
    "name" : "libssl.1.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397776896,
    "size" : 1572864,
    "uuid" : "3fa12991-7e4b-39ea-bfd2-fdd5d71a0714",
    "path" : "\/opt\/homebrew\/*\/libcrypto.1.1.dylib",
    "name" : "libcrypto.1.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340449280,
    "size" : 16384,
    "uuid" : "1fa425e1-3d6f-319a-9aa5-5c880cdc699a",
    "path" : "\/Users\/USER\/*\/digest.bundle",
    "name" : "digest.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340580352,
    "size" : 16384,
    "uuid" : "05a9b9a6-629c-38c0-923c-5643d60e8617",
    "path" : "\/Users\/USER\/*\/nonblock.bundle",
    "name" : "nonblock.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340711424,
    "size" : 16384,
    "uuid" : "676c1113-27b9-371b-9399-8e58c3198f6e",
    "path" : "\/Users\/USER\/*\/etc.bundle",
    "name" : "etc.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4403789824,
    "size" : 98304,
    "uuid" : "50555b59-8fc0-31ca-98e7-b482c5de0ac1",
    "path" : "\/Users\/USER\/*\/bigdecimal.bundle",
    "name" : "bigdecimal.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340842496,
    "size" : 16384,
    "uuid" : "af0a8029-ef97-390d-9872-a2194d071cb9",
    "path" : "\/Users\/USER\/*\/strscan.bundle",
    "name" : "strscan.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4340973568,
    "size" : 16384,
    "uuid" : "482b0d43-3224-30ff-9c2c-00700f83a6ff",
    "path" : "\/Users\/USER\/*\/escape.bundle",
    "name" : "escape.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4394450944,
    "size" : 32768,
    "uuid" : "1d4192b5-13ad-3e6c-a338-b37fddf89f7e",
    "path" : "\/Users\/USER\/*\/puma_http11.bundle",
    "name" : "puma_http11.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4341104640,
    "size" : 16384,
    "uuid" : "ad283519-3535-3a81-a545-a6a94fa501a0",
    "path" : "\/Users\/USER\/*\/cparse.bundle",
    "name" : "cparse.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4341235712,
    "size" : 16384,
    "uuid" : "e35f7955-5a89-337a-b850-8bd0508119b1",
    "path" : "\/Users\/USER\/*\/sha1.bundle",
    "name" : "sha1.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4341366784,
    "size" : 16384,
    "uuid" : "12a2a448-febb-3af3-b1c5-94a91d06449f",
    "path" : "\/Users\/USER\/*\/md5.bundle",
    "name" : "md5.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4415209472,
    "size" : 1949696,
    "uuid" : "8bb38d53-1b35-3d5b-9060-32dbee5b9d96",
    "path" : "\/Users\/USER\/*\/appsignal_extension.bundle",
    "name" : "appsignal_extension.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4413571072,
    "size" : 180224,
    "uuid" : "0c349bb8-f445-3a98-97fc-588d560f6769",
    "path" : "\/Users\/USER\/*\/pg_ext.bundle",
    "name" : "pg_ext.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4414210048,
    "size" : 229376,
    "uuid" : "3badf42d-3db9-33cf-ac63-1cda4da55a88",
    "path" : "\/opt\/homebrew\/*\/libpq.5.15.dylib",
    "name" : "libpq.5.15.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4414537728,
    "size" : 212992,
    "uuid" : "2e419a9b-e8ce-394d-9c89-ec3cd0b594bf",
    "path" : "\/opt\/homebrew\/*\/libgssapi_krb5.2.2.dylib",
    "name" : "libgssapi_krb5.2.2.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4419403776,
    "size" : 524288,
    "uuid" : "1d1132bd-c65a-33cf-b350-a8a910168588",
    "path" : "\/opt\/homebrew\/*\/libkrb5.3.3.dylib",
    "name" : "libkrb5.3.3.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4413882368,
    "size" : 131072,
    "uuid" : "ea56a1e6-fce3-3ddf-bd1a-2aef74cf3e62",
    "path" : "\/opt\/homebrew\/*\/libk5crypto.3.1.dylib",
    "name" : "libk5crypto.3.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4392550400,
    "size" : 16384,
    "uuid" : "36bab93b-7121-390c-8a5c-be1b46504dd4",
    "path" : "\/opt\/homebrew\/*\/libcom_err.3.0.dylib",
    "name" : "libcom_err.3.0.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4397662208,
    "size" : 32768,
    "uuid" : "cd2abd34-8359-3eef-8ca8-c316ffd36ac3",
    "path" : "\/opt\/homebrew\/*\/libkrb5support.1.1.dylib",
    "name" : "libkrb5support.1.1.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4419043328,
    "size" : 131072,
    "uuid" : "6be08d7a-936c-3848-aaf1-9c97bed04d6b",
    "path" : "\/Users\/USER\/*\/ox.bundle",
    "name" : "ox.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4423319552,
    "size" : 114688,
    "uuid" : "28919413-5dda-319d-b951-43f6c4c35a13",
    "path" : "\/Users\/USER\/*\/ffi_c.bundle",
    "name" : "ffi_c.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4425203712,
    "size" : 1245184,
    "uuid" : "cbf38e59-d6d8-39d4-b5e6-da42c95bfb85",
    "path" : "\/Users\/USER\/*\/librdkafka.dylib",
    "name" : "librdkafka.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4423548928,
    "size" : 131072,
    "uuid" : "fab75602-2a38-3cbd-827a-7e04e6c34176",
    "path" : "\/opt\/homebrew\/*\/liblz4.1.9.4.dylib",
    "name" : "liblz4.1.9.4.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4426874880,
    "size" : 671744,
    "uuid" : "9cc1e4e5-da83-3b83-a1b9-b4f1ccc5d596",
    "path" : "\/opt\/homebrew\/*\/libzstd.1.5.5.dylib",
    "name" : "libzstd.1.5.5.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4424302592,
    "size" : 360448,
    "uuid" : "d6695f29-8d86-3d82-92da-2e6432bc9446",
    "path" : "\/opt\/homebrew\/*\/libssl.3.dylib",
    "name" : "libssl.3.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4431118336,
    "size" : 2342912,
    "uuid" : "334c2f0a-c726-3d6c-a343-9cc9d33aa92c",
    "path" : "\/opt\/homebrew\/*\/libcrypto.3.dylib",
    "name" : "libcrypto.3.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 4339138560,
    "size" : 32768,
    "uuid" : "1f02028e-3283-378e-b2fa-9b18cd282e2b",
    "path" : "\/usr\/lib\/libffi-trampolines.dylib",
    "name" : "libffi-trampolines.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4414095360,
    "size" : 32768,
    "uuid" : "52f850f9-c83b-3c8d-a538-bc01a35f769c",
    "path" : "\/Users\/USER\/*\/objspace.bundle",
    "name" : "objspace.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4341628928,
    "size" : 16384,
    "uuid" : "ec56541b-d048-37aa-a239-5d1d9f9c37a6",
    "path" : "\/Users\/USER\/*\/utf_16le.bundle",
    "name" : "utf_16le.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4341760000,
    "size" : 16384,
    "uuid" : "2bcdb6f3-d408-3d2e-ae41-629c69763ab9",
    "path" : "\/Users\/USER\/*\/utf_16be.bundle",
    "name" : "utf_16be.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4341891072,
    "size" : 16384,
    "uuid" : "14b37b02-bef5-389f-ba30-4411380ba435",
    "path" : "\/Users\/USER\/*\/console.bundle",
    "name" : "console.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 4342546432,
    "CFBundleShortVersionString" : "1.0",
    "CFBundleIdentifier" : "com.apple.AppSSO.AppSSOLocatePlugin-macOS",
    "size" : 16384,
    "uuid" : "c5dda11b-f174-3977-b97f-f40300096fe4",
    "path" : "\/System\/Library\/KerberosPlugins\/KerberosFrameworkPlugins\/AppSSOLocatePlugin_macOS.bundle\/Contents\/MacOS\/AppSSOLocatePlugin_macOS",
    "name" : "AppSSOLocatePlugin_macOS",
    "CFBundleVersion" : "1"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 4415094784,
    "CFBundleShortVersionString" : "1.0",
    "CFBundleIdentifier" : "com.apple.AppSSO.AppSSOConfigPlugin-macOS",
    "size" : 16384,
    "uuid" : "a5a6fcff-54a4-32ed-8424-30f958e61c06",
    "path" : "\/System\/Library\/KerberosPlugins\/KerberosFrameworkPlugins\/AppSSOConfigPlugin_macOS.bundle\/Contents\/MacOS\/AppSSOConfigPlugin_macOS",
    "name" : "AppSSOConfigPlugin_macOS",
    "CFBundleVersion" : "1"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 4418961408,
    "CFBundleShortVersionString" : "13.4",
    "CFBundleIdentifier" : "com.apple.heimdalodpac",
    "size" : 16384,
    "uuid" : "77912122-f55b-3737-9a54-49de2c14abe8",
    "path" : "\/System\/Library\/KerberosPlugins\/KerberosFrameworkPlugins\/heimdalodpac.bundle\/Contents\/MacOS\/heimdalodpac",
    "name" : "heimdalodpac",
    "CFBundleVersion" : "205"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 4423221248,
    "CFBundleShortVersionString" : "4.0",
    "CFBundleIdentifier" : "com.apple.kerberos.reachability",
    "size" : 16384,
    "uuid" : "9b6985de-428c-31c6-b8f2-bdc2403c8f7a",
    "path" : "\/System\/Library\/KerberosPlugins\/KerberosFrameworkPlugins\/Reachability.bundle\/Contents\/MacOS\/Reachability",
    "name" : "Reachability",
    "CFBundleVersion" : "2.0"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 4424204288,
    "CFBundleShortVersionString" : "4.0",
    "CFBundleIdentifier" : "com.apple.kerberos.sckerberosconfig",
    "size" : 16384,
    "uuid" : "d4012bd0-89cc-3bc9-a5fd-ab9798a5b920",
    "path" : "\/System\/Library\/KerberosPlugins\/KerberosFrameworkPlugins\/SCKerberosConfig.bundle\/Contents\/MacOS\/SCKerberosConfig",
    "name" : "SCKerberosConfig",
    "CFBundleVersion" : "1"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4342284288,
    "size" : 16384,
    "uuid" : "a192fae0-103d-379e-950e-4dd4cdaa426e",
    "path" : "\/Users\/USER\/*\/sha2.bundle",
    "name" : "sha2.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4445126656,
    "size" : 2686976,
    "uuid" : "7b1f42a7-f018-3046-89c6-a5a62f7f722f",
    "path" : "\/Users\/USER\/*\/nokogiri.bundle",
    "name" : "nokogiri.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64",
    "base" : 4342153216,
    "size" : 16384,
    "uuid" : "69972dad-a1a2-3cd9-8d8c-8e4ca5b27756",
    "path" : "\/Users\/USER\/*\/coverage.bundle",
    "name" : "coverage.bundle"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6821310464,
    "size" : 237544,
    "uuid" : "42f503e2-9273-360a-a086-c1b19bbd3962",
    "path" : "\/usr\/lib\/system\/libsystem_kernel.dylib",
    "name" : "libsystem_kernel.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6821548032,
    "size" : 53248,
    "uuid" : "46d35233-a051-3f4f-bba4-ba56dddc4d1a",
    "path" : "\/usr\/lib\/system\/libsystem_pthread.dylib",
    "name" : "libsystem_pthread.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6820098048,
    "size" : 520184,
    "uuid" : "95a70e20-1df3-3ddf-900c-315ed0b2c067",
    "path" : "\/usr\/lib\/system\/libsystem_c.dylib",
    "name" : "libsystem_c.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6821752832,
    "size" : 28668,
    "uuid" : "f80c6971-c080-31f5-ab6e-be01311154af",
    "path" : "\/usr\/lib\/system\/libsystem_platform.dylib",
    "name" : "libsystem_platform.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6818930688,
    "size" : 110592,
    "uuid" : "3f3e75b7-f0a7-30bb-9fd7-fd1307fe6055",
    "path" : "\/usr\/lib\/system\/libsystem_trace.dylib",
    "name" : "libsystem_trace.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6818652160,
    "size" : 278528,
    "uuid" : "f3f19227-ff8f-389c-a094-6f4c16e458af",
    "path" : "\/usr\/lib\/system\/libxpc.dylib",
    "name" : "libxpc.dylib"
  },
  {
    "source" : "P",
    "arch" : "arm64e",
    "base" : 6818045952,
    "size" : 582996,
    "uuid" : "bd993f39-c902-37d6-8bd8-6d827c7f121e",
    "path" : "\/usr\/lib\/dyld",
    "name" : "dyld"
  },
  {
    "size" : 0,
    "source" : "A",
    "base" : 0,
    "uuid" : "00000000-0000-0000-0000-000000000000"
  }
],
  "sharedCache" : {
  "base" : 6817382400,
  "size" : 3551805440,
  "uuid" : "7d9faa84-5c6b-3ef4-9379-faba64346673"
},
  "vmSummary" : "ReadOnly portion of Libraries: Total=1.0G resident=0K(0%) swapped_out_or_unallocated=1.0G(100%)\nWritable regions: Total=1.1G written=0K(0%) resident=0K(0%) swapped_out=0K(0%) unallocated=1.1G(100%)\n\n                                VIRTUAL   REGION \nREGION TYPE                        SIZE    COUNT (non-coalesced) \n===========                     =======  ======= \nActivity Tracing                   256K        1 \nKernel Alloc Once                   32K        1 \nMALLOC                           295.2M       56 \nMALLOC guard page                   96K        5 \nMALLOC_MEDIUM (reserved)         352.0M        3         reserved VM address space (unallocated)\nMALLOC_NANO (reserved)           384.0M        1         reserved VM address space (unallocated)\nSTACK GUARD                       56.0M        3 \nStack                             21.7M       10 \nStack Guard                         96K        6 \nVM_ALLOCATE                       57.8M      397 \n__AUTH                             556K      138 \n__AUTH_CONST                      9946K      274 \n__CTF                               824        1 \n__DATA                            3526K      319 \n__DATA_CONST                      12.1M      334 \n__DATA_DIRTY                       476K       97 \n__FONT_DATA                        2352        1 \n__LINKEDIT                       808.2M       62 \n__OBJC_RO                         66.3M        1 \n__OBJC_RW                         2011K        1 \n__TEXT                           209.3M      346 \ndyld private memory                272K        2 \nmapped file                       4992K        4 \nshared memory                       64K        4 \n===========                     =======  ======= \nTOTAL                              2.2G     2067 \nTOTAL, minus reserved VM space     1.5G     2067 \n",
  "legacyInfo" : {
  "threadTriggered" : {
    "queue" : "com.apple.main-thread"
  }
},
  "logWritingSignature" : "a8a01ec2b2e166c0510810efb5d6d44b8d3c0756",
  "trialInfo" : {
  "rollouts" : [
    {
      "rolloutId" : "60186475825c62000ccf5450",
      "factorPackIds" : {

      },
      "deploymentId" : 240000055
    },
    {
      "rolloutId" : "60f8ddccefea4203d95cbeef",
      "factorPackIds" : {

      },
      "deploymentId" : 240000025
    }
  ],
  "experiments" : [
    {
      "treatmentId" : "c28e4ee6-1b08-4f90-8e05-2809e78310a3",
      "experimentId" : "6317d2003d24842ff850182a",
      "deploymentId" : 400000013
    },
    {
      "treatmentId" : "6dd670af-0633-45e4-ae5f-122ae4df02be",
      "experimentId" : "64406ba83deb637ac8a04419",
      "deploymentId" : 900000005
    }
  ]
}
}

[jk779]

Same here (https://github.com/ged/ruby-pg/issues/311#issuecomment-1591540807)

I suspect this came from an update either of krb5 last week or postgresql@14/libpq last month (unlikely)

The temporary fix in #311 is still working, just export PGGSSENCMODE="disable" until this is fixed :)

[hbontempo-cw]

Great! Temporary fix worked.

Thanks @jk779

[jgrichardson]

Thank you SO much for the temp workaround. That solved it for me.

[stanhu]

I'm not sure if there's anything that can be done to fix it in this library. See https://github.com/ged/ruby-pg/issues/311#issuecomment-1609970533 for more details.

[olivier-thatch]

Thanks for the detailed info, @stanhu.

In case it helps anyone else, in a Rails app you can edit config/database.yml and add this line to the development and test keys:

  <% if RUBY_PLATFORM =~ /darwin/ %>gssencmode: disable<% end %>

which will disable GSSAPI on macOS without requiring every developer to set PGGSSENCMODE="disable" in their own environments.

[Meekohi]

I'm getting the same but none of the export PGGSSENCMODE="disable" tricks are working unfortunately, slightly different configuration:

Postgres 11.16 Newest Amazon Linux (al2023-ami-2023.1.20230629.0-kernel-6.1-x86_64) Ruby 2.7.2p137 (2020-10-01 revision 5445e04352) [x86_64-linux] Rails 5.2.8 Tried pg (1.5.3) and pg (1.4.6)

[stanhu]

@Meekohi If you include the crash log from macOS, that might help.

[Meekohi]

I rolled back to the older Amazon AMI (Amazon Linux 2) and confirm everything works fine there, so it seems to be something with the newest AMI2023. Apologies but I ditched the machines without getting the logs.

[stanhu]

@Meekohi Ok, the GSSAPI issue really only pertains to macOS, so if you're using a Linux system you're likely running into a different problem.

[lioneldebauge]

Experiencing this issue as well

Postgres 14.5 MacOS Ventura 13.2.1 ruby 3.1.2p20 (2022-04-12 revision 4491bb740a) [arm64-darwin22] Rails 7.0.6 pg 1.5.3

Running temp fix mentioned above worked for me. Thanks a lot for that 🙏

[KidA001]

Thanks for the detailed info, @stanhu.

In case it helps anyone else, in a Rails app you can edit config/database.yml and add this line to the development and test keys:

  <% if RUBY_PLATFORM =~ /darwin/ %>gssencmode: disable<% end %>

which will disable GSSAPI on macOS without requiring every developer to set PGGSSENCMODE="disable" in their own environments.

Wow - I spend hours trying to find a resolution to this issue. This was very helpful

[route]

Actually after upgrading Rails from 6 to 7, the issue disappeared for me. Maybe because of connection flusher, weird.

[ColinTheRobot]

fwiw was encountering this in my last role, and we were on Rails 7 on an m1 mac. Not on that code base any more though so can't share any other interesting details. The workarounds outlined in the above comments did work for me

On Thu, Sep 14, 2023 at 3:21 PM Dmitry Vorotilin @.***> wrote:

Actually after upgrading Rails from 6 to 7, the issue disappeared for me. Maybe because of connection flusher, weird.

— Reply to this email directly, view it on GitHub https://github.com/ged/ruby-pg/issues/538#issuecomment-1720013028, or unsubscribe https://github.com/notifications/unsubscribe-auth/ABLBNRPTYH5HZJLXACVGGCTX2NKLFANCNFSM6AAAAAAZGTBCNI . You are receiving this because you are subscribed to this thread.Message ID: @.***>

[robbporto]

This is still happening on Rails 7.

[bethesque]

Potentially same segmentation fault occurring with:

OS: MacOS Sonoma (14.1.1) Chip: Apple M1 Ruby: 3.2.2 ruby-pg: 1.5.4 postgres (installed via brew): 14.10

Using export PGGSSENCMODE="disable" stops the error.

[thibpoullain]

Hi guys,

I have also the segfaults randomly poping and flushing my databases.

ruby 3.2.2, pg 1.5.4, rails 6.1.7.6 postgresql@14 on a Mac M1.

export PGGSSENCMODE="disable" Seems to work !

Thx !!!

This is the segfault message :

Segfault.txt

[cesc1989]

As mentioned, setting export PGGSSENCMODE="disable" does the trick

My settings:

• Ruby 3.0.6
• Rails 6.1.6
• Mac M1. Ventura 13.2.1
• psql (PostgreSQL) 14.8 (Homebrew)

[grncdr]

I've recently started to experience this (or a similar) issue when connecting to an RDS instance.

Edit: details moved to #555

[larskanis]

I've recently started to experience this (or a similar) issue when connecting to an RDS instance.

@grncdr Please open a separate issue with the relevant details.

[TeTiRoss]

I rolled back to the older Amazon AMI (Amazon Linux 2) and confirm everything works fine there, so it seems to be something with the newest AMI2023. Apologies but I ditched the machines without getting the logs.

@Meekohi hey, seems like I have the same issue. Can you describe in more details what have you done to fix it? In your setup do you use RDS or postgresql hosted on EC2?

[Meekohi]

I rolled back to Amazon Linux 2 and have not tried the newer versions again since. We connect to RDS although I don't think it should matter.

[stanhu]

Perhaps this issue should be retitled, macOS segmentation fault when connection occurs in a fork. This issue describes a macOS client issue due to GSSAPI calls (used in Kubernetes authentication) as I described in detail in https://github.com/ged/ruby-pg/issues/311#issuecomment-1609970533.

There is a separate segfault described in https://github.com/ged/ruby-pg/issues/555.

[sobrinho]

Same here:

-- Control frame information -----------------------------------------------
c:0064 p:---- s:0364 e:000363 CFUNC  :connect_poll
c:0063 p:0510 s:0360 e:000359 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/pg-1.5.5/lib/pg/connection.rb:690
c:0062 p:0338 s:0347 e:000346 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/pg-1.5.5/lib/pg/connection.rb:824
c:0061 p:0007 s:0336 e:000335 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/pg-1.5.5/lib/pg/connection.rb:759
c:0060 p:0019 s:0330 e:000329 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/pg-1.5.5/lib/pg.rb:63
c:0059 p:0013 s:0324 e:000323 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/postgresql_adapter.rb:78
c:0058 p:0112 s:0318 e:000316 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/postgresql_adapter.rb:37 [FINISH]
c:0057 p:---- s:0310 e:000309 CFUNC  :public_send
c:0056 p:0021 s:0304 e:000303 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:656
c:0055 p:0021 s:0300 e:000299 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:700
c:0054 p:0013 s:0296 e:000295 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:679
c:0053 p:0012 s:0290 e:000289 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:640
c:0052 p:0011 s:0284 e:000282 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:341
c:0051 p:0021 s:0278 e:000274 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_pool.rb:181
c:0050 p:0256 s:0271 e:000270 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_adapters/abstract/connection_handler.rb:21
c:0049 p:0014 s:0261 e:000260 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_handling.rb:313
c:0048 p:0003 s:0257 e:000256 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/connection_handling.rb:280
c:0047 p:0015 s:0253 e:000252 METHOD /Users/sobrinho/.gem/ruby/3.1.4/gems/activerecord-7.0.8/lib/active_record/internal_metadata.rb:17

[agirlnamedsophia]

Same issue here running mutation testing against a rails 7 app with ruby 3.2.3

[galievruslan]

I have same issue Ubuntu 22 Ruby 2.7.8 Rails 5.2.8.1 pg gem 1.5.5 PostgreSQL version 12.18 with postgis

I try set gssencmode: disable in my database.yml, It did not help. I try export PGGSSENCMODE="disable" without changes

This project on exactly the same server, but only with PostgreSQL 11 it works without problems.

I understood what the reason was. I compared two servers on both Ubuntu 22 and PostgreSQL 12, the only difference was in the openssl version. On openssl version 1.1.1f everything worked fine, but not on version 1.0. After I installed openssl 1.1.1f on the server, everything began to work without problems and without gssencmode: disable

wget http://security.ubuntu.com/ubuntu/pool/main/o/openssl/openssl_1.1.1f-1ubuntu2.22_amd64.deb
wget http://security.ubuntu.com/ubuntu/pool/main/o/openssl/libssl1.1_1.1.1f-1ubuntu2.22_amd64.deb
wget http://security.ubuntu.com/ubuntu/pool/main/o/openssl/libssl-dev_1.1.1f-1ubuntu2.22_amd64.deb
sudo dpkg -i libssl1.1_1.1.1f-1ubuntu2.22_amd64.deb
sudo dpkg -i libssl-dev_1.1.1f-1ubuntu2.22_amd64.deb 
sudo dpkg -i openssl_1.1.1f-1ubuntu2.22_amd64.deb 
rvm uninstall 2.7.8
rvm install ruby-2.7.8 --with-openssl-dir=/usr/lib

[agrare]

I ran into this issue as well on CentOS Stream 9, however I was able to work around it by installing an older version of openssl.

OS: CentOS Stream release 9 Arch: x86_64 Ruby: 3.1.2p20 (2022-04-12 revision 4491bb740a) [x86_64-linux] PG gem: 1.5.6 OpenSSL: 3.2.1-1.el9

If I manually downgrade to openssl rpm version 3.0.7 without changing anything else, dnf install openssl-1:3.0.7-27.el9, I am able to connect to my database again.

[sebaherrera07]

If you ended up here like me and no of the fixes mentioned worked, what did work for me was upgrading Postgres to 14.11+, because it seems it was an issue caused by some incompatibility with some openssl version. Source: https://www.postgresql.org/docs/release/14.11

I'm on macOS 14.5 with M1 Pro, and installed postgres via asdf.