Error on start JBoss AS 6.0 up
pepelara Jan 1, 2012 2:44 AMI have recently installed HSQLDB 2.2.6 and on JBoss 6.0.0.Final AS start up I see then following error,
08:25:44,000 WARN [DBUserEditorImpl] could not create user or role table
08:25:44,015 ERROR [STDERR] java.lang.RuntimeException: java.sql.SQLSyntaxErrorException: nombre del objeto ya existe: MAIL_USERS in statement [CREATE TABLE MAIL_USERS (USER_NAME VARCHAR(40) PRIMARY KEY, PASSWORD VARCHAR(40) NOT NULL)]
08:25:44,015 ERROR [STDERR] at org.buni.meldware.mail.usereditor.db.DBUserEditorImpl.executeStatement(DBUserEditorImpl.java:189)
08:25:44,015 ERROR [STDERR] at org.buni.meldware.mail.usereditor.db.DBUserEditorImpl.start(DBUserEditorImpl.java:156)
08:25:44,015 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
08:25:44,015 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
08:25:44,015 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
08:25:44,015 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:597)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:271)
08:25:44,015 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:670)
08:25:44,015 ERROR [STDERR] at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
08:25:44,015 ERROR [STDERR] at $Proxy41.start(Unknown Source)
08:25:44,015 ERROR [STDERR] at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:53)
08:25:44,015 ERROR [STDERR] at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:41)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379)
08:25:44,015 ERROR [STDERR] at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:301)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939)
08:25:44,015 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654)
08:25:44,015 ERROR [STDERR] at org.jboss.system.ServiceController.doChange(ServiceController.java:671)
08:25:44,031 ERROR [STDERR] at org.jboss.system.ServiceController.start(ServiceController.java:443)
08:25:44,031 ERROR [STDERR] at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:189)
08:25:44,031 ERROR [STDERR] at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:102)
08:25:44,031 ERROR [STDERR] at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:49)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:55)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:179)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1832)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1550)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1571)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1491)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployersImpl.change(DeployersImpl.java:1983)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:1076)
08:25:44,031 ERROR [STDERR] at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:679)
08:25:44,031 ERROR [STDERR] at org.jboss.system.server.profileservice.deployers.MainDeployerPlugin.process(MainDeployerPlugin.java:106)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileControllerContext$DelegateDeployer.process(ProfileControllerContext.java:143)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileDeployAction.deploy(ProfileDeployAction.java:151)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileDeployAction.installActionInternal(ProfileDeployAction.java:94)
08:25:44,031 ERROR [STDERR] at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:54)
08:25:44,031 ERROR [STDERR] at org.jboss.kernel.plugins.dependency.InstallsAwareAction.installAction(InstallsAwareAction.java:42)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:379)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:2044)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:1083)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.executeOrIncrementStateDirectly(AbstractController.java:1322)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1246)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1139)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:939)
08:25:44,031 ERROR [STDERR] at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:654)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileActivationWrapper$BasicProfileActivation.start(ProfileActivationWrapper.java:190)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileActivationWrapper.start(ProfileActivationWrapper.java:87)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileActivationService.activateProfile(ProfileActivationService.java:215)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.dependency.ProfileActivationService.activate(ProfileActivationService.java:159)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.bootstrap.AbstractProfileServiceBootstrap.activate(AbstractProfileServiceBootstrap.java:112)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.resolver.BasicResolverFactory$ProfileResolverFacade.deploy(BasicResolverFactory.java:87)
08:25:44,031 ERROR [STDERR] at org.jboss.profileservice.bootstrap.AbstractProfileServiceBootstrap.start(AbstractProfileServiceBootstrap.java:91)
08:25:44,031 ERROR [STDERR] at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:132)
08:25:44,031 ERROR [STDERR] at org.jboss.system.server.profileservice.bootstrap.BasicProfileServiceBootstrap.start(BasicProfileServiceBootstrap.java:56)
08:25:44,031 ERROR [STDERR] at org.jboss.bootstrap.impl.base.server.AbstractServer.startBootstraps(AbstractServer.java:827)
08:25:44,031 ERROR [STDERR] at org.jboss.bootstrap.impl.base.server.AbstractServer$StartServerTask.run(AbstractServer.java:417)
08:25:44,031 ERROR [STDERR] at java.lang.Thread.run(Thread.java:662)
08:25:44,031 ERROR [STDERR] Caused by: java.sql.SQLSyntaxErrorException: nombre del objeto ya existe: MAIL_USERS in statement [CREATE TABLE MAIL_USERS (USER_NAME VARCHAR(40) PRIMARY KEY, PASSWORD VARCHAR(40) NOT NULL)]
08:25:44,031 ERROR [STDERR] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.jdbc.JDBCPreparedStatement.execute(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.execute(CachedPreparedStatement.java:215)
08:25:44,031 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:299)
08:25:44,031 ERROR [STDERR] at org.buni.meldware.mail.usereditor.db.DBUserEditorImpl.executeStatement(DBUserEditorImpl.java:187)
08:25:44,031 ERROR [STDERR] ... 81 more
08:25:44,031 ERROR [STDERR] Caused by: org.hsqldb.HsqlException: nombre del objeto ya existe: MAIL_USERS
08:25:44,031 ERROR [STDERR] at org.hsqldb.error.Error.error(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.error.Error.error(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.SchemaObjectSet.checkAdd(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.SchemaManager.checkSchemaObjectNotExists(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.StatementSchema.setOrCheckObjectName(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.StatementSchema.getResult(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.StatementSchema.execute(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.Session.executeCompiledStatement(Unknown Source)
08:25:44,031 ERROR [STDERR] at org.hsqldb.Session.execute(Unknown Source)
08:25:44,031 ERROR [STDERR] ... 86 more
I have left the DefaultDS in hsqldb-ds.xml file as it is.
Which is the problem?
Thanks in advance,
Jose