activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "HiSkill (JIRA)" <j...@apache.org>
Subject [jira] Commented: (AMQ-1109) Start Broker SQL Exception
Date Fri, 13 Nov 2009 03:41:52 GMT

    [ https://issues.apache.org/activemq/browse/AMQ-1109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=55369#action_55369
] 

HiSkill commented on AMQ-1109:
------------------------------

I am using 5.3.0 deployed as EAR/RAR on JBoss. I don't have the setting useDatabaseLock="true"
in the broker-config.xml.
 
With MSSQL 2000 and MSSQL 2005 it works fine but with MSSQL 2008 I keep getting these messages,
broker never starts up.

2009-11-12 21:51:15,992 INFO  [STDOUT] 2009-11-12 21:51:15,992 [ActiveMQ Broker] INFO  DefaultDatabaseLocker
         - Failed to acquire lock.  Sleeping for 1000 milli(s) before trying again...

Looks like the ACTIVEMQ_MSGS table is not getting created where as ACTIVEMQ_ACKS & ACTIVEMQ_LOCK
tables are created.

Even with useDatabaseLock="true", broker doesn't come up.  Any idea when this fix is expected?


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