Latte macchiato
Explore posts from serversDTDrizzle Team
•Created by Latte macchiato on 4/14/2025 in #help
Migrations not being applied, despite being marked as complete
Hi,
I have a project with multiple migrations that now seems to not actually apply.
Starting fresh with a clear database applies them all without any issue, but trying to migrate an existing database seems to just not do anything:
The command terminates after that.
The newest migration this is happening with is contained in the journal file:
and is called the proper name in the filesystem as well. Contents:
The weird part is that it looks like the migration is marked as applied in the DB, despite none of the queries having actually ran (there are 12 migrations in total).
I am at my wits end with debugging this.
> db:migrate
> drizzle-kit migrate
No config path provided, using default 'drizzle.config.ts'
Reading config file '/root/MintyScenarios/drizzle.config.ts'
Using 'pg' driver for database querying
> db:migrate
> drizzle-kit migrate
No config path provided, using default 'drizzle.config.ts'
Reading config file '/root/MintyScenarios/drizzle.config.ts'
Using 'pg' driver for database querying
{
"idx": 12,
"version": "7",
"when": 1744673080355,
"tag": "0012_illegal_thunderball",
"breakpoints": true
}
{
"idx": 12,
"version": "7",
"when": 1744673080355,
"tag": "0012_illegal_thunderball",
"breakpoints": true
}
ALTER TABLE "adventures" ALTER COLUMN "history" SET DATA TYPE jsonb;--> statement-breakpoint
[...]
ALTER TABLE "adventures" ALTER COLUMN "history" SET DATA TYPE jsonb;--> statement-breakpoint
[...]
id | hash | created_at
----+------------------------------------------------------------------+---------------
1 | c8247b1414021feec941aa336b4a72c641121c7d33c2b8777d7c5eddb93e65cd | 1744573954728
2 | 211b9351539ea30813dca97ce5ca8407a1502cdf4386087731268b1384079d69 | 1744575957391
3 | a1ee3df3b64174a8846fbae593ea6141fb097989bc320bfbcd4113af7f2fb0aa | 1744583579085
4 | e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 | 1744685000000
5 | d78451866ef1b91187ec487e3337d06242b1b2be3b1da02763611b41debee474 | 1744585806582
6 | 62e417a21159ad433efc2a653ee7079749881ba75d0a5caf2d98a32be8977889 | 1744589238926
7 | c2188cb9222dacea49b5598d093de3ec7262fb8cd7ae4de13a3a7ea3f2cfdadb | 1744621830859
8 | 1850ad8eaa340a31e1f85bba335e0be00d67b03a9e60024448fbc6e458d1f5cc | 1744625049182
9 | b0732433775616a265b5ef5916a3bf74d5bf809bc774c1fbafa09b989e2b86ce | 1744625049183
10 | d236a5bb6035bacf4ce659515234e9b4020ac1328aaae58fd9978498dba422eb | 1744625049184
11 | 6fffd6493d4e6099cb252ec5238fa9d148da7cdcbda4be6ffe241d8e01c00199 | 1744628403236
12 | fffa2a3cbde7f8ee5bcdbee77e0ba6102f172621f5546dbf5439166f4c4dbe43 | 1744635620765
id | hash | created_at
----+------------------------------------------------------------------+---------------
1 | c8247b1414021feec941aa336b4a72c641121c7d33c2b8777d7c5eddb93e65cd | 1744573954728
2 | 211b9351539ea30813dca97ce5ca8407a1502cdf4386087731268b1384079d69 | 1744575957391
3 | a1ee3df3b64174a8846fbae593ea6141fb097989bc320bfbcd4113af7f2fb0aa | 1744583579085
4 | e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855 | 1744685000000
5 | d78451866ef1b91187ec487e3337d06242b1b2be3b1da02763611b41debee474 | 1744585806582
6 | 62e417a21159ad433efc2a653ee7079749881ba75d0a5caf2d98a32be8977889 | 1744589238926
7 | c2188cb9222dacea49b5598d093de3ec7262fb8cd7ae4de13a3a7ea3f2cfdadb | 1744621830859
8 | 1850ad8eaa340a31e1f85bba335e0be00d67b03a9e60024448fbc6e458d1f5cc | 1744625049182
9 | b0732433775616a265b5ef5916a3bf74d5bf809bc774c1fbafa09b989e2b86ce | 1744625049183
10 | d236a5bb6035bacf4ce659515234e9b4020ac1328aaae58fd9978498dba422eb | 1744625049184
11 | 6fffd6493d4e6099cb252ec5238fa9d148da7cdcbda4be6ffe241d8e01c00199 | 1744628403236
12 | fffa2a3cbde7f8ee5bcdbee77e0ba6102f172621f5546dbf5439166f4c4dbe43 | 1744635620765
2 replies
IImmich
•Created by Latte macchiato on 5/20/2023 in #help-desk-support
Facial Recognition ECONNREFUSED
Running a full "Recognize Faces" job floods the docker logs with errors.
What I've tried:
- stopping the stack & starting it again
- using the latest docker-compose straight from GitHub (only adjusted the external mapping of immich-proxy)
The errors look like this:
There's one for every image it seems to try and scan.
The docker compose ps looks like this:
immich_microservices | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
immich_microservices | [Nest] 1 - 05/20/2023, 7:35:48 PM ERROR [FacialRecognitionService] Unable run facial recognition pipeline: 6a173c8f-0a91-4e90-a502-1a73aa01bb1e
immich_microservices | Error: connect ECONNREFUSED 172.18.0.5:3003
immich_microservices | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
immich_microservices | [Nest] 1 - 05/20/2023, 7:35:48 PM ERROR [FacialRecognitionService] Unable run facial recognition pipeline: 8a6a8e36-a869-4eb5-bc0e-213e517c8633
immich_microservices | Error: connect ECONNREFUSED 172.18.0.5:3003
immich_microservices | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
immich_microservices | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
immich_microservices | [Nest] 1 - 05/20/2023, 7:35:48 PM ERROR [FacialRecognitionService] Unable run facial recognition pipeline: 6a173c8f-0a91-4e90-a502-1a73aa01bb1e
immich_microservices | Error: connect ECONNREFUSED 172.18.0.5:3003
immich_microservices | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
immich_microservices | [Nest] 1 - 05/20/2023, 7:35:48 PM ERROR [FacialRecognitionService] Unable run facial recognition pipeline: 8a6a8e36-a869-4eb5-bc0e-213e517c8633
immich_microservices | Error: connect ECONNREFUSED 172.18.0.5:3003
immich_microservices | at TCPConnectWrap.afterConnect [as oncomplete] (node:net:1494:16)
root@immich-ct:~# docker compose ps
NAME IMAGE COMMAND SERVICE CREATED STATUS PORTS
immich_machine_learning ghcr.io/immich-app/immich-machine-learning:release "python src/main.py" immich-machine-learning About a minute ago Up About a minute
immich_microservices ghcr.io/immich-app/immich-server:release "/bin/sh ./start-mic…" immich-microservices About a minute ago Up About a minute 3001/tcp
immich_postgres postgres:14 "docker-entrypoint.s…" database About a minute ago Up About a minute 5432/tcp
immich_proxy ghcr.io/immich-app/immich-proxy:release "/docker-entrypoint.…" immich-proxy About a minute ago Up About a minute 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp
immich_redis redis:6.2 "docker-entrypoint.s…" redis About a minute ago Up About a minute 6379/tcp
immich_server ghcr.io/immich-app/immich-server:release "/bin/sh ./start-ser…" immich-server About a minute ago Up About a minute 3001/tcp
immich_typesense typesense/typesense:0.24.0 "/opt/typesense-serv…" typesense About a minute ago Up About a minute 8108/tcp
immich_web ghcr.io/immich-app/immich-web:release "/bin/sh ./entrypoin…" immich-web About a minute ago Up About a minute 3000/tcp
root@immich-ct:~# docker compose ps
NAME IMAGE COMMAND SERVICE CREATED STATUS PORTS
immich_machine_learning ghcr.io/immich-app/immich-machine-learning:release "python src/main.py" immich-machine-learning About a minute ago Up About a minute
immich_microservices ghcr.io/immich-app/immich-server:release "/bin/sh ./start-mic…" immich-microservices About a minute ago Up About a minute 3001/tcp
immich_postgres postgres:14 "docker-entrypoint.s…" database About a minute ago Up About a minute 5432/tcp
immich_proxy ghcr.io/immich-app/immich-proxy:release "/docker-entrypoint.…" immich-proxy About a minute ago Up About a minute 0.0.0.0:8080->8080/tcp, :::8080->8080/tcp
immich_redis redis:6.2 "docker-entrypoint.s…" redis About a minute ago Up About a minute 6379/tcp
immich_server ghcr.io/immich-app/immich-server:release "/bin/sh ./start-ser…" immich-server About a minute ago Up About a minute 3001/tcp
immich_typesense typesense/typesense:0.24.0 "/opt/typesense-serv…" typesense About a minute ago Up About a minute 8108/tcp
immich_web ghcr.io/immich-app/immich-web:release "/bin/sh ./entrypoin…" immich-web About a minute ago Up About a minute 3000/tcp
63 replies