I encountered some very strange database issues, and many tables were inexplicably deleted.
Problem Description After deploying the Medusa backend to my own server, I encountered some strange issues. The system runs stably for a few days, but then the storefront page reports an error when opened. Upon checking the database, I found that the region table and some other tables were deleted. I'm not sure what caused this.
Table Structure Comparison
Here is the comparison of the database table structure before and after:
Before
After
System Information Here is my package.json dependencies information:
json "dependencies": { "@medusajs/admin": "^7.1.16", "@medusajs/cache-inmemory": "1.8.11", "@medusajs/cache-redis": "^1.9.2", "@medusajs/event-bus-local": "1.9.9", "@medusajs/event-bus-redis": "^1.8.14", "@medusajs/file-local": "1.0.4", "@medusajs/medusa": "^1.20.9", "@tanstack/react-query": "4.22.0", "body-parser": "^1.19.0", "cors": "^2.8.5", "dotenv": "16.3.1", "express": "^4.17.2", "medusa-fulfillment-manual": "1.1.41", "medusa-interfaces": "1.3.10", "medusa-payment-manual": "1.0.25", "medusa-payment-stripe": "6.0.11", "prism-react-renderer": "^2.0.4", "typeorm": "0.3.16" }, Medusa Version (including plugins): 1.20.9 Node.js Version: v20.17.0 Database: Docker-Postgres Operating System: Linux VM-0-7-CentOS 4.18.0-348.7.1.el8_5.x86_64 Browser (if relevant): I hope to find out the cause of the problem and get a solution.