java.sql.BatchUpdateException: Batch entry 9 INSERT INTO "Private.statistics.page-views" ("adid","interval","type","count") VALUES ('12345678','MONTH_201701','sometype',1) ON CONFLICT ("adid","interval","type") DO UPDATE SET "count"=EXCLUDED."count" was aborted. Call getNextException to see the cause.

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Google Groups by Unknown author, 11 months ago
Batch entry 9 INSERT INTO "Private.statistics.page-views" ("adid","interval","type","count") VALUES ('12345678','MONTH_201701','sometype',1) ON CONFLICT ("adid","interval","type") DO UPDATE SET "count"=EXCLUDED."count" was aborted. Call getNextException to see the cause.
via Oracle Community by 843859, 1 year ago
Batch entry 0 INSERT INTO sys_group_permission (GroupID, PermissionID , Enabled) VALUES ('10','1','Y') was aborted. Call getNextException to see the cause.
via Stack Overflow by hellzone
, 2 years ago
Batch entry 0 insert into registered_user (alias, id, register_time, title, type, uuid) values ('www.google.com', '0010001774', '2013-12-23T14:13:46', 'Google software', 'Special', 'A39D895E-111B-47E7-AFCD-25125556A0A0') was aborted. Call getNextException to see the cause.
via Stack Overflow by My God
, 1 year ago
Batch entry 0 update cust set password='530a32c1-eba5-4de8-8e85-97d3af62c331', reference_id='41e24e58-a108-4f12-9b6b-4250a7a379e5', cust_uuid=? where cust_id=82737513 was aborted. Call getNextException to see the cause.
via sourceforge.net by Unknown author, 2 years ago
Batch entry 0 CREATE TABLE unused (a int primary key) was aborted. Call getNextException to see the cause.
via Atlassian JIRA by Andrew Myers [Atlassian], 1 year ago
='1280381875156', cru_metrics_version='1', cru_all_reviewers_complete='1', cru_due_date='1280986675000', cru_issue_key='TST-1', cru_parent_review=NULL, cru_creator='2', cru_project='1' where cru_review_id='1' was aborted. Call getNextException to see the cause.
java.sql.BatchUpdateException: Batch entry 9 INSERT INTO "Private.statistics.page-views" ("adid","interval","type","count") VALUES ('12345678','MONTH_201701','sometype',1) ON CONFLICT ("adid","interval","type") DO UPDATE SET "count"=EXCLUDED."count" was aborted. Call getNextException to see the cause.
at org.postgresql.jdbc2.AbstractJdbc2Statement$BatchResultHandler.handleError(AbstractJdbc2Statement.java:2778)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1912)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:338)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2959)
at io.confluent.connect.jdbc.sink.BufferedRecords.flush(BufferedRecords.java:98)
at io.confluent.connect.jdbc.sink.BufferedRecords.add(BufferedRecords.java:77)
at io.confluent.connect.jdbc.sink.JdbcDbWriter.write(JdbcDbWriter.java:62)
at io.confluent.connect.jdbc.sink.JdbcSinkTask.put(JdbcSinkTask.java:66)
at org.apache.kafka.connect.runtime.WorkerSinkTask.deliverMessages(WorkerSinkTask.java:384)
at org.apache.kafka.connect.runtime.WorkerSinkTask.poll(WorkerSinkTask.java:240)
at org.apache.kafka.connect.runtime.WorkerSinkTask.iteration(WorkerSinkTask.java:172)
at org.apache.kafka.connect.runtime.WorkerSinkTask.execute(WorkerSinkTask.java:143)
at org.apache.kafka.connect.runtime.WorkerTask.doRun(WorkerTask.java:140)
at org.apache.kafka.connect.runtime.WorkerTask.run(WorkerTask.java:175)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)

Users with the same issue

15 times, 1 week ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.