3481 lines
160 KiB
Plaintext
3481 lines
160 KiB
Plaintext
--- Verification Started ---
|
|
Found termination 470efa33-4abc-4ba1-8b17-710350161ded. Assigning participants...
|
|
node.exe : Error adding
|
|
participant 6fa3cf01-9675
|
|
-4cfa-a6f6-dd3838f9a8cf
|
|
to termination 470efa33-4
|
|
abc-4ba1-8b17-710350161de
|
|
d: Error
|
|
At C:\Program
|
|
Files\nodejs\npx.ps1:29
|
|
char:3
|
|
+ & $NODE_EXE
|
|
$NPX_CLI_JS $args
|
|
+ ~~~~~~~~~~~~~~~~~~~~~
|
|
~~~~~~~~
|
|
+ CategoryInfo
|
|
: NotSpecified:
|
|
(Error adding pa...5
|
|
0161ded: Error:Strin
|
|
g) [], RemoteExcepti
|
|
on
|
|
+ FullyQualifiedErro
|
|
rId : NativeCommandE
|
|
rror
|
|
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('18a8c491
|
|
-82b3-4416-8683-ce177d8b5
|
|
b3e','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','6fa3cf01-9675-4c
|
|
fa-a6f6-dd3838f9a8cf','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.873
|
|
Z"}','2026-04-09
|
|
18:31:01.880
|
|
+00:00','2026-04-09
|
|
18:31:01.880 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_06dcc0b58
|
|
5554b76b2aef1e381d0fb3a$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('18a8c491
|
|
-82b3-4416-8683-ce177d8b5
|
|
b3e','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','6fa3cf01-9675-4c
|
|
fa-a6f6-dd3838f9a8cf','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.873
|
|
Z"}','2026-04-09
|
|
18:31:01.880
|
|
+00:00','2026-04-09
|
|
18:31:01.880 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_06dcc0b585554b7
|
|
6b2aef1e381d0fb3a$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('18a8c491
|
|
-82b3-4416-8683-ce177d8b5
|
|
b3e','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','6fa3cf01-9675-4c
|
|
fa-a6f6-dd3838f9a8cf','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.873
|
|
Z"}','2026-04-09
|
|
18:31:01.880
|
|
+00:00','2026-04-09
|
|
18:31:01.880 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_06dcc0b58
|
|
5554b76b2aef1e381d0fb3a$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('18a8c491
|
|
-82b3-4416-8683-ce177d8b5
|
|
b3e','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','6fa3cf01-9675-4c
|
|
fa-a6f6-dd3838f9a8cf','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.873
|
|
Z"}','2026-04-09
|
|
18:31:01.880
|
|
+00:00','2026-04-09
|
|
18:31:01.880 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_06dcc0b585554b7
|
|
6b2aef1e381d0fb3a$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_06dcc0b58
|
|
5554b76b2aef1e381d0fb3a$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('18a8c491
|
|
-82b3-4416-8683-ce177d8b5
|
|
b3e','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','6fa3cf01-9675-4c
|
|
fa-a6f6-dd3838f9a8cf','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.873
|
|
Z"}','2026-04-09
|
|
18:31:01.880
|
|
+00:00','2026-04-09
|
|
18:31:01.880 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_06dcc0b585554b7
|
|
6b2aef1e381d0fb3a$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
bd434a3b-97fe-452a-b196-d
|
|
6aa9a138868 to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4f7dd34c
|
|
-3327-476a-abed-81e6e4008
|
|
dfa','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','bd434a3b-97fe-45
|
|
2a-b196-d6aa9a138868','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.963
|
|
Z"}','2026-04-09
|
|
18:31:01.967
|
|
+00:00','2026-04-09
|
|
18:31:01.967 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_2d8d02008
|
|
2e849a9b603296d0790345a$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4f7dd34c
|
|
-3327-476a-abed-81e6e4008
|
|
dfa','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','bd434a3b-97fe-45
|
|
2a-b196-d6aa9a138868','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.963
|
|
Z"}','2026-04-09
|
|
18:31:01.967
|
|
+00:00','2026-04-09
|
|
18:31:01.967 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_2d8d020082e849a
|
|
9b603296d0790345a$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4f7dd34c
|
|
-3327-476a-abed-81e6e4008
|
|
dfa','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','bd434a3b-97fe-45
|
|
2a-b196-d6aa9a138868','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.963
|
|
Z"}','2026-04-09
|
|
18:31:01.967
|
|
+00:00','2026-04-09
|
|
18:31:01.967 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_2d8d02008
|
|
2e849a9b603296d0790345a$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4f7dd34c
|
|
-3327-476a-abed-81e6e4008
|
|
dfa','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','bd434a3b-97fe-45
|
|
2a-b196-d6aa9a138868','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.963
|
|
Z"}','2026-04-09
|
|
18:31:01.967
|
|
+00:00','2026-04-09
|
|
18:31:01.967 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_2d8d020082e849a
|
|
9b603296d0790345a$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_2d8d02008
|
|
2e849a9b603296d0790345a$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4f7dd34c
|
|
-3327-476a-abed-81e6e4008
|
|
dfa','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','bd434a3b-97fe-45
|
|
2a-b196-d6aa9a138868','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.963
|
|
Z"}','2026-04-09
|
|
18:31:01.967
|
|
+00:00','2026-04-09
|
|
18:31:01.967 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_2d8d020082e849a
|
|
9b603296d0790345a$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
5b804f85-432e-48b7-b880-0
|
|
a4e76ce3a79 to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b913952b
|
|
-8532-4480-bc10-cb86fce7e
|
|
60b','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b804f85-432e-48
|
|
b7-b880-0a4e76ce3a79','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.974
|
|
Z"}','2026-04-09
|
|
18:31:01.976
|
|
+00:00','2026-04-09
|
|
18:31:01.976 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_db5d2b008
|
|
3ae44e696464cdc093bdc55$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b913952b
|
|
-8532-4480-bc10-cb86fce7e
|
|
60b','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b804f85-432e-48
|
|
b7-b880-0a4e76ce3a79','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.974
|
|
Z"}','2026-04-09
|
|
18:31:01.976
|
|
+00:00','2026-04-09
|
|
18:31:01.976 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_db5d2b0083ae44e
|
|
696464cdc093bdc55$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b913952b
|
|
-8532-4480-bc10-cb86fce7e
|
|
60b','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b804f85-432e-48
|
|
b7-b880-0a4e76ce3a79','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.974
|
|
Z"}','2026-04-09
|
|
18:31:01.976
|
|
+00:00','2026-04-09
|
|
18:31:01.976 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_db5d2b008
|
|
3ae44e696464cdc093bdc55$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b913952b
|
|
-8532-4480-bc10-cb86fce7e
|
|
60b','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b804f85-432e-48
|
|
b7-b880-0a4e76ce3a79','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.974
|
|
Z"}','2026-04-09
|
|
18:31:01.976
|
|
+00:00','2026-04-09
|
|
18:31:01.976 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_db5d2b0083ae44e
|
|
696464cdc093bdc55$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_db5d2b008
|
|
3ae44e696464cdc093bdc55$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b913952b
|
|
-8532-4480-bc10-cb86fce7e
|
|
60b','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b804f85-432e-48
|
|
b7-b880-0a4e76ce3a79','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:01.974
|
|
Z"}','2026-04-09
|
|
18:31:01.976
|
|
+00:00','2026-04-09
|
|
18:31:01.976 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_db5d2b0083ae44e
|
|
696464cdc093bdc55$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
5b8be476-5a02-41c6-8e62-1
|
|
f3992292eb6 to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b08b0d1e
|
|
-d616-4ac0-8e02-19adca12f
|
|
32c','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b8be476-5a02-41
|
|
c6-8e62-1f3992292eb6','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.233
|
|
Z"}','2026-04-09
|
|
18:31:02.236
|
|
+00:00','2026-04-09
|
|
18:31:02.236 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_f4e43a9f4
|
|
d8b4bae8908d39772548918$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b08b0d1e
|
|
-d616-4ac0-8e02-19adca12f
|
|
32c','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b8be476-5a02-41
|
|
c6-8e62-1f3992292eb6','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.233
|
|
Z"}','2026-04-09
|
|
18:31:02.236
|
|
+00:00','2026-04-09
|
|
18:31:02.236 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_f4e43a9f4d8b4ba
|
|
e8908d39772548918$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b08b0d1e
|
|
-d616-4ac0-8e02-19adca12f
|
|
32c','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b8be476-5a02-41
|
|
c6-8e62-1f3992292eb6','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.233
|
|
Z"}','2026-04-09
|
|
18:31:02.236
|
|
+00:00','2026-04-09
|
|
18:31:02.236 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_f4e43a9f4
|
|
d8b4bae8908d39772548918$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b08b0d1e
|
|
-d616-4ac0-8e02-19adca12f
|
|
32c','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b8be476-5a02-41
|
|
c6-8e62-1f3992292eb6','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.233
|
|
Z"}','2026-04-09
|
|
18:31:02.236
|
|
+00:00','2026-04-09
|
|
18:31:02.236 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_f4e43a9f4d8b4ba
|
|
e8908d39772548918$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_f4e43a9f4
|
|
d8b4bae8908d39772548918$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('b08b0d1e
|
|
-d616-4ac0-8e02-19adca12f
|
|
32c','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','5b8be476-5a02-41
|
|
c6-8e62-1f3992292eb6','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.233
|
|
Z"}','2026-04-09
|
|
18:31:02.236
|
|
+00:00','2026-04-09
|
|
18:31:02.236 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_f4e43a9f4d8b4ba
|
|
e8908d39772548918$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
e685d4e3-d2b1-495b-be91-e
|
|
29a16fb0b0b to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('7b545aab
|
|
-b209-442e-8e65-350d4d299
|
|
4bb','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','e685d4e3-d2b1-49
|
|
5b-be91-e29a16fb0b0b','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.246
|
|
Z"}','2026-04-09
|
|
18:31:02.249
|
|
+00:00','2026-04-09
|
|
18:31:02.249 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_da537da65
|
|
4614461b378cef1a05d3cf1$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('7b545aab
|
|
-b209-442e-8e65-350d4d299
|
|
4bb','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','e685d4e3-d2b1-49
|
|
5b-be91-e29a16fb0b0b','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.246
|
|
Z"}','2026-04-09
|
|
18:31:02.249
|
|
+00:00','2026-04-09
|
|
18:31:02.249 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_da537da65461446
|
|
1b378cef1a05d3cf1$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('7b545aab
|
|
-b209-442e-8e65-350d4d299
|
|
4bb','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','e685d4e3-d2b1-49
|
|
5b-be91-e29a16fb0b0b','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.246
|
|
Z"}','2026-04-09
|
|
18:31:02.249
|
|
+00:00','2026-04-09
|
|
18:31:02.249 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_da537da65
|
|
4614461b378cef1a05d3cf1$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('7b545aab
|
|
-b209-442e-8e65-350d4d299
|
|
4bb','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','e685d4e3-d2b1-49
|
|
5b-be91-e29a16fb0b0b','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.246
|
|
Z"}','2026-04-09
|
|
18:31:02.249
|
|
+00:00','2026-04-09
|
|
18:31:02.249 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_da537da65461446
|
|
1b378cef1a05d3cf1$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_da537da65
|
|
4614461b378cef1a05d3cf1$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('7b545aab
|
|
-b209-442e-8e65-350d4d299
|
|
4bb','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','e685d4e3-d2b1-49
|
|
5b-be91-e29a16fb0b0b','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.246
|
|
Z"}','2026-04-09
|
|
18:31:02.249
|
|
+00:00','2026-04-09
|
|
18:31:02.249 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_da537da65461446
|
|
1b378cef1a05d3cf1$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
ba3e4a29-7c31-4709-9c86-2
|
|
65457b07d08 to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('281a5837
|
|
-b5c6-4f15-a868-c44719392
|
|
4cf','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','ba3e4a29-7c31-47
|
|
09-9c86-265457b07d08','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.266
|
|
Z"}','2026-04-09
|
|
18:31:02.269
|
|
+00:00','2026-04-09
|
|
18:31:02.269 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_d73b992ec
|
|
f984098b308583551636cff$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('281a5837
|
|
-b5c6-4f15-a868-c44719392
|
|
4cf','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','ba3e4a29-7c31-47
|
|
09-9c86-265457b07d08','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.266
|
|
Z"}','2026-04-09
|
|
18:31:02.269
|
|
+00:00','2026-04-09
|
|
18:31:02.269 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_d73b992ecf98409
|
|
8b308583551636cff$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('281a5837
|
|
-b5c6-4f15-a868-c44719392
|
|
4cf','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','ba3e4a29-7c31-47
|
|
09-9c86-265457b07d08','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.266
|
|
Z"}','2026-04-09
|
|
18:31:02.269
|
|
+00:00','2026-04-09
|
|
18:31:02.269 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_d73b992ec
|
|
f984098b308583551636cff$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('281a5837
|
|
-b5c6-4f15-a868-c44719392
|
|
4cf','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','ba3e4a29-7c31-47
|
|
09-9c86-265457b07d08','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.266
|
|
Z"}','2026-04-09
|
|
18:31:02.269
|
|
+00:00','2026-04-09
|
|
18:31:02.269 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_d73b992ecf98409
|
|
8b308583551636cff$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_d73b992ec
|
|
f984098b308583551636cff$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('281a5837
|
|
-b5c6-4f15-a868-c44719392
|
|
4cf','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','ba3e4a29-7c31-47
|
|
09-9c86-265457b07d08','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.266
|
|
Z"}','2026-04-09
|
|
18:31:02.269
|
|
+00:00','2026-04-09
|
|
18:31:02.269 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_d73b992ecf98409
|
|
8b308583551636cff$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
76ce1223-80b8-46e0-a74c-9
|
|
3de8c4c50e2 to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('f53eed21
|
|
-dd85-4f48-a7ca-4d580226c
|
|
703','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','76ce1223-80b8-46
|
|
e0-a74c-93de8c4c50e2','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.281
|
|
Z"}','2026-04-09
|
|
18:31:02.283
|
|
+00:00','2026-04-09
|
|
18:31:02.283 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_3f3a4559f
|
|
72044779e697b364d53d19b$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('f53eed21
|
|
-dd85-4f48-a7ca-4d580226c
|
|
703','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','76ce1223-80b8-46
|
|
e0-a74c-93de8c4c50e2','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.281
|
|
Z"}','2026-04-09
|
|
18:31:02.283
|
|
+00:00','2026-04-09
|
|
18:31:02.283 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_3f3a4559f720447
|
|
79e697b364d53d19b$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('f53eed21
|
|
-dd85-4f48-a7ca-4d580226c
|
|
703','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','76ce1223-80b8-46
|
|
e0-a74c-93de8c4c50e2','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.281
|
|
Z"}','2026-04-09
|
|
18:31:02.283
|
|
+00:00','2026-04-09
|
|
18:31:02.283 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_3f3a4559f
|
|
72044779e697b364d53d19b$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('f53eed21
|
|
-dd85-4f48-a7ca-4d580226c
|
|
703','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','76ce1223-80b8-46
|
|
e0-a74c-93de8c4c50e2','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.281
|
|
Z"}','2026-04-09
|
|
18:31:02.283
|
|
+00:00','2026-04-09
|
|
18:31:02.283 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_3f3a4559f720447
|
|
79e697b364d53d19b$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_3f3a4559f
|
|
72044779e697b364d53d19b$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('f53eed21
|
|
-dd85-4f48-a7ca-4d580226c
|
|
703','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','76ce1223-80b8-46
|
|
e0-a74c-93de8c4c50e2','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.281
|
|
Z"}','2026-04-09
|
|
18:31:02.283
|
|
+00:00','2026-04-09
|
|
18:31:02.283 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_3f3a4559f720447
|
|
79e697b364d53d19b$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
Error adding participant
|
|
a52ecffc-05ce-408c-b85b-c
|
|
1ac5ad32e30 to
|
|
termination 470efa33-4abc
|
|
-4ba1-8b17-710350161ded:
|
|
Error
|
|
at Query.run (C:\laxm
|
|
an\Dealer_Onboard\Dealer_
|
|
Onboarding_Backend\node_m
|
|
odules\sequelize\src\dial
|
|
ects\postgres\query.js:76
|
|
:25)
|
|
at <anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\sequelize\src\se
|
|
quelize.js:650:28)
|
|
at process.processTic
|
|
ksAndRejections (node:int
|
|
ernal/process/task_queues
|
|
:105:5)
|
|
at async PostgresQuer
|
|
yInterface.insert (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\sequelize\src\dia
|
|
lects\abstract\query-inte
|
|
rface.js:795:21)
|
|
at async model.save (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\node_modules\sequelize\s
|
|
rc\model.js:4154:35)
|
|
at async
|
|
Function.create (C:\laxma
|
|
n\Dealer_Onboard\Dealer_O
|
|
nboarding_Backend\node_mo
|
|
dules\sequelize\src\model
|
|
.js:2305:12)
|
|
at async
|
|
Function.findOrCreate (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\sequelize\src
|
|
\model.js:2417:25)
|
|
at async
|
|
Function.addParticipant (
|
|
C:\laxman\Dealer_Onboard\
|
|
Dealer_Onboarding_Backend
|
|
\src\services\Participant
|
|
Service.ts:23:13)
|
|
at async Function.ass
|
|
ignTerminationParticipant
|
|
s (C:\laxman\Dealer_Onboa
|
|
rd\Dealer_Onboarding_Back
|
|
end\src\services\Particip
|
|
antService.ts:107:17)
|
|
at async verify (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\ver
|
|
ify_participants_logic.ts
|
|
:12:13) {
|
|
name: 'SequelizeForeign
|
|
KeyConstraintError',
|
|
parent: error: insert
|
|
or update on table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4e668b8a
|
|
-53c5-464c-b83b-50090b39b
|
|
d00','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','a52ecffc-05ce-40
|
|
8c-b85b-c1ac5ad32e30','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.302
|
|
Z"}','2026-04-09
|
|
18:31:02.304
|
|
+00:00','2026-04-09
|
|
18:31:02.304 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
[ParticipantService] Added 8 participants to termination 470efa33-4abc-4ba1-8b17-710350161ded
|
|
Termination Participants added: 0
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_997f40b07
|
|
24e4c87be1a8e748d85f4d7$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4e668b8a
|
|
-53c5-464c-b83b-50090b39b
|
|
d00','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','a52ecffc-05ce-40
|
|
8c-b85b-c1ac5ad32e30','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.302
|
|
Z"}','2026-04-09
|
|
18:31:02.304
|
|
+00:00','2026-04-09
|
|
18:31:02.304 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_997f40b0724e4c8
|
|
7be1a8e748d85f4d7$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
original: error:
|
|
insert or update on
|
|
table
|
|
"request_participants"
|
|
violates foreign key
|
|
constraint "request_parti
|
|
cipants_requestId_fkey"
|
|
at
|
|
parseErrorMessage (C:\lax
|
|
man\Dealer_Onboard\Dealer
|
|
_Onboarding_Backend\node_
|
|
modules\pg-protocol\src\p
|
|
arser.ts:394:9)
|
|
at
|
|
Parser.handlePacket (C:\l
|
|
axman\Dealer_Onboard\Deal
|
|
er_Onboarding_Backend\nod
|
|
e_modules\pg-protocol\src
|
|
\parser.ts:212:19)
|
|
at Parser.parse (C:
|
|
\laxman\Dealer_Onboard\De
|
|
aler_Onboarding_Backend\n
|
|
ode_modules\pg-protocol\s
|
|
rc\parser.ts:105:30)
|
|
at
|
|
Socket.<anonymous> (C:\la
|
|
xman\Dealer_Onboard\Deale
|
|
r_Onboarding_Backend\node
|
|
_modules\pg-protocol\src\
|
|
index.ts:7:48)
|
|
at Socket.emit
|
|
(node:events:518:28)
|
|
at addChunk (node:i
|
|
nternal/streams/readable:
|
|
561:12)
|
|
at readableAddChunk
|
|
PushByteMode (node:intern
|
|
al/streams/readable:512:3
|
|
)
|
|
at Readable.push (n
|
|
ode:internal/streams/read
|
|
able:392:5)
|
|
at
|
|
TCP.onStreamRead (node:in
|
|
ternal/stream_base_common
|
|
s:189:23) {
|
|
length: 877,
|
|
severity: 'ERROR',
|
|
code: '23503',
|
|
detail: 'Key (request
|
|
Id)=(470efa33-4abc-4ba1-8
|
|
b17-710350161ded) is not
|
|
present in table
|
|
"applications".',
|
|
hint: undefined,
|
|
position: undefined,
|
|
internalPosition:
|
|
undefined,
|
|
internalQuery:
|
|
undefined,
|
|
where: `SQL
|
|
statement "INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4e668b8a
|
|
-53c5-464c-b83b-50090b39b
|
|
d00','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','a52ecffc-05ce-40
|
|
8c-b85b-c1ac5ad32e30','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.302
|
|
Z"}','2026-04-09
|
|
18:31:02.304
|
|
+00:00','2026-04-09
|
|
18:31:02.304 +00:00')
|
|
RETURNING *"\n` +
|
|
'PL/pgSQL function
|
|
pg_temp_12.testfunc()
|
|
line 1 at SQL statement',
|
|
schema: 'public',
|
|
table:
|
|
'request_participants',
|
|
column: undefined,
|
|
dataType: undefined,
|
|
constraint: 'request_
|
|
participants_requestId_fk
|
|
ey',
|
|
file:
|
|
'ri_triggers.c',
|
|
line: '2783',
|
|
routine:
|
|
'ri_ReportViolation',
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_997f40b07
|
|
24e4c87be1a8e748d85f4d7$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4e668b8a
|
|
-53c5-464c-b83b-50090b39b
|
|
d00','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','a52ecffc-05ce-40
|
|
8c-b85b-c1ac5ad32e30','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.302
|
|
Z"}','2026-04-09
|
|
18:31:02.304
|
|
+00:00','2026-04-09
|
|
18:31:02.304 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_997f40b0724e4c8
|
|
7be1a8e748d85f4d7$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: undefined
|
|
},
|
|
sql: `CREATE OR
|
|
REPLACE FUNCTION
|
|
pg_temp.testfunc(OUT
|
|
response
|
|
"request_participants",
|
|
OUT sequelize_caught_exce
|
|
ption text) RETURNS
|
|
RECORD AS $func_997f40b07
|
|
24e4c87be1a8e748d85f4d7$
|
|
BEGIN INSERT INTO
|
|
"request_participants" ("
|
|
id","requestId","requestT
|
|
ype","userId","participan
|
|
tType","joinedMethod","me
|
|
tadata","createdAt","upda
|
|
tedAt") VALUES ('4e668b8a
|
|
-53c5-464c-b83b-50090b39b
|
|
d00','470efa33-4abc-4ba1-
|
|
8b17-710350161ded','termi
|
|
nation','a52ecffc-05ce-40
|
|
8c-b85b-c1ac5ad32e30','co
|
|
ntributor','auto','{"auto
|
|
Mapped":true,"assignedAt"
|
|
:"2026-04-09T18:31:02.302
|
|
Z"}','2026-04-09
|
|
18:31:02.304
|
|
+00:00','2026-04-09
|
|
18:31:02.304 +00:00')
|
|
RETURNING * INTO
|
|
response; EXCEPTION WHEN
|
|
unique_violation THEN
|
|
GET STACKED DIAGNOSTICS s
|
|
equelize_caught_exception
|
|
= PG_EXCEPTION_DETAIL;
|
|
END $func_997f40b0724e4c8
|
|
7be1a8e748d85f4d7$
|
|
LANGUAGE plpgsql; SELECT
|
|
(testfunc.response)."id",
|
|
(testfunc.response)."req
|
|
uestId", (testfunc.respon
|
|
se)."requestType", (testf
|
|
unc.response)."userId", (
|
|
testfunc.response)."parti
|
|
cipantType", (testfunc.re
|
|
sponse)."joinedMethod", (
|
|
testfunc.response)."metad
|
|
ata", (testfunc.response)
|
|
."createdAt", (testfunc.r
|
|
esponse)."updatedAt", tes
|
|
tfunc.sequelize_caught_ex
|
|
ception FROM
|
|
pg_temp.testfunc(); DROP
|
|
FUNCTION IF EXISTS
|
|
pg_temp.testfunc();`,
|
|
parameters: {},
|
|
table:
|
|
'request_participants',
|
|
fields: null,
|
|
value: undefined,
|
|
index: 'request_partici
|
|
pants_requestId_fkey',
|
|
reltype: undefined
|
|
}
|
|
No constitutional change records found to verify.
|
|
No resignation records found to verify.
|
|
--- Verification Completed ---
|