Current release of [rds] optional dependencies cannot be installed on Mac

[dbirman]

Describe the bug
On both my M1 and M3 macbook pros running Sonoma I can't install the redshift optional dependencies anymore. I'm not sure if it's the same issue on both. I'm using Python 3.12 and 3.13 respectively.

To Reproduce
Steps to reproduce the behavior:

1. pip install aind-data-access-api[rds]

  error: subprocess-exited-with-error
  
  × Preparing metadata (pyproject.toml) did not run successfully.
  │ exit code: 1
  ╰─> [227 lines of output]
      + meson setup /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9 /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/.mesonpy-65s8ums2/build -Dbuildtype=release -Db_ndebug=if-release -Db_vscrt=md --vsenv --native-file=/private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/.mesonpy-65s8ums2/build/meson-python-native-file.ini
      The Meson build system
      Version: 1.2.1
      Source dir: /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9
      Build dir: /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/.mesonpy-65s8ums2/build
      Build type: native build
      Project name: pandas
      Project version: 2.1.4
      C compiler for the host machine: cc (clang 16.0.0 "Apple clang version 16.0.0 (clang-1600.0.26.6)")
      C linker for the host machine: cc ld64 1115.7.3
      C++ compiler for the host machine: c++ (clang 16.0.0 "Apple clang version 16.0.0 (clang-1600.0.26.6)")
      C++ linker for the host machine: c++ ld64 1115.7.3
      Cython compiler for the host machine: cython (cython 0.29.37)
      Host machine cpu family: aarch64
      Host machine cpu: aarch64
      Program python found: YES (/Users/daniel.birman/proj/aind-metadata-upgrader/.venv/bin/python3.13)
      Did not find pkg-config by name 'pkg-config'
      Found Pkg-config: NO
      Run-time dependency python found: YES 3.13
      Build targets in project: 53
      
      pandas 2.1.4
      
        User defined options
          Native files: /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/.mesonpy-65s8ums2/build/meson-python-native-file.ini
          buildtype   : release
          vsenv       : True
          b_ndebug    : if-release
          b_vscrt     : md
      
      Found ninja-1.13.0.git.kitware.jobserver-pipe-1 at /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-build-env-k3g9lq7d/normal/bin/ninja
      
      Visual Studio environment is needed to run Ninja. It is recommended to use Meson wrapper:
      /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-build-env-k3g9lq7d/overlay/bin/meson compile -C .
      + /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-build-env-k3g9lq7d/normal/bin/ninja
      [1/151] Generating pandas/_libs/intervaltree_helper_pxi with a custom command
      [2/151] Generating pandas/_libs/algos_common_helper_pxi with a custom command
      [3/151] Generating pandas/_libs/khash_primitive_helper_pxi with a custom command
      [4/151] Generating pandas/_libs/hashtable_func_helper_pxi with a custom command
      [5/151] Generating pandas/_libs/index_class_helper_pxi with a custom command
      [6/151] Generating pandas/_libs/algos_take_helper_pxi with a custom command
      [7/151] Generating pandas/_libs/hashtable_class_helper_pxi with a custom command
      [8/151] Generating pandas/_libs/sparse_op_helper_pxi with a custom command
      [9/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/base.pyx
      [10/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/nattype.pyx
      [11/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/ccalendar.pyx
      [12/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/dtypes.pyx
      [13/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/np_datetime.pyx
      [14/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/timezones.pyx
      [15/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/strptime.pyx
      [16/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/fields.pyx
      [17/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/parsing.pyx
      [18/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/conversion.pyx
      [19/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/timestamps.pyx
      [20/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/offsets.pyx
      [21/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/timedeltas.pyx
      [22/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/period.pyx
      [23/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/indexing.pyx
      [24/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/arrays.pyx
      [25/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/vectorized.pyx
      [26/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslibs/tzconversion.pyx
      [27/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/ops_dispatch.pyx
      [28/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/properties.pyx
      [29/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/missing.pyx
      [30/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/hashing.pyx
      [31/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/internals.pyx
      [32/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/byteswap.pyx
      [33/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/ops.pyx
      [34/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/sas.pyx
      [35/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/index.pyx
      [36/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/lib.pyx
      [37/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/parsers.pyx
      [38/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/reshape.pyx
      [39/151] Compiling C object pandas/_libs/tslibs/base.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_base.pyx.c.o
      FAILED: [code=1] pandas/_libs/tslibs/base.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_base.pyx.c.o
      cc -Ipandas/_libs/tslibs/base.cpython-313-darwin.so.p -Ipandas/_libs/tslibs -I../../pandas/_libs/tslibs -I../../../../pip-build-env-k3g9lq7d/overlay/lib/python3.13/site-packages/numpy/core/include -I../../pandas/_libs/include -I/opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13 -I/opt/homebrew/Cellar/python@3.13/3.13.0_1/Frameworks/Python.framework/Versions/3.13/include/python3.13 -fvisibility=hidden -fcolor-diagnostics -DNDEBUG -w -std=c99 -O3 -DNPY_NO_DEPRECATED_API=0 -DNPY_TARGET_VERSION=NPY_1_21_API_VERSION -MD -MQ pandas/_libs/tslibs/base.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_base.pyx.c.o -MF pandas/_libs/tslibs/base.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_base.pyx.c.o.d -o pandas/_libs/tslibs/base.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_base.pyx.c.o -c pandas/_libs/tslibs/base.cpython-313-darwin.so.p/pandas/_libs/tslibs/base.pyx.c
      pandas/_libs/tslibs/base.cpython-313-darwin.so.p/pandas/_libs/tslibs/base.pyx.c:5399:70: error: too few arguments to function call, expected 6, have 5
       5397 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
            |                           ~~~~~~~~~~~~~~~~~~~
       5398 |                                               bytes, sizeof(val),
       5399 |                                               is_little, !is_unsigned);
            |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      pandas/_libs/tslibs/base.cpython-313-darwin.so.p/pandas/_libs/tslibs/base.pyx.c:5633:70: error: too few arguments to function call, expected 6, have 5
       5631 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
            |                           ~~~~~~~~~~~~~~~~~~~
       5632 |                                               bytes, sizeof(val),
       5633 |                                               is_little, !is_unsigned);
            |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      2 errors generated.
      [40/151] Compiling C object pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_ccalendar.pyx.c.o
      FAILED: [code=1] pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_ccalendar.pyx.c.o
      cc -Ipandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p -Ipandas/_libs/tslibs -I../../pandas/_libs/tslibs -I../../../../pip-build-env-k3g9lq7d/overlay/lib/python3.13/site-packages/numpy/core/include -I../../pandas/_libs/include -I/opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13 -I/opt/homebrew/Cellar/python@3.13/3.13.0_1/Frameworks/Python.framework/Versions/3.13/include/python3.13 -fvisibility=hidden -fcolor-diagnostics -DNDEBUG -w -std=c99 -O3 -DNPY_NO_DEPRECATED_API=0 -DNPY_TARGET_VERSION=NPY_1_21_API_VERSION -MD -MQ pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_ccalendar.pyx.c.o -MF pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_ccalendar.pyx.c.o.d -o pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_ccalendar.pyx.c.o -c pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/pandas/_libs/tslibs/ccalendar.pyx.c
      pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/pandas/_libs/tslibs/ccalendar.pyx.c:7378:70: error: too few arguments to function call, expected 6, have 5
       7376 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
            |                           ~~~~~~~~~~~~~~~~~~~
       7377 |                                               bytes, sizeof(val),
       7378 |                                               is_little, !is_unsigned);
            |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      pandas/_libs/tslibs/ccalendar.cpython-313-darwin.so.p/pandas/_libs/tslibs/ccalendar.pyx.c:7688:70: error: too few arguments to function call, expected 6, have 5
       7686 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
            |                           ~~~~~~~~~~~~~~~~~~~
       7687 |                                               bytes, sizeof(val),
       7688 |                                               is_little, !is_unsigned);
            |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      2 errors generated.
      [41/151] Compiling C object pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_dtypes.pyx.c.o
      FAILED: [code=1] pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_dtypes.pyx.c.o
      cc -Ipandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p -Ipandas/_libs/tslibs -I../../pandas/_libs/tslibs -I../../../../pip-build-env-k3g9lq7d/overlay/lib/python3.13/site-packages/numpy/core/include -I../../pandas/_libs/include -I/opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13 -I/opt/homebrew/Cellar/python@3.13/3.13.0_1/Frameworks/Python.framework/Versions/3.13/include/python3.13 -fvisibility=hidden -fcolor-diagnostics -DNDEBUG -w -std=c99 -O3 -DNPY_NO_DEPRECATED_API=0 -DNPY_TARGET_VERSION=NPY_1_21_API_VERSION -MD -MQ pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_dtypes.pyx.c.o -MF pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_dtypes.pyx.c.o.d -o pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/meson-generated_pandas__libs_tslibs_dtypes.pyx.c.o -c pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:11412:7: error: call to undeclared function '_PyDict_SetItem_KnownHash'; ISO C99 and later do not support implicit function declarations [-Wimplicit-function-declaration]
       11412 |   if (__Pyx_SetNameInClass(__pyx_t_8, __pyx_n_s_FR_ANN, __pyx_t_2) < 0) __PYX_ERR(0, 189, __pyx_L1_error)
             |       ^
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:1893:38: note: expanded from macro '__Pyx_SetNameInClass'
       1893 |     (likely(PyDict_CheckExact(ns)) ? _PyDict_SetItem_KnownHash(ns, name, value, ((PyASCIIObject *) name)->hash) : PyObject_SetItem(ns, name, value))
            |                                      ^
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:11412:7: note: did you mean '_PyDict_GetItem_KnownHash'?
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:1893:38: note: expanded from macro '__Pyx_SetNameInClass'
       1893 |     (likely(PyDict_CheckExact(ns)) ? _PyDict_SetItem_KnownHash(ns, name, value, ((PyASCIIObject *) name)->hash) : PyObject_SetItem(ns, name, value))
            |                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/dictobject.h:38:24: note: '_PyDict_GetItem_KnownHash' declared here
         38 | PyAPI_FUNC(PyObject *) _PyDict_GetItem_KnownHash(PyObject *mp, PyObject *key,
            |                        ^
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:16381:70: error: too few arguments to function call, expected 6, have 5
       16379 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
             |                           ~~~~~~~~~~~~~~~~~~~
       16380 |                                               bytes, sizeof(val),
       16381 |                                               is_little, !is_unsigned);
             |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:16577:70: error: too few arguments to function call, expected 6, have 5
       16575 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
             |                           ~~~~~~~~~~~~~~~~~~~
       16576 |                                               bytes, sizeof(val),
       16577 |                                               is_little, !is_unsigned);
             |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:16925:70: error: too few arguments to function call, expected 6, have 5
       16923 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
             |                           ~~~~~~~~~~~~~~~~~~~
       16924 |                                               bytes, sizeof(val),
       16925 |                                               is_little, !is_unsigned);
             |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:17197:70: error: too few arguments to function call, expected 6, have 5
       17195 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
             |                           ~~~~~~~~~~~~~~~~~~~
       17196 |                                               bytes, sizeof(val),
       17197 |                                               is_little, !is_unsigned);
             |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      pandas/_libs/tslibs/dtypes.cpython-313-darwin.so.p/pandas/_libs/tslibs/dtypes.pyx.c:17431:70: error: too few arguments to function call, expected 6, have 5
       17429 |                 int ret = _PyLong_AsByteArray((PyLongObject *)v,
             |                           ~~~~~~~~~~~~~~~~~~~
       17430 |                                               bytes, sizeof(val),
       17431 |                                               is_little, !is_unsigned);
             |                                                                      ^
      /opt/homebrew/opt/python@3.13/Frameworks/Python.framework/Versions/3.13/include/python3.13/cpython/longobject.h:111:17: note: '_PyLong_AsByteArray' declared here
        111 | PyAPI_FUNC(int) _PyLong_AsByteArray(PyLongObject* v,
            |                 ^                   ~~~~~~~~~~~~~~~~
        112 |     unsigned char* bytes, size_t n,
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        113 |     int little_endian, int is_signed, int with_exceptions);
            |     ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
      6 errors generated.
      [42/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/interval.pyx
      [43/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/tslib.pyx
      [44/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/testing.pyx
      [45/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/window/indexers.pyx
      [46/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/writers.pyx
      [47/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/sparse.pyx
      [48/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/window/aggregations.pyx
      [49/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/groupby.pyx
      [50/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/join.pyx
      [51/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/algos.pyx
      [52/151] Compiling Cython source /private/var/folders/xc/dy775dmx531c7m3xzhq8m3_h0000gp/T/pip-install-e_t60mni/pandas_2795ee5ffc0e49adb19e12db0ce94ca9/pandas/_libs/hashtable.pyx
      ninja: build stopped: subcommand failed.
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.

Expected behavior
I think the issue is pinning pandas to a particular version for this version, not totally sure from the error. On the M1 mac I think the issue is related to the psycopg2-binary package which no longer installs, also might be an issue with pinning versions. Current pandas release is 2.3.1 is there a reason to have a ceiling or can we change the requirement to "<3"

[dbirman]

pip install aind-data-access-api[rds] is also crashing on Code Ocean capsules now, using the Python (3.12.4, Ubuntu 22.04) environment:

  error: subprocess-exited-with-error
  
  × python setup.py egg_info did not run successfully.
  │ exit code: 1
  ╰─> [23 lines of output]
      running egg_info
      creating /tmp/pip-pip-egg-info-dh7x07ev/psycopg2_binary.egg-info
      writing /tmp/pip-pip-egg-info-dh7x07ev/psycopg2_binary.egg-info/PKG-INFO
      writing dependency_links to /tmp/pip-pip-egg-info-dh7x07ev/psycopg2_binary.egg-info/dependency_links.txt
      writing top-level names to /tmp/pip-pip-egg-info-dh7x07ev/psycopg2_binary.egg-info/top_level.txt
      writing manifest file '/tmp/pip-pip-egg-info-dh7x07ev/psycopg2_binary.egg-info/SOURCES.txt'
      
      Error: pg_config executable not found.
      
      pg_config is required to build psycopg2 from source.  Please add the directory
      containing pg_config to the $PATH or specify the full executable path with the
      option:
      
          python setup.py build_ext --pg-config /path/to/pg_config build ...
      
      or with the pg_config option in 'setup.cfg'.
      
      If you prefer to avoid building psycopg2 from source, please install the PyPI
      'psycopg2-binary' package instead.
      
      For further information please check the 'doc/src/install.rst' file (also at
      <https://www.psycopg.org/docs/install.html>).
      
      [end of output]
  
  note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

[yosefmaru]

I was able to replicate the issue in CO capsule that runs on Ubuntu 22.04 and Python 3.12.4. Installing libpq-dev and gcc seems to solve the issue (apt install -y libpq-dev gcc). The error doesn't occur for Python versions <3.12.

Also, I tried to replicate the issue in my local WSL Ubuntu 22.04 terminal with a Python 3.12.4 and was able pip install fine. Perhaps those two libraries were already installed.