ruby-pg
ruby-pg copied to clipboard
Published
20 hours ago •
ged
ged
Segmentation fault
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
...
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
}
]
}
}
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 :)
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.
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.
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)
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 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.
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 🙏
Thanks for the detailed info, @stanhu.
In case it helps anyone else, in a Rails app you can edit
config/database.ymland add this line to thedevelopmentandtestkeys:<% 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
Actually after upgrading Rails from 6 to 7, the issue disappeared for me. Maybe because of connection flusher, weird.
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: @.***>
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.
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 :
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)
I've recently started to experience this (or a similar) issue when connecting to an RDS instance.
Edit: details moved to #555
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.
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?
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.
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.
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
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
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.
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.
