mirror of
https://github.com/kevinveenbirkenbach/computer-playbook.git
synced 2026-11-06 10:59:59 +00:00
Every fresh Mobilizon deploy on PostgreSQL 18 died in migration 20190806131306. Four migrations drop the integer id column, add a uuid id without NOT NULL and declare it the primary key in the same ALTER TABLE. PostgreSQL 18 rejects that with 42P16 "primary key column "id" is not marked NOT NULL", PostgreSQL 17 accepted it. The container exited 1 and restarted in a loop, in compose and in swarm. Upstream fixed it for 5.3.0 by adding null: false to that line in the four migrations. No published image carries the fix yet, so the role builds its own image on top of the pinned upstream one and applies the same one-line change to the same four files. The build fails once a base image no longer contains the unfixed line and names the migration, so the patch cannot outlive its reason unnoticed. TODO.md lists what to delete then. Closes #779 Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
20 lines
990 B
Django/Jinja
20 lines
990 B
Django/Jinja
{% include 'roles/sys-svc-compose/templates/base.yml.j2' %}
|
|
{% set service_name = 'mobilizon' %}
|
|
{{ service_name }}:
|
|
{{ lookup('template', 'roles/sys-svc-container/templates/build.yml.j2') | indent(4) }}
|
|
args:
|
|
MOBILIZON_IMAGE: "{{ MOBILIZON_IMAGE }}"
|
|
MOBILIZON_VERSION: "{{ MOBILIZON_VERSION }}"
|
|
{{ lookup('container_image', application_id, 'mobilizon') }}
|
|
{{ lookup('compose_only', 'container_name', mobilizon_container) }}
|
|
{{ lookup('container_volumes', service_name) | indent(4) }}
|
|
{{ lookup('container_ports', ['mobilizon', 'http', DOCKER_BIND_HOST]) | indent(4) }}
|
|
{{ lookup('container_healthcheck', service_name) | indent(4) }}
|
|
{% include 'roles/sys-svc-container/templates/base.yml.j2' %}
|
|
{{ lookup('container_extra_hosts') | indent(4) }}
|
|
{{ lookup('container_depends_on', application_id) | indent(4) }}
|
|
{{ lookup('container_networks') | indent(4) }}
|
|
|
|
{{ lookup('compose_volumes') }}
|
|
{{ lookup('compose_networks') }}
|