Project

General

Profile

Actions

Bug #16239

closed

Crash when accessing postgresql-12

Added by marksiemers (Mark Siemers) about 3 years ago. Updated almost 3 years ago.

Status:
Third Party's Issue
Priority:
Normal
Assignee:
-
Target version:
-
ruby -v:
ruby 2.6.4p104 (2019-08-28 revision 67798) [x86_64-darwin18]
[ruby-core:95230]

Description

This may have been caused by a recent upgrade to postgresql 12 on my local machine (running OS X Mojave). pgAdmin 4 is also giving me an error.

I am running a rails console, and as soon as I try to do anything with ActiveRecord that accesses the database, I get an error and a crash report,


Files


Related issues 2 (0 open2 closed)

Related to Ruby master - Bug #16385: Segmentation fault when running a rails app with pumaThird Party's IssueActions
Related to Ruby master - Bug #16390: Crash report for ruby2.6.4p104Third Party's IssueActions
Actions #1

Updated by marksiemers (Mark Siemers) about 3 years ago

  • Subject changed from Crash when access postgresql-12 to Crash when accessing postgresql-12
Actions #2

Updated by marksiemers (Mark Siemers) about 3 years ago

  • ruby -v set to ruby 2.6.4p104 (2019-08-28 revision 67798) [x86_64-darwin18]

Updated by jeremyevans0 (Jeremy Evans) about 3 years ago

  • Status changed from Open to Third Party's Issue

This crash happens inside the pg gem. It's either caused by the pg gem, libpq (PostgreSQL), or one of the internal Mac OS libraries listed.

7   ???                           	0x0000000200000000 0 + 8589934592
8   com.apple.security            	0x00007fff3f57c059 invocation function for block in Security::KeychainCore::StorageManager::tickleKeychain(Security::KeychainCore::KeychainImpl*) + 287
9   libdispatch.dylib             	0x00007fff5fd6d63d _dispatch_client_callout + 8
10  libdispatch.dylib             	0x00007fff5fd79129 _dispatch_lane_barrier_sync_invoke_and_complete + 60
11  com.apple.security            	0x00007fff3f57be47 Security::KeychainCore::StorageManager::tickleKeychain(Security::KeychainCore::KeychainImpl*) + 441
12  com.apple.security            	0x00007fff3f37cae2 Security::KeychainCore::KCCursorImpl::next(Security::KeychainCore::Item&) + 230
13  com.apple.security            	0x00007fff3f523c98 Security::KeychainCore::IdentityCursor::next(Security::SecPointer<Security::KeychainCore::Identity>&) + 192
14  com.apple.security            	0x00007fff3f545f2f SecIdentitySearchCopyNext + 145
15  com.apple.security            	0x00007fff3f550956 SecItemCopyMatching_osx(__CFDictionary const*, void const**) + 238
16  com.apple.security            	0x00007fff3f553fc5 SecItemCopyMatching + 316
17  com.apple.Heimdal             	0x00007fff4feae830 0x7fff4fe5c000 + 337968
18  com.apple.Heimdal             	0x00007fff4fead35e hx509_certs_find + 67
19  com.apple.Heimdal             	0x00007fff4fe88a6c _krb5_pk_find_cert + 246
20  com.apple.GSS                 	0x00007fff364dbd8e _gsspku2u_acquire_cred + 386
21  com.apple.GSS                 	0x00007fff364cb0d8 gss_acquire_cred + 523
22  libpq.5.dylib                 	0x0000000112b4b77d pg_GSS_have_cred_cache + 54
23  libpq.5.dylib                 	0x0000000112b39edf PQconnectPoll + 6377
24  libpq.5.dylib                 	0x0000000112b36f8b connectDBComplete + 232
25  libpq.5.dylib                 	0x0000000112b37112 PQconnectdb + 36
26  pg_ext.bundle                 	0x000000011157ab01 gvl_PQconnectdb_skeleton + 17
27  ruby                          	0x000000010f1dfff9 call_without_gvl + 185
28  pg_ext.bundle                 	0x000000011157aadd gvl_PQconnectdb + 45
29  pg_ext.bundle                 	0x000000011157fcb9 pgconn_init + 121
30  ruby                          	0x000000010f221b1c vm_call0_body + 604

If I had to guess, this is a PostgreSQL issue with GSS authentication on Mac OS. Since PostgreSQL 12 was just released, it may be a regression. Please try contacting the PostgreSQL developers.

Actions #4

Updated by jeremyevans0 (Jeremy Evans) almost 3 years ago

  • Related to Bug #16385: Segmentation fault when running a rails app with puma added
Actions #5

Updated by jeremyevans0 (Jeremy Evans) almost 3 years ago

  • Related to Bug #16390: Crash report for ruby2.6.4p104 added

Updated by cbandy (Chris Bandy) almost 3 years ago

@jeremyevans0 (Jeremy Evans) is correct. This is a fatal interaction between the PostgreSQL 12 client libraries and the GSS implementation provided by macOS. This is being tracked in the pg gem at https://github.com/ged/ruby-pg/issues/311.

An immediate workaround is to include gssencmode: "disable" or gssencmode=disable in your connection configuration.

Actions

Also available in: Atom PDF