partition table insert error!

From: dbatoCloud Solution <dbatocloud17(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: partition table insert error!
Date: 2021-03-10 15:28:00
Message-ID: CAEz7P_vn4Ww7525aiOLVvhy+u6_cT+N3ORY1P7iRU_bOeOYByA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi All,
I am getting the below after creating partition table by range wise while
inserting job

Exception in component tDBOutput_8 (I120_core_contact_session_history)
java.sql.SQLException: Batch entry 0 INSERT INTO
"core"."contact_transaction_history"
("contact_transaction_id","mdm_contact_id","contact_id","opportunity_id","legacy_crm_id","idp_id","activity_datetime","unique_reference_number","utm_campaign_text","utm_content_text","utm_mdm_text","utm_referenced_text","utm_source_text","utm_trm_text","registration_verification_datetime","arrival_date","departure_date","priority_code","purchasing_budget","file_upload_url","source_description","transaction_status_id","registration_method_id","edition_id","source_system_id","email_address","hash_email_address","record_insert_datetime","record_insert_by","record_update_datetime","record_update_by","source_create_datetime","source_update_datetime","websiteurl","customfield1","customfield2","customfield3","customfield4","customfield5","probability","hotel_booking","crm_contact_type_id")
VALUES
(38407428,'7212a1f9-fe5a-4245-bfba-47a3fab3ccb0',111037164,'0067A000009sUunQAE',NULL,NULL,'2021-03-09
11:27:21+00'::timestamp,'','','','','','','',NULL,NULL,NULL,'','','','',14324,NULL,3374,31,'
haribhajan(dot)saini(at)informa(dot)com','1f1076a54571e0b5afb2829309ed7ced','2021-03-09
11:27:24+00'::timestamp,'MULE','2021-03-10
15:17:05+00'::timestamp,'MULE','2021-03-09
11:27:23+00'::timestamp,'2021-03-09
11:27:23+00'::timestamp,'','','','','','','',NULL,14438) was aborted:
ERROR: duplicate key value violates unique constraint
"contact_transaction_history_2_contact_transaction_id_recor_key4" Call
getNextException to see other errors in the batch.
caused by: ERROR: duplicate key value violates unique constraint
"contact_transaction_history_2_contact_transaction_id_recor_key4"
at
touchstone.i120_core_contact_session_history_0_8.I120_core_contact_session_history$1tAsyncIn_tDBOutput_8_ParallelThread.run(I120_core_contact_session_history.java:40806)
Caused by: org.postgresql.util.PSQLException: ERROR: duplicate key value
violates unique constraint
"contact_transaction_history_2_contact_transaction_id_recor_key4"
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2440)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2183)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:481)
at org.postgresql.jdbc.PgStatement.executeBatch(PgStatement.java:840)
at
org.postgresql.jdbc.PgPreparedStatement.executeBatch(PgPreparedStatement.java:1538)

at
touchstone.i120_core_contact_session_history_0_8.I120_core_contact_session_history$1tAsyncIn_tDBOutput_8_ParallelThread.run(I120_core_contact_session_history.java:40792)

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2021-03-10 15:48:01 Re: partition table insert error!
Previous Message Laurenz Albe 2021-03-10 08:14:46 Re: Lock after several failed login attempts