QueryFailedError: column CronTrigger__CronTrigger_serverlessFunction.universalIdentifier does not exist

[derevyan]

Got this after upgrade 1.7 -> latest, any one face same, any easy fix? Thanks a lot.

[Nest] 34 - 10/22/2025, 1:36:00 PM LOG [BullMQDriver] Processing job repeat:CronTriggerCronJob:1761140160000 with name CronTriggerCronJob on queue cron-queue query failed: SELECT "CronTrigger"."id" AS "CronTrigger_id", "CronTrigger"."settings" AS "CronTrigger_settings", "CronTrigger"."workspaceId" AS "CronTrigger_workspaceId", "CronTrigger__CronTrigger_serverlessFunction"."universalIdentifier" AS "CronTrigger__CronTrigger_serverlessFunction_universalIdentifier", "CronTrigger__CronTrigger_serverlessFunction"."id" AS "CronTrigger__CronTrigger_serverlessFunction_id", "CronTrigger__CronTrigger_serverlessFunction"."name" AS "CronTrigger__CronTrigger_serverlessFunction_name", "CronTrigger__CronTrigger_serverlessFunction"."description" AS "CronTrigger__CronTrigger_serverlessFunction_description", "CronTrigger__CronTrigger_serverlessFunction"."latestVersion" AS "CronTrigger__CronTrigger_serverlessFunction_latestVersion", "CronTrigger__CronTrigger_serverlessFunction"."publishedVersions" AS "CronTrigger__CronTrigger_serverlessFunction_publishedVersions", "CronTrigger__CronTrigger_serverlessFunction"."runtime" AS "CronTrigger__CronTrigger_serverlessFunction_runtime", "CronTrigger__CronTrigger_serverlessFunction"."timeoutSeconds" AS "CronTrigger__CronTrigger_serverlessFunction_timeoutSeconds", "CronTrigger__CronTrigger_serverlessFunction"."workspaceId" AS "CronTrigger__CronTrigger_serverlessFunction_workspaceId", "CronTrigger__CronTrigger_serverlessFunction"."applicationId" AS "CronTrigger__CronTrigger_serverlessFunction_applicationId", "CronTrigger__CronTrigger_serverlessFunction"."checksum" AS "CronTrigger__CronTrigger_serverlessFunction_checksum", "CronTrigger__CronTrigger_serverlessFunction"."serverlessFunctionLayerId" AS "03960e5dea7d86b73c64a787112b0c45801f984d", "CronTrigger__CronTrigger_serverlessFunction"."createdAt" AS "CronTrigger__CronTrigger_serverlessFunction_createdAt", "CronTrigger__CronTrigger_serverlessFunction"."updatedAt" AS "CronTrigger__CronTrigger_serverlessFunction_updatedAt", "CronTrigger__CronTrigger_serverlessFunction"."deletedAt" AS "CronTrigger__CronTrigger_serverlessFunction_deletedAt" FROM "core"."cronTrigger" "CronTrigger" LEFT JOIN "core"."serverlessFunction" "CronTrigger__CronTrigger_serverlessFunction" ON "CronTrigger__CronTrigger_serverlessFunction"."id"="CronTrigger"."serverlessFunctionId" AND ("CronTrigger__CronTrigger_serverlessFunction"."deletedAt" IS NULL) WHERE (("CronTrigger"."workspaceId" = $1)) -- PARAMETERS: ["ff91c061-4bdc-4ee6-85c7-91f163449a61"] error: error: column CronTrigger__CronTrigger_serverlessFunction.universalIdentifier does not exist Exception Captured undefined [ QueryFailedError: column CronTrigger__CronTrigger_serverlessFunction.universalIdentifier does not exist at PostgresQueryRunner.query (/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:219:19) at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async SelectQueryBuilder.loadRawResults (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2192:25) at async SelectQueryBuilder.executeEntitiesAndRawResults (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2040:26) at async SelectQueryBuilder.getRawAndEntities (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29) at async SelectQueryBuilder.getMany (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25) at async CronTriggerCronJob.handle (/app/packages/twenty-server/dist/src/engine/metadata-modules/cron-trigger/crons/jobs/cron-trigger.cron.job.js:60:34) at async descriptor.value (/app/packages/twenty-server/dist/src/engine/core-modules/cron/sentry-cron-monitor.decorator.js:60:24) at async MessageQueueExplorer.invokeProcessMethods (/app/packages/twenty-server/dist/src/engine/core-modules/message-queue/message-queue.explorer.js:113:17) at async MessageQueueExplorer.handleProcessor (/app/packages/twenty-server/dist/src/engine/core-modules/message-queue/message-queue.explorer.js:106:13) { query: 'SELECT "CronTrigger"."id" AS "CronTrigger_id", "CronTrigger"."settings" AS "CronTrigger_settings", "CronTrigger"."workspaceId" AS "CronTrigger_workspaceId", "CronTrigger__CronTrigger_serverlessFunction"."universalIdentifier" AS "CronTrigger__CronTrigger_serverlessFunction_universalIdentifier", "CronTrigger__CronTrigger_serverlessFunction"."id" AS "CronTrigger__CronTrigger_serverlessFunction_id", "CronTrigger__CronTrigger_serverlessFunction"."name" AS "CronTrigger__CronTrigger_serverlessFunction_name", "CronTrigger__CronTrigger_serverlessFunction"."description" AS "CronTrigger__CronTrigger_serverlessFunction_description", "CronTrigger__CronTrigger_serverlessFunction"."latestVersion" AS "CronTrigger__CronTrigger_serverlessFunction_latestVersion", "CronTrigger__CronTrigger_serverlessFunction"."publishedVersions" AS "CronTrigger__CronTrigger_serverlessFunction_publishedVersions", "CronTrigger__CronTrigger_serverlessFunction"."runtime" AS "CronTrigger__CronTrigger_serverlessFunction_runtime", "CronTrigger__CronTrigger_serverlessFunction"."timeoutSeconds" AS "CronTrigger__CronTrigger_serverlessFunction_timeoutSeconds", "CronTrigger__CronTrigger_serverlessFunction"."workspaceId" AS "CronTrigger__CronTrigger_serverlessFunction_workspaceId", "CronTrigger__CronTrigger_serverlessFunction"."applicationId" AS "CronTrigger__CronTrigger_serverlessFunction_applicationId", "CronTrigger__CronTrigger_serverlessFunction"."checksum" AS "CronTrigger__CronTrigger_serverlessFunction_checksum", "CronTrigger__CronTrigger_serverlessFunction"."serverlessFunctionLayerId" AS "03960e5dea7d86b73c64a787112b0c45801f984d", "CronTrigger__CronTrigger_serverlessFunction"."createdAt" AS "CronTrigger__CronTrigger_serverlessFunction_createdAt", "CronTrigger__CronTrigger_serverlessFunction"."updatedAt" AS "CronTrigger__CronTrigger_serverlessFunction_updatedAt", "CronTrigger__CronTrigger_serverlessFunction"."deletedAt" AS "CronTrigger__CronTrigger_serverlessFunction_deletedAt" FROM "core"."cronTrigger" "CronTrigger" LEFT JOIN "core"."serverlessFunction" "CronTrigger__CronTrigger_serverlessFunction" ON "CronTrigger__CronTrigger_serverlessFunction"."id"="CronTrigger"."serverlessFunctionId" AND ("CronTrigger__CronTrigger_serverlessFunction"."deletedAt" IS NULL) WHERE (("CronTrigger"."workspaceId" = $1))', parameters: [ 'ff91c061-4bdc-4ee6-85c7-91f163449a61' ], driverError: error: column CronTrigger__CronTrigger_serverlessFunction.universalIdentifier does not exist at /app/node_modules/pg/lib/client.js:526:17 at process.processTicksAndRejections (node:internal/process/task_queues:105:5) at async PostgresQueryRunner.query (/app/node_modules/typeorm/driver/postgres/PostgresQueryRunner.js:184:25) at async SelectQueryBuilder.loadRawResults (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2192:25) at async SelectQueryBuilder.executeEntitiesAndRawResults (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:2040:26) at async SelectQueryBuilder.getRawAndEntities (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:684:29) at async SelectQueryBuilder.getMany (/app/node_modules/typeorm/query-builder/SelectQueryBuilder.js:750:25) at async CronTriggerCronJob.handle (/app/packages/twenty-server/dist/src/engine/metadata-modules/cron-trigger/crons/jobs/cron-trigger.cron.job.js:60:34) at async descriptor.value (/app/packages/twenty-server/dist/src/engine/core-modules/cron/sentry-cron-monitor.decorator.js:60:24) at async MessageQueueExplorer.invokeProcessMethods (/app/packages/twenty-server/dist/src/engine/core-modules/message-queue/message-queue.explorer.js:113:17) { length: 162, severity: 'ERROR', code: '42703', detail: undefined, hint: undefined, position: '158', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '3722', routine: 'errorMissingColumn' }, length: 162, severity: 'ERROR', code: '42703', detail: undefined, hint: undefined, position: '158', internalPosition: undefined, internalQuery: undefined, where: undefined, schema: undefined, table: undefined, column: undefined, dataType: undefined, constraint: undefined, file: 'parse_relation.c', line: '3722', routine: 'errorMissingColumn' } ]

[derevyan]

Solved by gradual step by step version bump that trigger proper migration process.