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.


Solutions on the web197

Solution icon of googlegroups
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.

Solution icon of oraclecommunity
Batch entry 0 insert into testuser (testUserId, testName) values (1, test name) was aborted. Call getNextException to see the cause.

Solution icon of googlegroups
via Google Groups by Allen Rohner, 1 year ago
Batch entry 0 insert into es.sessions (id, user_id) VALUES (41, 1) was aborted. Call getNextException to see the cause.

Solution icon of web
via hivmr.com by Unknown author, 1 year ago
Batch entry 0 insert into testuser (testUserId, testName) values (1, test name) was aborted. Call getNextException to see the cause.

Solution icon of web
Batch entry 0 INSERT INTO metrics_MetricSource_statistics_list (cdo_source, cdo_idx, cdo_value) VALUES('254', '9', '4627') was aborted. Call getNextException to see the cause.

Solution icon of ehour
via eHour JIRA by DTI, 1 year ago
Batch entry 4 insert into USER_TO_USERROLE (USER_ID, ROLE) values ('374', 'ROLE_PROJECTMANAGER') was aborted. Call getNextException to see the cause.

Solution icon of web
Batch entry 0 INSERT INTO metrics_MetricSource_statistics_list (cdo_source, cdo_idx, cdo_value) VALUES('254', '9', '4627') was aborted. Call getNextException to see the cause.

Solution icon of coderanch
via Coderanch by Prasad Shindikar, 9 months ago
Batch entry 0 insert into ORDERS (ORDER_DESC, ORDER_ID) values (myorder, 23) was aborted. Call getNextException to see the cause.

Solution icon of ehour
via eHour JIRA by claude, 1 year ago
Batch entry 4 insert into USER_TO_USERROLE (USER_ID, ROLE) values ('204', 'ROLE_PROJECTMANAGER') was aborted. Call getNextException to see the cause.

Solution icon of stackoverflow
Batch entry 0 insert into student (name, id) values ('asdfgh', '4') was aborted. Call getNextException to see the cause.

Stack trace

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)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

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
Samebug visitor profile picture
Unknown user
Once, 1 year ago
6 more bugmates