Bug 751001

Summary:	Hibernate Transaction rollback when pushing edited content spec
Product:	[Community] PressGang CCMS	Reporter:	Joshua Wulf <jwulf>
Component:	CSProcessor	Assignee:	Lee Newson <lnewson>
Status:	CLOSED CANTFIX	QA Contact:
Severity:	unspecified	Docs Contact:
Priority:	unspecified
Version:	1.x	CC:	jwulf, lcarlon
Target Milestone:	---
Target Release:	---
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	Bug Fix
Doc Text:		Story Points:	---
Clone Of:		Environment:
Last Closed:	2012-02-22 04:16:39 UTC	Type:	---
Regression:	---	Mount Type:	---
Documentation:	---	CRM:
Verified Versions:		Category:	---
oVirt Team:	---	RHEL 7.3 requirements from Atomic Host:
Cloudforms Team:	---	Target Upstream Version:
Embargoed:
Bug Depends On:
Bug Blocks:	751295

Description Joshua Wulf 2011-11-03 07:22:38 UTC

On the client: 


[jwulf@gaura Topic-based_authoring]$ skynet push -ce post-Writing_with_Topics.txt
Skynet client version: 12.0
Loading configuration from /home/jwulf/.config/skynet.ini
Web Service at http://localhost:8080/ version: 13.0

INFO:  The Content Specification is valid.
WARN:  Note: All descriptions, tags, source urls and writers will be ignored for existing Topics.
ERROR: Hibernate Transaction rollback.
INFO:  The Content Specification saved successfully.

Content Specification ID: 6
Revision: 34



On the server:

17:17:14,286 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Received Push Request
17:17:14,286 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Processing Push Request
17:17:14,289 INFO  [org.hibernate.jdbc.ConnectionManager] (http--0.0.0.0-8080-4) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
17:17:14,422 INFO  [com.redhat.contentspec.processor.ContentSpecProcessor] (http--0.0.0.0-8080-4) The Content Specification is valid.
17:17:14,422 WARN  [com.redhat.contentspec.processor.ContentSpecProcessor] (http--0.0.0.0-8080-4) Note: All descriptions, tags, source urls and writers will be ignored for existing Topics.
17:17:14,430 WARN  [org.hibernate.jdbc.AbstractBatcher] (http--0.0.0.0-8080-4) exception clearing maxRows/queryTimeout: java.sql.SQLException: Statement already closed
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) [mysql-connector-java-5.1.17-bin.jar:]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987) [mysql-connector-java-5.1.17-bin.jar:]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982) [mysql-connector-java-5.1.17-bin.jar:]
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927) [mysql-connector-java-5.1.17-bin.jar:]
	at com.mysql.jdbc.jdbc2.optional.StatementWrapper.getMaxRows(StatementWrapper.java:327) [mysql-connector-java-5.1.17-bin.jar:]
	at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.getMaxRows(CachedPreparedStatement.java:536)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.getMaxRows(WrappedStatement.java:524)
	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.Loader.getResultSet(Loader.java:1967) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.Loader.doQuery(Loader.java:802) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.Loader.doList(Loader.java:2533) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.Loader.list(Loader.java:2271) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [hibernate3.jar:3.6.7.Final]
	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890) [hibernate3.jar:3.6.7.Final]
	at com.redhat.contentspec.database.DBWriter.cleanExistingData(DBWriter.java:555) [classes:]
	at com.redhat.contentspec.processor.Scope.saveScope(Scope.java:179) [classes:]
	at com.redhat.contentspec.processor.ContentSpecProcessor.validateContentSpec(ContentSpecProcessor.java:188) [classes:]
	at com.redhat.contentspec.processor.ContentSpecProcessor.readFileData(ContentSpecProcessor.java:144) [classes:]
	at com.redhat.contentspec.service.WebService.push(WebService.java:114) [classes:]
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_21]
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [:1.6.0_21]
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [:1.6.0_21]
	at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_21]
	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.2.1.GA.jar:]
	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.2.1.GA.jar:]
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139) [jboss-as-web-7.0.1.Final.jar:7.0.1.Final]
	at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57) [jboss-as-web-7.0.1.Final.jar:7.0.1.Final]
	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49) [jboss-as-jpa-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952) [jbossweb-7.0.1.Final.jar:7.0.1.Final]
	at java.lang.Thread.run(Thread.java:619) [:1.6.0_21]

17:17:14,435 WARN  [org.hibernate.util.JDBCExceptionReporter] (http--0.0.0.0-8080-4) SQL Error: 0, SQLState: S1000
17:17:14,435 ERROR [org.hibernate.util.JDBCExceptionReporter] (http--0.0.0.0-8080-4) No operations allowed after statement closed
17:17:14,435 ERROR [com.redhat.contentspec.database.utils.TransactionHandler] (http--0.0.0.0-8080-4) Hibernate Transaction rollback.
17:17:14,583 ERROR [stderr] (http--0.0.0.0-8080-4) org.hibernate.exception.GenericJDBCException: could not execute query
17:17:14,583 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
17:17:14,583 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
17:17:14,583 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.doList(Loader.java:2536)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2276)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.list(Loader.java:2271)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:452)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1268)
17:17:14,584 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.database.DBWriter.cleanExistingData(DBWriter.java:555)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.processor.Scope.saveScope(Scope.java:179)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.processor.ContentSpecProcessor.validateContentSpec(ContentSpecProcessor.java:188)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.processor.ContentSpecProcessor.readFileData(ContentSpecProcessor.java:144)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.service.WebService.push(WebService.java:114)
17:17:14,585 ERROR [stderr] (http--0.0.0.0-8080-4) 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at java.lang.reflect.Method.invoke(Method.java:597)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
17:17:14,586 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
17:17:14,587 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
17:17:14,588 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) 	at java.lang.Thread.run(Thread.java:619)
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) Caused by: java.sql.SQLException: No operations allowed after statement closed
17:17:14,589 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:987)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:982)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.mysql.jdbc.jdbc2.optional.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:854)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:107)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:208)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.getResultSet(Loader.java:1953)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.doQuery(Loader.java:802)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:274)
17:17:14,590 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.loader.Loader.doList(Loader.java:2533)
17:17:14,591 ERROR [stderr] (http--0.0.0.0-8080-4) 	... 43 more
17:17:15,222 INFO  [com.redhat.contentspec.processor.ContentSpecProcessor] (http--0.0.0.0-8080-4) The Content Specification saved successfully.
17:17:15,224 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Processed Push Request
17:18:10,642 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Received Pull Request
17:18:10,645 INFO  [org.hibernate.jdbc.ConnectionManager] (http--0.0.0.0-8080-4) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
17:18:10,646 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Processed Pull Request
17:18:50,261 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Received Pull Request
17:18:50,263 INFO  [org.hibernate.jdbc.ConnectionManager] (http--0.0.0.0-8080-4) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
17:18:50,263 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Processed Pull Request
17:19:02,622 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Received Push Request
17:19:02,622 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Processing Push Request
17:19:02,625 INFO  [org.hibernate.jdbc.ConnectionManager] (http--0.0.0.0-8080-4) forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
17:19:02,774 INFO  [com.redhat.contentspec.processor.ContentSpecProcessor] (http--0.0.0.0-8080-4) The Content Specification is valid.
17:19:02,774 WARN  [com.redhat.contentspec.processor.ContentSpecProcessor] (http--0.0.0.0-8080-4) Note: All descriptions, tags, source urls and writers will be ignored for existing Topics.
17:19:02,781 ERROR [com.redhat.contentspec.database.utils.TransactionHandler] (http--0.0.0.0-8080-4) Hibernate Transaction rollback.
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) org.hibernate.NonUniqueResultException: query did not return a unique result: 2
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:899)
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:890)
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.database.DBWriter.cleanExistingData(DBWriter.java:555)
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.processor.Scope.saveScope(Scope.java:179)
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.processor.ContentSpecProcessor.validateContentSpec(ContentSpecProcessor.java:188)
17:19:02,909 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.processor.ContentSpecProcessor.readFileData(ContentSpecProcessor.java:144)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at com.redhat.contentspec.service.WebService.push(WebService.java:114)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at java.lang.reflect.Method.invoke(Method.java:597)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
17:19:02,910 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
17:19:02,911 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
17:19:02,912 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
17:19:02,913 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
17:19:02,913 ERROR [stderr] (http--0.0.0.0-8080-4) 	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
17:19:02,913 ERROR [stderr] (http--0.0.0.0-8080-4) 	at java.lang.Thread.run(Thread.java:619)
17:19:03,246 INFO  [com.redhat.contentspec.processor.ContentSpecProcessor] (http--0.0.0.0-8080-4) The Content Specification saved successfully.
17:19:03,250 INFO  [com.redhat.contentspec.service.WebService] (http--0.0.0.0-8080-4) Processed Push Request

Comment 1 Joshua Wulf 2011-11-04 10:25:49 UTC

Error pushing edited spec with 0.14.0:

I'm getting this pushing an edited content spec with build 14:


19:50:59,673 INFO  [com.redhat.contentspec.processor.ContentSpecProcessor]
(http--0.0.0.0-8080-3) The Content Specification is valid.
19:50:59,673 WARN  [com.redhat.contentspec.processor.ContentSpecProcessor]
(http--0.0.0.0-8080-3) Note: All descriptions, tags, source urls and writers
will be ignored for existing Topics.
19:50:59,939 WARN  [org.hibernate.util.JDBCExceptionReporter]
(http--0.0.0.0-8080-3) SQL Error: 1048, SQLState: 23000
19:50:59,939 ERROR [org.hibernate.util.JDBCExceptionReporter]
(http--0.0.0.0-8080-3) Column 'TypeID' cannot be null
19:50:59,940 WARN  [com.arjuna.ats.arjuna] (http--0.0.0.0-8080-3) ARJUNA12125:
TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple<
0:ffff7f000001:e6305da:4eb3aa9f:fc,
org.hibernate.transaction.synchronization.HibernateSynchronizationImpl@5cf18ff2
>: org.hibernate.exception.ConstraintViolationException: could not insert:
[com.redhat.contentspec.database.entity.ContentLevels_AUD]
 at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
[hibernate3.jar:3.6.7.Final]
 at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
[hibernate3.jar:3.6.7.Final]
 at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
[hibernate3.jar:3.6.7.Final]
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
[hibernate3.jar:3.6.7.Final]
 at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
[hibernate3.jar:3.6.7.Final]
 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.envers.synchronization.AuditProcess.doBeforeTransactionCompletion(AuditProcess.java:155)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.engine.ActionQueue$BeforeTransactionCompletionProcessQueue.beforeTransactionCompletion(ActionQueue.java:543)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.engine.ActionQueue.beforeTransactionCompletion(ActionQueue.java:216)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.impl.SessionImpl.beforeTransactionCompletion(SessionImpl.java:571)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.jdbc.JDBCContext.beforeTransactionCompletion(JDBCContext.java:250)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.transaction.synchronization.CallbackCoordinator.beforeCompletion(CallbackCoordinator.java:125)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.transaction.synchronization.HibernateSynchronizationImpl.beforeCompletion(HibernateSynchronizationImpl.java:51)
[hibernate3.jar:3.6.7.Final]
 at
com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:97)
 at
com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:274)
 at
com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:94)
 at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:159)
 at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1159)
 at
com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:119)
 at
com.redhat.contentspec.database.utils.TransactionHandler.forceCommitTransaction(TransactionHandler.java:113)
[classes:]
 at com.redhat.contentspec.processor.Scope.saveScope(Scope.java:231) [classes:]
 at
com.redhat.contentspec.processor.ContentSpecProcessor.validateContentSpec(ContentSpecProcessor.java:188)
[classes:]
 at
com.redhat.contentspec.processor.ContentSpecProcessor.readFileData(ContentSpecProcessor.java:144)
[classes:]
 at com.redhat.contentspec.service.WebService.push(WebService.java:120)
[classes:]
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [:1.6.0_21]
 at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[:1.6.0_21]
 at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[:1.6.0_21]
 at java.lang.reflect.Method.invoke(Method.java:597) [:1.6.0_21]
 at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
[resteasy-jaxrs-2.2.1.GA.jar:]
 at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
[jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]
 at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
[jboss-as-web-7.0.1.Final.jar:7.0.1.Final]
 at org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
[jboss-as-web-7.0.1.Final.jar:7.0.1.Final]
 at
org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49)
[jboss-as-jpa-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
[jbossweb-7.0.1.Final.jar:7.0.1.Final]
 at java.lang.Thread.run(Thread.java:619) [:1.6.0_21]
Caused by: java.sql.BatchUpdateException: Column 'TypeID' cannot be null
 at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
[mysql-connector-java-5.1.17-bin.jar:]
 at
com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeBatch(StatementWrapper.java:721)
[mysql-connector-java-5.1.17-bin.jar:]
 at
org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:708)
 at
org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1050)
 at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
[hibernate3.jar:3.6.7.Final]
 at org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:56)
[hibernate3.jar:3.6.7.Final]
 at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2434)
[hibernate3.jar:3.6.7.Final]
 ... 56 more
Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Column 'TypeID' cannot be null
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[:1.6.0_21]
 at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
[:1.6.0_21]
 at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
[:1.6.0_21]
 at java.lang.reflect.Constructor.newInstance(Constructor.java:513) [:1.6.0_21]
 at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.Util.getInstance(Util.java:386)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
[mysql-connector-java-5.1.17-bin.jar:]
 at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
[mysql-connector-java-5.1.17-bin.jar:]
 at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
[mysql-connector-java-5.1.17-bin.jar:]
 at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976)
[mysql-connector-java-5.1.17-bin.jar:]
 ... 63 more

19:51:00,072 ERROR [com.redhat.contentspec.database.utils.TransactionHandler]
(http--0.0.0.0-8080-3) Hibernate Transaction rollback.
19:51:00,072 ERROR [stderr] (http--0.0.0.0-8080-3)
java.lang.IllegalStateException: BaseTransaction.rollback - no transaction!
19:51:00,073 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.rollback(BaseTransaction.java:132)
19:51:00,073 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.database.utils.TransactionHandler.rollbackTransaction(TransactionHandler.java:129)
19:51:00,073 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.processor.Scope.saveScope(Scope.java:233)
19:51:00,073 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.processor.ContentSpecProcessor.validateContentSpec(ContentSpecProcessor.java:188)
19:51:00,073 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.processor.ContentSpecProcessor.readFileData(ContentSpecProcessor.java:144)
19:51:00,073 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.service.WebService.push(WebService.java:120)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
java.lang.reflect.Method.invoke(Method.java:597)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
19:51:00,074 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
19:51:00,075 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
19:51:00,076 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
19:51:00,077 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
19:51:00,078 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
19:51:00,078 ERROR [stderr] (http--0.0.0.0-8080-3)  at
java.lang.Thread.run(Thread.java:619)
19:51:00,078 ERROR [com.redhat.contentspec.database.utils.TransactionHandler]
(http--0.0.0.0-8080-3) Hibernate Transaction rollback failed. Please contact a
system administrator.
19:51:00,078 ERROR [stderr] (http--0.0.0.0-8080-3)
javax.transaction.RollbackException: Could not commit transaction.
19:51:00,079 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1171)
19:51:00,079 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:119)
19:51:00,079 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.database.utils.TransactionHandler.forceCommitTransaction(TransactionHandler.java:113)
19:51:00,079 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.processor.Scope.saveScope(Scope.java:231)
19:51:00,079 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.processor.ContentSpecProcessor.validateContentSpec(ContentSpecProcessor.java:188)
19:51:00,080 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.processor.ContentSpecProcessor.readFileData(ContentSpecProcessor.java:144)
19:51:00,080 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.redhat.contentspec.service.WebService.push(WebService.java:120)
19:51:00,080 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
19:51:00,080 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
19:51:00,080 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
19:51:00,080 ERROR [stderr] (http--0.0.0.0-8080-3)  at
java.lang.reflect.Method.invoke(Method.java:597)
19:51:00,081 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:140)
19:51:00,081 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:255)
19:51:00,081 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:220)
19:51:00,081 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:209)
19:51:00,081 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:519)
19:51:00,081 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:496)
19:51:00,082 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:119)
19:51:00,082 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208)
19:51:00,082 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55)
19:51:00,082 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50)
19:51:00,082 ERROR [stderr] (http--0.0.0.0-8080-3)  at
javax.servlet.http.HttpServlet.service(HttpServlet.java:847)
19:51:00,083 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329)
19:51:00,083 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248)
19:51:00,083 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275)
19:51:00,083 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161)
19:51:00,083 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:139)
19:51:00,084 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.as.web.NamingValve.invoke(NamingValve.java:57)
19:51:00,084 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:49)
19:51:00,084 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:154)
19:51:00,084 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
19:51:00,084 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
19:51:00,084 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:362)
19:51:00,085 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877)
19:51:00,085 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:667)
19:51:00,085 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:952)
19:51:00,085 ERROR [stderr] (http--0.0.0.0-8080-3)  at
java.lang.Thread.run(Thread.java:619)
19:51:00,085 ERROR [stderr] (http--0.0.0.0-8080-3) Caused by:
org.hibernate.exception.ConstraintViolationException: could not insert:
[com.redhat.contentspec.database.entity.ContentLevels_AUD]
19:51:00,085 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:96)
19:51:00,086 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
19:51:00,086 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2454)
19:51:00,086 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2874)
19:51:00,086 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:79)
19:51:00,086 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.engine.ActionQueue.execute(ActionQueue.java:273)
19:51:00,086 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:265)
19:51:00,087 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
19:51:00,087 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
19:51:00,087 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
19:51:00,087 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
19:51:00,087 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.envers.synchronization.AuditProcess.doBeforeTransactionCompletion(AuditProcess.java:155)
19:51:00,087 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.engine.ActionQueue$BeforeTransactionCompletionProcessQueue.beforeTransactionCompletion(ActionQueue.java:543)
19:51:00,088 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.engine.ActionQueue.beforeTransactionCompletion(ActionQueue.java:216)
19:51:00,088 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.impl.SessionImpl.beforeTransactionCompletion(SessionImpl.java:571)
19:51:00,088 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.jdbc.JDBCContext.beforeTransactionCompletion(JDBCContext.java:250)
19:51:00,088 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.transaction.synchronization.CallbackCoordinator.beforeCompletion(CallbackCoordinator.java:125)
19:51:00,088 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.transaction.synchronization.HibernateSynchronizationImpl.beforeCompletion(HibernateSynchronizationImpl.java:51)
19:51:00,088 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:97)
19:51:00,089 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:274)
19:51:00,089 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:94)
19:51:00,089 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:159)
19:51:00,089 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1159)
19:51:00,089 ERROR [stderr] (http--0.0.0.0-8080-3)  ... 36 more
19:51:00,089 ERROR [stderr] (http--0.0.0.0-8080-3) Caused by:
java.sql.BatchUpdateException: Column 'TypeID' cannot be null
19:51:00,090 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2024)
19:51:00,090 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1449)
19:51:00,090 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.jdbc2.optional.StatementWrapper.executeBatch(StatementWrapper.java:721)
19:51:00,090 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeBatch(CachedPreparedStatement.java:708)
19:51:00,090 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.jboss.jca.adapters.jdbc.WrappedStatement.executeBatch(WrappedStatement.java:1050)
19:51:00,090 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
19:51:00,091 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.jdbc.BatchingBatcher.addToBatch(BatchingBatcher.java:56)
19:51:00,091 ERROR [stderr] (http--0.0.0.0-8080-3)  at
org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2434)
19:51:00,091 ERROR [stderr] (http--0.0.0.0-8080-3)  ... 56 more
19:51:00,091 ERROR [stderr] (http--0.0.0.0-8080-3) Caused by:
com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
Column 'TypeID' cannot be null
19:51:00,091 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
19:51:00,091 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
19:51:00,092 ERROR [stderr] (http--0.0.0.0-8080-3)  at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
19:51:00,092 ERROR [stderr] (http--0.0.0.0-8080-3)  at
java.lang.reflect.Constructor.newInstance(Constructor.java:513)
19:51:00,092 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
19:51:00,092 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.Util.getInstance(Util.java:386)
19:51:00,092 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1039)
19:51:00,092 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
19:51:00,093 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
19:51:00,093 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
19:51:00,093 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
19:51:00,093 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2625)
19:51:00,093 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
19:51:00,093 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2415)
19:51:00,094 ERROR [stderr] (http--0.0.0.0-8080-3)  at
com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1976)
19:51:00,094 ERROR [stderr] (http--0.0.0.0-8080-3)  ... 63 more
19:51:00,094 ERROR [com.redhat.contentspec.processor.ContentSpecProcessor]
(http--0.0.0.0-8080-3) An error occurred when inserting into the database
please try again.
19:51:00,095 INFO  [com.redhat.contentspec.service.WebService]
(http--0.0.0.0-8080-3) Processed Push Request

Comment 2 Joshua Wulf 2011-11-04 10:25:57 UTC

*** Bug 750768 has been marked as a duplicate of this bug. ***

Comment 3 Lee Newson 2011-11-06 23:20:14 UTC

Not entirely sure the cause of this bug at this stage. However on part of it is that when an error occurred it continued and didn't fail. As such this ended up having faulty database records. As such I've found that issue and fixed it, so that now if the database cleaning does fail the processing will  be stopped.

Comment 4 Lee Newson 2011-11-07 00:38:24 UTC

Sorry for the horrible English in the last comment :(

Since this issue shouldn't cause any database errors now, due to the fix described above. I'm gonna move this to ON_QA. Josh if you feel this is wrong feel free to move it back to ASSIGNED.

Comment 5 Lee Newson 2011-11-07 05:17:45 UTC

Edit: moving this back to ASSIGNED until i find the root cause. Also going to move it to the "Release Tracker Unscheduled features" tracker

Comment 6 Lee Newson 2011-11-07 05:22:08 UTC

Just saw the error from build 0.14.0.

Josh use the SQL Query below. It should fix it.

ALTER TABLE  `ContentLevels_AUD` CHANGE  `TypeID`  `TypeID` INT( 11 ) NULL DEFAULT NULL;

Comment 7 Lee Newson 2012-02-22 04:16:39 UTC

Changing this to CANTFIX since the processor no longer uses databases there is no way for this error to occur or to be fixed.