Cockroachdb #355

New Issue

MrUnknownDE · 2026-04-05T20:59:36+02:00

MrUnknownDE commented

2026-04-05 20:59:36 +02:00

Originally created by @haras-unicorn on 9/14/2025

Trying cockroachdb again...

This time adding it as a feature with its own migrations and schema.

It's basically the same as postgres only with the difference of patches to migrations and the DATABASE_URL having to start with cockroach or cockroachdb.

I also added a nix flake and helix configuration which i use for development - hope you don't mind.

Creating a draft for now because I couldn't get playwright tests up and running because of this bit of weirdness:

[+] Running 1/1
 ! Playwright Warning pull access denied for playwright_oidc_playwright, repository ...                     1.3s 
Compose can now delegate builds to bake for better performance.
 To do so, set COMPOSE_BAKE=true.
[+] Building 8.4s (6/14)                                                                          docker:default
 => [Playwright internal] load build definition from Dockerfile                                             0.0s
 => => transferring dockerfile: 1.20kB                                                                      0.0s
 => [Playwright internal] load metadata for docker.io/library/debian:bookworm-slim                          0.7s
 => [Playwright internal] load .dockerignore                                                                0.0s
 => => transferring context: 2B                                                                             0.0s
 => [Playwright internal] load build context                                                                0.0s
 => => transferring context: 1.44kB                                                                         0.0s
 => CACHED [Playwright  1/10] FROM docker.io/library/debian:bookworm-slim@sha256:df52e55e3361a81ac1bead266  0.0s
 => ERROR [Playwright  2/10] RUN apt-get update     && apt-get install -y ca-certificates curl     && curl  7.7s
------                                                                                                           
 > [Playwright  2/10] RUN apt-get update     && apt-get install -y ca-certificates curl     && curl -fsSL https://download.docker.com/linux/debian/gpg -o /etc/apt/keyrings/docker.asc     && chmod a+r /etc/apt/keyrings/docker.asc     && echo "deb [signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/debian bookworm stable" | tee /etc/apt/sources.list.d/docker.list     && apt-get update     && apt-get install -y --no-install-recommends         containerd.io         docker-buildx-plugin         docker-ce         docker-ce-cli         docker-compose-plugin         git         libmariadb-dev-compat         libpq5         nodejs         npm         openssl     && rm -rf /var/lib/apt/lists/*:
0.233 Ign:1 http://deb.debian.org/debian bookworm InRelease
0.298 Ign:2 http://deb.debian.org/debian bookworm-updates InRelease
0.377 Ign:3 http://deb.debian.org/debian-security bookworm-security InRelease
1.291 Ign:1 http://deb.debian.org/debian bookworm InRelease
1.354 Ign:2 http://deb.debian.org/debian bookworm-updates InRelease
1.437 Ign:3 http://deb.debian.org/debian-security bookworm-security InRelease
3.351 Ign:1 http://deb.debian.org/debian bookworm InRelease
3.411 Ign:2 http://deb.debian.org/debian bookworm-updates InRelease
3.496 Ign:3 http://deb.debian.org/debian-security bookworm-security InRelease
7.428 Err:1 http://deb.debian.org/debian bookworm InRelease
7.428   Temporary failure resolving 'deb.debian.org'
7.517 Err:2 http://deb.debian.org/debian bookworm-updates InRelease
7.517   Temporary failure resolving 'deb.debian.org'
7.606 Err:3 http://deb.debian.org/debian-security bookworm-security InRelease
7.606   Temporary failure resolving 'deb.debian.org'
7.609 Reading package lists...
7.617 W: Failed to fetch http://deb.debian.org/debian/dists/bookworm/InRelease  Temporary failure resolving 'deb.debian.org'
7.617 W: Failed to fetch http://deb.debian.org/debian/dists/bookworm-updates/InRelease  Temporary failure resolving 'deb.debian.org'
7.617 W: Failed to fetch http://deb.debian.org/debian-security/dists/bookworm-security/InRelease  Temporary failure resolving 'deb.debian.org'
7.617 W: Some index files failed to download. They have been ignored, or old ones used instead.
7.626 Reading package lists...
7.633 Building dependency tree...
7.633 Reading state information...
7.634 Package ca-certificates is not available, but is referred to by another package.
7.634 This may mean that the package is missing, has been obsoleted, or
7.634 is only available from another source
7.634 
7.634 E: Package 'ca-certificates' has no installation candidate
7.634 E: Unable to locate package curl
------
failed to solve: process "/bin/bash -o pipefail -c apt-get update     && apt-get install -y ca-certificates curl     && curl -fsSL https://download.docker.com/linux/debian/gpg -o /etc/apt/keyrings/docker.asc     && chmod a+r /etc/apt/keyrings/docker.asc     && echo \"deb [signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/debian bookworm stable\" | tee /etc/apt/sources.list.d/docker.list     && apt-get update     && apt-get install -y --no-install-recommends         containerd.io         docker-buildx-plugin         docker-ce         docker-ce-cli         docker-compose-plugin         git         libmariadb-dev-compat         libpq5         nodejs         npm         openssl     && rm -rf /var/lib/apt/lists/*" did not complete successfully: exit code: 100

If someone knows what I'm doing wrong, info would be much appreciated :).

*Originally created by @haras-unicorn on 9/14/2025* Trying cockroachdb again... This time adding it as a feature with its own migrations and schema. It's basically the same as postgres only with the difference of patches to migrations and the DATABASE_URL having to start with cockroach or cockroachdb. I also added a nix flake and helix configuration which i use for development - hope you don't mind. Creating a draft for now because I couldn't get playwright tests up and running because of this bit of weirdness: ```text [+] Running 1/1 ! Playwright Warning pull access denied for playwright_oidc_playwright, repository ... 1.3s Compose can now delegate builds to bake for better performance. To do so, set COMPOSE_BAKE=true. [+] Building 8.4s (6/14) docker:default => [Playwright internal] load build definition from Dockerfile 0.0s => => transferring dockerfile: 1.20kB 0.0s => [Playwright internal] load metadata for docker.io/library/debian:bookworm-slim 0.7s => [Playwright internal] load .dockerignore 0.0s => => transferring context: 2B 0.0s => [Playwright internal] load build context 0.0s => => transferring context: 1.44kB 0.0s => CACHED [Playwright 1/10] FROM docker.io/library/debian:bookworm-slim@sha256:df52e55e3361a81ac1bead266 0.0s => ERROR [Playwright 2/10] RUN apt-get update && apt-get install -y ca-certificates curl && curl 7.7s ------ > [Playwright 2/10] RUN apt-get update && apt-get install -y ca-certificates curl && curl -fsSL https://download.docker.com/linux/debian/gpg -o /etc/apt/keyrings/docker.asc && chmod a+r /etc/apt/keyrings/docker.asc && echo "deb [signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/debian bookworm stable" | tee /etc/apt/sources.list.d/docker.list && apt-get update && apt-get install -y --no-install-recommends containerd.io docker-buildx-plugin docker-ce docker-ce-cli docker-compose-plugin git libmariadb-dev-compat libpq5 nodejs npm openssl && rm -rf /var/lib/apt/lists/*: 0.233 Ign:1 http://deb.debian.org/debian bookworm InRelease 0.298 Ign:2 http://deb.debian.org/debian bookworm-updates InRelease 0.377 Ign:3 http://deb.debian.org/debian-security bookworm-security InRelease 1.291 Ign:1 http://deb.debian.org/debian bookworm InRelease 1.354 Ign:2 http://deb.debian.org/debian bookworm-updates InRelease 1.437 Ign:3 http://deb.debian.org/debian-security bookworm-security InRelease 3.351 Ign:1 http://deb.debian.org/debian bookworm InRelease 3.411 Ign:2 http://deb.debian.org/debian bookworm-updates InRelease 3.496 Ign:3 http://deb.debian.org/debian-security bookworm-security InRelease 7.428 Err:1 http://deb.debian.org/debian bookworm InRelease 7.428 Temporary failure resolving 'deb.debian.org' 7.517 Err:2 http://deb.debian.org/debian bookworm-updates InRelease 7.517 Temporary failure resolving 'deb.debian.org' 7.606 Err:3 http://deb.debian.org/debian-security bookworm-security InRelease 7.606 Temporary failure resolving 'deb.debian.org' 7.609 Reading package lists... 7.617 W: Failed to fetch http://deb.debian.org/debian/dists/bookworm/InRelease Temporary failure resolving 'deb.debian.org' 7.617 W: Failed to fetch http://deb.debian.org/debian/dists/bookworm-updates/InRelease Temporary failure resolving 'deb.debian.org' 7.617 W: Failed to fetch http://deb.debian.org/debian-security/dists/bookworm-security/InRelease Temporary failure resolving 'deb.debian.org' 7.617 W: Some index files failed to download. They have been ignored, or old ones used instead. 7.626 Reading package lists... 7.633 Building dependency tree... 7.633 Reading state information... 7.634 Package ca-certificates is not available, but is referred to by another package. 7.634 This may mean that the package is missing, has been obsoleted, or 7.634 is only available from another source 7.634 7.634 E: Package 'ca-certificates' has no installation candidate 7.634 E: Unable to locate package curl ------ failed to solve: process "/bin/bash -o pipefail -c apt-get update && apt-get install -y ca-certificates curl && curl -fsSL https://download.docker.com/linux/debian/gpg -o /etc/apt/keyrings/docker.asc && chmod a+r /etc/apt/keyrings/docker.asc && echo \"deb [signed-by=/etc/apt/keyrings/docker.asc] https://download.docker.com/linux/debian bookworm stable\" | tee /etc/apt/sources.list.d/docker.list && apt-get update && apt-get install -y --no-install-recommends containerd.io docker-buildx-plugin docker-ce docker-ce-cli docker-compose-plugin git libmariadb-dev-compat libpq5 nodejs npm openssl && rm -rf /var/lib/apt/lists/*" did not complete successfully: exit code: 100 ``` If someone knows what I'm doing wrong, info would be much appreciated :).

MrUnknownDE closed this issue

2026-04-05 20:59:36 +02:00

Sign in to join this conversation.

No Label

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: github/vaultwarden#355