[
https://issues.apache.org/activemq/browse/AMQ-1109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Hondong reopened AMQ-1109:
--------------------------
Hello.
I don´t think, that this Issue is fixed because:
deactivating the lock Database option works for, but even the Slave will become
online.
If both were Online using the same Database, you get Problems with the Messages
produced on the slave or the master.
You will get an inconsitent state.
The Master did not recocognize Messages produced on the Slave and the other way
arround.
Kind regards,
Nils Hondong
> Start Broker SQL Exception
> --------------------------
>
> Key: AMQ-1109
> URL: https://issues.apache.org/activemq/browse/AMQ-1109
> Project: ActiveMQ
> Issue Type: Bug
> Components: Broker
> Affects Versions: 4.1.0
> Environment: Windows 2000, SQL 2005
> Reporter: Artem
> Priority: Critical
> Fix For: 5.0.0
>
> Attachments: activemq.log
>
> Original Estimate: 0 minutes
> Remaining Estimate: 0 minutes
>
> 1. Create DB for ActiveMQ
> 2. Start broker using jtds SQL 2005 driver.
> 3. Exception:
> 2006-12-27 11:08:48,796 [main ] INFO JDBCPersistenceAdapter
> - Database driver recognized:
> [jtds_type_4_jdbc_driver_for_ms_sql_server_and_sybase]
> 2006-12-27 11:08:48,983 [main ] INFO DefaultDatabaseLocker
> - Attempting to acquire the exclusive lock to become the Master broker
> 2006-12-27 11:08:48,983 [main ] ERROR DefaultDatabaseLocker
> - Failed to acquire lock: java.sql.SQLException: Line 1: FOR UPDATE clause
> allowed only for DECLARE CURSOR.
> java.sql.SQLException: Line 1: FOR UPDATE clause allowed only for DECLARE
> CURSOR.
> at
> net.sourceforge.jtds.jdbc.SQLDiagnostic.addDiagnostic(SQLDiagnostic.java:365)
> at net.sourceforge.jtds.jdbc.TdsCore.tdsErrorToken(TdsCore.java:2781)
> at net.sourceforge.jtds.jdbc.TdsCore.nextToken(TdsCore.java:2224)
> at net.sourceforge.jtds.jdbc.TdsCore.getMoreResults(TdsCore.java:628)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.processResults(JtdsStatement.java:525)
> at
> net.sourceforge.jtds.jdbc.JtdsStatement.executeSQL(JtdsStatement.java:487)
> at
> net.sourceforge.jtds.jdbc.JtdsPreparedStatement.execute(JtdsPreparedStatement.java:475)
> at
> org.apache.activemq.store.jdbc.DefaultDatabaseLocker.start(DefaultDatabaseLocker.java:59)
> at
> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.start(JDBCPersistenceAdapter.java:175)
> at
> org.apache.activemq.broker.BrokerService.createRegionBroker(BrokerService.java:1251)
> at
> org.apache.activemq.broker.BrokerService.createBroker(BrokerService.java:1209)
> at
> org.apache.activemq.broker.BrokerService.getBroker(BrokerService.java:508)
> at
> org.apache.activemq.broker.BrokerService.start(BrokerService.java:394)
> at
> org.apache.activemq.xbean.XBeanBrokerService.afterPropertiesSet(XBeanBrokerService.java:47)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1062)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1029)
> at
> org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:420)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:245)
> at
> org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:141)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:242)
> at
> org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:156)
> at
> org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:290)
> at
> org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:348)
> at
> org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:161)
> at
> org.apache.xbean.spring.context.ClassPathXmlApplicationContext.<init>(ClassPathXmlApplicationContext.java:51)
> at
> org.apache.activemq.xbean.XBeanBrokerFactory.createBroker(XBeanBrokerFactory.java:41)
> at
> org.apache.activemq.broker.BrokerFactory.createBroker(BrokerFactory.java:57)
> at
> org.apache.activemq.console.command.StartCommand.startBroker(StartCommand.java:82)
> at
> org.apache.activemq.console.command.StartCommand.runTask(StartCommand.java:47)
> at
> org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:50)
> at
> org.apache.activemq.console.command.ShellCommand.runTask(ShellCommand.java:65)
> at
> org.apache.activemq.console.command.AbstractCommand.execute(AbstractCommand.java:50)
> at
> org.apache.activemq.console.command.ShellCommand.main(ShellCommand.java:46)
> 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.apache.activemq.console.Main.runTaskClass(Main.java:159)
> at org.apache.activemq.console.Main.main(Main.java:91)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
