Hi,
it seems dikkop is unhappy again, this time because of some OpenSSL
stuff. I'm not sure it's our problem - it might be issues with the other
packages, or maybe something FreeBSD specific, not sure.
We did some investigation of an unrelated issue on dikkop about a month
ago [1], so it wasn't doing/reporting the buildfram stuff for a while.
After that I had to poweroff/move the machine, and unfortunately it
didn't boot after that - it's a rpi4 so maybe the SD card got damaged or
something, not sure.
I used the opportunity to install the new 14-BETA1 (instead of the
14-current snapshot), but unfortunately it started having issues :-(
Both 11 and 12 failed with a weird openssl segfaults in plpython tests,
see [2] and [3]. And 13 is stuck in some openssl stuff in plpython
tests, with 100% CPU usage (for ~30h now):
#0 0x00000000850e86c0 in OPENSSL_sk_insert ()
from /usr/local/lib/libcrypto.so.11
#1 0x00000000850a5848 in CRYPTO_set_ex_data ()
from /usr/local/lib/libcrypto.so.11
...
Full backtrace attached. I'm not sure what could possibly be causing
this, except maybe something in FreeBSD? Or maybe there's some confusion
about libraries? No idea.
The system is entirely new, there's only a handful of packages installed
(full list attached), and I don't think I did anything strange or much
different from the previous 14-current install.
Any ideas what might be causing this?
regards
[1]
https://www.postgresql.org/message-id/b2bc5c16-899e-ca99-26ed-e623b4259ec7%40enterprisedb.com
[2]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dikkop&dt=2023-09-16%2021%3A10%3A45
[3]
https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=dikkop&dt=2023-09-17%2000%3A01%3A42
--
Tomas Vondra
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company(gdb) bt
#0 0x00000000850e86c0 in OPENSSL_sk_insert () from
/usr/local/lib/libcrypto.so.11
#1 0x00000000850a5848 in CRYPTO_set_ex_data () from
/usr/local/lib/libcrypto.so.11
#2 0x000000009fa6e698 in ossl_lib_ctx_generic_new (parent_ign=<optimized out>,
ptr_ign=<optimized out>, ad=0x9fced5b8, index=1, argl_ign=<optimized out>,
argp=<optimized out>) at /usr/src/crypto/openssl/crypto/context.c:333
#3 0x000000009fa716bc in ossl_crypto_alloc_ex_data_intern
(class_index=class_index@entry=16, obj=0x0, obj@entry=0x8116e690,
ad=ad@entry=0x9fced5b8, idx=1) at /usr/src/crypto/openssl/crypto/ex_data.c:456
#4 0x000000009fa6e360 in ossl_lib_ctx_get_data (ctx=ctx@entry=0x9fced5b0,
index=index@entry=3, meth=<optimized out>) at
/usr/src/crypto/openssl/crypto/context.c:428
#5 0x000000009fbcc69c in ossl_property_name (ctx=ctx@entry=0x9fced5b0,
s=0x9f9949bc "provider", create=create@entry=1) at
/usr/src/crypto/openssl/crypto/property/property_string.c:214
#6 0x000000009fbcbf14 in ossl_property_parse_init (ctx=ctx@entry=0x9fced5b0)
at /usr/src/crypto/openssl/crypto/property/property_parse.c:557
#7 0x000000009fa6dc3c in context_init (ctx=0x9fced5b0) at
/usr/src/crypto/openssl/crypto/context.c:102
#8 0x000000009fa6e0b0 in default_context_do_init () at
/usr/src/crypto/openssl/crypto/context.c:155
#9 default_context_do_init_ossl_ () at
/usr/src/crypto/openssl/crypto/context.c:152
#10 0x00000000896fccd8 in _thr_once (once_control=0x9fced780,
init_routine=0x9fa6e088 <default_context_do_init_ossl_>) at
/usr/src/lib/libthr/thread/thr_once.c:96
#11 0x00000000850ec218 in CRYPTO_THREAD_run_once () from
/usr/local/lib/libcrypto.so.11
#12 0x000000009fa6e250 in get_thread_default_context () at
/usr/src/crypto/openssl/crypto/context.c:166
#13 get_default_context () at /usr/src/crypto/openssl/crypto/context.c:174
#14 ossl_lib_ctx_get_concrete (ctx=0x0) at
/usr/src/crypto/openssl/crypto/context.c:295
#15 ossl_lib_ctx_get_data (ctx=0x0, index=0, index@entry=-2129205248,
meth=0x9fc9c778) at /usr/src/crypto/openssl/crypto/context.c:373
#16 0x000000009fb85cfc in get_evp_method_store (libctx=0x9fced5b0) at
/usr/src/crypto/openssl/crypto/evp/evp_fetch.c:82
#17 inner_evp_generic_fetch (methdata=methdata@entry=0x8116e8e0, prov=0x0,
prov@entry=0x8116e8c0, operation_id=operation_id@entry=1, name_id=0,
name_id@entry=-2129205056, name=0x0, name@entry=0x8116e8c0 "\300\244\267\237",
properties=0x0, properties@entry=0x8116e8c0 "\300\244\267\237",
new_method=0x9fb79fa0 <evp_md_from_algorithm>, up_ref_method=0x9fb7a49c
<evp_md_up_ref>, free_method=0x9fb7a4c0 <evp_md_free>)
at /usr/src/crypto/openssl/crypto/evp/evp_fetch.c:270
#18 0x000000009fb86748 in evp_generic_do_all (libctx=0x0, operation_id=1,
user_fn=0x9f7ee234, user_arg=0x8116e968, new_method=0x9fa6e6bc
<ossl_lib_ctx_generic_free>, up_ref_method=0x0, free_method=0x3)
at /usr/src/crypto/openssl/crypto/evp/evp_fetch.c:654
#19 0x000000009f7ea91c in PyInit__hashlib () from
/usr/local/lib/python3.9/lib-dynload/_hashlib.cpython-39.so
#20 0x00000000992abff8 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#21 0x00000000992ab860 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#22 0x00000000991feda4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#23 0x00000000992859f8 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#24 0x0000000099288efc in ?? () from /usr/local/lib/libpython3.9.so.1.0
#25 0x00000000991c0928 in _PyFunction_Vectorcall () from
/usr/local/lib/libpython3.9.so.1.0
#26 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#27 0x000000009928567c in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#28 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#29 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#30 0x0000000099285660 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#31 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#32 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#33 0x0000000099285700 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#34 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#35 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#36 0x0000000099285700 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#37 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#38 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#39 0x0000000099285700 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#40 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#41 0x00000000991c1ddc in ?? () from /usr/local/lib/libpython3.9.so.1.0
#42 0x00000000991c1fb4 in _PyObject_CallMethodIdObjArgs () from
/usr/local/lib/libpython3.9.so.1.0
#43 0x00000000992aa714 in PyImport_ImportModuleLevelObject () from
/usr/local/lib/libpython3.9.so.1.0
#44 0x0000000099284448 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#45 0x0000000099288efc in ?? () from /usr/local/lib/libpython3.9.so.1.0
#46 0x0000000099280058 in PyEval_EvalCode () from
/usr/local/lib/libpython3.9.so.1.0
#47 0x000000009927cc28 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#48 0x00000000991feda4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
--Type <RET> for more, q to quit, c to continue without paging--
#49 0x00000000992859f8 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#50 0x0000000099288efc in ?? () from /usr/local/lib/libpython3.9.so.1.0
#51 0x00000000991c0928 in _PyFunction_Vectorcall () from
/usr/local/lib/libpython3.9.so.1.0
#52 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#53 0x000000009928567c in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#54 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#55 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#56 0x0000000099285660 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#57 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#58 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#59 0x0000000099285700 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#60 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#61 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#62 0x0000000099285700 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#63 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#64 0x00000000991c1ddc in ?? () from /usr/local/lib/libpython3.9.so.1.0
#65 0x00000000991c1fb4 in _PyObject_CallMethodIdObjArgs () from
/usr/local/lib/libpython3.9.so.1.0
#66 0x00000000992aa714 in PyImport_ImportModuleLevelObject () from
/usr/local/lib/libpython3.9.so.1.0
#67 0x0000000099284448 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#68 0x00000000991c09e4 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#69 0x00000000992882d0 in ?? () from /usr/local/lib/libpython3.9.so.1.0
#70 0x0000000099285700 in _PyEval_EvalFrameDefault () from
/usr/local/lib/libpython3.9.so.1.0
#71 0x0000000099288efc in ?? () from /usr/local/lib/libpython3.9.so.1.0
#72 0x0000000099280058 in PyEval_EvalCode () from
/usr/local/lib/libpython3.9.so.1.0
#73 0x00000000967f360c in PLy_procedure_call (proc=proc@entry=0x553a88563120,
kargs=<optimized out>, vargs=<optimized out>) at plpy_exec.c:1050
#74 0x00000000967f2dc0 in PLy_exec_function
(fcinfo=fcinfo@entry=0x553a88569858, proc=0x553a88563120) at plpy_exec.c:104
#75 0x00000000967f4f44 in plpython3_call_handler (fcinfo=0x553a88569858) at
plpy_main.c:270
#76 0x00000000006a8190 in ExecInterpExpr (state=0x553a88569770,
econtext=<optimized out>, isnull=<optimized out>) at execExprInterp.c:680
#77 0x00000000006ded28 in ExecEvalExprSwitchContext (state=0x553a88569770,
econtext=0x553a88569470, isNull=0x8117162c) at
../../../src/include/executor/executor.h:322
#78 ExecProject (projInfo=0x553a88569768) at
../../../src/include/executor/executor.h:356
#79 ExecResult (pstate=<optimized out>) at nodeResult.c:136
#80 0x00000000006af9cc in ExecProcNode (node=0x553a88569358) at
../../../src/include/executor/executor.h:248
#81 ExecutePlan (estate=0x553a88569120, use_parallel_mode=<optimized out>,
operation=CMD_SELECT, numberTuples=0, direction=<optimized out>,
dest=0x553a88567d90, planstate=<optimized out>, sendTuples=<optimized out>,
execute_once=<optimized out>) at execMain.c:1632
#82 standard_ExecutorRun (queryDesc=0x553a87e3dd20, direction=<optimized out>,
count=0, execute_once=<optimized out>) at execMain.c:350
#83 0x000000000083bbf0 in PortalRunSelect (portal=portal@entry=0x553a87f2c120,
forward=<optimized out>, count=0, count@entry=9223372036854775807,
dest=dest@entry=0x553a88567d90) at pquery.c:921
#84 0x000000000083b814 in PortalRun (portal=portal@entry=0x553a87f2c120,
count=9223372036854775807, isTopLevel=<optimized out>, run_once=<optimized
out>, dest=dest@entry=0x553a88567d90, altdest=altdest@entry=0x553a88567d90,
qc=qc@entry=0x811719f0) at pquery.c:765
#85 0x000000000083aa48 in exec_simple_query
(query_string=query_string@entry=0x553a87e1f120 "SELECT import_test_one('sha
hash of this string');") at postgres.c:1238
#86 0x0000000000838470 in PostgresMain (argc=<optimized out>, argv=<optimized
out>, argv@entry=0x553a87f13340, dbname=<optimized out>, username=<optimized
out>) at postgres.c:4359
#87 0x00000000007accf4 in BackendRun (port=port@entry=0x553a87ecf000) at
postmaster.c:4560
#88 0x00000000007ac394 in BackendStartup (port=0x553a87ecf000) at
postmaster.c:4244
#89 ServerLoop () at postmaster.c:1742
#90 0x00000000007a9864 in PostmasterMain (argc=<optimized out>, argc@entry=3,
argv=<optimized out>, argv@entry=0x81172938) at postmaster.c:1415
#91 0x0000000000703098 in main (argc=3, argv=0x81172938) at main.c:210
bash-5.2.15
bison-3.8.2,1
boost-libs-1.82.0_1
ca_root_nss-3.92
ccache-3.7.12_4
curl-8.2.1
expat-2.5.0
flex-2.6.4_2
gdb-13.1_3
gettext-0.22
gettext-runtime-0.22_1
gettext-tools-0.22
git-2.42.0
gmake-4.3_2
gmp-6.3.0
htop-3.2.2_1
icu-73.2,1
indexinfo-0.3.1
libedit-3.1.20221030,1
libffi-3.4.4
libgcrypt-1.10.2
libgpg-error-1.47
libiconv-1.17
libidn2-2.3.4
liblz4-1.9.4,1
libnghttp2-1.55.1_1
libpsl-0.21.2_3
libssh2-1.11.0,3
libtextstyle-0.22
libtommath-1.2.0_2
libunistring-1.1
libxml2-2.10.4
libxslt-1.1.37
m4-1.4.19,1
mpdecimal-2.5.1
mpfr-4.2.0_2,1
nano-7.2
ncurses-6.4
openssl-1.1.1v,1
p5-Authen-NTLM-1.09_1
p5-Authen-SASL-2.17
p5-B-Hooks-EndOfScope-0.26
p5-CGI-4.57
p5-Clone-0.46
p5-Data-OptList-0.114
p5-Digest-HMAC-1.04
p5-Dist-CheckConflicts-0.11_1
p5-Encode-Locale-1.05
p5-Error-0.17029
p5-File-Listing-6.16
p5-GSSAPI-0.28_2
p5-HTML-Parser-3.81
p5-HTML-Tagset-3.20_1
p5-HTTP-CookieJar-0.014
p5-HTTP-Cookies-6.10
p5-HTTP-Date-6.06
p5-HTTP-Message-6.44
p5-HTTP-Negotiate-6.01_1
p5-IO-HTML-1.004
p5-IO-Socket-IP-0.42
p5-IO-Socket-SSL-2.083_1
p5-IO-Tty-1.17
p5-IPC-Run-20220807.0
p5-LWP-MediaTypes-6.04
p5-LWP-Protocol-https-6.11
p5-Module-Implementation-0.09_1
p5-Module-Runtime-0.016
p5-Mozilla-CA-20230807
p5-Net-HTTP-6.23
p5-Net-SSLeay-1.92
p5-Package-Stash-0.40
p5-Package-Stash-XS-0.30
p5-Params-Util-1.102
p5-Safe-Isa-1.000010
p5-Sub-Exporter-0.990
p5-Sub-Exporter-Progressive-0.001013
p5-Sub-Install-0.929
p5-Test-Harness-3.47
p5-Test-LWP-UserAgent-0.030
p5-TimeDate-2.33,1
p5-Try-Tiny-0.31
p5-URI-5.19
p5-Variable-Magic-0.63
p5-WWW-RobotRules-6.02_1
p5-libwww-6.70
p5-namespace-clean-0.27
pcre2-10.42
perl5-5.34.1_3
perl5-devel-5.39.0.62_3
pkg-1.20.6
pkgconf-1.8.1,1
python-3.9_3,2
python3-3_3
python39-3.9.17
readline-8.2.1
screen-4.9.1
source-highlight-3.1.9_6
sudo-1.9.14p3
tcl87-8.7.a5_1
xml2c-20151019_2
xxhash-0.8.2
zstd-1.5.5
