Following most basic steps for default scenario yielded a migration issue

Hello. I am completely new to calcom and decided to try self hosting a version on my mac just to check it out.

I followed the steps on https://github.com/calcom/docker?tab=readme-ov-file#most-users-running-calcom-with-docker-compose and did not change any environment variables after copying .env.example to .env as I could see that each required variable had a default value set.

After running docker compose up -d and waiting for it to finish, I opened calcom on localhost:3000 which redirected me to http://localhost:3000/auth/login, which did not load. When I looked at the console I saw Object { name: "Internal Server Error.", message: "500 - Internal Server Error.", statusCode: 500 }.

I ran docker ps and saw I had three containers running – "database", "docker-calcom-1", and "docker-studio-1". Running docker logs yielded

The table public.users does not exist in the current database. on docker-calcom-1

and ongoing rolling errors on database, eg
2024-10-29 03:42:55.693 UTC [71] ERROR: relation "public.users" does not exist at character 57 2024-10-29 03:42:55.693 UTC [71] STATEMENT: SELECT COUNT(*) FROM (SELECT "public"."users"."id" FROM "public"."users" WHERE 1=1 OFFSET $1) AS "sub"

I noticed that a new version of this repo was released just 6 hours ago, see https://github.com/calcom/docker/releases/tag/v4.6.13 and https://hub.docker.com/r/calcom/cal.com/tags – and when I run docker images I can see that the one I have in my local registry is tagged as latest, and was created 6 hours ago.

I wonder if some migration bug was introduced in this version or whether I have made a mistake?

I can also see that currently the "main" tag is not the same as the "latest" tag – would it make any difference to use the "main" tag for the image in the docker-compose.yml by default?

Still broken, I provided basic configuration and upon docker compose up there were errors about the schema not being populated. The migrations or initial database create is not running.

$ docker compose up
WARN[0000] The "NEXT_PUBLIC_WEBSITE_PRIVACY_POLICY_URL" variable is not set. Defaulting to a blank string. 
WARN[0000] The "NEXT_PUBLIC_WEBSITE_TERMS_URL" variable is not set. Defaulting to a blank string. 
[+] Running 12/12
 ✔ studio Pulled                                                                                                                                                                                                                                                                                                   102.6s 
   ✔ 3e6b9d1a9511 Pull complete                                                                                                                                                                                                                                                                                      4.6s 
   ✔ 37927ed901b1 Pull complete                                                                                                                                                                                                                                                                                      5.3s 
   ✔ 79b2f47ad444 Pull complete                                                                                                                                                                                                                                                                                      6.4s 
   ✔ e23f099911d6 Pull complete                                                                                                                                                                                                                                                                                     27.4s 
   ✔ cda7f44f2bdd Pull complete                                                                                                                                                                                                                                                                                     27.5s 
   ✔ c6b30c3f1696 Pull complete                                                                                                                                                                                                                                                                                     28.5s 
   ✔ 3697be50c98b Pull complete                                                                                                                                                                                                                                                                                     28.6s 
   ✔ 461077a72fb7 Pull complete                                                                                                                                                                                                                                                                                     28.7s 
   ✔ 218bb1925ba6 Pull complete                                                                                                                                                                                                                                                                                     28.8s 
   ✔ 7cd37d6caf70 Pull complete                                                                                                                                                                                                                                                                                     99.0s 
 ✔ calcom Pulled                                                                                                                                                                                                                                                                                                   102.6s 
[+] Running 5/5
 ✔ Network stack                         Created                                                                                                                                                                                                                                                                     0.1s 
 ✔ Volume "calcom-docker_database-data"  Created                                                                                                                                                                                                                                                                     0.0s 
 ✔ Container database                    Created                                                                                                                                                                                                                                                                     0.2s 
 ✔ Container calcom-docker-calcom-1      Created                                                                                                                                                                                                                                                                     0.1s 
 ✔ Container calcom-docker-studio-1      Created                                                                                                                                                                                                                                                                     0.1s 
Attaching to calcom-1, studio-1, database
database  | The files belonging to this database system will be owned by user "postgres".
database  | This user must also own the server process.
database  | 
database  | The database cluster will be initialized with locale "en_US.utf8".
database  | The default database encoding has accordingly been set to "UTF8".
database  | The default text search configuration will be set to "english".
database  | 
database  | Data page checksums are disabled.
database  | 
database  | fixing permissions on existing directory /var/lib/postgresql/data ... ok
database  | creating subdirectories ... ok
database  | selecting dynamic shared memory implementation ... posix
database  | selecting default "max_connections" ... 100
database  | selecting default "shared_buffers" ... 128MB
database  | selecting default time zone ... Etc/UTC
database  | creating configuration files ... ok
database  | running bootstrap script ... ok
calcom-1  | + scripts/replace-placeholder.sh http://localhost:3000 http://localhost:3000
calcom-1  | Nothing to replace, the value is already set to http://localhost:3000.
calcom-1  | + scripts/wait-for-it.sh database:5432 -- echo database is up
calcom-1  | nc command is missing!
calcom-1  | + npx prisma migrate deploy --schema /calcom/packages/prisma/schema.prisma
database  | performing post-bootstrap initialization ... ok
database  | syncing data to disk ... ok
database  | 
database  | 
database  | Success. You can now start the database server using:
database  | 
database  |     pg_ctl -D /var/lib/postgresql/data -l logfile start
database  | 
database  | initdb: warning: enabling "trust" authentication for local connections
database  | 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.
database  | waiting for server to start....2025-07-15 13:02:38.934 UTC [47] LOG:  starting PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
database  | 2025-07-15 13:02:38.946 UTC [47] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
database  | 2025-07-15 13:02:38.974 UTC [50] LOG:  database system was shut down at 2025-07-15 13:02:38 UTC
database  | 2025-07-15 13:02:38.985 UTC [47] LOG:  database system is ready to accept connections
database  |  done
database  | server started
studio-1  | Prisma schema loaded from packages/prisma/schema.prisma
calcom-1  | Prisma schema loaded from packages/prisma/schema.prisma
calcom-1  | Datasource "db": PostgreSQL database "calendso", schema "public" at "database:5432"
studio-1  | Prisma Studio is up on http://localhost:5555
calcom-1  | 
calcom-1  | Error: P1001: Can't reach database server at `database`:`5432`
calcom-1  | 
calcom-1  | Please make sure your database server is running at `database`:`5432`.
calcom-1  | npm notice
calcom-1  | npm notice New major version of npm available! 10.8.2 -> 11.4.2
calcom-1  | npm notice Changelog: https://github.com/npm/cli/releases/tag/v11.4.2
calcom-1  | npm notice To update run: npm install -g npm@11.4.2
calcom-1  | npm notice
calcom-1  | + npx ts-node --transpile-only /calcom/packages/prisma/seed-app-store.ts
database  | CREATE DATABASE
database  | 
database  | 
database  | /usr/local/bin/docker-entrypoint.sh: ignoring /docker-entrypoint-initdb.d/*
database  | 
database  | waiting for server to shut down....2025-07-15 13:02:39.137 UTC [47] LOG:  received fast shutdown request
database  | 2025-07-15 13:02:39.146 UTC [47] LOG:  aborting any active transactions
database  | 2025-07-15 13:02:39.148 UTC [47] LOG:  background worker "logical replication launcher" (PID 53) exited with exit code 1
database  | 2025-07-15 13:02:39.148 UTC [48] LOG:  shutting down
database  | 2025-07-15 13:02:39.156 UTC [48] LOG:  checkpoint starting: shutdown immediate
database  | 2025-07-15 13:02:39.354 UTC [48] LOG:  checkpoint complete: wrote 921 buffers (5.6%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.033 s, sync=0.135 s, total=0.206 s; sync files=301, longest=0.009 s, average=0.001 s; distance=4238 kB, estimate=4238 kB; lsn=0/1908980, redo lsn=0/1908980
database  | 2025-07-15 13:02:39.357 UTC [47] LOG:  database system is shut down
database  |  done
database  | server stopped
database  | 
database  | PostgreSQL init process complete; ready for start up.
database  | 
database  | 2025-07-15 13:02:39.468 UTC [1] LOG:  starting PostgreSQL 17.2 (Debian 17.2-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
database  | 2025-07-15 13:02:39.468 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
database  | 2025-07-15 13:02:39.468 UTC [1] LOG:  listening on IPv6 address "::", port 5432
database  | 2025-07-15 13:02:39.486 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
database  | 2025-07-15 13:02:39.505 UTC [63] LOG:  database system was shut down at 2025-07-15 13:02:39 UTC
database  | 2025-07-15 13:02:39.517 UTC [1] LOG:  database system is ready to accept connections
database  | 2025-07-15 13:02:39.905 UTC [67] ERROR:  relation "public.App" does not exist at character 203
database  | 2025-07-15 13:02:39.905 UTC [67] STATEMENT:  SELECT "public"."App"."slug", "public"."App"."dirName", "public"."App"."keys", "public"."App"."categories"::text[], "public"."App"."createdAt", "public"."App"."updatedAt", "public"."App"."enabled" FROM "public"."App" WHERE ("public"."App"."slug" = $1 OR "public"."App"."dirName" = $2) LIMIT $3 OFFSET $4
calcom-1  | Could not upsert app: apple-calendar. Error: PrismaClientKnownRequestError: 
calcom-1  | Invalid `prisma.app.findFirst()` invocation:
calcom-1  | 
calcom-1  | 
calcom-1  | The table `public.App` does not exist in the current database.
calcom-1  |     at Cn.handleRequestError (/calcom/node_modules/@prisma/client/runtime/library.js:123:6817)
calcom-1  |     at Cn.handleAndLogRequestError (/calcom/node_modules/@prisma/client/runtime/library.js:123:6206)
calcom-1  |     at Cn.request (/calcom/node_modules/@prisma/client/runtime/library.js:123:5926)
calcom-1  |     at async l (/calcom/node_modules/@prisma/client/runtime/library.js:128:9968)
calcom-1  |     at async createApp (/calcom/packages/prisma/seed-app-store.ts:187:22)
calcom-1  |     at async main (/calcom/packages/prisma/seed-app-store.ts:246:3) {
calcom-1  |   code: 'P2021',
calcom-1  |   clientVersion: '5.4.2',
calcom-1  |   meta: { table: 'public.App' }
calcom-1  | }
database  | 2025-07-15 13:02:39.913 UTC [67] ERROR:  relation "public.App" does not exist at character 203
database  | 2025-07-15 13:02:39.913 UTC [67] STATEMENT:  SELECT "public"."App"."slug", "public"."App"."dirName", "public"."App"."keys", "public"."App"."categories"::text[], "public"."App"."createdAt", "public"."App"."updatedAt", "public"."App"."enabled" FROM "public"."App" WHERE ("public"."App"."slug" = $1 OR "public"."App"."dirName" = $2) LIMIT $3 OFFSET $4
calcom-1  | Could not upsert app: caldav-calendar. Error: PrismaClientKnownRequestError: 
calcom-1  | Invalid `prisma.app.findFirst()` invocation:
calcom-1  | 
calcom-1  | 
calcom-1  | The table `public.App` does not exist in the current database.

Keeps repeating: calcom-1 | The table public.App does not exist in the current database.

Navigation Menu

Repository navigation

Following most basic steps for default scenario yielded a migration issue #386

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Following most basic steps for default scenario yielded a migration issue #386

Description

Activity

jcalfee commented on Jul 15, 2025

jcalfee commented on Jul 15, 2025

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions