https://www.prisma.io/ logo
Join Slack
Powered by
Hi, I'm creating a Circle CI config and it seems t...
# prisma-migrate
c
Hi, I'm creating a Circle CI config and it seems to be working, for the most part. My job steps are 1) initialize the postgres container 2) 
prisma migrate deploy
(per the docs) 3) run tests (1 test does a 
create
, then a 
findAll
, and it's passing) After running 
prisma migrate deploy
, my postgres container shows an error (in thread)
Copy code
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US.utf8".
The default database encoding has accordingly been set to "UTF8".
The default text search configuration will be set to "english".

Data page checksums are disabled.

fixing permissions on existing directory /var/lib/postgresql/data ... ok
creating subdirectories ... ok
selecting dynamic shared memory implementation ... posix
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default time zone ... Etc/UTC
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

initdb: warning: enabling "trust" authentication for local connections
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.

Success. You can now start the database server using:

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

waiting for server to start....2021-07-14 19:22:26.060 UTC [81] LOG:  starting PostgreSQL 13.3 (Debian 13.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-07-14 19:22:26.060 UTC [81] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-07-14 19:22:26.062 UTC [82] LOG:  database system was shut down at 2021-07-14 19:22:25 UTC
2021-07-14 19:22:26.065 UTC [81] LOG:  database system is ready to accept connections
 done
server started
CREATE DATABASE


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

2021-07-14 19:22:26.308 UTC [81] LOG:  received fast shutdown request
2021-07-14 19:22:26.308 UTC [81] LOG:  aborting any active transactions
waiting for server to shut down....2021-07-14 19:22:26.310 UTC [81] LOG:  background worker "logical replication launcher" (PID 88) exited with exit code 1
2021-07-14 19:22:26.310 UTC [83] LOG:  shutting down
2021-07-14 19:22:26.320 UTC [81] LOG:  database system is shut down
 done
server stopped

PostgreSQL init process complete; ready for start up.
After `prisma migrate deploy`:
Copy code
2021-07-14 19:22:26.430 UTC [9] LOG:  starting PostgreSQL 13.3 (Debian 13.3-1.pgdg100+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit
2021-07-14 19:22:26.431 UTC [9] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2021-07-14 19:22:26.431 UTC [9] LOG:  listening on IPv6 address "::", port 5432
2021-07-14 19:22:26.431 UTC [9] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-07-14 19:22:26.433 UTC [114] LOG:  database system was shut down at 2021-07-14 19:22:26 UTC
2021-07-14 19:22:26.436 UTC [9] LOG:  database system is ready to accept connections
2021-07-14 19:22:35.034 UTC [286] ERROR:  relation "_prisma_migrations" does not exist at character 126
2021-07-14 19:22:35.034 UTC [286] STATEMENT:  SELECT "id", "checksum", "finished_at", "migration_name", "logs", "rolled_back_at", "started_at", "applied_steps_count" FROM "_prisma_migrations" ORDER BY "started_at" ASC

Build was canceled
Open in Slack
PreviousNext
Powered by