search

conda-forge / psycopg2-feedstock

A conda-smithy repository for psycopg2.
BSD 3-Clause "New" or "Revised" License
0 stars 12 forks source link

Psycopg2 segfaults with openssl == 3.2.0 #94

Closed matthewwardrop closed 2 months ago

matthewwardrop commented 9 months ago

Solution to issue cannot be found in the documentation.

Issue

Upstream postgres had a bug in its usage of openssl that caused it segfault with OpenSSL 3.2.0. This was fixed: https://github.com/conda-forge/postgresql-feedstock/issues/178 . However, I still see the segfault when using psycopg2. Is the binary statically linked or some such?

Installed packages

# Name                    Version                   Build  Channel
_libgcc_mutex             0.1                 conda_forge    conda-forge
_openmp_mutex             4.5                       2_gnu    conda-forge
_r-mutex                  1.0.1               anacondar_1    conda-forge
annotated-types           0.6.0              pyhd8ed1ab_0    conda-forge
astor                     0.8.1              pyh9f0ad1d_0    conda-forge
aws-c-auth                0.7.7                h4faf3ed_1    conda-forge
aws-c-cal                 0.6.9                h3b91eb8_1    conda-forge
aws-c-common              0.9.8                hd590300_0    conda-forge
aws-c-compression         0.2.17               hfd9eb17_6    conda-forge
aws-c-event-stream        0.3.2                h1fff966_7    conda-forge
aws-c-http                0.7.14               hc86c171_2    conda-forge
aws-c-io                  0.13.36              hc23c90e_0    conda-forge
aws-c-mqtt                0.9.10               hba57965_1    conda-forge
aws-c-s3                  0.4.1                hfadff92_0    conda-forge
aws-c-sdkutils            0.1.12               hfd9eb17_5    conda-forge
aws-checksums             0.1.17               hfd9eb17_5    conda-forge
aws-crt-cpp               0.24.7               h97e63c7_6    conda-forge
aws-sdk-cpp               1.11.182             h8beafcf_7    conda-forge
bash-completion           2.11                 ha770c72_1    conda-forge
bcrypt                    4.0.1            py39h9fdd4d6_1    conda-forge
beautifulsoup4            4.12.2             pyha770c72_0    conda-forge
binutils                  2.40                 hdd6e379_0    conda-forge
binutils_impl_linux-64    2.40                 hf600244_0    conda-forge
binutils_linux-64         2.40                 hbdbef99_2    conda-forge
boltons                   23.0.0             pyhd8ed1ab_0    conda-forge
brotli-python             1.1.0            py39h3d6467e_1    conda-forge
bwidget                   1.9.14               ha770c72_1    conda-forge
bzip2                     1.0.8                hd590300_5    conda-forge
c-ares                    1.22.1               hd590300_0    conda-forge
ca-certificates           2023.11.17           hbcca054_0    conda-forge
cached-property           1.5.2                hd8ed1ab_1    conda-forge
cached_property           1.5.2              pyha770c72_1    conda-forge
cairo                     1.18.0               h3faef2a_0    conda-forge
cctools                   949.0.1              h22b1bf0_7    conda-forge
cctools_osx-64            949.0.1              h5a3fd96_7    conda-forge
cffi                      1.16.0           py39h7a31438_0    conda-forge
chardet                   5.2.0            py39hf3d152e_1    conda-forge
click                     8.1.7           unix_pyh707e725_0    conda-forge
cmdstan                   2.33.1               hff4ab46_0    conda-forge
cmdstanpy                 1.2.0              pyhd8ed1ab_0    conda-forge
colorama                  0.4.6              pyhd8ed1ab_0    conda-forge
conda                     23.9.0           py39hf3d152e_0    conda-forge
conda-build               3.27.0           py39hf3d152e_0    conda-forge
conda-index               0.2.3              pyhd8ed1ab_0    conda-forge
conda-package-handling    2.2.0              pyh38be061_0    conda-forge
conda-package-streaming   0.9.0              pyhd8ed1ab_0    conda-forge
conda-tree                1.1.0              pyhd8ed1ab_2    conda-forge
coreutils                 9.4                  hd590300_0    conda-forge
cryptography              41.0.5           py39hd4f0224_0    conda-forge
curl                      8.4.0                hca28451_0    conda-forge
docker-py                 6.1.3              pyhd8ed1ab_0    conda-forge
docstring_parser          0.15               pyhd8ed1ab_0    conda-forge
expat                     2.5.0                hcb278e6_1    conda-forge
font-ttf-dejavu-sans-mono 2.37                 hab24e00_0    conda-forge
font-ttf-inconsolata      3.000                h77eed37_0    conda-forge
font-ttf-source-code-pro  2.038                h77eed37_0    conda-forge
font-ttf-ubuntu           0.83                 h77eed37_1    conda-forge
fontconfig                2.14.2               h14ed4e7_0    conda-forge
fonts-conda-ecosystem     1                             0    conda-forge
fonts-conda-forge         1                             0    conda-forge
formulaic                 0.6.6              pyhd8ed1ab_0    conda-forge
freetype                  2.12.1               h267a509_2    conda-forge
fribidi                   1.0.10               h36c2ea0_0    conda-forge
gcc                       12.3.0               h8d2909c_2    conda-forge
gcc_impl_linux-64         12.3.0               he2b93b0_3    conda-forge
gcc_linux-64              12.3.0               h76fc315_2    conda-forge
gdb                       12.1             py39hf8bf4ad_0    conda-forge
gettext                   0.21.1               h27087fc_0    conda-forge
gflags                    2.2.2             he1b5a44_1004    conda-forge
gfortran                  12.3.0               h499e0f7_2    conda-forge
gfortran_impl_linux-64    12.3.0               hfcedea8_3    conda-forge
glog                      0.6.0                h6f12383_0    conda-forge
gmp                       6.3.0                h59595ed_0    conda-forge
gmpy2                     2.1.2            py39h376b7d2_1    conda-forge
graphite2                 1.3.13            h58526e2_1001    conda-forge
graphlib-backport         1.0.3              pyhd8ed1ab_0    conda-forge
gxx                       12.3.0               h8d2909c_2    conda-forge
gxx_impl_linux-64         12.3.0               he2b93b0_3    conda-forge
gxx_linux-64              12.3.0               h8a814eb_2    conda-forge
harfbuzz                  8.3.0                h3d44ed6_0    conda-forge
icu                       73.2                 h59595ed_0    conda-forge
idna                      3.4                pyhd8ed1ab_0    conda-forge
importlib-metadata        6.8.0              pyha770c72_0    conda-forge
inflect                   7.0.0              pyhd8ed1ab_0    conda-forge
interface_meta            1.3.0              pyhd8ed1ab_0    conda-forge
jinja2                    3.1.2              pyhd8ed1ab_1    conda-forge
jsonpatch                 1.33               pyhd8ed1ab_0    conda-forge
jsonpointer               2.4              py39hf3d152e_3    conda-forge
kernel-headers_linux-64   2.6.32              he073ed8_16    conda-forge
keyutils                  1.6.1                h166bdaf_0    conda-forge
krb5                      1.21.2               h659d440_0    conda-forge
lazy-object-proxy         1.9.0            py39hd1e30aa_1    conda-forge
ld64                      530                           7    conda-forge
ld64_osx-64               530                  h3104ce3_7    conda-forge
ld_impl_linux-64          2.40                 h41732ed_0    conda-forge
lerc                      4.0.0                h27087fc_0    conda-forge
libabseil                 20230802.1      cxx17_h59595ed_0    conda-forge
libarchive                3.7.2                h039dbb9_0    conda-forge
libarrow                  14.0.1           h2b6da2a_4_cpu    conda-forge
libarrow-acero            14.0.1           h59595ed_4_cpu    conda-forge
libarrow-dataset          14.0.1           h59595ed_4_cpu    conda-forge
libarrow-flight           14.0.1           h120cb0d_4_cpu    conda-forge
libarrow-flight-sql       14.0.1           h61ff412_4_cpu    conda-forge
libarrow-gandiva          14.0.1           hacb8726_4_cpu    conda-forge
libarrow-substrait        14.0.1           h61ff412_4_cpu    conda-forge
libblas                   3.9.0           20_linux64_openblas    conda-forge
libbrotlicommon           1.1.0                hd590300_1    conda-forge
libbrotlidec              1.1.0                hd590300_1    conda-forge
libbrotlienc              1.1.0                hd590300_1    conda-forge
libcblas                  3.9.0           20_linux64_openblas    conda-forge
libcrc32c                 1.1.2                h9c3ff4c_0    conda-forge
libcurl                   8.4.0                hca28451_0    conda-forge
libdeflate                1.19                 hd590300_0    conda-forge
libedit                   3.1.20191231         he28a2e2_2    conda-forge
libev                     4.33                 h516909a_1    conda-forge
libevent                  2.1.12               hf998b51_1    conda-forge
libexpat                  2.5.0                hcb278e6_1    conda-forge
libffi                    3.4.2                h7f98852_5    conda-forge
libgcc-devel_linux-64     12.3.0             h8bca6fd_103    conda-forge
libgcc-ng                 13.2.0               h807b86a_3    conda-forge
libgfortran-ng            13.2.0               h69a702a_3    conda-forge
libgfortran5              13.2.0               ha4646dd_3    conda-forge
libgit2                   1.7.1                hca3a8ce_0    conda-forge
libglib                   2.78.1               hebfc3b9_0    conda-forge
libgomp                   13.2.0               h807b86a_3    conda-forge
libgoogle-cloud           2.12.0               h5206363_4    conda-forge
libgrpc                   1.59.3               hd6c4280_0    conda-forge
libhwloc                  2.9.3           default_h554bfaf_1009    conda-forge
libiconv                  1.17                 h166bdaf_0    conda-forge
libjpeg-turbo             3.0.0                hd590300_1    conda-forge
liblapack                 3.9.0           20_linux64_openblas    conda-forge
liblief                   0.12.3               h27087fc_0    conda-forge
libllvm10                 10.0.1               he513fc3_3    conda-forge
libllvm15                 15.0.7               h5cf9203_3    conda-forge
libnghttp2                1.58.0               h47da74e_0    conda-forge
libnsl                    2.0.1                hd590300_0    conda-forge
libnuma                   2.0.16               h0b41bf4_1    conda-forge
libopenblas               0.3.25          pthreads_h413a1c8_0    conda-forge
libparquet                14.0.1           h352af49_4_cpu    conda-forge
libpng                    1.6.39               h753d276_0    conda-forge
libpq                     16.1                 hfc447b1_0    conda-forge
libprotobuf               4.24.4               hf27288f_0    conda-forge
libre2-11                 2023.06.02           h7a70373_0    conda-forge
libsanitizer              12.3.0               h0f45ef3_3    conda-forge
libsodium                 1.0.18               h36c2ea0_1    conda-forge
libsqlite                 3.44.2               h2797004_0    conda-forge
libssh2                   1.11.0               h0841786_0    conda-forge
libstdcxx-devel_linux-64  12.3.0             h8bca6fd_103    conda-forge
libstdcxx-ng              13.2.0               h7e041cc_3    conda-forge
libthrift                 0.19.0               hb90f79a_1    conda-forge
libtiff                   4.6.0                ha9c0a0a_2    conda-forge
libunwind                 1.6.2                h9c3ff4c_0    conda-forge
libutf8proc               2.8.0                h166bdaf_0    conda-forge
libuuid                   2.38.1               h0b41bf4_0    conda-forge
libuv                     1.46.0               hd590300_0    conda-forge
libv8                     8.9.83               ha8e4f12_4    conda-forge
libwebp-base              1.3.2                hd590300_0    conda-forge
libxcb                    1.15                 h0b41bf4_0    conda-forge
libxml2                   2.11.6               h232c23b_0    conda-forge
libzlib                   1.2.13               hd590300_5    conda-forge
lz4-c                     1.9.4                hcb278e6_0    conda-forge
lzo                       2.10              h516909a_1000    conda-forge
make                      4.3                  hd18ef5c_1    conda-forge
markupsafe                2.1.3            py39hd1e30aa_1    conda-forge
meson                     1.2.3              pyhd8ed1ab_0    conda-forge
more-itertools            10.1.0             pyhd8ed1ab_0    conda-forge
mpc                       1.3.1                hfe3b2da_0    conda-forge
mpfr                      4.2.1                h9458935_0    conda-forge
mpmath                    1.3.0              pyhd8ed1ab_0    conda-forge
ncurses                   6.4                  h59595ed_2    conda-forge
ninja                     1.11.1               h924138e_0    conda-forge
nodejs                    20.8.1               h1990674_0    conda-forge
numpy                     1.24.4           py39h6183b62_0    conda-forge
openjdk                   8.0.382              hd590300_0    conda-forge
openssl                   3.1.4                hd590300_0    conda-forge
orc                       1.9.2                h4b38347_0    conda-forge
packaging                 23.2               pyhd8ed1ab_0    conda-forge
pandas                    2.1.3            py39hddac248_0    conda-forge
pandoc                    3.1.3                h32600fe_0    conda-forge
pango                     1.50.14              ha41ecd1_2    conda-forge
paramiko                  3.3.1              pyhd8ed1ab_0    conda-forge
patch                     2.7.6             h7f98852_1002    conda-forge
patchelf                  0.17.2               h58526e2_0    conda-forge
patsy                     0.5.3              pyhd8ed1ab_0    conda-forge
pcre2                     10.40                hc3806b6_0    conda-forge
pip                       23.3.1             pyhd8ed1ab_0    conda-forge
pipdeptree                2.9.1              pyhd8ed1ab_0    conda-forge
pixman                    0.42.2               h59595ed_0    conda-forge
pkginfo                   1.9.6              pyhd8ed1ab_0    conda-forge
pluggy                    1.3.0              pyhd8ed1ab_0    conda-forge
psutil                    5.9.5            py39hd1e30aa_1    conda-forge
psycopg2                  2.9.7            py39h89197e3_1    conda-forge
pthread-stubs             0.4               h36c2ea0_1001    conda-forge
py-lief                   0.12.3           py39h5a03fae_0    conda-forge
py-spy                    0.3.14               h87a5ac0_0    conda-forge
pyarrow                   14.0.1          py39h6925388_4_cpu    conda-forge
pycosat                   0.6.6            py39hd1e30aa_0    conda-forge
pycparser                 2.21               pyhd8ed1ab_0    conda-forge
pydantic                  2.5.2              pyhd8ed1ab_0    conda-forge
pydantic-core             2.14.5           py39h9fdd4d6_0    conda-forge
pygments                  2.17.2             pyhd8ed1ab_0    conda-forge
pynacl                    1.5.0            py39hd1e30aa_3    conda-forge
pyopenssl                 23.3.0             pyhd8ed1ab_0    conda-forge
pysocks                   1.7.1              pyha2e5f31_6    conda-forge
python                    3.9.18          h0755675_0_cpython    conda-forge
python-dateutil           2.8.2              pyhd8ed1ab_0    conda-forge
python-libarchive-c       5.0              py39hf3d152e_2    conda-forge
python-tzdata             2023.3             pyhd8ed1ab_0    conda-forge
python_abi                3.9                      4_cp39    conda-forge
pytz                      2023.3.post1       pyhd8ed1ab_0    conda-forge
pywin32-on-windows        0.1.0              pyh1179c8e_3    conda-forge
pyyaml                    6.0.1            py39hd1e30aa_1    conda-forge
r-arrow                   14.0.1            r43h59595ed_0    conda-forge
r-askpass                 1.2.0             r43h57805ef_0    conda-forge
r-assertthat              0.2.1             r43hc72bb7e_4    conda-forge
r-backports               1.4.1             r43h57805ef_2    conda-forge
r-base                    4.3.2                h93585b2_0    conda-forge
r-base64enc               0.1_3           r43h57805ef_1006    conda-forge
r-bigd                    0.2.0             r43hc72bb7e_1    conda-forge
r-bit                     4.0.5             r43h57805ef_1    conda-forge
r-bit64                   4.0.5             r43h57805ef_2    conda-forge
r-bitops                  1.0_7             r43h57805ef_2    conda-forge
r-brew                    1.0_8             r43hc72bb7e_2    conda-forge
r-brio                    1.1.3             r43h57805ef_2    conda-forge
r-bslib                   0.6.1             r43hc72bb7e_0    conda-forge
r-cachem                  1.0.8             r43h57805ef_1    conda-forge
r-callr                   3.7.3             r43hc72bb7e_1    conda-forge
r-caret                   6.0_94            r43h57805ef_1    conda-forge
r-class                   7.3_22            r43h57805ef_1    conda-forge
r-cli                     3.6.1             r43ha503ecb_1    conda-forge
r-clipr                   0.8.0             r43hc72bb7e_2    conda-forge
r-clock                   0.7.0             r43ha503ecb_1    conda-forge
r-codetools               0.2_19            r43hc72bb7e_1    conda-forge
r-colorspace              2.1_0             r43h57805ef_1    conda-forge
r-commonmark              1.9.0             r43h57805ef_1    conda-forge
r-conquer                 1.3.3             r43h08d816e_2    conda-forge
r-cpp11                   0.4.6             r43hc72bb7e_0    conda-forge
r-crayon                  1.5.2             r43hc72bb7e_2    conda-forge
r-credentials             2.0.1             r43hc72bb7e_0    conda-forge
r-curl                    5.1.0             r43hf9611b0_0    conda-forge
r-cyclocomp               1.1.1             r43hc72bb7e_0    conda-forge
r-data.table              1.14.8            r43h029312a_2    conda-forge
r-desc                    1.4.2             r43hc72bb7e_2    conda-forge
r-devtools                2.4.5             r43hc72bb7e_2    conda-forge
r-diagram                 1.6.5             r43ha770c72_2    conda-forge
r-diffobj                 0.3.5             r43h57805ef_2    conda-forge
r-digest                  0.6.33            r43ha503ecb_0    conda-forge
r-downlit                 0.4.3             r43hc72bb7e_0    conda-forge
r-dplyr                   1.1.4             r43ha503ecb_0    conda-forge
r-e1071                   1.7_13            r43ha503ecb_1    conda-forge
r-ellipsis                0.3.2             r43h57805ef_2    conda-forge
r-evaluate                0.23              r43hc72bb7e_0    conda-forge
r-fansi                   1.0.5             r43h57805ef_0    conda-forge
r-farver                  2.1.1             r43ha503ecb_2    conda-forge
r-fastmap                 1.1.1             r43ha503ecb_1    conda-forge
r-fontawesome             0.5.2             r43hc72bb7e_0    conda-forge
r-forcats                 1.0.0             r43hc72bb7e_1    conda-forge
r-foreach                 1.5.2             r43hc72bb7e_2    conda-forge
r-fs                      1.6.3             r43ha503ecb_0    conda-forge
r-future                  1.33.0            r43hc72bb7e_0    conda-forge
r-future.apply            1.11.0            r43hc72bb7e_1    conda-forge
r-generics                0.1.3             r43hc72bb7e_2    conda-forge
r-gert                    2.0.0             r43hc25a090_0    conda-forge
r-ggplot2                 3.4.4             r43hc72bb7e_0    conda-forge
r-gh                      1.4.0             r43hc72bb7e_1    conda-forge
r-gitcreds                0.1.2             r43hc72bb7e_2    conda-forge
r-glmnet                  4.1_8             r43hcf54a89_0    conda-forge
r-globals                 0.16.2            r43hc72bb7e_1    conda-forge
r-glue                    1.6.2             r43h57805ef_2    conda-forge
r-gower                   1.0.1             r43h57805ef_1    conda-forge
r-gsdesign                3.6.0             r43h57805ef_0    conda-forge
r-gt                      0.10.0            r43hc72bb7e_0    conda-forge
r-gtable                  0.3.4             r43hc72bb7e_0    conda-forge
r-hardhat                 1.3.0             r43hc72bb7e_1    conda-forge
r-highr                   0.10              r43hc72bb7e_1    conda-forge
r-htmltools               0.5.7             r43ha503ecb_0    conda-forge
r-htmlwidgets             1.6.3             r43hc72bb7e_0    conda-forge
r-httpuv                  1.6.12            r43ha503ecb_0    conda-forge
r-httr                    1.4.7             r43hc72bb7e_0    conda-forge
r-httr2                   1.0.0             r43hc72bb7e_0    conda-forge
r-ini                     0.3.1           r43hc72bb7e_1005    conda-forge
r-ipred                   0.9_14            r43h57805ef_1    conda-forge
r-irdisplay               1.1               r43hd8ed1ab_2    conda-forge
r-irkernel                1.3.2             r43h785f33e_1    conda-forge
r-isoband                 0.2.7             r43ha503ecb_2    conda-forge
r-iterators               1.0.14            r43hc72bb7e_2    conda-forge
r-jquerylib               0.1.4             r43hc72bb7e_2    conda-forge
r-jsonlite                1.8.7             r43h57805ef_0    conda-forge
r-juicyjuice              0.1.0             r43hc72bb7e_1    conda-forge
r-kernsmooth              2.23_22           r43h13b3f57_0    conda-forge
r-knitr                   1.45              r43hc72bb7e_0    conda-forge
r-labeling                0.4.3             r43hc72bb7e_0    conda-forge
r-later                   1.3.1             r43ha503ecb_1    conda-forge
r-lattice                 0.22_5            r43h57805ef_0    conda-forge
r-lava                    1.7.3             r43hc72bb7e_0    conda-forge
r-lazyeval                0.2.2             r43h57805ef_4    conda-forge
r-lifecycle               1.0.4             r43hc72bb7e_0    conda-forge
r-lintr                   3.1.1             r43hc72bb7e_0    conda-forge
r-listenv                 0.9.0             r43hc72bb7e_1    conda-forge
r-lobstr                  1.1.2             r43ha503ecb_3    conda-forge
r-lubridate               1.9.3             r43h57805ef_0    conda-forge
r-magrittr                2.0.3             r43h57805ef_2    conda-forge
r-markdown                1.11              r43hc72bb7e_0    conda-forge
r-mass                    7.3_60            r43h57805ef_1    conda-forge
r-matrix                  1.6_3             r43h316c678_0    conda-forge
r-matrixmodels            0.5_3             r43hc72bb7e_0    conda-forge
r-matrixstats             1.1.0             r43h57805ef_0    conda-forge
r-memoise                 2.0.1             r43hc72bb7e_2    conda-forge
r-mgcv                    1.9_0             r43h316c678_0    conda-forge
r-mime                    0.12              r43h57805ef_2    conda-forge
r-miniui                  0.1.1.1         r43hc72bb7e_1004    conda-forge
r-modelmetrics            1.2.2.2           r43ha503ecb_3    conda-forge
r-munsell                 0.5.0           r43hc72bb7e_1006    conda-forge
r-mvtnorm                 1.2_4             r43hd9ac46e_0    conda-forge
r-nlme                    3.1_164           r43h61816a4_0    conda-forge
r-nnet                    7.3_19            r43h57805ef_1    conda-forge
r-numderiv                2016.8_1.1        r43hc72bb7e_5    conda-forge
r-openssl                 2.1.1             r43hb353fa6_0    conda-forge
r-parallelly              1.36.0            r43hc72bb7e_1    conda-forge
r-pbdzmq                  0.3_10            r43ha81a24b_0    conda-forge
r-pillar                  1.9.0             r43hc72bb7e_1    conda-forge
r-pkgbuild                1.4.2             r43hc72bb7e_0    conda-forge
r-pkgconfig               2.0.3             r43hc72bb7e_3    conda-forge
r-pkgdown                 2.0.7             r43hc72bb7e_1    conda-forge
r-pkgload                 1.3.3             r43hc72bb7e_0    conda-forge
r-plyr                    1.8.9             r43ha503ecb_0    conda-forge
r-praise                  1.0.0           r43hc72bb7e_1007    conda-forge
r-prettyunits             1.2.0             r43hc72bb7e_0    conda-forge
r-proc                    1.18.5            r43ha503ecb_0    conda-forge
r-processx                3.8.2             r43h57805ef_0    conda-forge
r-prodlim                 2023.08.28        r43ha503ecb_0    conda-forge
r-profvis                 0.3.8             r43h57805ef_3    conda-forge
r-progressr               0.14.0            r43hc72bb7e_0    conda-forge
r-promises                1.2.1             r43ha503ecb_0    conda-forge
r-proxy                   0.4_27            r43h57805ef_2    conda-forge
r-ps                      1.7.5             r43h57805ef_1    conda-forge
r-purrr                   1.0.2             r43h57805ef_0    conda-forge
r-quantreg                5.97              r43hd9ac46e_0    conda-forge
r-r2rtf                   1.1.1             r43hc72bb7e_0    conda-forge
r-r6                      2.5.1             r43hc72bb7e_2    conda-forge
r-ragg                    1.2.6             r43h73ae6e3_0    conda-forge
r-rappdirs                0.3.3             r43h57805ef_2    conda-forge
r-rcmdcheck               1.4.0             r43h785f33e_2    conda-forge
r-rcolorbrewer            1.1_3             r43h785f33e_2    conda-forge
r-rcpp                    1.0.11            r43h7df8631_0    conda-forge
r-rcpparmadillo           0.12.6.4.0        r43h08d816e_0    conda-forge
r-rcppeigen               0.3.3.9.4         r43h08d816e_0    conda-forge
r-rcppparallel            5.1.6             r43ha503ecb_1    conda-forge
r-reactable               0.4.4             r43hc72bb7e_1    conda-forge
r-reactr                  0.5.0             r43hc72bb7e_0    conda-forge
r-recipes                 1.0.8             r43hc72bb7e_0    conda-forge
r-rematch2                2.1.2             r43hc72bb7e_3    conda-forge
r-remotes                 2.4.2.1           r43hc72bb7e_0    conda-forge
r-repr                    1.1.6             r43h785f33e_1    conda-forge
r-reshape2                1.4.4             r43ha503ecb_3    conda-forge
r-rex                     1.2.1             r43hc72bb7e_2    conda-forge
r-rlang                   1.1.2             r43ha503ecb_0    conda-forge
r-rmarkdown               2.25              r43hc72bb7e_0    conda-forge
r-roxygen2                7.2.3             r43ha503ecb_1    conda-forge
r-rpart                   4.1.21            r43h57805ef_0    conda-forge
r-rprojroot               2.0.4             r43hc72bb7e_0    conda-forge
r-rstudioapi              0.15.0            r43hc72bb7e_0    conda-forge
r-rversions               2.1.2             r43hc72bb7e_2    conda-forge
r-sandwich                3.0_2             r43hc72bb7e_2    conda-forge
r-sass                    0.4.7             r43ha503ecb_0    conda-forge
r-scales                  1.3.0             r43hc72bb7e_0    conda-forge
r-sessioninfo             1.2.2             r43hc72bb7e_2    conda-forge
r-shape                   1.4.6             r43ha770c72_2    conda-forge
r-shiny                   1.8.0             r43h785f33e_0    conda-forge
r-sourcetools             0.1.7_1           r43ha503ecb_1    conda-forge
r-sparsem                 1.81              r43h61816a4_2    conda-forge
r-squarem                 2021.1            r43hc72bb7e_2    conda-forge
r-stringi                 1.8.2             r43h9facbd6_0    conda-forge
r-stringr                 1.5.1             r43h785f33e_0    conda-forge
r-survival                3.5_7             r43h57805ef_0    conda-forge
r-sys                     3.4.2             r43h57805ef_1    conda-forge
r-systemfonts             1.0.5             r43haf97adc_0    conda-forge
r-testthat                3.2.0             r43ha503ecb_0    conda-forge
r-textshaping             0.3.7             r43hd87b9d6_0    conda-forge
r-tibble                  3.2.1             r43h57805ef_2    conda-forge
r-tidyr                   1.3.0             r43ha503ecb_1    conda-forge
r-tidyselect              1.2.0             r43hc72bb7e_1    conda-forge
r-timechange              0.2.0             r43ha503ecb_1    conda-forge
r-timedate                4022.108          r43hc72bb7e_1    conda-forge
r-tinytex                 0.49              r43hc72bb7e_0    conda-forge
r-tzdb                    0.4.0             r43ha503ecb_1    conda-forge
r-urlchecker              1.0.1             r43hc72bb7e_2    conda-forge
r-usethis                 2.2.2             r43hc72bb7e_0    conda-forge
r-utf8                    1.2.4             r43h57805ef_0    conda-forge
r-uuid                    1.1_1             r43h57805ef_0    conda-forge
r-v8                      4.4.0             r43h432ea70_0    conda-forge
r-vctrs                   0.6.4             r43ha503ecb_0    conda-forge
r-viridislite             0.4.2             r43hc72bb7e_1    conda-forge
r-waldo                   0.5.2             r43hc72bb7e_0    conda-forge
r-whisker                 0.4.1             r43hc72bb7e_1    conda-forge
r-withr                   2.5.2             r43hc72bb7e_0    conda-forge
r-xfun                    0.41              r43ha503ecb_0    conda-forge
r-xml2                    1.3.5             r43h1ad5fc0_0    conda-forge
r-xmlparsedata            1.0.5             r43hc72bb7e_2    conda-forge
r-xopen                   1.0.0           r43hc72bb7e_1005    conda-forge
r-xtable                  1.8_4             r43hc72bb7e_5    conda-forge
r-yaml                    2.3.7             r43h57805ef_1    conda-forge
r-zip                     2.3.0             r43h57805ef_1    conda-forge
r-zoo                     1.8_12            r43h57805ef_1    conda-forge
rdma-core                 28.9                 h59595ed_1    conda-forge
re2                       2023.06.02           h2873b5e_0    conda-forge
readline                  8.2                  h8228510_1    conda-forge
requests                  2.31.0             pyhd8ed1ab_0    conda-forge
ripgrep                   13.0.0               he8a937b_3    conda-forge
rpy2                      3.5.11          py39r43h44dd56e_3    conda-forge
rpy2-arrow                0.0.7              pyhd8ed1ab_0    conda-forge
ruamel.yaml               0.17.39          py39hd1e30aa_0    conda-forge
ruamel.yaml.clib          0.2.7            py39hd1e30aa_2    conda-forge
s2n                       1.3.56               h06160fa_0    conda-forge
scipy                     1.11.4           py39h474f0d3_0    conda-forge
sed                       4.8                  he412f7d_0    conda-forge
setuptools                68.2.2             pyhd8ed1ab_0    conda-forge
simplegeneric             0.8.1                      py_1    conda-forge
six                       1.16.0             pyh6c4a22f_0    conda-forge
snappy                    1.1.10               h9fff704_0    conda-forge
soupsieve                 2.5                pyhd8ed1ab_1    conda-forge
spec-classes              1.2.5              pyhd8ed1ab_0    conda-forge
stanio                    0.3.0              pyhd8ed1ab_0    conda-forge
statsmodels               0.14.0           py39h44dd56e_2    conda-forge
sympy                     1.12            pypyh9d50eac_103    conda-forge
sysroot_linux-64          2.12                he073ed8_16    conda-forge
tapi                      1000.10.8            hc9558a2_4    conda-forge
tbb                       2021.10.0            h00ab1b0_2    conda-forge
tbb-devel                 2021.10.0            h00ab1b0_2    conda-forge
tk                        8.6.13          noxft_h4845f30_101    conda-forge
tktable                   2.10                 h0c5db8f_5    conda-forge
tomli                     2.0.1              pyhd8ed1ab_0    conda-forge
tqdm                      4.66.1             pyhd8ed1ab_0    conda-forge
typing-extensions         4.8.0                hd8ed1ab_0    conda-forge
typing_extensions         4.8.0              pyha770c72_0    conda-forge
tzdata                    2023c                h71feb2d_0    conda-forge
tzlocal                   5.2              py39hf3d152e_0    conda-forge
ucx                       1.15.0               h64cca9d_0    conda-forge
urllib3                   1.26.18            pyhd8ed1ab_0    conda-forge
websocket-client          1.6.4              pyhd8ed1ab_0    conda-forge
wheel                     0.42.0             pyhd8ed1ab_0    conda-forge
wrapt                     1.16.0           py39hd1e30aa_0    conda-forge
xorg-kbproto              1.0.7             h7f98852_1002    conda-forge
xorg-libice               1.1.1                hd590300_0    conda-forge
xorg-libsm                1.2.4                h7391055_0    conda-forge
xorg-libx11               1.8.7                h8ee46fc_0    conda-forge
xorg-libxau               1.0.11               hd590300_0    conda-forge
xorg-libxdmcp             1.1.3                h7f98852_0    conda-forge
xorg-libxext              1.3.4                h0b41bf4_2    conda-forge
xorg-libxrender           0.9.11               hd590300_0    conda-forge
xorg-libxt                1.3.0                hd590300_1    conda-forge
xorg-renderproto          0.11.1            h7f98852_1002    conda-forge
xorg-xextproto            7.3.0             h0b41bf4_1003    conda-forge
xorg-xproto               7.0.31            h7f98852_1007    conda-forge
xz                        5.2.6                h166bdaf_0    conda-forge
yaml                      0.2.5                h7f98852_2    conda-forge
zeromq                    4.3.5                h59595ed_0    conda-forge
zipp                      3.17.0             pyhd8ed1ab_0    conda-forge
zlib                      1.2.13               hd590300_5    conda-forge
zstd                      1.5.5                hfc55251_0    conda-forge

Environment info

active environment : xp-env
    active env location : <<REDACTED>>
            shell level : 2
       user config file : <<HOME>>/.condarc
 populated config files : <<REDACTED>>/.condarc
                          <<REDACTED>>/condarc
          conda version : 23.3.1
    conda-build version : 3.25.0
         python version : 3.10.12.final.0
       virtual packages : __archspec=1=x86_64
                          __glibc=2.38=0
                          __linux=6.6.3=0
                          __unix=0=0
       base environment : <<REDACTED>>  (writable)
      conda av data dir : <<REDACTED>>/etc/conda
  conda av metadata url : None
           channel URLs : https://conda.anaconda.org/conda-forge/linux-64
                          https://conda.anaconda.org/conda-forge/noarch
          package cache : <<REDACTED>>/pkgs
                          <<HOME>>/.conda/pkgs
       envs directories : <<REDACTED>>/envs
                          <<HOME>>/.conda/envs
               platform : linux-64
             user-agent : conda/23.3.1 requests/2.31.0 CPython/3.10.12 Linux/6.6.3-arch1-1 arch/ glibc/2.38
                UID:GID : 1000:1000
             netrc file : None
           offline mode : False
akrherz commented 9 months ago

Sadly, I am attempting to figure this too. I was reproducing it earlier today, but my simple repo test case, just failed to reproduce it sigh...

matthewwardrop commented 9 months ago

Ugh. Heisenbugs are the worst.

Of course, if it continues to not reproduce more globally, I'd take the win ;).

akrherz commented 9 months ago

@matthewwardrop Are you apt installing anything onto your GHA runner? Hopefully I can isolate a simple repo shortly

matthewwardrop commented 9 months ago

Hi @akrherz ! I experience these issues when locally installing into an isolated conda environment. We do install some pip dependencies as well, but these are for proprietary purposes so I stripped them out of the conda list. The pip deps didn't override the psycopg package.

akrherz commented 9 months ago

sweet, I reproduced it in a simple repo, whew. But, I can not reproduce locally on linux 64, sigh.

akrherz commented 9 months ago

I have also now reproduced this on Github Actions with psycopg2 2.9.9, so a rebuild earlier today of it did not help :(

akrherz commented 9 months ago

related: conda-forge/openssl-feedstock#144

kindly wondering if @h-vetinari and/or @hmaarrfk have thoughts on this issue?

h-vetinari commented 9 months ago

You can see from the environment in the OP that it doesn't have OpenSSL 3.2 in it:

openssl                   3.1.4                hd590300_0    conda-forge

So this is very likely an unrelated issue. Also, to pick up the fix for https://github.com/conda-forge/postgresql-feedstock/issues/178, you need at least build number 1 or higher, whereas the environment in the OP has:

libpq                     16.1                 hfc447b1_0    conda-forge
                                                        ^
                                                        too old
akrherz commented 9 months ago

My psql reproducer here has

postgresql 16.1 h7387d8b_4 conda-forge

h-vetinari commented 9 months ago

It's not completely impossible that the patch backported in https://github.com/conda-forge/postgresql-feedstock/pull/181 (by touching the config) created a kind of soft ABI-break. Something compiled against unpatched postgresql might pick up a different config than the new one, with correspondingly different behaviour.

This is just hypothesis for now, but if so, we should rebuild this feedstock (i.e. compile against newest libqp) and see if the error persists. If so, we need a repodata patch to ensure that previous builds don't use the patched libpq (e.g. by simply adding openssl <3.2), and do the same for the v2 branch.

CC @conda-forge/postgresql, resp. @ocefpaf for merging https://github.com/conda-forge/postgresql-feedstock/pull/181

PS. Written before @akrherz's last comment but less important now:

> sweet, I [reproduced it](https://github.com/akrherz/psycopg_repo/actions/runs/7095051547/job/19311362285) in a simple repo, whew. But, I can not reproduce locally on linux 64, sigh. So that run actually used ``` libpq 16.1 hedfdc17_4 conda-forge openssl 3.2.0 hd590300_1 conda-forge psycopg 3.1.14 py312h052295b_0 conda-forge ``` but also a different psycopg version compared to the OP, which had: ``` psycopg2 2.9.7 py39h89197e3_1 conda-forge ```
h-vetinari commented 9 months ago

It's not completely impossible that the patch [...] created a kind of soft ABI-break

This is looking more and more likely IMO.

matthewwardrop commented 9 months ago

Oh... My apologies. I may also have reverted the update to OpenSSL 3.2 and verified that it solved things, but forgot to roll the packages forward again. 3.1.* works fine here. It's updating to 3.2 that causes the problem.

On Mon, Dec 4, 2023, 21:43 h-vetinari @.***> wrote:

It's not completely impossible that the patch [...] created a kind of soft ABI-break

This is looking more and more likely https://github.com/conda-forge/postgresql-feedstock/issues/191#issuecomment-1840051154 IMO.

— Reply to this email directly, view it on GitHub https://github.com/conda-forge/psycopg2-feedstock/issues/94#issuecomment-1840052389, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAA6P3RCILN6U4HAI7BLCNLYH2YB7AVCNFSM6AAAAABAGZKP7OVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTQNBQGA2TEMZYHE . You are receiving this because you were mentioned.Message ID: @.***>

akrherz commented 9 months ago

build 6 of postgresql/libpq 16.1 should fix this issue. I am no longer able to reproduce it.

akrherz commented 8 months ago

@matthewwardrop Are you still having this issue?

xylar commented 2 months ago

I'm closing this issue as it seems like it might be fixed. Please re-open if not.