When starting Trustify with the dump data, a migration failure error occurs.

[bxf12315]

Migration Failure Issue

Problem Description

I ran into an issue where a migration failed.

Steps to Reproduce

Step 1: Download dump data

Download the dump data from the following URL:

wget -c https://trustify-dumps.s3.eu-west-1.amazonaws.com/20250604T002104Z/dump.sql.gz -o dump.sql.gz

Step 2: Start PostgreSQL

Start PostgreSQL using Podman:

podman run --rm -it --name trustify-postgres \
  -e POSTGRES_USER=postgres \
  -e POSTGRES_PASSWORD=trustify \
  -e POSTGRES_DB=trustify \
  -p 5432:5432 \
  postgres:17

Step 3: Import dump data

Import the downloaded dump data into PostgreSQL:

gzcat dump.sql.gz | env PGPASSWORD=trustify psql -U postgres -d trustify -h localhost -p 5432 -v ON_ERROR_STOP=1
echo "VACUUM ANALYZE; REINDEX database trustify;" | env PGPASSWORD=trustify psql -U postgres -d trustify -h localhost -p 5432 -v ON_ERROR_STOP=1

Step 4: Start trustify

Start trustify with the following command:

RUST_LOG=debug cargo run --bin trustd -- api --auth-disabled --devmode

Error

However, startup failed with the following error:

Environment

• Database: PostgreSQL 17
• Container Runtime: Podman

[bxf12315]

@ctron, please check it.

[ctron]

That is expected, as the storage data is not available to the system. In order to have a fully working system, it is required to have both SQL and store data available. Either via S3 or file system.

The accompanying data dump would be: https://trustify-dumps.s3.eu-west-1.amazonaws.com/20250604T002104Z/dump.tar.gz