Unable to Start new container. #177
Comments
60plus
added
🎛️ server
|
Are you starting this container from scratch? |
version: "3.8"
services:
gamevault-backend:
image: phalcode/gamevault-backend:latest
container_name: GameVault
restart: unless-stopped
environment:
DB_HOST: db
DB_USERNAME: gamevault
DB_PASSWORD: PASSWORD
# The Following Line grants Admin Role to account with this username upon registration.
SERVER_ADMIN_USERNAME: MYNAME
# Uncomment and Insert your RAWG API Key here if you have one (http://rawg.io/login?forward=developer)
RAWG_API_KEY: <MYAPI>
volumes:
# Mount the folder where your games are
- PATH TO STORAGE/GameVAULT/Install:/files
# Mount the folder where gamevault should store its images
- PATH TO STORAGE/APPS/GameVault/Images:/images
ports:
- 8581:8080
db:
image: postgres:15
container_name: GameVault-DB
restart: unless-stopped
environment:
POSTGRES_USER: gamevault
POSTGRES_PASSWORD: PASSWORD
POSTGRES_DB: gamevault
volumes:
# Mount the folder where your postgres database files should land
- PATH TO STORAGE /APPS/GameVault/DB:/var/lib/postgresql/dataPASSWORD is the same in both containers |
|
can you provide me the full log of gamevault 1 minute after starting it aswell? |
|
|
The logs dont really show any error. Could you maybe try the following?
|
|
Hi, I got the same. Problem.
I already tried clearing all mapped folders and starting from scratch with new containers, but noting seems to help. |
What i did alerady:
It all started yesterday. Maybe it's somehow connected to yesterday's GameVault-app update. |
|
It sounds like some badly updated image broke us. I can reproduce this aswell now. Will try to fix and keep you guys updated ASAP. |
|
TL;DR: The issue has been resolved in version 4.0.1. Post Mortem: Please tell me if it works. |
|
Yep. It work again. |
|
@60plus Thank you so much for sponsoring!!! |
Describe the bug
unable to start container.
To Reproduce
Deploy new container.
Expected behavior
No issues
Additional context
LOGS.
DB LOG:
2023-08-25 06:24:09.279 UTC [1] LOG: starting PostgreSQL 15.4 (Debian 15.4-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2023-08-25 06:24:09.280 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432
2023-08-25 06:24:09.280 UTC [1] LOG: listening on IPv6 address "::", port 5432
2023-08-25 06:24:09.285 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2023-08-25 06:24:09.291 UTC [29] LOG: database system was interrupted; last known up at 2023-08-25 06:13:48 UTC
2023-08-25 06:24:09.364 UTC [29] LOG: database system was not properly shut down; automatic recovery in progress
2023-08-25 06:24:09.367 UTC [29] LOG: redo starts at 0/19875D8
2023-08-25 06:24:09.367 UTC [29] LOG: invalid record length at 0/1987610: wanted 24, got 0
2023-08-25 06:24:09.367 UTC [29] LOG: redo done at 0/19875D8 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2023-08-25 06:24:09.372 UTC [27] LOG: checkpoint starting: end-of-recovery immediate wait
2023-08-25 06:24:09.383 UTC [27] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.004 s, sync=0.002 s, total=0.014 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB
2023-08-25 06:24:09.389 UTC [1] LOG: database system is ready to accept connections
2023-08-25 06:24:10.246 UTC [33] ERROR: relation "game" does not exist at character 2034
2023-08-25 06:24:10.246 UTC [33] STATEMENT: SELECT "Game"."id" AS "Game_id", "Game"."created_at" AS "Game_created_at", "Game"."updated_at" AS "Game_updated_at", "Game"."deleted_at" AS "Game_deleted_at", "Game"."entity_version" AS "Game_entity_version", "Game"."rawg_id" AS "Game_rawg_id", "Game"."title" AS "Game_title", "Game"."rawg_title" AS "Game_rawg_title", "Game"."version" AS "Game_version", "Game"."release_date" AS "Game_release_date", "Game"."rawg_release_date" AS "Game_rawg_release_date", "Game"."cache_date" AS "Game_cache_date", "Game"."file_path" AS "Game_file_path", "Game"."size" AS "Game_size", "Game"."description" AS "Game_description", "Game"."website_url" AS "Game_website_url", "Game"."metacritic_rating" AS "Game_metacritic_rating", "Game"."average_playtime" AS "Game_average_playtime", "Game"."early_access" AS "Game_early_access", "Game"."type" AS "Game_type", "Game"."box_image_id" AS "Game_box_image_id", "Game"."background_image_id" AS "Game_background_image_id", "Game__box_image"."id" AS "Game__box_image_id", "Game__box_image"."created_at" AS "Game__box_image_created_at", "Game__box_image"."updated_at" AS "Game__box_image_updated_at", "Game__box_image"."deleted_at" AS "Game__box_image_deleted_at", "Game__box_image"."entity_version" AS "Game__box_image_entity_version", "Game__box_image"."source" AS "Game__box_image_source", "Game__box_image"."path" AS "Game__box_image_path", "Game__box_image"."media_type" AS "Game__box_image_media_type", "Game__background_image"."id" AS "Game__background_image_id", "Game__background_image"."created_at" AS "Game__background_image_created_at", "Game__background_image"."updated_at" AS "Game__background_image_updated_at", "Game__background_image"."deleted_at" AS "Game__background_image_deleted_at", "Game__background_image"."entity_version" AS "Game__background_image_entity_version", "Game__background_image"."source" AS "Game__background_image_source", "Game__background_image"."path" AS "Game__background_image_path", "Game__background_image"."media_type" AS "Game__background_image_media_type" FROM "game" "Game" LEFT JOIN "image" "Game__box_image" ON "Game__box_image"."id"="Game"."box_image_id" AND ("Game__box_image"."deleted_at" IS NULL) LEFT JOIN "image" "Game__background_image" ON "Game__background_image"."id"="Game"."background_image_id" AND ("Game__background_image"."deleted_at" IS NULL) WHERE "Game"."deleted_at" IS NULL
GameVault-Backend LOG:
/app/node_modules/.pnpm/typeorm@0.3.17_better-sqlite3@8.5.0_pg@8.11.2_ts-node@10.9.1/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:211
QueryFailedError: relation "game" does not exist
query: 'SELECT "Game"."id" AS "Game_id", "Game"."created_at" AS "Game_created_at", "Game"."updated_at" AS "Game_updated_at", "Game"."deleted_at" AS "Game_deleted_at", "Game"."entity_version" AS "Game_entity_version", "Game"."rawg_id" AS "Game_rawg_id", "Game"."title" AS "Game_title", "Game"."rawg_title" AS "Game_rawg_title", "Game"."version" AS "Game_version", "Game"."release_date" AS "Game_release_date", "Game"."rawg_release_date" AS "Game_rawg_release_date", "Game"."cache_date" AS "Game_cache_date", "Game"."file_path" AS "Game_file_path", "Game"."size" AS "Game_size", "Game"."description" AS "Game_description", "Game"."website_url" AS "Game_website_url", "Game"."metacritic_rating" AS "Game_metacritic_rating", "Game"."average_playtime" AS "Game_average_playtime", "Game"."early_access" AS "Game_early_access", "Game"."type" AS "Game_type", "Game"."box_image_id" AS "Game_box_image_id", "Game"."background_image_id" AS "Game_background_image_id", "Game__box_image"."id" AS "Game__box_image_id", "Game__box_image"."created_at" AS "Game__box_image_created_at", "Game__box_image"."updated_at" AS "Game__box_image_updated_at", "Game__box_image"."deleted_at" AS "Game__box_image_deleted_at", "Game__box_image"."entity_version" AS "Game__box_image_entity_version", "Game__box_image"."source" AS "Game__box_image_source", "Game__box_image"."path" AS "Game__box_image_path", "Game__box_image"."media_type" AS "Game__box_image_media_type", "Game__background_image"."id" AS "Game__background_image_id", "Game__background_image"."created_at" AS "Game__background_image_created_at", "Game__background_image"."updated_at" AS "Game__background_image_updated_at", "Game__background_image"."deleted_at" AS "Game__background_image_deleted_at", "Game__background_image"."entity_version" AS "Game__background_image_entity_version", "Game__background_image"."source" AS "Game__background_image_source", "Game__background_image"."path" AS "Game__background_image_path", "Game__background_image"."media_type" AS "Game__background_image_media_type" FROM "game" "Game" LEFT JOIN "image" "Game__box_image" ON "Game__box_image"."id"="Game"."box_image_id" AND ("Game__box_image"."deleted_at" IS NULL) LEFT JOIN "image" "Game__background_image" ON "Game__background_image"."id"="Game"."background_image_id" AND ("Game__background_image"."deleted_at" IS NULL) WHERE "Game"."deleted_at" IS NULL',
parameters: [],
driverError: error: relation "game" does not exist
},
length: 105,
severity: 'ERROR',
code: '42P01',
detail: undefined,
hint: undefined,
position: '2034',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: 'parse_relation.c',
line: '1392',
routine: 'parserOpenTable'
}
Node.js v20.5.1
The text was updated successfully, but these errors were encountered: