Pattern selector

Most relevant patterns first. Most helpful ones displayed. Click here to show all.

  1. Bootstrap.main() has thrown an UpgradeException
    Tomcat Catalina
    0
    0
    0
  2. PreparedStatement.executeInternal() has thrown a MySQLIntegrityConstraintViolationException
    MySQL Connector/J
    104
    130
    23

Your stack trace compared to the selected pattern

Jump to solutionsExpand frames
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`confluence40`.`content_perm`, CONSTRAINT `FKBD74B31676E33274` FOREIGN KEY (`CPS_ID`) REFERENCES `content_perm_set` (`ID`))
11 matching frames hidden
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2693)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2102)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2395)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2313)
23 frames hidden

Solution

chinthana11 months ago

Nothing is wrong with the database. When it gives you those errors, it's telling you that you are trying to input "nothing" (null) into a column that doesn't allow it. Fix it by removing the not null constraint or by passing a value to that field.

External results for this pattern (10)

  1. WENLINRONGvia GitHub3 weeks ago
    javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace
  2. ariehkovlervia GitHub3 weeks ago
    Duplicate entry '6' for key 'PRIMARY' │···························
    Show stack trace
  3. Jonathan Pricevia Google Groups1 month ago
    Could not execute JDBC batch update
    Show stack trace
  4. 吴冉波via Google Groups1 month ago
    Duplicate entry '115-67' for key 'permission_permission_meta_resource_uniq'
    Show stack trace
  5. TTTimWangvia GitHub2 months ago
    Column 'gift_id' cannot be null ; SQL []; Column 'gift_id' cannot be null; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: Column 'gift_id' cannot be null
    Show stack trace
  6. cdmvirtvia GitHub2 months ago
    Cannot add or update a child row: a foreign key constraint fails (`mobhunting`.`mh_Bounties`, CONSTRAINT `mh_Bounties_Player_Id_1` FOREIGN KEY (`BOUNTYOWNER_ID`) REFERENCES `mh_Players` (`PLAYER_ID`) ON DELETE CASCADE)
    Show stack trace
  7. hh6plusvia Stack Overflow3 months ago
    Duplicate entry '2750633-163072083-袋-0' for key 'uk_unit_name'
    Show stack trace
  8. Jon Snowvia Stack Overflow3 months ago
  9. cthielenvia GitHub4 months ago
    could not execute statement; SQL [n/a]; constraint [sectionGroup_unique_courseId_termCode]; nested exception is org.hibernate.exception.ConstraintViolationException: could not execute statement
    Show stack trace