Upgrade 0.42.18 -> 0.43.5 sync metadata objects error
Hi there!
Selfhosted. upgrading 0.42.18 with spilo image and proper working state (all migrations and upgrade command successfully. all green and without issues).
Followed upgrade guide to new postgres:16 image, with proper dumps and restore on new db. All running ok and started new 0.43.5 image successfully with new DB (https://twenty.com/developers/section/self-hosting/upgrade-guide#v0.42.0-to-v0.43.0).
0.43.5:
-
yarn database:migrate:prod without issues. (all green)
- yarn command:prod upgrade with error on sync metadata object without details to check on db for any broken record.
Front doesn't render object list, but I do have access if I use url to change between them.
Any ideas?? Anyone had similar errors? Thanks!!
3 Replies
Hey @dialnco could you please inspect your
metadata.objectMetadata table for isCustom false object metadata rows ?
Seems like sync-metadata is unable to retrieve standard object models ( companies,notes,tasks etc )I do have all my objects on
metadata.objectMetadata table. (standard and custom objects).
But checking on other tables, it seams metadata.indexFieldMetadata is empty. Should I have records there? is there a command to generate those indexes for metadata fields? o just a corrupted state on DB dump and restoring?
Hey @dialnco
Should I have records there?Yes ! this contains all of your
objectMetadata fields definition
Unforntunately unless i'm mistaken there's no such command to populate this table
I think you might have lost some data during your database migration
If you have some backup available please double check them
Let me know !