medusa icon indicating copy to clipboard operation
medusa copied to clipboard

I encountered some very strange database issues, and many tables were inexplicably deleted.

Open ahqrt opened this issue 1 year ago • 0 comments

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 image

After image

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.

ahqrt avatar Oct 15 '24 06:10 ahqrt