Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

php-fpm SIGABRT when pg_connect() called with host parameter #13339

Open
ianthrive opened this issue Feb 6, 2024 · 17 comments
Open

php-fpm SIGABRT when pg_connect() called with host parameter #13339

ianthrive opened this issue Feb 6, 2024 · 17 comments
Assignees
@devnexen
Labels
Bug Extension: pgsql SAPI: fpm Status: Verified

Comments

@ianthrive
Copy link

ianthrive commented Feb 6, 2024 •
edited
Loading

Description

It does not happen if host=localhost is removed from the pg_connect() call.
Happens in 8.2 and 8.3. Does NOT happen in 8.1.
CLI is not affected.

The following code:

<?php
$c = pg_connect('host=localhost user=ian dbname=ipb');
print("done\n");

Resulted in this output:

[06-Feb-2024 11:04:49.029619] DEBUG: pid 85554, fpm_pctl_perform_idle_server_maintenance(), line 382: [pool www] currently 0 active children, 0 spare children
[06-Feb-2024 11:04:49.392539] DEBUG: pid 85554, fpm_children_make(), line 430: blocking signals before child birth
[06-Feb-2024 11:04:49.395351] DEBUG: pid 85554, fpm_children_make(), line 454: unblocking signals, child born
[06-Feb-2024 11:04:49.395602] DEBUG: pid 85554, fpm_children_make(), line 460: [pool www] child 85609 started
[06-Feb-2024 11:04:49.395736] DEBUG: pid 85554, fpm_pctl_on_socket_accept(), line 553: [pool www] got accept without idle child available .... I forked
[06-Feb-2024 11:04:49.395882] DEBUG: pid 85554, fpm_event_loop(), line 435: event module triggered 1 events
[06-Feb-2024 11:04:49.413857] DEBUG: pid 85554, fpm_got_signal(), line 82: received SIGCHLD
[06-Feb-2024 11:04:49.416453] DEBUG: pid 85554, fpm_event_loop(), line 435: event module triggered 1 events
[06-Feb-2024 11:04:49.417548] WARNING: pid 85554, fpm_children_bury(), line 281: [pool www] child 85609 exited on signal 6 (SIGABRT) after 0.021964 seconds from start
[06-Feb-2024 11:04:49.417756] DEBUG: pid 85554, fpm_children_make(), line 430: blocking signals before child birth
[06-Feb-2024 11:04:49.421868] DEBUG: pid 85554, fpm_children_make(), line 454: unblocking signals, child born
[06-Feb-2024 11:04:49.422117] NOTICE: pid 85554, fpm_children_make(), line 460: [pool www] child 85611 started
[06-Feb-2024 11:04:50.031248] DEBUG: pid 85554, fpm_pctl_perform_idle_server_maintenance(), line 382: [pool www] currently 0 active children, 1 spare children

But I expected this output instead:

done

% uname -a
Darwin ian.local 23.1.0 Darwin Kernel Version 23.1.0: Mon Oct  9 21:27:24 PDT 2023; root:xnu-10002.41.9~6/RELEASE_ARM64_T6000 arm64

% sw_vers -ProductVersion
14.1.2

/opt/local/bin/php83 -v
PHP 8.3.2 (cli) (built: Jan 26 2024 23:59:55) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.3.2, Copyright (c) Zend Technologies

% /opt/local/bin/php81 -v
PHP 8.1.27 (cli) (built: Jan  9 2024 01:07:36) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.27, Copyright (c) Zend Technologies

% otool -L /opt/local/lib/php83/extensions/no-debug-non-zts-20230831/pgsql.so
/opt/local/lib/php83/extensions/no-debug-non-zts-20230831/pgsql.so:
	/opt/local/lib/postgresql15/libpq.5.dylib (compatibility version 5.0.0, current version 5.15.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1336.0.0)

% otool -L /opt/local/lib/php81/extensions/no-debug-non-zts-20210902/pgsql.so 
/opt/local/lib/php81/extensions/no-debug-non-zts-20210902/pgsql.so:
	/opt/local/lib/postgresql15/libpq.5.dylib (compatibility version 5.0.0, current version 5.15.0)
	/usr/lib/libSystem.B.dylib (compatibility version 1.0.0, current version 1336.0.0)

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

% wdiff -3 php81/php-fpm.conf php83/php-fpm.conf

======================================================================
 [-run/php81/php-fpm.pid-] {+run/php83/php-fpm.pid+}
======================================================================
 [-log/php81/php-fpm.log-] {+log/php83/php-fpm.log+}
======================================================================
 [-php81-fpm-] {+php83-fpm+}
======================================================================

[-include=/opt/local/etc/php81/php-fpm.d/*.conf-]
{+include=/opt/local/etc/php83/php-fpm.d/*.conf+}
======================================================================

% wdiff -3 php81/php-fpm.d/www.conf php83/php-fpm.d/www.conf 

======================================================================
 {+Linux,+}
======================================================================


{+; Set the associated the route table (FIB). FreeBSD only
; Default Value: -1
;listen.setfib = 1+}
======================================================================
 [-prctl)-] {+prctl for Linux or
; PROC_TRACE_CTL procctl for FreeBSD)+}
======================================================================
 [-/opt/local/share/examples/php81/fpm/status.html-] {+/opt/local/share/examples/php83/fpm/status.html+}
======================================================================
 {+A list of request_uri values which should be filtered from the access log.
;
; As a security precuation, this setting will be ignored if:
;     - the request method is not GET or HEAD; or
;     - there is a request body; or
;     - there are query parameters; or
;     - the response code is outwith the successful range of 200 to 299
;
; Note:+}
======================================================================
 {+paths are matched against the output of the access.format tag "%r".
;       On common configurations, this may look more like SCRIPT_NAME than the
;       expected pre-rewrite URI.
;
; Default Value: not set
;access.suppress_path[] = /ping
;access.suppress_path[] = /health_check.php

; The+}
======================================================================
@devnexen
Copy link
Member

devnexen commented Feb 6, 2024 •
edited
Loading

is the issue occurring with php cli too ?

@ianthrive
Copy link
Author

is the issue occurring with php cli too ?

No, cli is not affected.

@devnexen
Copy link
Member

devnexen commented Feb 6, 2024

would it be possible to share a bit more infos ? e.g. relevant fpm config.

@ianthrive
Copy link
Author

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.

@ianthrive
Copy link
Author

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.

@devnexen
Copy link
Member

devnexen commented Feb 6, 2024

Does it happen also with persistent connections ?

@ianthrive
Copy link
Author

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.

@ianthrive
Copy link
Author

ianthrive commented Feb 6, 2024 •
edited
Loading

A couple other notes:

  • changing localhost to 127.0.0.1 has no effect
  • nginx is configured with fastcgi_pass 127.0.0.1:9000 and returns HTTP 502 Bad Gateway to the client

@devnexen
Copy link
Member

devnexen commented Feb 7, 2024

Ok thanks I ll have a better look some time this week.

@devnexen devnexen self-assigned this Feb 7, 2024
@ianthrive
Copy link
Author

@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.

@devnexen
Copy link
Member

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 ?

@ianthrive
Copy link
Author

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.

@devnexen
Copy link
Member

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

@devnexen
Copy link
Member

Would it be possible for you to try if you still get the issue if you add gssencmode=disable to your connection string ?

@ianthrive
Copy link
Author

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');

@devnexen
Copy link
Member

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".

@hacfi hacfi mentioned this issue Mar 1, 2024
Closed
@leonelvsc
Copy link

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

@leonelvsc leonelvsc mentioned this issue Apr 26, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@devnexen devnexen

Labels
Bug Extension: pgsql SAPI: fpm Status: Verified
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@ianthrive @leonelvsc @devnexen