org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT into DEPLOYMENT_IDS (DEPLOYMENT_KEY, DEPLOYMENT_ID)values (?, ?)]; Column 'DEPLOYMENT_ID' cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column 'DEPLOYMENT_ID' cannot be null

GitHub | trisberg | 3 months ago
  1. 0

    Task launch should check deployment id for null

    GitHub | 3 months ago | trisberg
    org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [INSERT into DEPLOYMENT_IDS (DEPLOYMENT_KEY, DEPLOYMENT_ID)values (?, ?)]; Column 'DEPLOYMENT_ID' cannot be null; nested exception is java.sql.SQLIntegrityConstraintViolationException: Column 'DEPLOYMENT_ID' cannot be null
  2. 0

    Hibernate Cannot add or update a child row issue

    Stack Overflow | 2 years ago
    java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`etendering_test`.`announcement`, CONSTRAINT `announcement_public_procurement_ibfk_1` FOREIGN KEY (`public_procurement_id`) REFERENCES `public_procurement` (`id`))
  3. 0

    When I add an environment named "TEST", it failed and after that can not use any function

    GitHub | 1 year ago | hjianhao
    org.jooq.exception.DataAccessException: SQL [insert into `project_member` (`name`, `account_id`, `kind`, `uuid`, `state`, `created`, `data`, `external_id`, `project_id`, `external_id_type`, `role`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)]; Cannot add or update a child row: a foreign key constraint fails (`cattle`.`project_member`, CONSTRAINT `fk_project_member__account_id` FOREIGN KEY (`account_id`) REFERENCES `account` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Not able to add environment.

    GitHub | 12 months ago | sangeethah
    org.jooq.exception.DataAccessException: SQL [insert into `account` (`name`, `kind`, `uuid`, `description`, `state`, `created`, `data`) values (?, ?, ?, ?, ?, ?, ?)]; Column 'uuid' cannot be null
  6. 0

    Exception during DID registration from DID Provider

    GitHub | 2 years ago | gvagenas
    org.mariadb.jdbc.internal.common.QueryException: Column 'pure_sip' cannot be null

    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. org.mariadb.jdbc.internal.common.QueryException

      Column 'DEPLOYMENT_ID' cannot be null

      at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult()
    2. mariadb-java-client
      MySQLPreparedStatement.executeUpdate
      1. org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:969)[mariadb-java-client-1.2.3.jar!/:na]
      2. org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1021)[mariadb-java-client-1.2.3.jar!/:na]
      3. org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1003)[mariadb-java-client-1.2.3.jar!/:na]
      4. org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:271)[mariadb-java-client-1.2.3.jar!/:na]
      5. org.mariadb.jdbc.MySQLStatement.executeUpdate(MySQLStatement.java:348)[mariadb-java-client-1.2.3.jar!/:na]
      6. org.mariadb.jdbc.MySQLPreparedStatement.executeUpdate(MySQLPreparedStatement.java:143)[mariadb-java-client-1.2.3.jar!/:na]
      6 frames
    3. Spring Framework
      JdbcTemplate.update
      1. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:873)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:866)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:866)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:927)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      6. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:932)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      6 frames
    4. org.springframework.cloud
      RdbmsDeploymentIdRepository$$FastClassBySpringCGLIB$$4b66fd71.invoke
      1. org.springframework.cloud.dataflow.server.repository.RdbmsDeploymentIdRepository.save(RdbmsDeploymentIdRepository.java:47)[spring-cloud-dataflow-server-core-1.0.0.BUILD-SNAPSHOT.jar!/:1.0.0.BUILD-SNAPSHOT]
      2. org.springframework.cloud.dataflow.server.repository.RdbmsDeploymentIdRepository$$FastClassBySpringCGLIB$$4b66fd71.invoke(<generated>)[spring-cloud-dataflow-server-core-1.0.0.BUILD-SNAPSHOT.jar!/:1.0.0.BUILD-SNAPSHOT]
      2 frames
    5. Spring Core
      MethodProxy.invoke
      1. org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204)[spring-core-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      1 frame
    6. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:720)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    7. Spring Tx
      PersistenceExceptionTranslationInterceptor.invoke
      1. org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:136)[spring-tx-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      1 frame
    8. Spring AOP
      CglibAopProxy$DynamicAdvisedInterceptor.intercept
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:655)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    9. org.springframework.cloud
      TaskDeploymentController.deploy
      1. org.springframework.cloud.dataflow.server.repository.RdbmsDeploymentIdRepository$$EnhancerBySpringCGLIB$$bb8c0477.save(<generated>)[spring-cloud-dataflow-server-core-1.0.0.BUILD-SNAPSHOT.jar!/:1.0.0.BUILD-SNAPSHOT]
      2. org.springframework.cloud.dataflow.server.service.impl.DefaultTaskService.executeTask(DefaultTaskService.java:164)[spring-cloud-dataflow-server-core-1.0.0.BUILD-SNAPSHOT.jar!/:1.0.0.BUILD-SNAPSHOT]
      3. org.springframework.cloud.dataflow.server.controller.TaskDeploymentController.deploy(TaskDeploymentController.java:74)[spring-cloud-dataflow-server-core-1.0.0.BUILD-SNAPSHOT.jar!/:1.0.0.BUILD-SNAPSHOT]
      3 frames
    10. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_40]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_40]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_40]
      4. java.lang.reflect.Method.invoke(Method.java:497)[na:1.8.0_40]
      4 frames
    11. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:221)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    12. Spring MVC
      FrameworkServlet.doPost
      1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:110)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:832)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:743)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:961)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:895)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:967)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:869)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      8 frames
    13. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      1 frame
    14. Spring MVC
      FrameworkServlet.service
      1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:843)[spring-webmvc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      1 frame
    15. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      1 frame
    16. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    17. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)[tomcat-embed-websocket-8.0.33.jar!/:8.0.33]
      1 frame
    18. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    19. Spring Boot Actuator
      EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal
      1. org.springframework.boot.actuate.autoconfigure.EndpointWebMvcAutoConfiguration$ApplicationContextHeaderFilter.doFilterInternal(EndpointWebMvcAutoConfiguration.java:261)[spring-boot-actuator-1.3.5.RELEASE.jar!/:1.3.5.RELEASE]
      1 frame
    20. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      1 frame
    21. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    22. Spring Boot Actuator
      WebRequestTraceFilter.doFilterInternal
      1. org.springframework.boot.actuate.trace.WebRequestTraceFilter.doFilterInternal(WebRequestTraceFilter.java:115)[spring-boot-actuator-1.3.5.RELEASE.jar!/:1.3.5.RELEASE]
      1 frame
    23. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      1 frame
    24. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    25. Spring Security
      FilterChainProxy.doFilter
      1. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:207)[spring-security-web-4.0.4.RELEASE.jar!/:4.0.4.RELEASE]
      2. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:176)[spring-security-web-4.0.4.RELEASE.jar!/:4.0.4.RELEASE]
      2 frames
    26. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    27. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    28. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    29. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    30. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:87)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    31. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    32. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:77)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    33. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    34. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:121)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      2 frames
    35. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2 frames
    36. Spring Boot Actuator
      MetricsFilter.doFilterInternal
      1. org.springframework.boot.actuate.autoconfigure.MetricsFilter.doFilterInternal(MetricsFilter.java:103)[spring-boot-actuator-1.3.5.RELEASE.jar!/:1.3.5.RELEASE]
      1 frame
    37. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
      1 frame
    38. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:106)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:502)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:522)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      9 frames
    39. Grizzly HTTP
      NioEndpoint$SocketProcessor.run
      1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1095)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:672)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      3. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1502)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.run(NioEndpoint.java:1458)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      4 frames
    40. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_40]
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_40]
      2 frames
    41. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)[tomcat-embed-core-8.0.33.jar!/:8.0.33]
      1 frame
    42. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)[na:1.8.0_40]
      1 frame