You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@activemq.apache.org by StrongBad <jw...@absolute-performance.com> on 2006/09/07 20:36:37 UTC
Failed to create database 'derbydb'
Can anyone give me a tip on this one? I've searched and found a lot of the
same, but solutions
such as the one pointed to here -->
http://www.nabble.com/forum/ViewPost.jtp?post=5965229&framed=y
don't seem to work for me. I've deleted the dir and recreated it and the
same happens.
ACTIVEMQ_HOME: /usr/local/activemq
Loading message broker from: xbean:activemq.xml
INFO BrokerService - ActiveMQ 4.0.1 JMS Message Broker
(localhost) is starting
INFO BrokerService - For help or more information please
see: http://incubator.apache.org/activemq/
ERROR BrokerService - Failed to start ActiveMQ JMS Message
Broker. Reason: java.io.IOException: Failed to create database 'derbydb',
see the next exception for details.
java.io.IOException: Failed to create database 'derbydb', see the next
exception for details.
at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:42)
at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:58)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.createAdapter(JDBCPersistenceAdapter.java:229)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getAdapter(JDBCPersistenceAdapter.java:213)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:139)
at
org.apache.activemq.store.journal.JournalPersistenceAdapter.start(JournalPersistenceAdapter.java:216)
at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:930)
at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:888)
at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:458)
at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:361)
at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:43)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)
at
org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:158)
at
org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:48)
at
org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:40)
at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:56)
at
org.apache.activemq.console.command.StartCommand.startBroker(StartCommand.java:81)
at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:46)
at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:49)
at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:81)
at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:49)
at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:45)
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 org.apache.activemq.console.Main.runTaskClass(Main.java:135)
at org.apache.activemq.console.Main.main(Main.java:67)
Caused by: SQL Exception: Failed to create database 'derbydb', see the next
exception for details.
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.newEmbedSQLException(Unknown
Source)
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.newSQLException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection.createDatabase(Unknown
Source)
at org.apache.derby.impl.jdbc.EmbedConnection.<init>(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedConnection30.<init>(Unknown
Source)
at org.apache.derby.jdbc.Driver30.getNewEmbedConnection(Unknown
Source)
at org.apache.derby.jdbc.InternalDriver.connect(Unknown Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown
Source)
at org.apache.derby.jdbc.EmbeddedDataSource.getConnection(Unknown
Source)
at
org.apache.activemq.store.jdbc.TransactionContext.getConnection(TransactionContext.java:54)
... 31 more
ERROR: java.lang.RuntimeException: Failed to execute start task. Reason:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in class
path resource [activemq.xml]: Initialization of bean failed; nested
exception is java.io.IOException: Failed to create database 'derbydb', see
the next exception for details.
ERROR: java.lang.Exception:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in class
path resource [activemq.xml]: Initialization of bean failed; nested
exception is java.io.IOException: Failed to create database 'derbydb', see
the next exception for details.
INFO BrokerService - ActiveMQ Message Broker (localhost,
null) is shutting down
INFO NetworkConnector - Network Connector default Stopped
INFO TransportConnector - Connector default Stopped
INFO TransportConnector - Connector stomp Stopped
INFO VMTransportFactory - Shutting down VM connectors for
broker: localhost
INFO BrokerService - ActiveMQ JMS Message Broker
(localhost, null) stopped
--
View this message in context: http://www.nabble.com/Failed-to-create-database-%27derbydb%27-tf2234864.html#a6195981
Sent from the ActiveMQ - User forum at Nabble.com.
Re: Failed to create database 'derbydb'
Posted by StrongBad <jw...@absolute-performance.com>.
I tried the solution mentioned in
http://www.nabble.com/forum/ViewPost.jtp?post=6179899&framed=y
Here is the result:
$ activemq
ACTIVEMQ_HOME: /usr/local/activemq
Loading message broker from: xbean:activemq.xml
INFO BrokerService - ActiveMQ 4.0.1 JMS Message Broker
(localhost) is starting
INFO BrokerService - For help or more information please
see: http://incubator.apache.org/activemq/
INFO JDBCPersistenceAdapter - Database driver recognized:
[apache_derby_embedded_jdbc_driver]
WARN DefaultJDBCAdapter - Could not create JDBC tables; they
could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_CIDX ON
ACTIVEMQ_MSGS (CONTAINER) Message: Exception during creation of file
/usr/local/stuff/data/derbydb/seg0/c331.dat for container SQLState: XSDF1
Vendor code: 20000
WARN DefaultJDBCAdapter - Could not create JDBC tables; they
could already exist. Failure was: CREATE INDEX ACTIVEMQ_MSGS_EIDX ON
ACTIVEMQ_MSGS (EXPIRATION) Message: Exception during creation of file
/usr/local/stuff/data/derbydb/seg0/c341.dat for container SQLState: XSDF1
Vendor code: 20000
WARN DefaultJDBCAdapter - Could not create JDBC tables; they
could already exist. Failure was: CREATE TABLE ACTIVEMQ_ACKS(CONTAINER
VARCHAR(250) NOT NULL, CLIENT_ID VARCHAR(250) NOT NULL, SUB_NAME
VARCHAR(250) NOT NULL, SELECTOR VARCHAR(250), LAST_ACKED_ID INTEGER, PRIMARY
KEY ( CONTAINER, CLIENT_ID, SUB_NAME)) Message: Exception during creation of
file /usr/local/stuff/data/derbydb/seg0/c350.dat for container SQLState:
XSDF1 Vendor code: 20000
WARN JDBCPersistenceAdapter - Old message cleanup failed due to:
SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist.
ERROR BrokerService - Failed to start ActiveMQ JMS Message
Broker. Reason: java.io.IOException: Failed to get last broker message id:
SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist.
java.io.IOException: Failed to get last broker message id: SQL Exception:
Table 'ACTIVEMQ_ACKS' does not exist.
at
org.apache.activemq.util.IOExceptionSupport.create(IOExceptionSupport.java:30)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:131)
at
org.apache.activemq.broker.region.RegionBroker.<init>(RegionBroker.java:91)
at
org.apache.activemq.broker.jmx.ManagedRegionBroker.<init>(ManagedRegionBroker.java:89)
at
org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:934)
at
org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:888)
at
org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:458)
at
org.apache.activemq.broker.BrokerService.start(BrokerService.java:361)
at
org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:43)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1059)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:363)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:226)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:147)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:275)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:320)
at
org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:158)
at
org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:48)
at
org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:40)
at
org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:56)
at
org.apache.activemq.console.command.StartCommand.startBroker(StartCommand.java:81)
at
org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:46)
at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:49)
at
org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:81)
at
org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:49)
at
org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:45)
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 org.apache.activemq.console.Main.runTaskClass(Main.java:135)
at org.apache.activemq.console.Main.main(Main.java:67)
Caused by: SQL Exception: Table 'ACTIVEMQ_ACKS' does not exist.
at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
at
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.handleException(Unknown Source)
at
org.apache.derby.impl.jdbc.ConnectionChild.handleException(Unknown Source)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown
Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source)
at
org.apache.activemq.store.jdbc.adapter.DefaultJDBCAdapter.doGetLastMessageBrokerSequenceId(DefaultJDBCAdapter.java:164)
at
org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.getLastMessageBrokerSequenceId(JDBCPersistenceAdapter.java:128)
... 29 more
ERROR: java.lang.RuntimeException: Failed to execute start task. Reason:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in class
path resource [activemq.xml]: Initialization of bean failed; nested
exception is java.io.IOException: Failed to get last broker message id: SQL
Exception: Table 'ACTIVEMQ_ACKS' does not exist.
ERROR: java.lang.Exception:
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'org.apache.activemq.xbean.XBeanBrokerService' defined in class
path resource [activemq.xml]: Initialization of bean failed; nested
exception is java.io.IOException: Failed to get last broker message id: SQL
Exception: Table 'ACTIVEMQ_ACKS' does not exist.
INFO BrokerService - ActiveMQ Message Broker (localhost,
null) is shutting down
INFO NetworkConnector - Network Connector default Stopped
INFO TransportConnector - Connector default Stopped
INFO TransportConnector - Connector stomp Stopped
INFO VMTransportFactory - Shutting down VM connectors for
broker: localhost
INFO BrokerService - ActiveMQ JMS Message Broker
(localhost, null) stopped
--
View this message in context: http://www.nabble.com/Failed-to-create-database-%27derbydb%27-tf2234864.html#a6197764
Sent from the ActiveMQ - User forum at Nabble.com.