activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hondong (JIRA)" <j...@apache.org>
Subject [jira] Reopened: (AMQ-1109) Start Broker SQL Exception
Date Wed, 15 Apr 2009 10:58:31 GMT

     [ 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.


Mime
View raw message