We have a web based application running on tomcat (5.5.9). It uses hibernate
(3.0), MySQL database (4.10) and MySQL J/connector(5.0.4) for database
connectivity.
Currently we are investigating Sequoia to provide load balancing and
transparent failover features.
We have a controller with RAIDb-1 configuration with just one database
backend.When we shutdown the controller via console, we are getting the
following error:
" ERROR controller.virtualdatabase.db Failed to unregister the mbean of virtual
database db
javax.management.InstanceNotFoundException:
sequoia:type=VirtualDataBase.RecoveryLog,VirtualDataBase=db".
See the end of the email for detail error log. What can I do to fix this error?
Also we do not need to use the RecoveryLog (as we are using Mysql replication),
how do I get rid of the error message:
"ERROR controller.jmx.MBeanServer Register mbean of type
sequoia:VirtualDataBase=db,type=VirtualDataBase.RecoveryLog failed with error
sequoia:type=VirtualDataBase.RecoveryLog,VirtualDataBase=db ({2})"
Thanks for your help in advance.
virutaldatabase config file:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.2//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.2.dtd";>
<SEQUOIA>
<VirtualDatabase name="db">
<AuthenticationManager>
<Admin>
<User username="admin" password="XXX"/>
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user1" vPassword="XXXX"/>
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="db" driver="com.mysql.jdbc.Driver"
url="jdbc:mysql://harrow:3306/db" connectionTestStatement="SELECT 1">
<ConnectionManager vLogin="user1" >
<VariablePoolConnectionManager initPoolSize="5" minPoolSize="5"
maxPoolSize="200" idleTimeout="3000" waitTimeout="10000"/>
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough"/>
</RequestScheduler>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="first"/>
<RAIDb-1-RoundRobin/>
</RAIDb-1>
</LoadBalancer>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
controller config file:
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE SEQUOIA-CONTROLLER PUBLIC "-//Continuent//DTD SEQUOIA-CONTROLLER 2.10.
2//EN" "http://sequoia.continuent.org/dtds/sequoia-controller-2.10.2.dtd";>
<SEQUOIA-CONTROLLER>
<Controller port="25322">
<Report hideSensitiveData="true" generateOnShutdown="true" generateOnFatal="
true" enableFileLogging="true" />
<JmxSettings>
<RmiJmxAdaptor port="1090"/>
</JmxSettings>
<VirtualDatabase configFile="mydb-raidb1.xml" virtualDatabaseNa
me="db" autoEnableBackends="true" />
</Controller>
</SEQUOIA-CONTROLLER>
Error:
2006-12-07 15:22:23,302 INFO controller.virtualdatabase.db Shutting down
virtual database db in safe mode : waiting for all current transactions to
complete
2006-12-07 15:22:23,303 INFO controller.virtualdatabase.db Waiting for virtual
database db shutdown
2006-12-07 15:22:23,303 DEBUG backend.DatabaseBackend.db Database backend db is
now in state sequoia.virtualdatabase.backend.disabled
2006-12-07 15:22:23,304 INFO controller.RequestManager.db Setting new virtual
database schema.
2006-12-07 15:22:23,305 DEBUG backend.DatabaseBackend.db Stopping 5 worker
threads of backend db
2006-12-07 15:22:23,310 DEBUG backend.DatabaseBackend.db Adding task
KillThreadTask to pending request queue
2006-12-07 15:22:23,312 DEBUG backend.DatabaseBackend.db Executing task
KillThreadTask
2006-12-07 15:22:23,312 DEBUG backend.DatabaseBackend.db Adding task
KillThreadTask to pending request queue
2006-12-07 15:22:23,313 DEBUG backend.DatabaseBackend.db db -
BackendWorkerThread for backend 'db' with RAIDb level:1 is shutting down
2006-12-07 15:22:23,313 DEBUG backend.DatabaseBackend.db Executing task
KillThreadTask
2006-12-07 15:22:23,313 DEBUG backend.DatabaseBackend.db Task KillThreadTask
completed
2006-12-07 15:22:23,314 DEBUG backend.DatabaseBackend.db db -
BackendWorkerThread for backend 'db' with RAIDb level:1 is shutting down
2006-12-07 15:22:23,314 DEBUG backend.DatabaseBackend.db Task KillThreadTask
completed
2006-12-07 15:22:23,314 DEBUG backend.DatabaseBackend.db Adding task
KillThreadTask to pending request queue
2006-12-07 15:22:23,315 DEBUG backend.DatabaseBackend.db Executing task
KillThreadTask
2006-12-07 15:22:23,315 DEBUG backend.DatabaseBackend.db db -
BackendWorkerThread for backend 'db' with RAIDb level:1 is shutting down
2006-12-07 15:22:23,315 DEBUG backend.DatabaseBackend.db Task KillThreadTask
completed
2006-12-07 15:22:23,315 DEBUG backend.DatabaseBackend.db Adding task
KillThreadTask to pending request queue
2006-12-07 15:22:23,315 DEBUG backend.DatabaseBackend.db Executing task
KillThreadTask
2006-12-07 15:22:23,316 DEBUG backend.DatabaseBackend.db db -
BackendWorkerThread for backend 'db' with RAIDb level:1 is shutting down
2006-12-07 15:22:23,316 DEBUG backend.DatabaseBackend.db Task KillThreadTask
completed
2006-12-07 15:22:23,318 DEBUG backend.DatabaseBackend.db Adding task
KillThreadTask to pending request queue
2006-12-07 15:22:23,319 DEBUG backend.DatabaseBackend.db Executing task
KillThreadTask
2006-12-07 15:22:23,319 DEBUG backend.DatabaseBackend.db db -
BackendWorkerThread for backend 'db' with RAIDb level:1 is shutting down
2006-12-07 15:22:23,319 DEBUG backend.DatabaseBackend.db Task KillThreadTask
completed
2006-12-07 15:22:23,322 INFO sequoia.controller.connection 5 connections freed
on "jdbc:mysql://leviathan:3306/db"
2006-12-07 15:22:23,435 INFO controller.RequestManager.db Backend db is now
disabled
2006-12-07 15:22:23,436 INFO sequoia.controller.shutdown Waiting for 0 virtual
database worker threads to terminate.
2006-12-07 15:22:23,436 INFO controller.virtualdatabase.db The virtual
database db has been successfully shut down
2006-12-07 15:22:23,437 ERROR controller.jmx.MBeanServer Register mbean of type
sequoia:VirtualDataBase=db,type=VirtualDataBase.RecoveryLog failed with error
sequoia:type=VirtualDataBase.RecoveryLog,VirtualDataBase=db ({2})
2006-12-07 15:22:23,438 ERROR controller.virtualdatabase.db Failed to
unregister the mbean of virtual database db
javax.management.InstanceNotFoundException:
sequoia:type=VirtualDataBase.RecoveryLog,VirtualDataBase=db
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.getMBean(DefaultMBeanServerInterceptor.java:1010)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.unregisterMBean(DefaultMBeanServerInterceptor.java:354)
at
com.sun.jmx.mbeanserver.JmxMBeanServer.unregisterMBean(JmxMBeanServer.java:527)
at
org.continuent.sequoia.controller.jmx.ChainedMBeanServer.unregisterMBean(ChainedMBeanServer.java:444)
at
org.continuent.sequoia.controller.jmx.MBeanServerManager.unregister(MBeanServerManager.java:260)
at
org.continuent.sequoia.controller.virtualdatabase.VirtualDatabase.shutdown(VirtualDatabase.java:3691)
at
org.continuent.sequoia.controller.virtualdatabase.management.VirtualDatabase.shutdown(VirtualDatabase.java:620)
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:585)
at
com.sun.jmx.mbeanserver.StandardMetaDataImpl.invoke(StandardMetaDataImpl.java:414)
at javax.management.StandardMBean.invoke(StandardMBean.java:323)
at
com.sun.jmx.mbeanserver.DynamicMetaDataImpl.invoke(DynamicMetaDataImpl.java:213)
at com.sun.jmx.mbeanserver.MetaDataImpl.invoke(MetaDataImpl.java:220)
at
com.sun.jmx.interceptor.DefaultMBeanServerInterceptor.invoke(DefaultMBeanServerInterceptor.java:815)
at
com.sun.jmx.mbeanserver.JmxMBeanServer.invoke(JmxMBeanServer.java:784)
at
org.continuent.sequoia.controller.jmx.ChainedMBeanServer.invoke(ChainedMBeanServer.java:318)
at
org.continuent.sequoia.controller.jmx.AuthenticatingMBeanServer.invoke(AuthenticatingMBeanServer.java:127)
at
javax.management.remote.rmi.RMIConnectionImpl.doOperation(RMIConnectionImpl.java:1408)
at
javax.management.remote.rmi.RMIConnectionImpl.access$100(RMIConnectionImpl.java:81)
at
javax.management.remote.rmi.RMIConnectionImpl$PrivilegedOperation.run(RMIConnectionImpl.java:1245)
at java.security.AccessController.doPrivileged(Native Method)
at
javax.management.remote.rmi.RMIConnectionImpl.doPrivilegedOperation(RMIConnectionImpl.java:1348)
at
javax.management.remote.rmi.RMIConnectionImpl.invoke(RMIConnectionImpl.java:782)
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:585)
at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
at sun.rmi.transport.Transport$1.run(Transport.java:153)
at java.security.AccessController.doPrivileged(Native Method)
at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
at
sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:460)
at
sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:701)
at java.lang.Thread.run(Thread.java:595)
2006-12-07 15:22:23,464 INFO controller.core.Controller Shutting down
controller 192.168.47.3:25322
2006-12-07 15:22:23,465 INFO controller.core.Controller Waiting for controller
shutdown
2006-12-07 15:22:23,465 INFO sequoia.controller.shutdown Starting controller
shutdown
2006-12-07 15:22:24,110 INFO sequoia.controller.shutdown A report has been
generated /usr/local/sequoia/log/sequoia.report
2006-12-07 15:22:24,110 INFO sequoia.controller.shutdown Shutting down Jmx
Agent
2006-12-07 15:22:24,124 INFO sequoia.controller.shutdown Waiting for
controller thread termination.
2006-12-07 15:22:24,124 INFO controller.core.Controller ControllerServerThread
terminating
2006-12-07 15:22:24,125 INFO sequoia.controller.shutdown Controller shutdown
completed
2006-12-07 15:22:24,125 INFO controller.core.Controller Shutdown of controller
192.168.47.3:25322 completed
____________________________________________________________________________________
Have a burning question?
Go to www.Answers.yahoo.com and get answers from real people who know._______________________________________________
Sequoia mailing list
Sequoia@lists.forge.continuent.org
https://forge.continuent.org/mailman/listinfo/sequoia
