Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

New Unraid not docker working with PostgreSQL dockers? #167

Open
mckenna654 opened this issue Jan 15, 2025 · 0 comments
Open

New Unraid not docker working with PostgreSQL dockers? #167

mckenna654 opened this issue Jan 15, 2025 · 0 comments
Labels
bug Something isn't working

Comments

@mckenna654
Copy link

Describe the bug

I've tried Postgres12.5, Postgres-Alpine and Postgres16 dockers however I'm getting the following errors:

initdb: warning: enabling "trust" authentication for local connections
initdb: hint: You can change this by editing pg_hba.conf or using the option -A, or --auth-local and --auth-host, the next time you run initdb.
2025-01-15 16:34:07.973 AEDT [1] LOG:  starting PostgreSQL 16.6 (Debian 16.6-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-01-15 16:34:07.973 AEDT [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-01-15 16:34:07.973 AEDT [1] LOG:  listening on IPv6 address "::", port 5432
2025-01-15 16:34:07.981 AEDT [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-01-15 16:34:07.989 AEDT [63] LOG:  database system was shut down at 2025-01-15 16:34:07 AEDT
2025-01-15 16:34:07.995 AEDT [1] LOG:  database system is ready to accept connections
2025-01-15 16:35:51.798 AEDT [79] ERROR:  permission denied for schema public at character 14
2025-01-15 16:35:51.798 AEDT [79] STATEMENT:  CREATE TABLE _prisma_migrations (
            id                      VARCHAR(36) PRIMARY KEY NOT NULL,
            checksum                VARCHAR(64) NOT NULL,
            finished_at             TIMESTAMPTZ,
            migration_name          VARCHAR(255) NOT NULL,
            logs                    TEXT,
            rolled_back_at          TIMESTAMPTZ,
            started_at              TIMESTAMPTZ NOT NULL DEFAULT now(),
            applied_steps_count     INTEGER NOT NULL DEFAULT 0
        );

2025-01-15 16:35:53.225 AEDT [80] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:35:53.225 AEDT [80] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:35:54.709 AEDT [81] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:35:54.709 AEDT [81] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:35:56.199 AEDT [82] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:35:56.199 AEDT [82] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:35:57.688 AEDT [83] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:35:57.688 AEDT [83] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:35:59.153 AEDT [84] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:35:59.153 AEDT [84] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:00.654 AEDT [85] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:00.654 AEDT [85] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:02.131 AEDT [86] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:02.131 AEDT [86] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:03.587 AEDT [87] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:03.587 AEDT [87] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:05.050 AEDT [88] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:05.050 AEDT [88] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:06.528 AEDT [89] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:06.528 AEDT [89] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:08.012 AEDT [90] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:08.012 AEDT [90] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:09.500 AEDT [92] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:09.500 AEDT [92] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:11.000 AEDT [93] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:11.000 AEDT [93] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:12.486 AEDT [94] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:12.486 AEDT [94] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:13.944 AEDT [95] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:13.944 AEDT [95] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:15.436 AEDT [96] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:15.436 AEDT [96] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-15 16:36:16.918 AEDT [97] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:16.918 AEDT [97] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Australia/Sydney
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok


Success. You can now start the database server using:

    pg_ctl -D /var/lib/postgresql/data -l logfile start

waiting for server to start....2025-01-15 16:34:07.738 AEDT [49] LOG:  starting PostgreSQL 16.6 (Debian 16.6-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-01-15 16:34:07.744 AEDT [49] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-01-15 16:34:07.754 AEDT [52] LOG:  database system was shut down at 2025-01-15 16:34:04 AEDT
2025-01-15 16:34:07.760 AEDT [49] LOG:  database system is ready to accept connections
 done
server started

/usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*

2025-01-15 16:34:07.851 AEDT [49] LOG:  received fast shutdown request
waiting for server to shut down....2025-01-15 16:34:07.854 AEDT [49] LOG:  aborting any active transactions
2025-01-15 16:34:07.856 AEDT [49] LOG:  background worker "logical replication launcher" (PID 55) exited with exit code 1
2025-01-15 16:34:07.856 AEDT [50] LOG:  shutting down
2025-01-15 16:34:07.858 AEDT [50] LOG:  checkpoint starting: shutdown immediate
2025-01-15 16:34:07.876 AEDT [50] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.006 s, total=0.021 s; sync files=2, longest=0.003 s, average=0.003 s; distance=0 kB, estimate=0 kB; lsn=0/14EA2C8, redo lsn=0/14EA2C8
2025-01-15 16:34:07.880 AEDT [49] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.

2025-01-15 16:36:18.396 AEDT [98] ERROR:  relation "public.Manga" does not exist at character 208
2025-01-15 16:36:18.396 AEDT [98] STATEMENT:  SELECT "public"."Manga"."id", "public"."Manga"."createdAt", "public"."Manga"."title", "public"."Manga"."interval", "public"."Manga"."source", "public"."Manga"."libraryId", "public"."Manga"."metadataId" FROM "public"."Manga" WHERE 1=1 OFFSET $1
2025-01-1

Reproduction steps

Running the kaizoku docker

Expected behavior

Operate as per normal

Additional context

No response

@mckenna654 mckenna654 added the bug Something isn't working label Jan 15, 2025
@mckenna654 mckenna654 changed the title New Unraid not docker working with PostgreSQL dockerrtsd? New Unraid not docker working with PostgreSQL dockers? Jan 15, 2025
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant