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 web1043

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 stackoverflow
Batch entry 6 insert into "sensordata" ("measure_time", "location_id", "sensor_id", "value") values (1462551000, 12, 15, NaN) on conflict ("measure_time", "location_id", "sensor_id") do update set "value" = NaN 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 stackoverflow
Batch entry 0 insert into student (name, id) values ('asdfgh', '4') 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 github
via GitHub by grooverdan
, 3 months ago
Batch entry 0 INSERT INTO "ACCOUNTS" VALUES (0, '0000000000000000000000000000000000000000000000000000000000000000') 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.

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, 10 months 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