Getting exception on JBoss-5.1.0.GA AS cluster even when no application is deployed on it: java.sql.SQLException: Table 'TIMERS' already exists
rupesh.bhadeshiya Jan 7, 2010 10:09 AMHi,
We are getting an exception when starting 2 JBoss-5.1.0.GA AS nodes in a cluster, even without deploying any application on it. We are stuck there, and really need help to come out of it and continue with deploying our ear on it successfully.
When we start first node (node-1), it creates several tables in the database. TIMERS table is one of them. When we start second node (node-2), it throws exception:
java.sql.SQLException: Table 'TIMERS' already exists
And hence server does not start properly.
This scenario is observed only in clustering and is observed even when we haven’t deployed any of our ear/war/jar application on it.
Same error also comes for table HILOSEQUENCES. For it we somehow managed it by setting attribute ‘CreateTable’ to ‘false’ in ‘jboss-service.xml’ in <JBOSS_HOME>\server\all\deploy\uuid-key-generator.sar\META-INF folder. We set it to false on node-2 once the table is created by JBoss which started on node-1, so it again does not go for firing ‘Create Table Query’ on node-2.
Actually this is also not proper way to do it, but we did not found any other way. Here also if you can help us then it will be very helpful to us.
But we did not found anything similar for TIMERS table.
Now if TIMERS table is required anyway then just like other JMS tables which are also created at JBoss server start and as JBoss ignores them ‘exception is ignored by JBoss for them’, similarly why same is not happening in case of ‘TIMERS’ table...?
Can anyone please help out here, we are badly stuck at it.
Below is the stack trace.
<code>
20:18:49,784 INFO [ServerImpl] Starting JBoss (Microcontainer)...
20:18:49,784 INFO [ServerImpl] Release ID: JBoss [The Oracle] 5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)
20:18:49,784 INFO [ServerImpl] Bootstrap URL: null
20:18:49,784 INFO [ServerImpl] Home Dir: C:\Java\App Servers\jboss-5.1.0.GA
20:18:49,784 INFO [ServerImpl] Home URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/
20:18:49,784 INFO [ServerImpl] Library URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/lib/
20:18:49,784 INFO [ServerImpl] Patch URL: null
20:18:49,784 INFO [ServerImpl] Common Base URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/common/
20:18:49,784 INFO [ServerImpl] Common Library URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/common/lib/
20:18:49,784 INFO [ServerImpl] Server Name: all
20:18:49,784 INFO [ServerImpl] Server Base Dir: C:\Java\App Servers\jboss-5.1.0.GA\server
20:18:49,784 INFO [ServerImpl] Server Base URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/server/
20:18:49,784 INFO [ServerImpl] Server Config URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/server/all/conf/
20:18:49,784 INFO [ServerImpl] Server Home Dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all
20:18:49,784 INFO [ServerImpl] Server Home URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/server/all/
20:18:49,784 INFO [ServerImpl] Server Data Dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all\data
20:18:49,784 INFO [ServerImpl] Server Library URL: file:/C:/Java/App%20Servers/jboss-5.1.0.GA/server/all/lib/
20:18:49,784 INFO [ServerImpl] Server Log Dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all\log
20:18:49,784 INFO [ServerImpl] Server Native Dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all\tmp\native
20:18:49,784 INFO [ServerImpl] Server Temp Dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all\tmp
20:18:49,784 INFO [ServerImpl] Server Temp Deploy Dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all\tmp\deploy
20:18:50,268 INFO [ServerImpl] Starting Microcontainer, bootstrapURL=file:/C:/Java/App%20Servers/jboss-5.1.0.GA/server/all/conf/bootstrap.xml
20:18:50,784 INFO [VFSCacheFactory] Initializing VFSCache [org.jboss.virtual.plugins.cache.CombinedVFSCache]
20:18:50,784 INFO [VFSCacheFactory] Using VFSCache [CombinedVFSCache[real-cache: null]]
20:18:51,065 INFO [CopyMechanism] VFS temp dir: C:\Java\App Servers\jboss-5.1.0.GA\server\all\tmp
20:18:51,065 INFO [ZipEntryContext] VFS force nested jars copy-mode is enabled.
20:18:52,315 INFO [ServerInfo] Java version: 1.5.0_12,Sun Microsystems Inc.
20:18:52,315 INFO [ServerInfo] Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_12-b04)
20:18:52,315 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_12-b04,Sun Microsystems Inc.
20:18:52,315 INFO [ServerInfo] OS-System: Windows XP 5.1,x86
20:18:52,315 INFO [ServerInfo] VM arguments: -Djboss.home=C:\Java\App Servers\jboss-5.1.0.GA -Djava.library.path=C:\Java\jdk1.5.0_12\bin -Djava.endorsed.dirs=C:\Java\App Servers\jboss-5.1.0.GA\lib\endorsed -Xms256m -Xmx640m -XX:MaxPermSize=256m -Djboss.messaging.ServerPeerID=2 -Djboss.service.binding.set=ports-default -agentlib:jdwp=transport=dt_socket,suspend=y,address=localhost:1683
20:18:52,378 INFO [JMXKernel] Legacy JMX core initialized
20:18:55,112 INFO [ProfileServiceBootstrap] Loading profile: ProfileKey@40578d[domain=default, server=default, name=all]
20:18:59,347 INFO [WebService] Using RMI server codebase: http://192.168.1.153:8083/
20:19:08,284 INFO [NativeServerConfig] JBoss Web Services - Stack Native Core
20:19:08,284 INFO [NativeServerConfig] 3.1.2.GA
20:19:09,378 INFO [AttributeCallbackItem] Owner callback not implemented.
20:19:25,972 INFO [orb] Property "jacorb.hashtable_class" is set to: java.util.Hashtable
20:19:26,003 INFO [singleton] created ORBSingleton
20:19:26,206 INFO [interceptors] InterceptorManager started with 2 Server Interceptors, 2 Client Interceptors and 4 IOR Interceptors
20:19:26,409 INFO [orb] ORB run
20:19:26,503 INFO [poa] oid:
72 6F 6F 74 root
object is activated
20:19:26,940 INFO [CorbaNamingService] CORBA Naming Started
20:19:31,519 INFO [JMXConnectorServerService] JMX Connector server: service:jmx:rmi://192.168.1.153/jndi/rmi://192.168.1.153:1090/jmxconnector
20:19:31,972 INFO [MailService] Mail Service bound to java:/MyMailSession
20:19:33,222 INFO [SnmpAgentService] SNMP agent going active
20:19:36,378 INFO [JChannel] JGroups version: 2.6.10.GA
20:19:36,909 INFO [test1cluster] Initializing partition test1cluster
---------------------------------------------------------
GMS: address is 192.168.1.153:1692 (cluster=test1cluster)
---------------------------------------------------------
20:19:37,097 INFO [test1cluster] Number of cluster members: 2
20:19:37,097 INFO [test1cluster] Other members: 1
20:19:37,159 INFO [PlatformMBeanServerRegistration] JBossCache MBeans were successfully registered to the platform mbean server.
20:19:37,175 INFO [JChannel] JGroups version: 2.6.10.GA
---------------------------------------------------------
GMS: address is 192.168.1.153:1692 (cluster=test1cluster-HAPartitionCache)
---------------------------------------------------------
20:19:37,316 INFO [RPCManagerImpl] Received new cluster view: [192.168.1.197:9595|7] [192.168.1.197:9595, 192.168.1.153:1692]
20:19:37,394 INFO [LegacyStateTransferIntegrator] Using version 4096
20:19:37,425 INFO [RPCManagerImpl] Cache local address is 192.168.1.153:1692
20:19:37,425 INFO [RPCManagerImpl] state was retrieved successfully (in 172 milliseconds)
20:19:37,441 INFO [ComponentRegistry] JBoss Cache version: JBossCache 'Cascabel' 3.1.0.GA
20:19:37,441 INFO [test1cluster] Fetching serviceState (will wait for 30000 milliseconds):
20:19:37,550 INFO [test1cluster] serviceState was retrieved successfully (in 109 milliseconds)
20:19:37,737 INFO [HANamingService] Started HAJNDI bootstrap; jnpPort=1100, backlog=50, bindAddress=/192.168.1.153
20:19:37,737 INFO [DetachedHANamingService$AutomaticDiscovery] Listening on /192.168.1.153:1102, group=239.255.100.101, HA-JNDI address=192.168.1.153:1100
20:19:39,472 INFO [UnifiedInvokerHA] Service name is jboss:service=invoker,type=unifiedha
20:19:40,956 WARN [JBossASSecurityMetadataStore] WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
20:19:40,987 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
20:19:41,316 WARN [AnnotationCreator] No ClassLoader provided, using TCCL: org.jboss.managed.api.annotation.ManagementComponent
20:19:41,456 INFO [TransactionManagerService] JBossTS Transaction Service (JTA version - tag:JBOSSTS_4_6_1_GA) - JBoss Inc.
20:19:41,456 INFO [TransactionManagerService] Setting up property manager MBean and JMX layer
20:19:41,909 INFO [TransactionManagerService] Initializing recovery manager
20:19:42,175 INFO [TransactionManagerService] Recovery manager configured
20:19:42,175 INFO [TransactionManagerService] Binding TransactionManager JNDI Reference
20:19:42,237 INFO [TransactionManagerService] Starting transaction recovery manager
20:19:43,378 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-192.168.1.153-8080
20:19:43,409 INFO [AjpProtocol] Initializing Coyote AJP/1.3 on ajp-192.168.1.153-8009
20:19:43,456 INFO [StandardService] Starting service jboss.web
20:19:43,456 INFO [StandardEngine] Starting Servlet Engine: JBoss Web/2.1.3.GA
20:19:43,566 INFO [Catalina] Server startup in 162 ms
20:19:43,597 INFO [TomcatDeployment] deploy, ctxPath=/juddi
20:19:44,472 INFO [RegistryServlet] Loading jUDDI configuration.
20:19:44,503 INFO [RegistryServlet] Resources loaded from: /WEB-INF/juddi.properties
20:19:44,503 INFO [RegistryServlet] Initializing jUDDI components.
20:19:45,566 INFO [TomcatDeployment] deploy, ctxPath=/jbossws
20:19:45,659 INFO [TomcatDeployment] deploy, ctxPath=/invoker
20:19:45,753 INFO [TomcatDeployment] deploy, ctxPath=/web-console
20:19:46,378 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Java/App Servers/jboss-5.1.0.GA/server/all/deploy/jboss-local-jdbc.rar/META-INF/ra.xml
20:19:46,425 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Java/App Servers/jboss-5.1.0.GA/server/all/deploy/jboss-xa-jdbc.rar/META-INF/ra.xml
20:19:46,456 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Java/App Servers/jboss-5.1.0.GA/server/all/deploy/jms-ra.rar/META-INF/ra.xml
20:19:46,503 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Java/App Servers/jboss-5.1.0.GA/server/all/deploy/mail-ra.rar/META-INF/ra.xml
20:19:46,581 INFO [RARDeployment] Required license terms exist, view vfszip:/C:/Java/App Servers/jboss-5.1.0.GA/server/all/deploy/quartz-ra.rar/META-INF/ra.xml
20:19:46,800 INFO [SimpleThreadPool] Job execution threads will use class loader of thread: main
20:19:46,894 INFO [QuartzScheduler] Quartz Scheduler v.1.5.2 created.
20:19:46,894 INFO [RAMJobStore] RAMJobStore initialized.
20:19:46,894 INFO [StdSchedulerFactory] Quartz scheduler 'DefaultQuartzScheduler' initialized from default resource file in Quartz package: 'quartz.properties'
20:19:46,894 INFO [StdSchedulerFactory] Quartz scheduler version: 1.5.2
20:19:46,894 INFO [QuartzScheduler] Scheduler DefaultQuartzScheduler_$_NON_CLUSTERED started.
20:19:47,331 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=MYDS' to JNDI name 'java:MYDS'
20:19:47,894 WARN [JDBCPersistenceManager]
JBoss Messaging Warning: DataSource connection transaction isolation should be READ_COMMITTED, but it is currently REPEATABLE_READ.
Using an isolation level less strict than READ_COMMITTED may lead to data consistency problems.
Using an isolation level more strict than READ_COMMITTED may lead to deadlock.
20:19:48,284 INFO [ServerPeer] JBoss Messaging 1.4.3.GA server [2] started
20:19:48,503 INFO [ConnectionFactoryJNDIMapper] supportsFailover attribute is true on connection factory: jboss.messaging.connectionfactory:service=ConnectionFactory but post office is non clustered. So connection factory will *not* support failover
20:19:48,503 INFO [ConnectionFactoryJNDIMapper] supportsLoadBalancing attribute is true on connection factory: jboss.messaging.connectionfactory:service=ConnectionFactory but post office is non clustered. So connection factory will *not* support load balancing
20:19:48,644 INFO [ConnectionFactory] Connector bisocket://192.168.1.153:4457 has leasing enabled, lease period 10000 milliseconds
20:19:48,644 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@13beecf started
20:19:48,644 INFO [ConnectionFactoryJNDIMapper] supportsFailover attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support failover
20:19:48,644 INFO [ConnectionFactoryJNDIMapper] supportsLoadBalancing attribute is true on connection factory: jboss.messaging.connectionfactory:service=ClusteredConnectionFactory but post office is non clustered. So connection factory will *not* support load balancing
20:19:48,644 INFO [ConnectionFactory] Connector bisocket://192.168.1.153:4457 has leasing enabled, lease period 10000 milliseconds
20:19:48,644 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@127e9e9 started
20:19:48,659 INFO [QueueService] Queue[/queue/MyQueue1] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,675 INFO [QueueService] Queue[/queue/MyQueue2] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,878 INFO [QueueService] Queue[/queue/MyQueue3] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,894 INFO [TopicService] Topic[/topic/MyTopic1] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,894 INFO [QueueService] Queue[/queue/MyQueue4] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,894 INFO [TopicService] Topic[/topic/MyTopic2] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,894 INFO [TopicService] Topic[/topic/MyTopic3] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,894 INFO [QueueService] Queue[/queue/MyQueue5] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,894 INFO [ConnectionFactory] Connector bisocket://192.168.1.153:4457 has leasing enabled, lease period 10000 milliseconds
20:19:48,894 INFO [ConnectionFactory] org.jboss.jms.server.connectionfactory.ConnectionFactory@6480d7 started
20:19:48,909 INFO [QueueService] Queue[/queue/MyQueue6] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,909 INFO [TopicService] Topic[/topic/MyTopic4] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,909 INFO [TopicService] Topic[/topic/MyTopic5] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,909 INFO [TopicService] Topic[/topic/MyTopic6] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,941 INFO [QueueService] Queue[/queue/MyQueue7] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,941 INFO [TopicService] Topic[/topic/MyTopic7] started, fullSize=200000, pageSize=2000, downCacheSize=2000
20:19:48,941 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
20:19:49,034 ERROR [AbstractKernelController] Error installing to Start: name=jboss.ejb:persistencePolicy=database,service=EJBTimerService state=Create mode=Manual requiredState=Installed
java.sql.SQLException: Table 'TIMERS' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
at org.jboss.resource.adapter.jdbc.WrappedStatement.executeUpdate(WrappedStatement.java:249)
at org.jboss.ejb.txtimer.GeneralPurposeDatabasePersistencePlugin.createTableIfNotExists(GeneralPurposeDatabasePersistencePlugin.java:175)
at org.jboss.ejb.txtimer.DatabasePersistencePolicy.startService(DatabasePersistencePolicy.java:104)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:322)
at sun.reflect.GeneratedMethodAccessor163.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:189)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:595)
20:19:49,206 INFO [TomcatDeployment] deploy, ctxPath=/admin-console
20:19:49,362 INFO [config] Initializing Mojarra (1.2_12-b01-FCS) for context '/admin-console'
20:19:56,613 INFO [TomcatDeployment] deploy, ctxPath=/jmx-console
20:19:56,988 ERROR [ProfileServiceBootstrap] Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):
DEPLOYMENTS MISSING DEPENDENCIES:
Deployment "jboss.ejb:service=EJBTimerService" is missing the following dependencies:
Dependency "jboss.ejb:persistencePolicy=database,service=EJBTimerService" (should be in state "Create", but is actually in state "**ERROR**")
DEPLOYMENTS IN ERROR:
Deployment "jboss.ejb:persistencePolicy=database,service=EJBTimerService" is in error due to the following reason(s): **ERROR**, java.sql.SQLException: Table 'TIMERS' already exists
20:19:57,003 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-192.168.1.153-8080
20:19:57,050 INFO [AjpProtocol] Starting Coyote AJP/1.3 on ajp-192.168.1.153-8009
20:19:57,066 INFO [ServerImpl] JBoss (Microcontainer) [5.1.0.GA (build: SVNTag=JBoss_5_1_0_GA date=200905221053)] Started in 1m:7s:282ms
</code>
Thanks in advance for all your help.
Regards,
Rupesh Bhadeshiya