[AS7-5420] Intermittent Testsuite: CMP Commerce Tests - Red Hat Issue Tracker

Type: Bug
Resolution: Done
Priority: Major
Fix Version/s: EAP 6.1.0.Alpha (7.2.0.Final), 7.1.4.Final (EAP)
Affects Version/s: 7.1.2.Final (EAP)
Component/s: Test Suite
Labels:
None

Git Pull Request:
https://github.com/jbossas/jboss-as/pull/2972

More CMP tests which fail sometimes, again this is due to an H2 behavior where dropping a table (done by a CMP module processor on undeploy) may be incomplete when a new deploy starts, and needs same tables.

In concrete, the deploy code will not find the table(s) on the DB metadata, tries to create and this fails.

Test:
 
org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderByQueryTestCase.org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderByQueryTestCase

Error Message:

Cannot deploy: cmp-commerce.jar

Stacktrace:

org.jboss.arquillian.container.spi.client.container.DeploymentException: Cannot deploy: cmp-commerce.jar
	at org.jboss.as.arquillian.container.ArchiveDeployer.deployInternal(ArchiveDeployer.java:83)
	at org.jboss.as.arquillian.container.ArchiveDeployer.deployInternal(ArchiveDeployer.java:64)
	at org.jboss.as.arquillian.container.ArchiveDeployer.deploy(ArchiveDeployer.java:46)
	at org.jboss.as.arquillian.container.CommonDeployableContainer.deploy(CommonDeployableContainer.java:145)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController$3.call(ContainerDeployController.java:161)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController$3.call(ContainerDeployController.java:128)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.executeOperation(ContainerDeployController.java:271)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.deploy(ContainerDeployController.java:127)
	at sun.reflect.GeneratedMethodAccessor28.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:99)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:81)
	at org.jboss.arquillian.container.impl.client.container.DeploymentExceptionHandler.verifyExpectedExceptionDuringDeploy(DeploymentExceptionHandler.java:50)
	at sun.reflect.GeneratedMethodAccessor27.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:88)
	at org.jboss.arquillian.container.impl.client.ContainerDeploymentContextHandler.createDeploymentContext(ContainerDeploymentContextHandler.java:78)
	at sun.reflect.GeneratedMethodAccessor14.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:88)
	at org.jboss.arquillian.container.impl.client.ContainerDeploymentContextHandler.createContainerContext(ContainerDeploymentContextHandler.java:57)
	at sun.reflect.GeneratedMethodAccessor13.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:88)
	at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:135)
	at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:115)
	at org.jboss.arquillian.core.impl.EventImpl.fire(EventImpl.java:67)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController$1.perform(ContainerDeployController.java:95)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController$1.perform(ContainerDeployController.java:80)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.forEachDeployment(ContainerDeployController.java:263)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.forEachManagedDeployment(ContainerDeployController.java:239)
	at org.jboss.arquillian.container.impl.client.container.ContainerDeployController.deployManaged(ContainerDeployController.java:79)
	at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:99)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:81)
	at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:135)
	at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:115)
	at org.jboss.arquillian.core.impl.EventImpl.fire(EventImpl.java:67)
	at org.jboss.arquillian.container.test.impl.client.ContainerEventController.execute(ContainerEventController.java:101)
	at sun.reflect.GeneratedMethodAccessor16.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.invokeObservers(EventContextImpl.java:99)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:81)
	at org.jboss.arquillian.test.impl.TestContextHandler.createClassContext(TestContextHandler.java:75)
	at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:88)
	at org.jboss.arquillian.test.impl.TestContextHandler.createSuiteContext(TestContextHandler.java:60)
	at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.jboss.arquillian.core.impl.ObserverImpl.invoke(ObserverImpl.java:90)
	at org.jboss.arquillian.core.impl.EventContextImpl.proceed(EventContextImpl.java:88)
	at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:135)
	at org.jboss.arquillian.core.impl.ManagerImpl.fire(ManagerImpl.java:115)
	at org.jboss.arquillian.test.impl.EventTestRunnerAdaptor.beforeClass(EventTestRunnerAdaptor.java:80)
	at org.jboss.arquillian.junit.Arquillian$2.evaluate(Arquillian.java:182)
	at org.jboss.arquillian.junit.Arquillian.multiExecute(Arquillian.java:314)
	at org.jboss.arquillian.junit.Arquillian.access$100(Arquillian.java:46)
	at org.jboss.arquillian.junit.Arquillian$3.evaluate(Arquillian.java:199)
	at org.junit.runners.ParentRunner.run(ParentRunner.java:300)
	at org.jboss.arquillian.junit.Arquillian.run(Arquillian.java:147)
	at org.jboss.as.test.integration.ejb.entity.cmp.CmpTestRunner.run(CmpTestRunner.java:71)
	at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:234)
	at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:133)
	at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:114)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:188)
	at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:166)
	at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:86)
	at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:101)
	at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:74)
Caused by: java.lang.Exception: {
    "JBAS014671: Failed services" => {"jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.jdbc.store-manager.START" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.jdbc.store-manager.START: JBAS010785: Failed start store manager
    Caused by: java.lang.RuntimeException: JBAS010765: Error while creating table: CUSTOMER_ADDRESS
    Caused by: org.h2.jdbc.JdbcSQLException: Table \"CUSTOMER_ADDRESS\" already exists; SQL statement:
CREATE TABLE CUSTOMER_ADDRESS (CUSTOMER BIGINT NOT NULL, ADDRESS BIGINT NOT NULL, CONSTRAINT PK_CUSTOMER_ADDRESS PRIMARY KEY (CUSTOMER, ADDRESS)) [42101-168]"},
    "JBAS014771: Services with missing/unavailable dependencies" => [
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.OrderEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.LineItemEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryBatchDeleteEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.UserEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeBatchDeleteEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryBatchDeleteEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".jdbc.store-manager.fk-barrier Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.UserEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.AddressEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.OrderEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.LineItemEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.AddressEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductEJB.START Missing[JBAS014861: <one or more transitive dependencies>]",
        "jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeBatchDeleteEJB.START Missing[JBAS014861: <one or more transitive dependencies>]"
    ]
}
	at org.jboss.as.controller.client.helpers.standalone.impl.ServerDeploymentPlanResultFuture.getActionResult(ServerDeploymentPlanResultFuture.java:134)
	at org.jboss.as.controller.client.helpers.standalone.impl.ServerDeploymentPlanResultFuture.getResultFromNode(ServerDeploymentPlanResultFuture.java:123)
	at org.jboss.as.controller.client.helpers.standalone.impl.ServerDeploymentPlanResultFuture.get(ServerDeploymentPlanResultFuture.java:85)
	at org.jboss.as.controller.client.helpers.standalone.impl.ServerDeploymentPlanResultFuture.get(ServerDeploymentPlanResultFuture.java:42)
	at org.jboss.as.controller.client.helpers.standalone.ServerDeploymentHelper.deploy(ServerDeploymentHelper.java:52)
	at org.jboss.as.arquillian.container.ArchiveDeployer.deployInternal(ArchiveDeployer.java:77)
	... 89 more
Standard Output

&#27;[0m16:08:50,245 INFO  [TableCleaner] (MSC service thread 1-5) NUKING!
&#27;[0m&#27;[0m16:08:50,247 INFO  [TableCleaner] (MSC service thread 1-5) NUKE SUCCESS!
&#27;[0m&#27;[0m16:08:50,251 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-5) JBAS015877: Stopped deployment cmp-commerce.jar in 34ms
&#27;[0m&#27;[0m16:08:50,262 INFO  [org.jboss.as.repository] (management-handler-thread - 2) JBAS014901: Content removed from location /home/jenkins/jenkins-work/workspace/as7-master-testsuite-ip6/testsuite/integration/basic/target/jbossas/standalone/data/content/a0/a4448ba0597eeeaa09d5531bf5ced59cd03c30/content
&#27;[0m&#27;[0m16:08:50,262 INFO  [org.jboss.as.server] (management-handler-thread - 2) JBAS018558: Undeployed "cmp-commerce.jar"
&#27;[0m&#27;[0m16:08:50,675 INFO  [org.jboss.as.repository] (management-handler-thread - 3) JBAS014900: Content added at location /home/jenkins/jenkins-work/workspace/as7-master-testsuite-ip6/testsuite/integration/basic/target/jbossas/standalone/data/content/6c/af1de7c5c33fd03ec78939a852af00ad256e2e/content
&#27;[0m&#27;[0m16:08:50,678 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015876: Starting deployment of "cmp-commerce.jar"
&#27;[0m&#27;[0m16:08:50,731 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named LineItemEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/LineItemEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.LineItemHome
	java:app/cmp-commerce/LineItemEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.LineItemHome
	java:module/LineItemEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.LineItemHome
	java:global/cmp-commerce/LineItemEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.LineItem
	java:app/cmp-commerce/LineItemEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.LineItem
	java:module/LineItemEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.LineItem

&#27;[0m&#27;[0m16:08:50,732 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named TransactionWrappingSessionBean in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/TransactionWrappingSessionBean!org.jboss.as.test.integration.ejb.entity.cmp.TransactionWrappingSessionBean
	java:app/cmp-commerce/TransactionWrappingSessionBean!org.jboss.as.test.integration.ejb.entity.cmp.TransactionWrappingSessionBean
	java:module/TransactionWrappingSessionBean!org.jboss.as.test.integration.ejb.entity.cmp.TransactionWrappingSessionBean
	java:global/cmp-commerce/TransactionWrappingSessionBean
	java:app/cmp-commerce/TransactionWrappingSessionBean
	java:module/TransactionWrappingSessionBean

&#27;[0m&#27;[0m16:08:50,733 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named TxTesterBean in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/TxTesterBean!org.jboss.as.test.integration.ejb.entity.cmp.commerce.TxTester
	java:app/cmp-commerce/TxTesterBean!org.jboss.as.test.integration.ejb.entity.cmp.commerce.TxTester
	java:module/TxTesterBean!org.jboss.as.test.integration.ejb.entity.cmp.commerce.TxTester
	java:global/cmp-commerce/TxTesterBean
	java:app/cmp-commerce/TxTesterBean
	java:module/TxTesterBean

&#27;[0m&#27;[0m16:08:50,734 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named CustomerEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Customer
	java:app/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Customer
	java:module/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Customer
	java:jboss/exported/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Customer
	java:global/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerLocal
	java:app/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerLocal
	java:module/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerLocal
	java:global/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerHome
	java:app/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerHome
	java:module/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerHome
	java:jboss/exported/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerHome
	java:global/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerLocalHome
	java:app/cmp-commerce/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerLocalHome
	java:module/CustomerEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.CustomerLocalHome

&#27;[0m&#27;[0m16:08:50,736 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named AddressEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/AddressEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.AddressHome
	java:app/cmp-commerce/AddressEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.AddressHome
	java:module/AddressEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.AddressHome
	java:global/cmp-commerce/AddressEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Address
	java:app/cmp-commerce/AddressEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Address
	java:module/AddressEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Address

&#27;[0m&#27;[0m16:08:50,736 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named ProductCategoryTypeEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/ProductCategoryTypeEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryTypeHome
	java:app/cmp-commerce/ProductCategoryTypeEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryTypeHome
	java:module/ProductCategoryTypeEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryTypeHome
	java:global/cmp-commerce/ProductCategoryTypeEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryType
	java:app/cmp-commerce/ProductCategoryTypeEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryType
	java:module/ProductCategoryTypeEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryType

&#27;[0m&#27;[0m16:08:50,737 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named ProductCategoryBatchDeleteEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/ProductCategoryBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategory
	java:app/cmp-commerce/ProductCategoryBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategory
	java:module/ProductCategoryBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategory
	java:global/cmp-commerce/ProductCategoryBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryHome
	java:app/cmp-commerce/ProductCategoryBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryHome
	java:module/ProductCategoryBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryHome

&#27;[0m&#27;[0m16:08:50,738 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named ProductCategoryEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/ProductCategoryEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategory
	java:app/cmp-commerce/ProductCategoryEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategory
	java:module/ProductCategoryEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategory
	java:global/cmp-commerce/ProductCategoryEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryHome
	java:app/cmp-commerce/ProductCategoryEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryHome
	java:module/ProductCategoryEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryHome

&#27;[0m&#27;[0m16:08:50,739 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named ProductCategoryTypeBatchDeleteEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/ProductCategoryTypeBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryType
	java:app/cmp-commerce/ProductCategoryTypeBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryType
	java:module/ProductCategoryTypeBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryType
	java:global/cmp-commerce/ProductCategoryTypeBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryTypeHome
	java:app/cmp-commerce/ProductCategoryTypeBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryTypeHome
	java:module/ProductCategoryTypeBatchDeleteEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductCategoryTypeHome

&#27;[0m&#27;[0m16:08:50,740 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named UserEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocalHome
	java:app/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocalHome
	java:module/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocalHome
	java:global/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserHome
	java:app/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserHome
	java:module/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserHome
	java:jboss/exported/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserHome
	java:global/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocal
	java:app/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocal
	java:module/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocal
	java:global/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.User
	java:app/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.User
	java:module/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.User
	java:jboss/exported/cmp-commerce/UserEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.User

&#27;[0m&#27;[0m16:08:50,742 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named OrderEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/OrderEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Order
	java:app/cmp-commerce/OrderEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Order
	java:module/OrderEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Order
	java:global/cmp-commerce/OrderEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderHome
	java:app/cmp-commerce/OrderEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderHome
	java:module/OrderEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderHome

&#27;[0m&#27;[0m16:08:50,743 INFO  [org.jboss.as.ejb3.deployment.processors.EjbJndiBindingsDeploymentUnitProcessor] (MSC service thread 1-2) JNDI bindings for session bean named ProductEJB in deployment unit deployment "cmp-commerce.jar" are as follows:

	java:global/cmp-commerce/ProductEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Product
	java:app/cmp-commerce/ProductEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Product
	java:module/ProductEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.Product
	java:global/cmp-commerce/ProductEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductHome
	java:app/cmp-commerce/ProductEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductHome
	java:module/ProductEJB!org.jboss.as.test.integration.ejb.entity.cmp.commerce.ProductHome

&#27;[0m&#27;[0m16:08:50,769 INFO  [TableCleaner] (MSC service thread 1-5) Activating cleaner for deployment: cmp-commerce.jar
&#27;[0m&#27;[0m16:08:50,888 INFO  [org.jboss.as.arquillian] (MSC service thread 1-1) Arquillian deployment detected: ArquillianConfig[service=jboss.arquillian.config."cmp-commerce.jar",unit=cmp-commerce.jar,tests=[org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToManyBiTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.OrderByQueryTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.TxTesterTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceCascadeDeleteTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.LazyResultSetLoadingTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.ManyToOneUniTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.UserLocalTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.ManyToManyBiTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.CommerceTestCase, org.jboss.as.test.integration.ejb.entity.cmp.commerce.OneToOneUnitTestCase]]
&#27;[0m&#27;[0m16:08:50,916 INFO  [org.jboss.osgi.framework] (MSC service thread 1-2) JBOSGI011006: OSGi Framework - 2.0.0.CR15
&#27;[0m&#27;[31m16:08:50,945 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-5) MSC00001: Failed to start service jboss.deployment.unit."cmp-commerce.jar".component.CustomerEJB.jdbc.store-manager.START: org.jboss.msc.service.StartException in service jboss.deployment.unit."cmp-commerce.jar".component.CustomerEJB.jdbc.store-manager.START: JBAS010785: Failed start store manager
	at org.jboss.as.cmp.jdbc.JdbcStoreManagerStartService.start(JdbcStoreManagerStartService.java:46)
	at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1811) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
	at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1746) [jboss-msc-1.0.2.GA.jar:1.0.2.GA]
	at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) [rt.jar:1.6.0_29]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) [rt.jar:1.6.0_29]
	at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_29]
Caused by: java.lang.RuntimeException: JBAS010765: Error while creating table: CUSTOMER_ADDRESS
	at org.jboss.as.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:447)
	at org.jboss.as.cmp.jdbc.JDBCStartCommand.execute(JDBCStartCommand.java:262)
	at org.jboss.as.cmp.jdbc.JDBCStoreManager.startStoreManager(JDBCStoreManager.java:234)
	at org.jboss.as.cmp.jdbc.JdbcStoreManagerStartService.start(JdbcStoreManagerStartService.java:44)
	... 5 more
Caused by: org.h2.jdbc.JdbcSQLException: Table "CUSTOMER_ADDRESS" already exists; SQL statement:
CREATE TABLE CUSTOMER_ADDRESS (CUSTOMER BIGINT NOT NULL, ADDRESS BIGINT NOT NULL, CONSTRAINT PK_CUSTOMER_ADDRESS PRIMARY KEY (CUSTOMER, ADDRESS)) [42101-168]
	at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
	at org.h2.message.DbException.get(DbException.java:169)
	at org.h2.message.DbException.get(DbException.java:146)
	at org.h2.command.ddl.CreateTable.update(CreateTable.java:108)
	at org.h2.command.CommandContainer.update(CommandContainer.java:75)
	at org.h2.command.Command.executeUpdate(Command.java:230)
	at org.h2.jdbc.JdbcStatement.executeUpdateInternal(JdbcStatement.java:125)
	at org.h2.jdbc.JdbcStatement.executeUpdate(JdbcStatement.java:110)
	at org.jboss.jca.adapters.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:375)
	at org.jboss.as.cmp.jdbc.JDBCStartCommand.createTable(JDBCStartCommand.java:439)
	... 8 more

&#27;[0m&#27;[0m16:08:51,198 INFO  [org.jboss.as.server] (management-handler-thread - 3) JBAS015870: Deploy of deployment "cmp-commerce.jar" was rolled back with failure message {"JBAS014671: Failed services" => {"jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.jdbc.store-manager.START" => "org.jboss.msc.service.StartException in service jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.jdbc.store-manager.START: JBAS010785: Failed start store manager
    Caused by: java.lang.RuntimeException: JBAS010765: Error while creating table: CUSTOMER_ADDRESS
    Caused by: org.h2.jdbc.JdbcSQLException: Table \"CUSTOMER_ADDRESS\" already exists; SQL statement:
CREATE TABLE CUSTOMER_ADDRESS (CUSTOMER BIGINT NOT NULL, ADDRESS BIGINT NOT NULL, CONSTRAINT PK_CUSTOMER_ADDRESS PRIMARY KEY (CUSTOMER, ADDRESS)) [42101-168]"},"JBAS014771: Services with missing/unavailable dependencies" => ["jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.OrderEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.CustomerEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.LineItemEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryBatchDeleteEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.UserEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeBatchDeleteEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryBatchDeleteEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".jdbc.store-manager.fk-barrier Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.UserEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.AddressEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.OrderEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.LineItemEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.AddressEJB.jdbc.store-manager.FOREIGN_KEYS Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductEJB.START Missing[JBAS014861: <one or more transitive dependencies>]","jboss.deployment.unit.\"cmp-commerce.jar\".component.ProductCategoryTypeBatchDeleteEJB.START Missing[JBAS014861: <one or more transitive dependencies>]"]}
&#27;[0m&#27;[0m16:08:51,284 INFO  [TableCleaner] (MSC service thread 1-5) NUKING!
&#27;[0m&#27;[0m16:08:51,289 INFO  [TableCleaner] (MSC service thread 1-5) NUKE SUCCESS!
&#27;[0m&#27;[0m16:08:51,303 INFO  [org.jboss.as.server.deployment] (MSC service thread 1-6) JBAS015877: Stopped deployment cmp-commerce.jar in 133ms
&#27;[0m

relates to

AS7-5395 Intermittent Testsuite: CMP Relationship Tests

Resolved

Assignee:: Eduardo Martins

Reporter:: Eduardo Martins

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Created:: 2012/08/23 9:28 AM

Updated:: 2012/09/21 5:03 PM

Resolved:: 2012/08/31 12:40 PM

Details

Description

Attachments

Issue Links

Easy Agile Planning Poker

Activity

People

Dates

Hide