2 Replies Latest reply on Jun 2, 2004 1:19 PM by Elias Ross

    Power Failure causing java.sql.SQLException

    Dave Morris Newbie

      Our JBOSS server took a power hit. We restarted the JBOSS server, and during restart we receive a message:

      10:25:14,517 INFO [TxConnectionManager] Started jboss.jca:service=LocalTxCM,name=DefaultDS
      10:25:22,909 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection:
      org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (java.sql.SQLException: Unexpected token: Unexpected token: in statement [

      ¦à++Gça+ª?àx»GWÄ-{?¦Æ+¤(_£])
      at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.c
      reateManagedConnection(LocalManagedConnectionFactory.java:160)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.cr
      eateConnectionEventListener(InternalManagedConnectionPool.java:451)
      at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.ge
      tConnection(InternalManagedConnectionPool.java:212)

      Checking one of our JMS queues, we get the following exceptions:

      ReceiversCount value

      RuntimeMBeanException: RuntimeException in MBean when getting attribute 'ReceiversCount' Cause: java.lang.NullPointerException

      MessageCounter value

      RuntimeMBeanException: RuntimeException in MBean when getting attribute 'MessageCounter' Cause: java.lang.NullPointerException

      ScheduledMessageCount value

      RuntimeMBeanException: RuntimeException in MBean when getting attribute 'ScheduledMessageCount' Cause: java.lang.NullPointerException

      We have reinstalled JBOSS to recover from the above issue in the past.

      Question: what steps can we take to recover from JBOSS DB corruption?