* Describe the bug
App crashes after uploading and running migration file. After successful upload, the app starts to restart and the “multiple primary keys for table “workflowManualTasks” are not allowed” error appears. The application stops responding, restarting app or Docker container doesn’t change anything.
* Environment
- NocoBase version: 1.6.2
- Database type and version: PostgreSQL 17
- OS: Windows 10 Professional
- Deployment Methods: Docker
- Docker image version: nocobase/nocobase:1.6.2
- NodeJS version:
* How To Reproduce
We want to migrate changes from environment X to Y. Both environments have same plugins installed and the same database type & version.
- In the environment X prepare the new migration with Migration manager. Migration rule should consist of ‘Schema only’ for user-defined collections (global rule) and ‘Overwrite priority’ for ‘Kernel/plugin built-in collections’ (global rule).
- Download the migration file.
- Upload the migration file from X to the Y environment.
Expected behavior
The migration should be completed susscessfully.