search

electric-sql / electric

Sync little subsets of your Postgres data into local apps and services.
https://electric-sql.com
Apache License 2.0
6.22k stars 147 forks source link

Error executing Prisma Migrations via ElectricSQL proxy #955

Closed alco closed 7 months ago

alco commented 7 months ago

https://discord.com/channels/933657521581858818/1201902430220980284

Multiple people have reported similar-looking issues in that thread.

The issue manifests as a Postgres error:

notes-sync-service  | 15:30:11.577 pid=<0.3425.0> proxy_session_id=1 [warning] Not validating user "postgres"
notes-sync-service  | 15:30:11.579 pid=<0.3425.0> proxy_session_id=1 [info] Initialising injector in capture mode %Electric.Postgres.Proxy.Injector.Electric{}
notes-sync-service  | 15:30:11.609 pid=<0.3425.0> proxy_session_id=1 [info] Upstream connection is ready to accept queries
notes-sync-service  | 15:30:11.638 pid=<0.3427.0> proxy_session_id=3 [warning] Not validating user "postgres"
notes-sync-service  | 15:30:11.639 pid=<0.3427.0> proxy_session_id=3 [info] Initialising injector in capture mode %Electric.Postgres.Proxy.Injector.Electric{}
notes-sync-service  | 15:30:11.650 pid=<0.3427.0> proxy_session_id=3 [info] Upstream connection is ready to accept queries
notes-db            | 2024-01-30 15:30:11.670 GMT [65] ERROR:  relation "_prisma_migrations" does not exist at character 126
notes-db            | 2024-01-30 15:30:11.670 GMT [65] 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
notes-sync-service  | 15:30:13.525 pid=<0.3429.0> proxy_session_id=4 [warning] Not validating user "postgres"
notes-sync-service  | 15:30:13.526 pid=<0.3429.0> proxy_session_id=4 [info] Initialising injector in capture mode %Electric.Postgres.Proxy.Injector.Shadow{database: "prisma_migrate_shadow_db_ad101716-2362-43d9-bd63-c5dec2080265"}
notes-sync-service  | 15:30:13.781 pid=<0.3429.0> proxy_session_id=4 [info] Upstream connection is ready to accept queries
notes-sync-service  | 15:30:16.249 pid=<0.3431.0> proxy_session_id=5 [warning] Not validating user "postgres"
notes-sync-service  | 15:30:16.250 pid=<0.3431.0> proxy_session_id=5 [info] Initialising injector in capture mode %Electric.Postgres.Proxy.Injector.Shadow{database: "prisma_migrate_shadow_db_36e575b0-e04f-4aa7-8775-e4b6e7a0344c"}
notes-sync-service  | 15:30:16.446 pid=<0.3431.0> proxy_session_id=5 [info] Upstream connection is ready to accept queries

and no errors in the sync service's log output:

the table (_prisma_migrations) actually gets created in the db, but nothing else

See also https://github.com/electric-sql/electric/discussions/939.

linear[bot] commented 7 months ago

VAX-1664 Error executing Prisma Migrations via ElectricSQL proxy