Open ianthrive opened 7 months ago
is the issue occurring with php cli too ?
is the issue occurring with php cli too ?
No, cli is not affected.
would it be possible to share a bit more infos ? e.g. relevant fpm config.
would it be possible to share a bit more infos ? e.g. relevant fpm config.
No problem, I added config files and diffs to the description.
would it be possible to share a bit more infos ? e.g. relevant fpm config.
Also, the FPM config is unchanged from the default Macports install.
Does it happen also with persistent connections ?
Does it happen also with persistent connections ?
If I change pg_connect()
to pg_pconnect()
there is no change. I'm not sure if that's what you're referring to.
A couple other notes:
localhost
to 127.0.0.1
has no effectfastcgi_pass 127.0.0.1:9000
and returns HTTP 502 Bad Gateway to the clientOk thanks I ll have a better look some time this week.
@devnexen Would you be able to point out where in the code base I can find pg_connect()
? I need to figure out what I'm going to do with all of my production instances. I'd much rather deploy a fix for v8.2+ (I'm deployed with v8.3) rather than downgrade to v8.1. It's more than likely way out of capability, but I'd like to see if I can come up with a patch for this.
I cannot really reproduce it, I have an issue but not a SIGABRT
, same for PHP 8.1 and PHP 8.3. By the way when you used 8.1 was it before the update to sonoma or also after ?
I cannot really reproduce it, I have an issue but not a
SIGABRT
, same for PHP 8.1 and PHP 8.3. By the way when you used 8.1 was it before the update to sonoma or also after ?
It was after. I tested it with 8.1, 8.2, and 8.3, the same day I created this issue.
So far, I get this crash with the homebrew version
* thread #1, queue = 'com.apple.main-thread', stop reason = EXC_BAD_ACCESS (code=1, address=0x1059f4a86)
* frame #0: 0x0000000186c6823c libsystem_trace.dylib`_os_log_preferences_refresh + 68
frame #1: 0x0000000186c68c9c libsystem_trace.dylib`os_log_type_enabled + 712
frame #2: 0x0000000187149dd8 CoreFoundation`-[CFPrefsPlistSource handleErrorReply:toMessage:settingKeys:toValues:count:retryCount:retryContinuation:] + 652
frame #3: 0x0000000186f9cdf4 CoreFoundation`-[CFPrefsPlistSource handleReply:toRequestNewDataMessage:onConnection:retryCount:error:] + 240
frame #4: 0x0000000186fd94ac CoreFoundation`-[CFPrefsPlistSource sendRequestNewDataMessage:toConnection:retryCount:error:] + 728
frame #5: 0x0000000186fd90f8 CoreFoundation`__50-[CFPrefsPlistSource alreadylocked_requestNewData]_block_invoke + 112
frame #6: 0x000000018713f87c CoreFoundation`-[_CFXPreferences withConnectionForRole:andUserIdentifier:performBlock:] + 52
frame #7: 0x0000000186fd8ea8 CoreFoundation`-[CFPrefsPlistSource alreadylocked_requestNewData] + 696
frame #8: 0x000000018714b76c CoreFoundation`-[CFPrefsPlistSource generationCount] + 452
frame #9: 0x0000000186f9cb24 CoreFoundation`-[CFPrefsSearchListSource handleReply:toRequestNewDataMessage:onConnection:retryCount:error:] + 140
frame #10: 0x0000000186f9ca70 CoreFoundation`__80-[CFPrefsSearchListSource alreadylocked_generationCountFromListOfSources:count:]_block_invoke + 60
frame #11: 0x0000000187115b08 CoreFoundation`__103-[CFPrefsSearchListSource synchronouslySendSystemMessage:andUserMessage:andDirectMessage:replyHandler:]_block_invoke_2 + 76
frame #12: 0x000000018713f87c CoreFoundation`-[_CFXPreferences withConnectionForRole:andUserIdentifier:performBlock:] + 52
frame #13: 0x0000000187115a94 CoreFoundation`__103-[CFPrefsSearchListSource synchronouslySendSystemMessage:andUserMessage:andDirectMessage:replyHandler:]_block_invoke + 148
frame #14: 0x0000000186fe0ce0 CoreFoundation`CFPREFERENCES_IS_WAITING_FOR_SYSTEM_CFPREFSD + 100
frame #15: 0x0000000187114e0c CoreFoundation`-[CFPrefsSearchListSource synchronouslySendSystemMessage:andUserMessage:andDirectMessage:replyHandler:] + 332
frame #16: 0x0000000186f9aaec CoreFoundation`-[CFPrefsSearchListSource alreadylocked_generationCountFromListOfSources:count:] + 232
frame #17: 0x0000000186f9a7f4 CoreFoundation`-[CFPrefsSearchListSource alreadylocked_getDictionary:] + 484
frame #18: 0x0000000186f9a368 CoreFoundation`-[CFPrefsSearchListSource alreadylocked_copyValueForKey:] + 172
frame #19: 0x0000000186f9a29c CoreFoundation`-[CFPrefsSource copyValueForKey:] + 52
frame #20: 0x0000000186f9a250 CoreFoundation`__76-[_CFXPreferences copyAppValueForKey:identifier:container:configurationURL:]_block_invoke + 32
frame #21: 0x0000000186f9389c CoreFoundation`__108-[_CFXPreferences(SearchListAdditions) withSearchListForIdentifier:container:cloudConfigurationURL:perform:]_block_invoke + 376
frame #22: 0x0000000187116458 CoreFoundation`-[_CFXPreferences withSearchListForIdentifier:container:cloudConfigurationURL:perform:] + 384
frame #23: 0x0000000186f93178 CoreFoundation`-[_CFXPreferences copyAppValueForKey:identifier:container:configurationURL:] + 156
frame #24: 0x0000000186f930a0 CoreFoundation`_CFPreferencesCopyAppValueWithContainerAndConfiguration + 112
frame #25: 0x00000001952653e4 Heimdal`init_context_from_config_file + 2932
frame #26: 0x000000019524982c Heimdal`krb5_set_config_files + 440
frame #27: 0x00000001952490ac Heimdal`krb5_init_context_flags + 348
frame #28: 0x0000000195248f44 Heimdal`krb5_init_context + 32
frame #29: 0x00000001977a7334 Kerberos`mshim_ctx + 64
frame #30: 0x00000001977a576c Kerberos`context_new_ccache_iterator + 92
frame #31: 0x00000001048e85b4 libkrb5.3.3.dylib`api_macos_ptcursor_next + 220
frame #32: 0x00000001048e58bc libkrb5.3.3.dylib`krb5_cccol_cursor_next + 80
frame #33: 0x00000001048e5b98 libkrb5.3.3.dylib`krb5_cccol_have_content + 92
frame #34: 0x00000001047dda2c libgssapi_krb5.2.2.dylib`acquire_cred_context + 1740
frame #35: 0x00000001047dd2e8 libgssapi_krb5.2.2.dylib`acquire_cred_from + 688
frame #36: 0x00000001047cf340 libgssapi_krb5.2.2.dylib`gss_add_cred_from + 628
frame #37: 0x00000001047cef84 libgssapi_krb5.2.2.dylib`gss_acquire_cred_from + 400
frame #38: 0x00000001047cede8 libgssapi_krb5.2.2.dylib`gss_acquire_cred + 36
frame #39: 0x00000001043f9d98 libpq.5.dylib`pg_GSS_have_cred_cache + 60
frame #40: 0x00000001043e8c0c libpq.5.dylib`PQconnectPoll + 5188
frame #41: 0x00000001043e5dc8 libpq.5.dylib`connectDBComplete + 276
frame #42: 0x00000001043e5f34 libpq.5.dylib`PQconnectdb + 44
frame #43: 0x00000001030036e4 php-fpm`php_pgsql_do_connect + 704
frame #44: 0x000000010322b120 php-fpm`ZEND_DO_ICALL_SPEC_RETVAL_USED_HANDLER + 84
frame #45: 0x00000001031ed484 php-fpm`execute_ex + 100
frame #46: 0x00000001031ed6b0 php-fpm`zend_execute + 280
frame #47: 0x00000001031cc150 php-fpm`zend_execute_scripts + 156
frame #48: 0x000000010316c068 php-fpm`php_execute_script + 460
frame #49: 0x00000001032bf028 php-fpm`main + 5604
frame #50: 0x0000000186b890e0 dyld`start + 2360
Would it be possible for you to try if you still get the issue if you add gssencmode=disable
to your connection string ?
Would it be possible for you to try if you still get the issue if you add
gssencmode=disable
to your connection string ?
That resolves the issue. For both 8.2 and 8.3. And 8.1 continues to work successfully.
This is the connection string that I'm using:
$c = pg_connect('host=localhost user=dbuser dbname=dbname gssencmode=disable');
Thanks for confirming, once I rebuilt libpq's homebrew without gss support it stopped crashing for me, I ll need to look to go beyond the "workarounds".
hmm i don't know if this is related, but i'm getting segfault when freePGconn from libpq is called
Fedora 40 with postgresql repositories from https://yum.postgresql.org/:
Linux notebook-leo 6.8.7-300.fc40.x86_64 #1 SMP PREEMPT_DYNAMIC Wed Apr 17 19:21:08 UTC 2024 x86_64 GNU/Linux
PHP 8.3.6 (cli) (built: Apr 10 2024 14:21:20) (NTS gcc x86_64)
Copyright (c) The PHP Group
Zend Engine v4.3.6, Copyright (c) Zend Technologies
with Zend OPcache v8.3.6, Copyright (c), by Zend Technologies
with Xdebug v3.3.2, Copyright (c) 2002-2024, by Derick Rethans
php bin/console doctrine:query:sql "select 1"
double free or corruption (out)
Aborted (core dumped)
PID: 1686 (php-fpm)
UID: 1000 (leonelfranchelli)
GID: 975 (nginx)
Signal: 6 (ABRT)
Timestamp: Thu 2024-04-25 21:29:07 -03 (8min ago)
Command Line: $'php-fpm: pool www'
Executable: /usr/sbin/php-fpm
Control Group: /system.slice/php-fpm.service
Unit: php-fpm.service
Slice: system.slice
Boot ID: e391f2619bf64868adbb30c7ab37fd15
Machine ID: 1445d9637bca4418a9a6eafe377780c6
Hostname: notebook-leo
Storage: /var/lib/systemd/coredump/core.php-fpm.1000.e391f2619bf64868adbb30c7ab37fd15.1686.1714091347000000.zst (present)
Size on Disk: 8.8M
Package: php/8.3.6-1.fc40.remi
build-id: c2bda6428bfc093a5a27a31719813c3112afac1f
Message: Process 1686 (php-fpm) of user 1000 dumped core.
Module libbasicobjects.so.0 from rpm ding-libs-0.6.2-56.fc40.x86_64
Module libpath_utils.so.1 from rpm ding-libs-0.6.2-56.fc40.x86_64
Module libcollection.so.4 from rpm ding-libs-0.6.2-56.fc40.x86_64
Module libgssrpc.so.4 from rpm krb5-1.21.2-5.fc40.x86_64
Module libverto.so.1 from rpm libverto-0.3.2-8.fc40.x86_64
Module libini_config.so.5 from rpm ding-libs-0.6.2-56.fc40.x86_64
Module libref_array.so.1 from rpm ding-libs-0.6.2-56.fc40.x86_64
Module proxymech.so from rpm gssproxy-0.9.2-3.fc40.x86_64
Module libnss_systemd.so.2 from rpm systemd-255.4-1.fc40.x86_64
Module libnss_sss.so.2 from rpm sssd-2.9.4-7.fc40.x86_64
Module libnss_resolve.so.2 from rpm systemd-255.4-1.fc40.x86_64
Module libnss_mdns4_minimal.so.2 from rpm nss-mdns-0.15.1-11.fc40.x86_64
Module libuuid.so.1 from rpm util-linux-2.40-13.fc40.x86_64
Module libfribidi.so.0 from rpm fribidi-1.0.13-4.fc40.x86_64
Module libICE.so.6 from rpm libICE-1.1.1-3.fc40.x86_64
Module libSM.so.6 from rpm libSM-1.2.4-3.fc40.x86_64
Module libltdl.so.7 from rpm libtool-2.4.7-10.fc40.x86_64
Module libXt.so.6 from rpm libXt-1.3.0-3.fc40.x86_64
Module libXext.so.6 from rpm libXext-1.3.6-1.fc40.x86_64
Module libfftw3.so.3 from rpm fftw-3.3.10-11.fc40.x86_64
Module libraqm.so.0 from rpm libraqm-0.8.0-7.fc40.x86_64
Module liblcms2.so.2 from rpm lcms2-2.16-3.fc40.x86_64
Module libMagickCore-7.Q16HDRI.so.10 from rpm ImageMagick-7.1.1.31-1.fc40.remi.x86_64
Module libMagickWand-7.Q16HDRI.so.10 from rpm ImageMagick-7.1.1.31-1.fc40.remi.x86_64
Module imagick.so from rpm php-pecl-imagick-im7-3.7.0-10.fc40.remi.8.3.x86_64
Module grpc.so from rpm php-pecl-grpc-1.61.0-1.fc40.remi.8.3.x86_64
Module libzip.so.5 from rpm libzip-1.10.1-3.fc40.x86_64
Module zip.so from rpm php-pecl-zip-1.22.3-1.fc40.remi.8.3.x86_64
Module xmlreader.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module pdo_sqlite.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module pdo_pgsql.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libexslt.so.0 from rpm libxslt-1.1.39-3.fc40.x86_64
Module libxslt.so.1 from rpm libxslt-1.1.39-3.fc40.x86_64
Module xsl.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module xmlwriter.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module xml.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module tokenizer.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module sqlite3.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libsodium.so.26 from rpm libsodium-1.0.19-4.fc40.x86_64
Module sodium.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module soap.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module simplexml.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module phar.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libsasl2.so.3 from rpm cyrus-sasl-2.1.28-19.fc40.x86_64
Module libevent-2.1.so.7 from rpm libevent-2.1.12-12.fc40.x86_64
Module pgsql.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module pdo.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libonig.so.5 from rpm oniguruma-6.9.9-3.fc40.x86_64
Module mbstring.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libcap-ng.so.0 from rpm libcap-ng-0.8.4-4.fc40.x86_64
Module libeconf.so.0 from rpm libeconf-0.6.2-1.fc40.x86_64
Module libaudit.so.1 from rpm audit-4.0.1-1.fc40.x86_64
Module libpam.so.0 from rpm pam-1.6.0-2.fc40.x86_64
Module libc-client.so.2007 from rpm uw-imap-2007f-32.fc40.remi.x86_64
Module imap.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module iconv.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module gettext.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libvmaf.so.1 from rpm vmaf-2.3.0-7.fc40.x86_64
Module libXau.so.6 from rpm libXau-1.0.11-6.fc40.x86_64
Module libbrotlicommon.so.1 from rpm brotli-1.1.0-3.fc40.x86_64
Module libgraphite2.so.3 from rpm graphite2-1.3.14-15.fc40.x86_64
Module libglib-2.0.so.0 from rpm glib2-2.80.0-1.fc40.x86_64
Module libaom.so.3 from rpm aom-3.8.2-1.fc40.x86_64
Module libSvtAv1Enc.so.1 from rpm svt-av1-1.4.1-5.fc40.x86_64
Module librav1e.so.0 from rpm rust-rav1e-0.7.1-1.fc40.x86_64
Module libdav1d.so.7 from rpm dav1d-1.4.0-1.fc40.x86_64
Module libsharpyuv.so.0 from rpm libwebp-1.3.2-5.fc40.x86_64
Module libjbig.so.2.1 from rpm jbigkit-2.1-29.fc40.x86_64
Module libLerc.so.4 from rpm liblerc-4.0.0-6.fc40.x86_64
Module libxcb.so.1 from rpm libxcb-1.16-4.fc40.x86_64
Module libbrotlidec.so.1 from rpm brotli-1.1.0-3.fc40.x86_64
Module libharfbuzz.so.0 from rpm harfbuzz-8.3.0-5.fc40.x86_64
Module libavif.so.16 from rpm libavif-1.0.4-1.fc40.x86_64
Module libwebp.so.7 from rpm libwebp-1.3.2-5.fc40.x86_64
Module libtiff.so.6 from rpm libtiff-4.6.0-2.fc40.x86_64
Module libX11.so.6 from rpm libX11-1.8.9-1.fc40.x86_64
Module libXpm.so.4 from rpm libXpm-3.5.17-3.fc40.x86_64
Module libimagequant.so.0 from rpm rust-imagequant-sys-4.0.3-3.fc40.x86_64
Module libjpeg.so.62 from rpm libjpeg-turbo-3.0.2-1.fc40.x86_64
Module libfreetype.so.6 from rpm freetype-2.13.2-5.fc40.x86_64
Module libfontconfig.so.1 from rpm fontconfig-2.15.0-4.fc40.x86_64
Module libpng16.so.16 from rpm libpng-1.6.40-3.fc40.x86_64
Module libgd.so.3 from rpm gd-2.3.3-16.fc40.x86_64
Module gd.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module ftp.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module fileinfo.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module exif.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module dom.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libkeyutils.so.1 from rpm keyutils-1.6.3-3.fc40.x86_64
Module libkrb5support.so.0 from rpm krb5-1.21.2-5.fc40.x86_64
Module libcom_err.so.2 from rpm e2fsprogs-1.47.0-5.fc40.x86_64
Module libk5crypto.so.3 from rpm krb5-1.21.2-5.fc40.x86_64
Module libkrb5.so.3 from rpm krb5-1.21.2-5.fc40.x86_64
Module libunistring.so.5 from rpm libunistring-1.1-7.fc40.x86_64
Module libgssapi_krb5.so.2 from rpm krb5-1.21.2-5.fc40.x86_64
Module libidn2.so.0 from rpm libidn2-2.3.7-1.fc40.x86_64
Module libnghttp2.so.14 from rpm nghttp2-1.59.0-3.fc40.x86_64
Module libcurl.so.4 from rpm curl-8.6.0-8.fc40.x86_64
Module curl.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module ctype.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module calendar.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libbz2.so.1 from rpm bzip2-1.0.8-18.fc40.x86_64
Module bz2.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module bcmath.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module xdebug.so from rpm php-pecl-xdebug3-3.3.2-1.fc40.remi.8.3.x86_64
Module libcapstone.so.5 from rpm capstone-5.0.1-3.fc40.x86_64
Module opcache.so from rpm php-8.3.6-1.fc40.remi.x86_64
Module libzstd.so.1 from rpm zstd-1.5.6-1.fc40.x86_64
Module liblzma.so.5 from rpm xz-5.4.6-3.fc40.x86_64
Module liblz4.so.1 from rpm lz4-1.9.4-6.fc40.x86_64
Module libcap.so.2 from rpm libcap-2.69-8.fc40.x86_64
Module libattr.so.1 from rpm attr-2.5.2-3.fc40.x86_64
Module libz.so.1 from rpm zlib-ng-2.1.6-2.fc40.x86_64
Module libpcre2-8.so.0 from rpm pcre2-10.42-2.fc40.2.x86_64
Module libcrypto.so.3 from rpm openssl-3.2.1-2.fc40.x86_64
Module libssl.so.3 from rpm openssl-3.2.1-2.fc40.x86_64
Module libxml2.so.2 from rpm libxml2-2.12.6-1.fc40.x86_64
Module libsystemd.so.0 from rpm systemd-255.4-1.fc40.x86_64
Module libacl.so.1 from rpm acl-2.3.2-1.fc40.x86_64
Module libselinux.so.1 from rpm libselinux-3.6-4.fc40.x86_64
Module libcrypt.so.2 from rpm libxcrypt-4.4.36-5.fc40.x86_64
Module php-fpm from rpm php-8.3.6-1.fc40.remi.x86_64
Stack trace of thread 1686:
#0 0x00007f8569cab144 __pthread_kill_implementation (libc.so.6 + 0x98144)
#1 0x00007f8569c5365e raise (libc.so.6 + 0x4065e)
#2 0x00007f8569c3b902 abort (libc.so.6 + 0x28902)
#3 0x00007f8569c3c767 __libc_message_impl.cold (libc.so.6 + 0x29767)
#4 0x00007f8569cb5175 malloc_printerr (libc.so.6 + 0xa2175)
#5 0x00007f8569cb72b0 _int_free_merge_chunk (libc.so.6 + 0xa42b0)
#6 0x00007f8569cb75ba _int_free (libc.so.6 + 0xa45ba)
#7 0x00007f8569cb9dce free (libc.so.6 + 0xa6dce)
#8 0x00007f8558abc003 freePGconn (libpq.so.private16-5 + 0x10003)
#9 0x00007f8558270b72 pgsql_handle_closer (pdo_pgsql.so + 0x6b72)
#10 0x00007f8558270f63 pdo_pgsql_handle_factory (pdo_pgsql.so + 0x6f63)
#11 0x00007f8559aa0d0c zim_PDO___construct (pdo.so + 0xbd0c)
#12 0x0000561002550132 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b132)
#13 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#14 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#15 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#16 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#17 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#18 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#19 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#20 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#21 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#22 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#23 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#24 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#25 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#26 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#27 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#28 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#29 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#30 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#31 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#32 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#33 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#34 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#35 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#36 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#37 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#38 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#39 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#40 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#41 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#42 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#43 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#44 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#45 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#46 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#47 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#48 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#49 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#50 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#51 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#52 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#53 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#54 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#55 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#56 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#57 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#58 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#59 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#60 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#61 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
#62 0x0000561002550094 ZEND_DO_FCALL_SPEC_OBSERVER_HANDLER (php-fpm + 0x6b094)
#63 0x0000561002551208 execute_ex.cold (php-fpm + 0x6c208)
Stack trace of thread 8083:
#0 0x00007f8569d2918d syscall (libc.so.6 + 0x11618d)
#1 0x00007f8557d4f44a AbslInternalPerThreadSemWait_lts_20230802 (grpc.so + 0x34f44a)
#2 0x00007f8557d526c1 _ZN4absl12lts_202308027CondVar10WaitCommonEPNS0_5MutexENS0_24synchronization_internal13KernelTimeoutE (grpc.so + 0x3526c1)
#3 0x00007f8557c48376 gpr_cv_wait (grpc.so + 0x248376)
#4 0x00007f8557c5f3e6 _ZN9grpc_core8Executor10ThreadMainEPv (grpc.so + 0x25f3e6)
#5 0x00007f8557c48b3d _ZZN9grpc_core12_GLOBAL__N_120ThreadInternalsPosixC4EPKcPFvPvES4_PbRKNS_6Thread7OptionsEENUlS4_E_4_FUNES4_.lto_priv.0 (grpc.so + 0x248b3d)
#6 0x00007f8569ca91b7 start_thread (libc.so.6 + 0x961b7)
#7 0x00007f8569d2b39c __clone3 (libc.so.6 + 0x11839c)
Stack trace of thread 8085:
#0 0x00007f8569d2918d syscall (libc.so.6 + 0x11618d)
#1 0x00007f8557d4f3ba AbslInternalPerThreadSemWait_lts_20230802 (grpc.so + 0x34f3ba)
#2 0x00007f8557d526c1 _ZN4absl12lts_202308027CondVar10WaitCommonEPNS0_5MutexENS0_24synchronization_internal13KernelTimeoutE (grpc.so + 0x3526c1)
#3 0x00007f8557c483f7 gpr_cv_wait (grpc.so + 0x2483f7)
#4 0x00007f8557c779bb _ZL12timer_threadPv (grpc.so + 0x2779bb)
#5 0x00007f8557c48b3d _ZZN9grpc_core12_GLOBAL__N_120ThreadInternalsPosixC4EPKcPFvPvES4_PbRKNS_6Thread7OptionsEENUlS4_E_4_FUNES4_.lto_priv.0 (grpc.so + 0x248b3d)
#6 0x00007f8569ca91b7 start_thread (libc.so.6 + 0x961b7)
#7 0x00007f8569d2b39c __clone3 (libc.so.6 + 0x11839c)
Stack trace of thread 8084:
#0 0x00007f8569d2918d syscall (libc.so.6 + 0x11618d)
#1 0x00007f8557d4f44a AbslInternalPerThreadSemWait_lts_20230802 (grpc.so + 0x34f44a)
#2 0x00007f8557d526c1 _ZN4absl12lts_202308027CondVar10WaitCommonEPNS0_5MutexENS0_24synchronization_internal13KernelTimeoutE (grpc.so + 0x3526c1)
#3 0x00007f8557c48376 gpr_cv_wait (grpc.so + 0x248376)
#4 0x00007f8557c5f3e6 _ZN9grpc_core8Executor10ThreadMainEPv (grpc.so + 0x25f3e6)
#5 0x00007f8557c48b3d _ZZN9grpc_core12_GLOBAL__N_120ThreadInternalsPosixC4EPKcPFvPvES4_PbRKNS_6Thread7OptionsEENUlS4_E_4_FUNES4_.lto_priv.0 (grpc.so + 0x248b3d)
#6 0x00007f8569ca91b7 start_thread (libc.so.6 + 0x961b7)
#7 0x00007f8569d2b39c __clone3 (libc.so.6 + 0x11839c)
ELF object binary architecture: AMD x86-64
Description
It does not happen if
host=localhost
is removed from thepg_connect()
call. Happens in 8.2 and 8.3. Does NOT happen in 8.1. CLI is not affected.The following code:
Resulted in this output:
But I expected this output instead:
PHP Version
8.3.2, 8.2.15, 8.1.27
Operating System
macOS 14.1.2
Config Files
php83-fpm.conf.txt php83-www.conf.txt php81-fpm.conf.txt php81-www.conf.txt