My strapi project is failing to deploy on render with below error:
Jun 15 06:21:23 PM $ strapi start
Jun 15 06:24:38 PM [2023-06-15 12:54:38.198] error: drop table if exists “brand_names” - cannot drop table brand_names because other objects depend on it
Jun 15 06:24:38 PM error: drop table if exists “brand_names” - cannot drop table brand_names because other objects depend on it
Jun 15 06:24:38 PM at Parser.parseErrorMessage (/opt/render/project/src/node_modules/pg-protocol/dist/parser.js:287:98)
Jun 15 06:24:38 PM at Parser.handlePacket (/opt/render/project/src/node_modules/pg-protocol/dist/parser.js:126:29)
Jun 15 06:24:38 PM at Parser.parse (/opt/render/project/src/node_modules/pg-protocol/dist/parser.js:39:38)
Jun 15 06:24:38 PM at Socket. (/opt/render/project/src/node_modules/pg-protocol/dist/index.js:11:42)
I have changed the contentType name from brand-name to brand in my local and it started successfully. However not able to deploy on render.
I have already removed its relation field to point to new Brand table. Still, it throws the error.
I have the same problem and would appreciate any help
[2023-06-20 06:09:29.496] debug: ⛔️ Server wasn't able to start properly.
[2023-06-20 06:09:29.498] error: drop table if exists "public"."tags" - cannot drop table tags because other objects depend on it
error: drop table if exists "public"."tags" - cannot drop table tags because other objects depend on it
at Parser.parseErrorMessage (/node_modules/pg-protocol/dist/parser.js:287:98)
at Parser.handlePacket (/node_modules/pg-protocol/dist/parser.js:126:29)
at Parser.parse (/node_modules/pg-protocol/dist/parser.js:39:38)
at Socket.<anonymous> (/node_modules/pg-protocol/dist/index.js:11:42)
at Socket.emit (node:events:513:28)
at Socket.emit (node:domain:489:12)
at addChunk (node:internal/streams/readable:324:12)
at readableAddChunk (node:internal/streams/readable:297:9)
at Readable.push (node:internal/streams/readable:234:10)
at TCP.onStreamRead (node:internal/stream_base_commons:190:23)
I am using PostgreSQL and running on version 4.9.2 of strapi
I removed Content-Type
Tags and changed all references in other Content-Types from Tags to another relation. Tags does not exist anywhere in the codebase anymore and locally it seemed to drop the table just fine while doing all this, but when deploying to the dev env the above messages keeps showing and it just stops
When I look in the database I still see these references to tags (foreign keys?):
They should have been removed right? Is this a bug? or do I need to do something specific?