org.hibernate.exception.ConstraintViolationException

If you like a tip written by other Samebug users, mark is as helpful! Marks help our algorithm provide you better solutions and also help other users.
tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: 9.4.1211

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

  • GitHub comment 1#39379176
    via GitHub by erensenelmis
    ,
  • Replacing records
    via by fschmidt,
  • When I tried to edit the text of a user added status (via workflow admin section) I must have edited the status text to be too long for the database as I got the following exception. {code} https://jira.globalrelay.net/secure/admin/workflows/EditStatus.jspa System Error A system error has occurred. Please try submitting this problem via the Support Request Page Otherwise, please create a support issue on our support system at http://support.atlassian.com with the following information: 1. a description of your problem 2. cut & paste the error and system information found below 3. attach the application server log file ( /opt/jira-enterprise-3.13-standalone/atlassian-jira.log ) Cause: org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Status][id,10008][description,][sequence,15][name,Build is Tested and Ready for Rollback Preparation and Deploy][iconurl,/images/icons/status_generic.gif] (SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))) Stack Trace: [hide] org.ofbiz.core.entity.GenericEntityException: while updating: [GenericEntity:Status][id,10008][description,][sequence,15][name,Build is Tested and Ready for Rollback Preparation and Deploy][iconurl,/images/icons/status_generic.gif] (SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))) at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:220) at org.ofbiz.core.entity.GenericDAO.customUpdate(GenericDAO.java:164) at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:157) at org.ofbiz.core.entity.GenericHelperDAO.store(GenericHelperDAO.java:207) at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1406) at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1386) at org.ofbiz.core.entity.GenericValue.store(GenericValue.java:81) at com.atlassian.jira.web.action.admin.constants.AbstractEditConstant.doExecute(AbstractEditConstant.java:53) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60)) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:375) at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:214) at org.ofbiz.core.entity.GenericDAO.customUpdate(GenericDAO.java:164) at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:157) at org.ofbiz.core.entity.GenericHelperDAO.store(GenericHelperDAO.java:207) at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1406) at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1386) at org.ofbiz.core.entity.GenericValue.store(GenericValue.java:81) at com.atlassian.jira.web.action.admin.constants.AbstractEditConstant.doExecute(AbstractEditConstant.java:53) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) org.postgresql.util.PSQLException: ERROR: value too long for type character varying(60) at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304) at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102) at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:373) at org.ofbiz.core.entity.GenericDAO.singleUpdate(GenericDAO.java:214) at org.ofbiz.core.entity.GenericDAO.customUpdate(GenericDAO.java:164) at org.ofbiz.core.entity.GenericDAO.update(GenericDAO.java:157) at org.ofbiz.core.entity.GenericHelperDAO.store(GenericHelperDAO.java:207) at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1406) at org.ofbiz.core.entity.GenericDelegator.store(GenericDelegator.java:1386) at org.ofbiz.core.entity.GenericValue.store(GenericValue.java:81) at com.atlassian.jira.web.action.admin.constants.AbstractEditConstant.doExecute(AbstractEditConstant.java:53) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:54) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:178) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:192) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:120) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:125) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.jira.web.filters.JIRAProfilingFilter.doFilter(JIRAProfilingFilter.java:16) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.web.filters.RequestCleanupFilter.doFilter(RequestCleanupFilter.java:50) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:350) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:71) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:33) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at com.atlassian.jira.appconsistency.db.DatabaseCompatibilityEnforcerFilter.doFilter(DatabaseCompatibilityEnforcerFilter.java:39) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:215) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:548) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:619) Referer URL: https://jira.globalrelay.net/secure/admin/workflows/EditStatus!default.jspa?id=10008 Build Information: Uptime : N/A Edition : Enterprise Version : 3.13 Build Number : 330 Atlassian Partner : null Installation Type : Standalone Server ID : AG8D-3RC5-JLSW-RSY4 Server Information: Application Server: Apache Tomcat/5.5.26 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/opt/jira-enterprise-3.13-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: /opt/jira-enterprise-3.13-standalone/atlassian-jira.log Memory Information: Total Memory: 227 MB Free Memory: 77 MB Used Memory: 150 MB Total PermGen Memory: 176 MB Free PermGen Memory: 72 MB Used PermGen Memory: 103 MB System Information: System Date : Wednesday, 04 Feb 2009 System Time : 23:20:50 Current Working Directory : /opt/jira-enterprise-3.13-standalone Java Version : 1.6.0_07 Java Vendor : Sun Microsystems Inc. JVM Version : 1.0 JVM Vendor : Sun Microsystems Inc. JVM Implementation Version : 10.0-b23 Java Runtime : Java(TM) SE Runtime Environment Java VM : Java HotSpot(TM) 64-Bit Server VM User Name : jira User Timezone : Etc/GMT User Locale : English (United States) System Encoding : UTF-8 Operating System : Linux 2.6.18-92.1.10.el5.centos.plus OS Architecture : amd64 Application Server Container : Database type : postgres72 Database JNDI address : java:comp/env/jdbc/JiraDS Database URL : Hidden Database version : 8.3.3 Database driver : PostgreSQL Native Driver PostgreSQL 8.3 JDBC4 with SSL (build 603) External user management : OFF Crowd integration : OFF JVM Input Arguments : -XX:MaxPermSize=128m -Xms128m -Xmx256m -Djava.awt.headless=true -Datlassian.standalone=JIRA -Dorg.apache.jasper.runtime.BodyContentImpl.LIMIT_BUFFER=true -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager -Djava.util.logging.config.file=/opt/jira-enterprise-3.13-standalone/conf/logging.properties -Djava.endorsed.dirs=/opt/jira-enterprise-3.13-standalone/common/endorsed -Dcatalina.base=/opt/jira-enterprise-3.13-standalone -Dcatalina.home=/opt/jira-enterprise-3.13-standalone -Djava.io.tmpdir=/opt/jira-enterprise-3.13-standalone/temp Language Info: Installed languages: Chinese (China) Chinese (Taiwan) Czech (Czech Republic) Danish (Denmark) Dutch (Belgium) English (UK) French (France) German (Germany) German (Switzerland) Hungarian (Hungary) Italian (Italy) Japanese (Japan) Norwegian (Norway) Polish (Poland) Portuguese (Brazil) Russian (Russia) Slovak (Slovakia) Spanish (Spain) Turkish (Turkey) Default language: English (United States) - System Default Request Information: - Request URL: https://jira.globalrelay.net/500page.jsp - Scheme: https - Server: jira.globalrelay.net - Port: 443 - URI: /500page.jsp - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: Request Attributes - javax.servlet.forward.request_uri : /secure/admin/workflows/EditStatus.jspa - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/admin/workflows/EditStatus.jspa - javax.servlet.forward.path_info : /500page.jsp - os_securityfilter_already_filtered : true - atlassian.core.seraph.original.url : /secure/admin/workflows/EditStatus.jspa - javax.servlet.error.servlet_name : action - javax.servlet.request.key_size : 128 - com.atlassian.gzipfilter.GzipFilter_already_filtered : true - loginfilter.already.filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@2aaa8061 - gzipMimeTypes : text/html,text/javascript,text/css,text/plain,application/x-javascript,application/javascript - javax.servlet.request.ssl_session : 498a154e22ee5aa49f593a753a32920aeb18c0b47a05f408ff98303b30f0ba01 - javax.servlet.error.message : - webwork.result : Value stack =========== =========== - javax.servlet.request.cipher_suite : TLS_DHE_RSA_WITH_AES_128_CBC_SHA - com.atlassian.jira.web.filters.RequestCleanupFilter_already_filtered : true - javax.servlet.error.request_uri : /secure/admin/workflows/EditStatus.jspa - jira.webwork.cleanup : false - javax.servlet.error.status_code : 500 - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - __sitemesh__filterapplied : true - javax.servlet.error.exception : javax.servlet.ServletException: while updating: [GenericEntity:Status][id,10008][description,][sequence,15][name,Build is Tested and Ready for Rollback Preparation and Deploy][iconurl,/images/icons/status_generic.gif] (SQL Exception while executing the following:UPDATE public.issuestatus SET SEQUENCE=?, pname=?, DESCRIPTION=?, ICONURL=? WHERE ID=? (ERROR: value too long for type character varying(60))) Request Logging 0 log statements generated by this request: Listeners - Issue Cache Listener (com.atlassian.jira.event.listeners.cache.IssueCacheListener) - Issue Index Listener (com.atlassian.jira.event.listeners.search.IssueIndexListener) - Mail Listener (com.atlassian.jira.event.listeners.mail.MailListener) Services - Backup Service (com.atlassian.jira.service.services.export.ExportService) - Delay: 720 minutes - USEZIP: Zip - DIR_NAME: /jira_backup - Mail Queue Service (com.atlassian.jira.service.services.mail.MailQueueService) - Delay: 1 minutes Plugins - Admin Menu Sections 1.0 - Plugin by Atlassian Software Systems - Enabled - Browse Project Operations Sections 1.0 - Plugin by Atlassian Software Systems - Enabled - Content Link Resolvers Plugin 1.0 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Custom Field Types & Searchers 1.0 - Plugin by Atlassian Software Systems - Enabled - FishEye Plugin 2.1 - Plugin by Atlassian Software Systems - Enabled - Issue Operations Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Issue Tab Panels Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Issue Views Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - JIRA Footer 1.0 - Plugin by Atlassian Software Systems - Enabled - Portlets Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Preset Filters Sections 1.0 - Plugin by Atlassian Software Systems - Enabled - Project Panels Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Project Role Actors Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - RPC JIRA Plugin 3.13 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Renderer Component Factories Plugin 1.0 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Renderer Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Reports Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Top Navigation Bar 1.0 - Plugin by Atlassian Software Systems - Enabled - User Format 1.0 - Plugin by Atlassian Software Systems - Enabled - User Navigation Bar Sections 1.0 - Plugin by Atlassian Software Systems - Enabled - User Profile Links 1.0 - Plugin by Atlassian Software Systems - Enabled - View Project Operations Sections 1.0 - Plugin by Atlassian Software Systems - Enabled - Web Resources Plugin 1.0 - Plugin by Atlassian Software Systems Pty Ltd - Enabled - Webwork Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Wiki Renderer Macros Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled - Workflow Plugin 1.0 - Plugin by Atlassian Software Systems - Enabled {code}
    via by Derek MacKie,
    • org.hibernate.exception.ConstraintViolationException: could not insert: [introducaohibernate01.Professor] at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:71) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2267) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660) at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at introducaohibernate01.ProfessorDAO.salvarProfessor(ProfessorDAO.java:20) at introducaohibernate01.Main.main(Main.java:42) Caused by: org.postgresql.util.PSQLException: ERRO: valor nulo na coluna "nome" viola a restrição não-nula at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1592) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1327) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:192) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:451) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:350) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:304) at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2250) ... 12 more

    Users with the same issue

    Unknown visitor1 times, last one,
    jokester
    2 times, last one,
    silex
    5 times, last one,
    Unknown visitor1 times, last one,
    Unknown visitor1 times, last one,
    92 more bugmates