Meta-Sync Stuck in Loading – Self-Hosted NocoDB (v0.258.2) with Postgres

External Data Source
1

Issue:

I’m experiencing an issue with meta-sync not working in my self-hosted NocoDB (v0.258.2) connected to a PostgreSQL database. The database contains 23 tables, about half of which were created directly in PostgreSQL and the rest via the NocoDB interface.

When attempting a meta-sync, the process gets stuck in a loading state. Three tables fail to sync:

  • Two tables show the sync-state: “New relation added”
  • One table shows the sync-state: “Column properties changed (Feedback_id)”

Logs:

image
image832×366 65.9 KB

[Nest] 9  - 03/11/2025, 1:04:03 PM   ERROR [JobsEventService] ---- !! JOB FAILED !! ----
id:jobgpro5sum4z2clf
error:TypeError (Cannot read properties of undefined (reading 'fk_related_model_id'))
stack: TypeError: Cannot read properties of undefined (reading 'fk_related_model_id')
    at Column.update (/usr/src/app/docker/main.js:2:1453700)
    at process.processTicksAndRejections (node:internal/process/task_queues:95:5)
    at async MetaDiffsService.syncBaseMeta (/usr/src/app/docker/main.js:2:2138813)
    at async MetaDiffsService.baseMetaDiffSync (/usr/src/app/docker/main.js:2:2140743)
    at async MetaSyncProcessor.job (/usr/src/app/docker/main.js:2:1794948)
    at async QueueService.jobWrapper (/usr/src/app/docker/main.js:2:1646345)
    at async run (/usr/src/app/node_modules/p-queue/dist/index.js:163:29)
A valid integer must be provided to limit
A valid integer must be provided to limit

Since I’d like to avoid disconnecting and reconnecting the database (to preserve existing views), I’m looking for any insights or workarounds. Has anyone else run into this issue?
Any help or insights would be greatly appreciated! Thanks in advance! :folded_hands:

2

cc @pranavxc

Issue is created here to track further. Please try once after rebasing to latest release. If issue still persists, please leave a note in Github issue thread.