worklenz icon indicating copy to clipboard operation
worklenz copied to clipboard

[SOCKET.IO] Error: duplicate key value violates unique constraint "tasks_assignees_pk"

Open yonas opened this issue 1 year ago • 0 comments

GET /api/v1/task-time-log/task/b8c817b7-a6b0-43d5-8144-91f47728e12d 304 19.237 ms - -
Trace: [SOCKET.IO] Error: duplicate key value violates unique constraint "tasks_assignees_pk"
    at /home/yonas/git/worklenz/worklenz-backend/node_modules/pg-pool/index.js:45:11
    at tryCatcher (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/util.js:16:23)
    at Promise._settlePromiseFromHandler (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/promise.js:547:31)
    at Promise._settlePromise (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/promise.js:604:18)
    at Promise._settlePromise0 (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/promise.js:649:10)
    at Promise._settlePromises (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/promise.js:725:18)
    at _drainQueueStep (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/async.js:93:12)
    at _drainQueue (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/async.js:86:9)
    at Async._drainQueues (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/async.js:102:5)
    at Async.drainQueues [as _onImmediate] (/home/yonas/git/worklenz/worklenz-backend/node_modules/bluebird/js/release/async.js:15:14)
    at process.processImmediate (node:internal/timers:478:21) {
  severity: 'ERROR',
  code: '23505',
  messageDetail: 'Key (task_id, project_member_id)=(b8c817b7-a6b0-43d5-8144-91f47728e12d, 60162685-02d7-4043-a88a-f3b60923c1b9) already exists.',
  where: 'SQL statement "INSERT INTO tasks_assignees (task_id, project_member_id, team_member_id, assigned_by)\n' +
    '    VALUES (_task_id, _project_member_id, _team_member_id, _reporter_user_id)"\n' +
    'PL/pgSQL function create_task_assignee(uuid,uuid,uuid,uuid) line 30 at SQL statement',
  schema: 'public',
  table: 'tasks_assignees',
  constraint: 'tasks_assignees_pk',
  file: 'nbtinsert.c',
  line: '671',
  routine: '_bt_check_unique'
}
    at log_error (/home/yonas/git/worklenz/worklenz-backend/build/socket.io/util.js:12:13)
    at on_quick_assign_or_remove (/home/yonas/git/worklenz/worklenz-backend/build/socket.io/commands/on-quick-assign-or-remove.js:63:30)

yonas avatar May 27 '24 02:05 yonas