java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`Prism`.`prism_data_extra`, CONSTRAINT `prism_data_extra_ibfk_1` FOREIGN KEY (`data_id`) REFERENCES `prism_data` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)

GitHub | Eufranio | 3 months ago
  1. 0

    GitHub comment 52#246145202

    GitHub | 3 months ago | Eufranio
    java.sql.BatchUpdateException: Cannot add or update a child row: a foreign key constraint fails (`Prism`.`prism_data_extra`, CONSTRAINT `prism_data_extra_ibfk_1` FOREIGN KEY (`data_id`) REFERENCES `prism_data` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)
  2. 0

    #936 — Prism database problems + eventual server crash — Prism – Snowy Evening

    snowy-evening.com | 2 years ago
    java.sql.BatchUpdateException: No operations allowed after statement closed.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    Play framework on tomcat+lighttpd - jpa

    Stack Overflow | 5 years ago | Skyrocket Rocketsky
    org.hibernate.exception.ConstraintViolationException: Could not execute JDBC batch update
  5. 0

    auto-purge issue

    GitHub | 10 months ago | EvilOlaf
    java.sql.BatchUpdateException: Table 'myplotdb.plot' doesn't exist

  1. linxiaolong 26 times, last 4 weeks ago
  2. linxiaolong 4 times, last 3 months ago
  3. mortalman7 32 times, last 5 months ago
9 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.BatchUpdateException

    Cannot add or update a child row: a foreign key constraint fails (`Prism`.`prism_data_extra`, CONSTRAINT `prism_data_extra_ibfk_1` FOREIGN KEY (`data_id`) REFERENCES `prism_data` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION)

    at com.mysql.jdbc.PreparedStatement.executeBatchSerially()
  2. MySQL jdbc
    PreparedStatement.executeBatch
    1. com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
    2. com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
    2 frames
  3. me.botsko.prism
    RecordingTask.run
    1. me.botsko.prism.actionlibs.RecordingTask.insertExtraData(RecordingTask.java:322)
    2. me.botsko.prism.actionlibs.RecordingTask.insertActionsIntoDatabase(RecordingTask.java:256)
    3. me.botsko.prism.actionlibs.RecordingTask.save(RecordingTask.java:36)
    4. me.botsko.prism.actionlibs.RecordingTask.run(RecordingTask.java:352)
    4 frames
  4. org.bukkit.craftbukkit
    CraftAsyncTask.run
    1. org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftTask.run(CraftTask.java:71)
    2. org.bukkit.craftbukkit.v1_7_R4.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
    2 frames
  5. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames