```[Nest] 7  - 05/11/2025, 4:13:16 PM   ERROR [Microservices:{"id":"c0cc689a-bc30-47f2-8d70-e5f9630b19d2","deleteOnDisk":true}] Unable to run job handler (backgroundTask/asset-deletion): PostgresError: update or delete on table "assets" violates foreign key constraint "FK_91704e101438fd0653f582426dc" on table "asset_stack"

PostgresError: update or delete on table "assets" violates foreign key constraint "FK_91704e101438fd0653f582426dc" on table "asset_stack"

    at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

    at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

    at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

    at Socket.emit (node:events:518:28)

    at addChunk (node:internal/streams/readable:561:12)

    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)

    at Readable.push (node:internal/streams/readable:392:5)

    at TCP.onStreamRead (node:internal/stream_base_commons:189:23)

Query failed : {

  durationMs: 2.0287130000069737,

  error: PostgresError: update or delete on table "assets" violates foreign key constraint "FK_91704e101438fd0653f582426dc" on table "asset_stack"

      at ErrorResponse (/usr/src/app/node_modules/postgres/cjs/src/connection.js:790:26)

      at handle (/usr/src/app/node_modules/postgres/cjs/src/connection.js:476:6)

      at Socket.data (/usr/src/app/node_modules/postgres/cjs/src/connection.js:315:9)

      at Socket.emit (node:events:518:28)

      at addChunk (node:internal/streams/readable:561:12)

      at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)

      at Readable.push (node:internal/streams/readable:392:5)

      at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {

    severity_local: 'ERROR',

    severity: 'ERROR',

    code: '23503',

    detail: 'Key (id)=(bf878ca1-2f99-4d1c-aa35-232585364057) is still referenced from table "asset_stack".',

    schema_name: 'public',

    table_name: 'asset_stack',

    constraint_name: 'FK_91704e101438fd0653f582426dc',

    file: 'ri_triggers.c',

    line: '2541',

    routine: 'ri_ReportViolation'

  },

  sql: 'delete from "assets" where "id" = $1::uuid',

  params: [ 'bf878ca1-2f99-4d1c-aa35-232585364057' ]

}```