libpq crashing on macOS during connection startup

From: John DeSoi <john(at)desoi(dot)dev>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: libpq crashing on macOS during connection startup
Date: 2023-11-30 14:45:41
Message-ID: 0100018c20b152e0-ec85ac20-b379-46d7-a962-c59e00f3201c-000000@email.amazonses.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have a macOS web server using Postgres that has been very stable until a month or two ago. If I restart the web server the problem seems to go away for a while, but starts happening again within days. I thought it was a PHP issue as discussed in the link below, but I just noticed in the crash report it seems to be something related to a call from libpq.

https://github.com/shivammathur/homebrew-php/issues/1862

Any ideas or suggestions appreciated.

John DeSoi, Ph.D.

-------------------------------------
Translated Report (Full Report Below)
-------------------------------------

Process: httpd [54877]
Path: /opt/homebrew/*/httpd
Identifier: httpd
Version: ???
Code Type: ARM-64 (Native)
Parent Process: httpd [6040]
Responsible: httpd [6040]
User ID: 502

Date/Time: 2023-11-30 07:06:00.0651 -0600
OS Version: macOS 12.7 (21G816)
Report Version: 12
Anonymous UUID: 750F146C-B2B5-BECA-EC21-1FEC0471D5AC

Time Awake Since Boot: 1000000 seconds

System Integrity Protection: enabled

Crashed Thread: 0 Dispatch queue: com.apple.root.utility-qos

Exception Type: EXC_BAD_ACCESS (SIGSEGV)
Exception Codes: KERN_INVALID_ADDRESS at 0x0000000000000110
Exception Codes: 0x0000000000000001, 0x0000000000000110
Exception Note: EXC_CORPSE_NOTIFY

VM Region Info: 0x110 is not in any region. Bytes before following region: 105553518919408
REGION TYPE START - END [ VSIZE] PRT/MAX SHRMOD REGION DETAIL
UNUSED SPACE AT START
--->
MALLOC_NANO (reserved) 600018000000-600020000000 [128.0M] rw-/rwx SM=NUL ...(unallocated)

Application Specific Information:
*** multi-threaded process forked ***
crashed on child side of fork pre-exec

Kernel Triage:
VM - pmap_enter failed with resource shortage
VM - pmap_enter failed with resource shortage

Thread 0 Crashed:: Dispatch queue: com.apple.root.utility-qos
0 libdispatch.dylib 0x199dd825c _dispatch_apply_with_attr_f + 1136
1 libdispatch.dylib 0x199dd8234 _dispatch_apply_with_attr_f + 1096
2 libdispatch.dylib 0x199dd847c dispatch_apply + 108
3 CoreFoundation 0x19a172a80 __104-[CFPrefsSearchListSource synchronouslySendDaemonMessage:andAgentMessage:andDirectMessage:replyHandler:]_block_invoke.92 + 132
4 CoreFoundation 0x19a007e8c CFPREFERENCES_IS_WAITING_FOR_SYSTEM_AND_USER_CFPREFSDS + 100
5 CoreFoundation 0x19a007ccc -[CFPrefsSearchListSource synchronouslySendDaemonMessage:andAgentMessage:andDirectMessage:replyHandler:] + 232
6 CoreFoundation 0x19a00649c -[CFPrefsSearchListSource alreadylocked_generationCountFromListOfSources:count:] + 252
7 CoreFoundation 0x19a006178 -[CFPrefsSearchListSource alreadylocked_getDictionary:] + 468
8 CoreFoundation 0x19a005cec -[CFPrefsSearchListSource alreadylocked_copyValueForKey:] + 172
9 CoreFoundation 0x19a005c20 -[CFPrefsSource copyValueForKey:] + 60
10 CoreFoundation 0x19a005bcc __76-[_CFXPreferences copyAppValueForKey:identifier:container:configurationURL:]_block_invoke + 44
11 CoreFoundation 0x199ffe9e0 __108-[_CFXPreferences(SearchListAdditions) withSearchListForIdentifier:container:cloudConfigurationURL:perform:]_block_invoke + 384
12 CoreFoundation 0x19a173350 -[_CFXPreferences withSearchListForIdentifier:container:cloudConfigurationURL:perform:] + 384
13 CoreFoundation 0x199ffe394 -[_CFXPreferences copyAppValueForKey:identifier:container:configurationURL:] + 168
14 CoreFoundation 0x199ffe2b0 _CFPreferencesCopyAppValueWithContainerAndConfiguration + 128
15 Heimdal 0x1a5d4cb80 init_context_from_config_file + 2732
16 Heimdal 0x1a5d33944 krb5_set_config_files + 392
17 Heimdal 0x1a5d33284 krb5_init_context_flags + 308
18 Heimdal 0x1a5d33144 krb5_init_context + 32
19 Kerberos 0x1a7fc32e8 mshim_ctx + 64
20 Kerberos 0x1a7fc16e4 context_new_ccache_iterator + 92
21 libkrb5.3.3.dylib 0x1017accc8 api_macos_ptcursor_next + 220
22 libkrb5.3.3.dylib 0x1017a9f0c krb5_cccol_cursor_next + 76
23 libkrb5.3.3.dylib 0x1017aa1f4 krb5_cccol_have_content + 92
24 libgssapi_krb5.2.2.dylib 0x1016a1f58 acquire_cred_context + 1668
25 libgssapi_krb5.2.2.dylib 0x1016a185c acquire_cred_from + 688
26 libgssapi_krb5.2.2.dylib 0x101693b8c gss_add_cred_from + 1108
27 libgssapi_krb5.2.2.dylib 0x101693568 gss_acquire_cred_from + 308
28 libgssapi_krb5.2.2.dylib 0x101693428 gss_acquire_cred + 36
29 libpq.5.dylib 0x1012a9db8 pg_GSS_have_cred_cache + 60
30 libpq.5.dylib 0x10129927c PQconnectPoll + 5600
31 libpq.5.dylib 0x10129623c connectDBComplete + 304
32 libpq.5.dylib 0x1012963a8 PQconnectdb + 44
33 libphp.so 0x10229569c pdo_pgsql_handle_factory + 328
34 libphp.so 0x102282230 zim_PDO___construct + 1496
35 libphp.so 0x10249bd0c ZEND_DO_FCALL_SPEC_RETVAL_UNUSED_HANDLER + 304
36 libphp.so 0x102479868 execute_ex + 52
37 libphp.so 0x10244b314 zend_call_function + 1332
38 libphp.so 0x10236cef0 zif_call_user_func_array + 136
39 libphp.so 0x1024b83e4 ZEND_DO_FCALL_BY_NAME_SPEC_RETVAL_USED_HANDLER + 264
40 libphp.so 0x102479868 execute_ex + 52
41 libphp.so 0x102479a64 zend_execute + 288
42 libphp.so 0x102459d84 zend_execute_scripts + 156
43 libphp.so 0x1023ff9a8 php_execute_script + 460
44 libphp.so 0x10253efa8 php_handler + 1024
45 httpd 0x100cc61a4 ap_run_handler + 64
46 httpd 0x100cc687c ap_invoke_handler + 264
47 httpd 0x100cfe364 ap_internal_redirect + 60
48 mod_rewrite.so 0x10204b6d8 handler_redirect + 136
49 httpd 0x100cc61a4 ap_run_handler + 64
50 httpd 0x100cc687c ap_invoke_handler + 264
51 httpd 0x100cfdf3c ap_process_async_request + 792
52 httpd 0x100cfdfec ap_process_request + 24
53 httpd 0x100cfae64 ap_process_http_connection + 344
54 httpd 0x100cd785c ap_run_process_connection + 64
55 mod_mpm_prefork.so 0x1010e23ec child_main + 1092
56 mod_mpm_prefork.so 0x1010e1e74 make_child + 436
57 mod_mpm_prefork.so 0x1010e18b0 prefork_run + 2056
58 httpd 0x100cd9f30 ap_run_mpm + 84
59 httpd 0x100ccd3b4 main + 2260
60 dyld 0x100fd108c start + 520

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2023-11-30 14:59:38 Re: libpq crashing on macOS during connection startup
Previous Message Loles 2023-11-30 13:37:26 Two started cluster on the same data directory and port