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)
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 |