dialoqbase: Database Tables Disappears and System Crashes with Docker-Compose Configuration

Error: P3009

migrate found failed migrations in the target database, new migrations will not be applied. Read more about how to resolve migration issues in a production database: https://pris.ly/d/migrate-resolve The init migration started at 2023-07-17 10:39:24.473380 UTC failed e7ca216e-13c0-4b58-9188-1e5048273a4d

About this issue

  • Original URL
  • State: closed
  • Created a year ago
  • Comments: 20 (10 by maintainers)

Most upvoted comments

I won’t close this issue. Let’s see how it works in a couple of days. Sorry for all the issues 😃

I have pulled a new image again, uploading and deleting documents repeatedly will not cause an error and cause the system to crash, but I am not sure whether the system database table will be automatically deleted in a few days and cause the system to crash. I hope you can continue to help troubleshoot the problem of the database table being automatically deleted

Hmm, so the issue is in the docker-compose configuration. I will try and test with the https://hub.docker.com/r/supabase/postgres image

I am going to update to version 0.0.20 to see if uploading the document, deleting the document and then uploading the document can be used stably. If there is any problem, I need your help

Did you try to update from version 0.0.18 to 0.0.19 or an earlier version like 0.0.2 or 0.0.3? There are a few breaking changes from versions 0.0.1 to 0.0.5; I apologize for that. If you attempted to update from an early version, please re-clone this repo

No, I did not update. After 0.0.19 ran successfully, after a period of time I suddenly found that the service was suspended and an appeal error was reported, and often I uploaded the document after deleting the document. The whole service also crashed. Can you help me to test it? Do you frequently delete documents before uploading them? This has happened to me many times, and every time I have to delete all the data and rebuild a service