ERROR: duplicate key value violates unique constraint "v_database_transactions_pkey"

Status
Not open for further replies.

kp123

New Member
Feb 6, 2017
19
1
3
43
Server Fusionpbx4.4 ,freeswitch 10.02, log database AWS RDS posgretsql:

2022-05-13 08:25:16 UTC:172.31.6.27(36422):fusionpbx@fusionpbx:[25031]:ERROR: duplicate key value violates unique constraint "v_database_transactions_pkey"
2022-05-13 08:25:16 UTC:172.31.6.27(36422):fusionpbx@fusionpbx:[25031]:DETAIL: Key (database_transaction_uuid)=(762fa26a-0eca-4f24-b55a-00d79213b934) already exists.
2022-05-13 08:25:16 UTC:172.31.6.27(36422):fusionpbx@fusionpbx:[25031]:STATEMENT: insert into v_database_transactions (database_transaction_uuid, domain_uuid, app_uuid, app_name, transaction_code, transaction_address, transaction_type, transaction_date, transaction_old, transaction_new, transaction_result )values ('762fa26a-0eca-4f24-b55a-00d79213b934', '9b313eb6-5bf4-42dc-b7dd-780a7350c7d8', '56165644-598d-4ed8-be01-d960bcb8ffed', 'call_recordings', '200', '127.0.0.1', 'add', now(), null, '{
"call_recordings": [
{
"call_recording_uuid": "6cd3e78d-851c-49bb-b0e4-1104d87b6157",
"domain_uuid": "9b313eb6-5bf4-42dc-b7dd-780a7350c7d8",
"call_recording_name": "6cd3e78d-851c-49bb-b0e4-1104d87b6157.wav",
........

-> CDR not write to table v_xml_cdr ( not find row Where name_record = 6cd3e78d-851c-49bb-b0e4-1104d87b6157.wav)

file 6cd3e78d-851c-49bb-b0e4-1104d87b6157.wav in local disk : ok
row data in table v_call_recording : ok

Fix???
 
Status
Not open for further replies.