cannot start electric after a wipe

[MichalNemec]

cannot start electric after a wipe

[linear]

VAX-1803 cannot start electric after a wipe

[MichalNemec]

SELECT slot_name,
       slot_type,
       database,
       active,
       restart_lsn,
       confirmed_flush_lsn
FROM pg_replication_slots;

showed me after wipe, that the replication still existed, wasnt cleared properly i assume, deleting it fixed it.
Could be also a good hint for people to check that.

[alco]

Hey @MichalNemec . Could you give us more details about the wiping process? What did you remove? Was Electric running at that time?

[MichalNemec]

My usecase is a little bit different, dotnet backend holds migrations, so in the development process when i create a migration on backend side, then electric does not know about new changes in database schema.

What im doing is this:

1. kill electric docker container
2. use https://electric-sql.com/docs/reference/roadmap#failure-modes code to wipe it
3. start electric again
4. do app migration (only enable electric on tables)
5. generate schema and continue with the work

However step 2 probably got messed up and step 3 didnt hint me that i didnt remove everything properly.

im doing this process because app should reflect what is in the database and backend holds the "real" database, so backend should be doing migrations. App should only get stuff from cli and generate db. Thats my usecase tho.

[alco]

@MichalNemec Thanks for sharing the details. We'll review that documentation page and bring it up to date.