1 Reply Latest reply on Sep 1, 2009 1:41 PM by Bill Robinson

    Can BladeLogic use a read-only DB instance?

    S Crawford

      Our DR environment for BladeLogic contains an Oracle database that is synchronized to the production DB using DataGuard. When we cutover to DR, we would like to run the DB instance in read-only mode, but when we try to start up the DR appservers, we get this error in the log files (below). Can BladeLogic support a read-only mode DB? (we understand that no data would be written, but can Config Manager still read data)?

       

      + [] Error installing to Start: name=bladelogic.service.AsDataSourceService state=Create

      com.bladelogic.app.service.ServiceInitializationException: com.bladelogic.mfw.util.BlException: java.sql.SQLException: Numeric Overflow

      at com.bladelogic.shared.db.BlDbPooledDataSource.start(BlDbPooledDataSource.java:88)

      at com.bladelogic.app.service.db.BlAsDbDataSource.start(BlAsDbDataSource.java:195)

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)

      at java.lang.reflect.Method.invoke(Unknown Source)

      at org.jboss.joinpoint.plugins.reflect.ReflectMethodJoinPoint.dispatch(ReflectMethodJoinPoint.java:72)

      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$DispatchJoinPoint.run(KernelControllerContextActions.java:631)

      at java.security.AccessController.doPrivileged(Native Method)

      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions.dispatchJoinPoint(KernelControllerContextActions.java:99)

      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$LifecycleAction.installAction(KernelControllerContextActions.java:452)

      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$1.run(KernelControllerContextActions.java:156)

      at java.security.AccessController.doPrivileged(Native Method)

      at org.jboss.kernel.plugins.dependency.KernelControllerContextActions$KernelControllerContextAction.install(KernelControllerContextActions.java:179)

      at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)

      at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:226)

      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:593)

      at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:346)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:438)

      at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:379)

      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:225)

      at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:151)

      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBean(AbstractKernelDeployer.java:291)

      at com.bladelogic.app.service.bootstrap.ServiceBeanXMLDeployer.deployBean(ServiceBeanXMLDeployer.java:38)

      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deployBeans(AbstractKernelDeployer.java:261)

      at org.jboss.kernel.plugins.deployment.AbstractKernelDeployer.deploy(AbstractKernelDeployer.java:117)

      at org.jboss.kernel.plugins.deployment.xml.BeanXMLDeployer.deploy(BeanXMLDeployer.java:91)

      at com.bladelogic.app.service.bootstrap.ServiceBootstrap.deploy(ServiceBootstrap.java:240)

      at com.bladelogic.app.service.bootstrap.ServiceBootstrap.deployService(ServiceBootstrap.java:187)

      at com.bladelogic.app.service.bootstrap.ServiceBootstrap.bootstrap(ServiceBootstrap.java:141)

      at org.jboss.kernel.plugins.bootstrap.AbstractBootstrap.run(AbstractBootstrap.java:91)

      at com.bladelogic.app.service.bootstrap.ServiceBootstrap.startup(ServiceBootstrap.java:66)

      at com.bladelogic.mfw.fw.BlManager.start(BlManager.java:802)

      at com.bladelogic.mfw.fw.BlManager.main(BlManager.java:1290)

      Caused by: com.bladelogic.mfw.util.BlException: java.sql.SQLException: Numeric Overflow

      at com.bladelogic.shared.db.pool.BlDbDbcpConnPool.(BlDbDbcpConnPool.java:84)

      ... 35 more

      +++