[ https://issues.apache.org/jira/browse/JUDDI-660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kurt T Stam updated JUDDI-660: ------------------------------ Fix Version/s: 3.2 Issue Type: Task (was: Bug) Summary: create profile for EAP 6.1.1 (was: Unable to view services when deploying juddi war to EAP 6.1.1) > create profile for EAP 6.1.1 > ---------------------------- > > Key: JUDDI-660 > URL: https://issues.apache.org/jira/browse/JUDDI-660 > Project: jUDDI > Issue Type: Task > Affects Versions: 3.1.3, 3.1.5 > Environment: RHEL 6.4, EAP 6.1.1, hibernate 4.1.4, mysql 14.14, > mysql-connector-java-5.1.6.jar > Reporter: Toufic Arabi > Assignee: Kurt T Stam > Fix For: 3.2 > > > Hello, > I am trying to get juddi 3.1.5 running on EAP 6.1.1. > I initially started with juddi 3.1.3, built the war from source and deployed > to EAP 6.0.1 with no errors, however I was not able to view juddiv3/services. > No error was being logged in juddi.log or EAP logs. > I moved to juddi 3.1.5 and EAP 6.1.1 and repeated the same build and deploy > process shown here: https://www.dropbox.com/sh/27uc13nhvcl3v7r/mkHa49RP6h > This link has the war and steps to deploy and configure for EAP 6.0.1 and > juddi 3.1.3 but my testing showed the same process is valid for EAP 6.1.1 and > juddi 3.1.5 > Deploying juddi 3.1.5 on EAP 6.1.1 shows this error: > [Server:server-one] 10:44:56,754 ERROR > [org.apache.juddi.servlets.RegistryServlet] (ServerService Thread Pool -- 67) > jUDDI registry could not be started.javax.persistence.PersistenceException: > org.hibernate.exception.ConstraintViolationException: Duplicate entry 'root' > for key 'PRIMARY': org.apache.commons.configuration.ConfigurationException: > javax.persistence.PersistenceException: > org.hibernate.exception.ConstraintViolationException: Duplicate entry 'root' > for key 'PRIMARY' > [Server:server-one] at > org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:136) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-two] 10:44:56,764 INFO [stdout] (ServerService Thread Pool -- > 64) Hibernate: insert into j3_category_bag values ( ) > [Server:server-one] at > org.apache.juddi.config.AppConfig.loadConfiguration(AppConfig.java:109) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.config.AppConfig.<init>(AppConfig.java:63) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.config.AppConfig.getInstance(AppConfig.java:197) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.config.AppConfig.getConfiguration(AppConfig.java:219) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.Registry.start(Registry.java:57) [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.servlets.RegistryServlet.init(RegistryServlet.java:46) > [classes:] > [Server:server-two] 10:44:56,764 INFO [stdout] (ServerService Thread Pool -- > 64) Hibernate: insert into j3_binding_category_bag (entity_key, id) values > (?, ?) > [Server:server-one] at > org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) > [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1] > [Server:server-one] at > org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) > [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1] > [Server:server-one] at > org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) > [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1] > [Server:server-one] at > org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) > [jbossweb-7.2.2.Final-redhat-1.jar:7.2.2.Final-redhat-1] > [Server:server-one] at > org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:156) > [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10] > [Server:server-one] at > org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:60) > [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10] > [Server:server-one] at > org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:93) > [jboss-as-web-7.2.1.Final-redhat-10.jar:7.2.1.Final-redhat-10] > [Server:server-one] at > java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) > [rt.jar:1.7.0_25] > [Server:server-one] at > java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334) > [rt.jar:1.7.0_25] > [Server:server-one] at > java.util.concurrent.FutureTask.run(FutureTask.java:166) [rt.jar:1.7.0_25] > [Server:server-one] at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) > [rt.jar:1.7.0_25] > [Server:server-one] at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) > [rt.jar:1.7.0_25] > [Server:server-one] at java.lang.Thread.run(Thread.java:724) > [rt.jar:1.7.0_25] > [Server:server-one] at > org.jboss.threads.JBossThread.run(JBossThread.java:122) > [Server:server-one] Caused by: javax.persistence.PersistenceException: > org.hibernate.exception.ConstraintViolationException: Duplicate entry 'root' > for key 'PRIMARY' > [Server:server-one] at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1377) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1300) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-two] 10:44:56,766 INFO [stdout] (ServerService Thread Pool -- > 64) Hibernate: insert into j3_keyed_reference (category_bag_id, key_name, > key_value, keyed_reference_group_id, tmodel_key_ref) values (?, ?, ?, ?, ?) > [Server:server-one] at > org.hibernate.ejb.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1306) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:871) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.apache.juddi.config.Install.installPublisherKeyGen(Install.java:496) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.config.Install.installRootPublisherKeyGen(Install.java:480) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.config.Install.install(Install.java:108) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] at > org.apache.juddi.config.AppConfig.getPersistentConfiguration(AppConfig.java:134) > [juddi-core-3.1.3.jar:3.1.3] > [Server:server-one] ... 20 more > [Server:server-one] Caused by: > org.hibernate.exception.ConstraintViolationException: Duplicate entry 'root' > for key 'PRIMARY' > [Server:server-one] at > org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:74) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:125) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:110) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:129) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.jdbc.internal.proxy.AbstractProxyHandler.invoke(AbstractProxyHandler.java:81) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at com.sun.proxy.$Proxy96.executeUpdate(Unknown > Source) > [Server:server-one] at > org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:56) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2859) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3300) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-two] 10:44:56,769 INFO [stdout] (ServerService Thread Pool -- > 64) Hibernate: insert into j3_service_descr (entity_key, descr, lang_code) > values (?, ?, ?) > [Server:server-one] at > org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:362) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:354) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.spi.ActionQueue.executeInserts(ActionQueue.java:261) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.spi.ActionQueue.addInsertAction(ActionQueue.java:178) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-two] 10:44:56,770 INFO [stdout] (ServerService Thread Pool -- > 64) Hibernate: insert into j3_service_name (entity_key, lang_code, name) > values (?, ?, ?) > [Server:server-one] at > org.hibernate.engine.spi.ActionQueue.addAction(ActionQueue.java:167) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.addInsertAction(AbstractSaveEventListener.java:320) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:287) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:126) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:835) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.internal.SessionImpl.persist(SessionImpl.java:828) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.spi.EJB3CascadingAction$1.cascade(EJB3CascadingAction.java:52) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeToOne(Cascade.java:380) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:323) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:208) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeCollectionElements(Cascade.java:409) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeCollection(Cascade.java:350) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeAssociation(Cascade.java:326) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascadeProperty(Cascade.java:208) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-two] 10:44:56,773 INFO [stdout] (ServerService Thread Pool -- > 64) Hibernate: insert into j3_discovery_url (entity_key, url, use_type) > values (?, ?, ?) > [Server:server-one] at > org.hibernate.engine.internal.Cascade.cascade(Cascade.java:165) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.cascadeAfterSave(AbstractSaveEventListener.java:448) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.performSaveOrReplicate(AbstractSaveEventListener.java:293) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.performSave(AbstractSaveEventListener.java:193) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:136) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.ejb.event.EJB3PersistEventListener.saveWithGeneratedId(EJB3PersistEventListener.java:78) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:208) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:151) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.event.internal.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:78) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.internal.SessionImpl.firePersist(SessionImpl.java:844) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.internal.SessionImpl.persist(SessionImpl.java:819) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.internal.SessionImpl.persist(SessionImpl.java:823) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] at > org.hibernate.ejb.AbstractEntityManagerImpl.persist(AbstractEntityManagerImpl.java:865) > [hibernate-entitymanager-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] ... 24 more > [Server:server-one] Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException: > Duplicate entry 'root' for key 'PRIMARY' > [Server:server-one] at > sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) > [rt.jar:1.7.0_25] > [Server:server-one] at > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) > [rt.jar:1.7.0_25] > [Server:server-one] at > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > [rt.jar:1.7.0_25] > [Server:server-one] at > java.lang.reflect.Constructor.newInstance(Constructor.java:526) > [rt.jar:1.7.0_25] > [Server:server-one] at > com.mysql.jdbc.Util.handleNewInstance(Util.java:406) > [Server:server-one] at com.mysql.jdbc.Util.getInstance(Util.java:381) > [Server:server-one] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) > [Server:server-one] at > com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) > [Server:server-one] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491) > [Server:server-one] at > com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423) > [Server:server-one] at > com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936) > [Server:server-one] at > com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060) > [Server:server-one] at > com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2542) > [Server:server-one] at > com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1734) > [Server:server-one] at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2019) > [Server:server-one] at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1937) > [Server:server-one] at > com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1922) > [Server:server-one] at > org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:493) > [Server:server-one] at > sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.7.0_25] > [Server:server-one] at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > [rt.jar:1.7.0_25] > [Server:server-one] at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > [rt.jar:1.7.0_25] > [Server:server-one] at > java.lang.reflect.Method.invoke(Method.java:606) [rt.jar:1.7.0_25] > [Server:server-one] at > org.hibernate.engine.jdbc.internal.proxy.AbstractStatementProxyHandler.continueInvocation(AbstractStatementProxyHandler.java:122) > [hibernate-core-4.1.4.Final.jar:4.1.4.Final] > [Server:server-one] ... 65 more -- This message was sent by Atlassian JIRA (v6.1#6144)