search

WordPress / openverse

Openverse is a search engine for openly-licensed media. This monorepo includes all application code.
https://openverse.org
MIT License
254 stars 204 forks source link

Update postgres Docker tag to v13.16 #5104

Closed openverse-bot closed 3 weeks ago

openverse-bot commented 4 weeks ago

This PR contains the following updates:

Package Type Update Change
postgres final minor 13.10 -> 13.16

Configuration

📅 Schedule: Branch creation - "before 4am on the first day of the month" (UTC), Automerge - At any time (no schedule defined).

🚦 Automerge: Enabled.

♻ Rebasing: Whenever PR is behind base branch, or you tick the rebase/retry checkbox.

🔕 Ignore: Close this PR and you won't be reminded about this update again.

This PR has been generated by Renovate Bot.

AetherUnbound commented 3 weeks ago

I've changed the upstream DB docker image to use pipx instead of using the python3-pip package for installing pgcli - this was causing a problem with the build step (see details below).

Build error ``` #12 [3/4] RUN apt-get update && apt-get install -yqq --no-install-recommends python3-boto3 postgresql-plpython3-13 python3-pip libpq-dev && apt-get autoremove -y && rm -rf /var/lib/apt/lists/* && pip3 install -U pip pgcli==4.1.0 #12 0.110 Get:1 http://deb.debian.org/debian bookworm InRelease [151 kB] #12 0.144 Get:2 http://apt.postgresql.org/pub/repos/apt bookworm-pgdg InRelease [129 kB] #12 0.148 Get:3 http://deb.debian.org/debian bookworm-updates InRelease [55.4 kB] #12 0.162 Get:4 http://deb.debian.org/debian-security bookworm-security InRelease [48.0 kB] #12 0.271 Get:5 http://deb.debian.org/debian bookworm/main amd64 Packages [8,787 kB] #12 0.400 Get:6 http://deb.debian.org/debian bookworm-updates/main amd64 Packages [2,468 B] #12 0.414 Get:7 http://deb.debian.org/debian-security bookworm-security/main amd64 Packages [190 kB] #12 0.492 Get:8 http://apt.postgresql.org/pub/repos/apt bookworm-pgdg/13 amd64 Packages [2,589 B] #12 0.518 Get:9 http://apt.postgresql.org/pub/repos/apt bookworm-pgdg/main amd64 Packages [358 kB] #12 1.212 Fetched 9,724 kB in 1s (8,562 kB/s) #12 1.212 Reading package lists... #12 3.385 debconf: delaying package configuration, since apt-utils is not installed #12 3.425 Selecting previously unselected package libpython3.11-minimal:amd64. #12 3.425 (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 11878 files and directories currently installed.) #12 3.435 Preparing to unpack .../libpython3.11-minimal_3.11.2-6+deb12u3_amd64.deb ... #12 3.436 Unpacking libpython3.11-minimal:amd64 (3.11.2-6+deb12u3) ... #12 3.516 Selecting previously unselected package libexpat1:amd64. #12 3.518 Preparing to unpack .../libexpat1_2.5.0-1+deb12u1_amd64.deb ... #12 3.521 Unpacking libexpat1:amd64 (2.5.0-1+deb12u1) ... #12 3.545 Selecting previously unselected package python3.11-minimal. #12 3.547 Preparing to unpack .../python3.11-minimal_3.11.2-6+deb12u3_amd64.deb ... #12 3.551 Unpacking python3.11-minimal (3.11.2-6+deb12u3) ... #12 3.692 Setting up libpython3.11-minimal:amd64 (3.11.2-6+deb12u3) ... #12 3.698 Setting up libexpat1:amd64 (2.5.0-1+deb12u1) ... #12 3.701 Setting up python3.11-minimal (3.11.2-6+deb12u3) ... #12 4.249 Selecting previously unselected package python3-minimal. #12 4.249 (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 12194 files and directories currently installed.) #12 4.258 Preparing to unpack .../0-python3-minimal_3.11.2-1+b1_amd64.deb ... #12 4.259 Unpacking python3-minimal (3.11.2-1+b1) ... #12 4.277 Selecting previously unselected package media-types. #12 4.279 Preparing to unpack .../1-media-types_10.0.0_all.deb ... #12 4.280 Unpacking media-types (10.0.0) ... #12 4.296 Selecting previously unselected package libtirpc-common. #12 4.298 Preparing to unpack .../2-libtirpc-common_1.3.3+ds-1_all.deb ... #12 4.299 Unpacking libtirpc-common (1.3.3+ds-1) ... #12 4.318 Selecting previously unselected package libtirpc3:amd64. #12 4.319 Preparing to unpack .../3-libtirpc3_1.3.3+ds-1_amd64.deb ... #12 4.320 Unpacking libtirpc3:amd64 (1.3.3+ds-1) ... #12 4.341 Selecting previously unselected package libnsl2:amd64. #12 4.343 Preparing to unpack .../4-libnsl2_1.3.0-2_amd64.deb ... #12 4.344 Unpacking libnsl2:amd64 (1.3.0-2) ... #12 4.361 Selecting previously unselected package libpython3.11-stdlib:amd64. #12 4.363 Preparing to unpack .../5-libpython3.11-stdlib_3.11.2-6+deb12u3_amd64.deb ... #12 4.364 Unpacking libpython3.11-stdlib:amd64 (3.11.2-6+deb12u3) ... #12 4.494 Selecting previously unselected package python3.11. #12 4.496 Preparing to unpack .../6-python3.11_3.11.2-6+deb12u3_amd64.deb ... #12 4.497 Unpacking python3.11 (3.11.2-6+deb12u3) ... #12 4.521 Selecting previously unselected package libpython3-stdlib:amd64. #12 4.522 Preparing to unpack .../7-libpython3-stdlib_3.11.2-1+b1_amd64.deb ... #12 4.523 Unpacking libpython3-stdlib:amd64 (3.11.2-1+b1) ... #12 4.542 Setting up python3-minimal (3.11.2-1+b1) ... #12 4.659 Selecting previously unselected package python3. #12 4.659 (Reading database ... (Reading database ... 5% (Reading database ... 10% (Reading database ... 15% (Reading database ... 20% (Reading database ... 25% (Reading database ... 30% (Reading database ... 35% (Reading database ... 40% (Reading database ... 45% (Reading database ... 50% (Reading database ... 55% (Reading database ... 60% (Reading database ... 65% (Reading database ... 70% (Reading database ... 75% (Reading database ... 80% (Reading database ... 85% (Reading database ... 90% (Reading database ... 95% (Reading database ... 100% (Reading database ... 12624 files and directories currently installed.) #12 4.668 Preparing to unpack .../00-python3_3.11.2-1+b1_amd64.deb ... #12 4.672 Unpacking python3 (3.11.2-1+b1) ... #12 4.692 Selecting previously unselected package ca-certificates. #12 4.694 Preparing to unpack .../01-ca-certificates_20230311_all.deb ... #12 4.695 Unpacking ca-certificates (20230311) ... #12 4.737 Selecting previously unselected package libssl-dev:amd64. #12 4.739 Preparing to unpack .../02-libssl-dev_3.0.14-1~deb12u2_amd64.deb ... #12 4.740 Unpacking libssl-dev:amd64 (3.0.14-1~deb12u2) ... #12 4.889 Selecting previously unselected package libpq-dev. #12 4.891 Preparing to unpack .../03-libpq-dev_17.0-1.pgdg120+1_amd64.deb ... #12 4.892 Unpacking libpq-dev (17.0-1.pgdg120+1) ... #12 4.917 Selecting previously unselected package libpython3.11:amd64. #12 4.919 Preparing to unpack .../04-libpython3.11_3.11.2-6+deb12u3_amd64.deb ... #12 4.920 Unpacking libpython3.11:amd64 (3.11.2-6+deb12u3) ... #12 5.058 Selecting previously unselected package postgresql-plpython3-13. #12 5.061 Preparing to unpack .../05-postgresql-plpython3-13_13.16-1.pgdg120+1_amd64.deb ... #12 5.061 Unpacking postgresql-plpython3-13 (13.16-1.pgdg120+1) ... #12 5.093 Selecting previously unselected package python3-six. #12 5.095 Preparing to unpack .../06-python3-six_1.16.0-4_all.deb ... #12 5.096 Unpacking python3-six (1.16.0-4) ... #12 5.113 Selecting previously unselected package python3-dateutil. #12 5.115 Preparing to unpack .../07-python3-dateutil_2.8.2-2_all.deb ... #12 5.116 Unpacking python3-dateutil (2.8.2-2) ... #12 5.135 Selecting previously unselected package python3-jmespath. #12 5.137 Preparing to unpack .../08-python3-jmespath_1.0.1-1_all.deb ... #12 5.138 Unpacking python3-jmespath (1.0.1-1) ... #12 5.157 Selecting previously unselected package python3-urllib3. #12 5.158 Preparing to unpack .../09-python3-urllib3_1.26.12-1_all.deb ... #12 5.159 Unpacking python3-urllib3 (1.26.12-1) ... #12 5.184 Selecting previously unselected package python3-certifi. #12 5.186 Preparing to unpack .../10-python3-certifi_2022.9.24-1_all.deb ... #12 5.187 Unpacking python3-certifi (2022.9.24-1) ... #12 5.215 Selecting previously unselected package python3-charset-normalizer. #12 5.217 Preparing to unpack .../11-python3-charset-normalizer_3.0.1-2_all.deb ... #12 5.218 Unpacking python3-charset-normalizer (3.0.1-2) ... #12 5.238 Selecting previously unselected package python3-idna. #12 5.240 Preparing to unpack .../12-python3-idna_3.3-1+deb12u1_all.deb ... #12 5.241 Unpacking python3-idna (3.3-1+deb12u1) ... #12 5.261 Selecting previously unselected package python3-pkg-resources. #12 5.263 Preparing to unpack .../13-python3-pkg-resources_66.1.1-1_all.deb ... #12 5.264 Unpacking python3-pkg-resources (66.1.1-1) ... #12 5.296 Selecting previously unselected package python3-chardet. #12 5.298 Preparing to unpack .../14-python3-chardet_5.1.0+dfsg-2_all.deb ... #12 5.299 Unpacking python3-chardet (5.1.0+dfsg-2) ... #12 5.330 Selecting previously unselected package python3-requests. #12 5.332 Preparing to unpack .../15-python3-requests_2.28.1+dfsg-1_all.deb ... #12 5.333 Unpacking python3-requests (2.28.1+dfsg-1) ... #12 5.354 Selecting previously unselected package python3-botocore. #12 5.356 Preparing to unpack .../16-python3-botocore_1.29.27+repack-1_all.deb ... #12 5.357 Unpacking python3-botocore (1.29.27+repack-1) ... #12 5.974 Selecting previously unselected package python3-s3transfer. #12 5.977 Preparing to unpack .../17-python3-s3transfer_0.6.0-1_all.deb ... #12 5.978 Unpacking python3-s3transfer (0.6.0-1) ... #12 6.000 Selecting previously unselected package python3-boto3. #12 6.003 Preparing to unpack .../18-python3-boto3_1.26.27+dfsg-1_all.deb ... #12 6.004 Unpacking python3-boto3 (1.26.27+dfsg-1) ... #12 6.039 Selecting previously unselected package python3-lib2to3. #12 6.041 Preparing to unpack .../19-python3-lib2to3_3.11.2-3_all.deb ... #12 6.042 Unpacking python3-lib2to3 (3.11.2-3) ... #12 6.069 Selecting previously unselected package python3-distutils. #12 6.071 Preparing to unpack .../20-python3-distutils_3.11.2-3_all.deb ... #12 6.072 Unpacking python3-distutils (3.11.2-3) ... #12 6.098 Selecting previously unselected package python3-setuptools. #12 6.100 Preparing to unpack .../21-python3-setuptools_66.1.1-1_all.deb ... #12 6.102 Unpacking python3-setuptools (66.1.1-1) ... #12 6.162 Selecting previously unselected package python3-wheel. #12 6.165 Preparing to unpack .../22-python3-wheel_0.38.4-2_all.deb ... #12 6.166 Unpacking python3-wheel (0.38.4-2) ... #12 6.186 Selecting previously unselected package python3-pip. #12 6.188 Preparing to unpack .../23-python3-pip_23.0.1+dfsg-1_all.deb ... #12 6.189 Unpacking python3-pip (23.0.1+dfsg-1) ... #12 6.330 Setting up media-types (10.0.0) ... #12 6.335 Setting up libtirpc-common (1.3.3+ds-1) ... #12 6.338 Setting up ca-certificates (20230311) ... #12 6.403 debconf: unable to initialize frontend: Dialog #12 6.403 debconf: (TERM is not set, so the dialog frontend is not usable.) #12 6.403 debconf: falling back to frontend: Readline #12 6.410 debconf: unable to initialize frontend: Readline #12 6.410 debconf: (This frontend requires a controlling tty.) #12 6.410 debconf: falling back to frontend: Teletype #12 6.819 Updating certificates in /etc/ssl/certs... #12 7.393 140 added, 0 removed; done. #12 7.411 Setting up libssl-dev:amd64 (3.0.14-1~deb12u2) ... #12 7.414 Setting up libtirpc3:amd64 (1.3.3+ds-1) ... #12 7.417 Setting up libpq-dev (17.0-1.pgdg120+1) ... #12 7.419 Setting up libnsl2:amd64 (1.3.0-2) ... #12 7.422 Setting up libpython3.11-stdlib:amd64 (3.11.2-6+deb12u3) ... #12 7.424 Setting up libpython3-stdlib:amd64 (3.11.2-1+b1) ... #12 7.427 Setting up python3.11 (3.11.2-6+deb12u3) ... #12 7.992 Setting up libpython3.11:amd64 (3.11.2-6+deb12u3) ... #12 7.995 Setting up python3 (3.11.2-1+b1) ... #12 8.001 running python rtupdate hooks for python3.11... #12 8.001 running python post-rtupdate hooks for python3.11... #12 8.074 Setting up python3-six (1.16.0-4) ... #12 8.169 Setting up python3-certifi (2022.9.24-1) ... #12 8.260 Setting up python3-jmespath (1.0.1-1) ... #12 8.360 Setting up python3-idna (3.3-1+deb12u1) ... #12 8.515 Setting up python3-urllib3 (1.26.12-1) ... #12 8.645 Setting up python3-dateutil (2.8.2-2) ... #12 8.768 Setting up python3-lib2to3 (3.11.2-3) ... #12 8.854 Setting up postgresql-plpython3-13 (13.16-1.pgdg120+1) ... #12 8.857 Setting up python3-pkg-resources (66.1.1-1) ... #12 9.073 Setting up python3-distutils (3.11.2-3) ... #12 9.175 Setting up python3-setuptools (66.1.1-1) ... #12 9.554 Setting up python3-charset-normalizer (3.0.1-2) ... #12 9.662 Setting up python3-wheel (0.38.4-2) ... #12 9.772 Setting up python3-chardet (5.1.0+dfsg-2) ... #12 10.01 Setting up python3-requests (2.28.1+dfsg-1) ... #12 10.12 Setting up python3-pip (23.0.1+dfsg-1) ... #12 10.98 Setting up python3-botocore (1.29.27+repack-1) ... #12 11.20 Setting up python3-s3transfer (0.6.0-1) ... #12 11.32 Setting up python3-boto3 (1.26.27+dfsg-1) ... #12 11.44 Processing triggers for postgresql-common (264.pgdg120+1) ... #12 11.50 debconf: unable to initialize frontend: Dialog #12 11.50 debconf: (TERM is not set, so the dialog frontend is not usable.) #12 11.50 debconf: falling back to frontend: Readline #12 11.51 debconf: unable to initialize frontend: Readline #12 11.51 debconf: (This frontend requires a controlling tty.) #12 11.51 debconf: falling back to frontend: Teletype #12 11.56 Building PostgreSQL dictionaries from installed myspell/hunspell packages... #12 11.56 Removing obsolete dictionary files: #12 11.57 Processing triggers for libc-bin (2.36-9+deb12u8) ... #12 11.58 Processing triggers for ca-certificates (20230311) ... #12 11.59 Updating certificates in /etc/ssl/certs... #12 12.04 0 added, 0 removed; done. #12 12.04 Running hooks in /etc/ca-certificates/update.d... #12 12.04 done. #12 12.07 Reading package lists... #12 12.50 Building dependency tree... #12 12.61 Reading state information... #12 12.73 0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded. #12 12.98 error: externally-managed-environment #12 12.98 #12 12.98 × This environment is externally managed #12 12.98 ╰─> To install Python packages system-wide, try apt install #12 12.98 python3-xyz, where xyz is the package you are trying to #12 12.98 install. #12 12.98 #12 12.98 If you wish to install a non-Debian-packaged Python package, #12 12.98 create a virtual environment using python3 -m venv path/to/venv. #12 12.98 Then use path/to/venv/bin/python and path/to/venv/bin/pip. Make #12 12.98 sure you have python3-full installed. #12 12.98 #12 12.98 If you wish to install a non-Debian packaged Python application, #12 12.98 it may be easiest to use pipx install xyz, which will manage a #12 12.98 virtual environment for you. Make sure you have pipx installed. #12 12.98 #12 12.98 See /usr/share/doc/python3.11/README.venv for more information. #12 12.98 #12 12.98 note: If you believe this is a mistake, please contact your Python installation or OS distribution provider. You can override this, at the risk of breaking your Python installation or OS, by passing --break-system-packages. #12 12.98 hint: See PEP 668 for the detailed specification. #12 ERROR: process "/bin/sh -c apt-get update && apt-get install -yqq --no-install-recommends python3-boto3 postgresql-plpython3-13 python3-pip libpq-dev && apt-get autoremove -y && rm -rf /var/lib/apt/lists/* && pip3 install -U pip pgcli==${PGCLI_VERSION}" did not complete successfully: exit code: 1 ------ > [3/4] RUN apt-get update && apt-get install -yqq --no-install-recommends python3-boto3 postgresql-plpython3-13 python3-pip libpq-dev && apt-get autoremove -y && rm -rf /var/lib/apt/lists/* && pip3 install -U pip pgcli==4.1.0: 12.98 sure you have python3-full installed. 12.98 12.98 If you wish to install a non-Debian packaged Python application, 12.98 it may be easiest to use pipx install xyz, which will manage a 12.98 virtual environment for you. Make sure you have pipx installed. 12.98 12.98 See /usr/share/doc/python3.11/README.venv for more information. 12.98 12.98 note: If you believe this is a mistake, please contact your Python installation or OS distribution provider. You can override this, at the risk of breaking your Python installation or OS, by passing --break-system-packages. 12.98 hint: See PEP 668 for the detailed specification. ------ Dockerfile:17 -------------------- 16 | 17 | >>> RUN apt-get update \ 18 | >>> && apt-get install -yqq --no-install-recommends \ 19 | >>> python3-boto3 \ 20 | >>> postgresql-plpython3-13 \ 21 | >>> python3-pip \ 22 | >>> libpq-dev \ 23 | >>> && apt-get autoremove -y \ 24 | >>> && rm -rf /var/lib/apt/lists/* \ 25 | >>> && pip3 install -U pip pgcli==${PGCLI_VERSION} 26 | -------------------- ERROR: failed to solve: process "/bin/sh -c apt-get update && apt-get install -yqq --no-install-recommends python3-boto3 postgresql-plpython3-13 python3-pip libpq-dev && apt-get autoremove -y && rm -rf /var/lib/apt/lists/* && pip3 install -U pip pgcli==${PGCLI_VERSION}" did not complete successfully: exit code: 1 ```
openverse-bot commented 3 weeks ago

Edited/Blocked Notification

Renovate will not automatically rebase this PR, because it does not recognize the last commit author and assumes somebody else may have edited the PR.

You can manually request rebase by checking the rebase/retry box above.

⚠️ Warning: custom changes will be lost.

krysal commented 3 weeks ago

Nice touch. Thank you, @AetherUnbound!