Thank you gert,
The problem was due to packet size of SQL server, i increased the
packet size and it is working fine.
Gert Vanthienen wrote:
>
> Arif,
>
>
> The stack trace seems to indicate that a rollback is being executed,
> while no transaction was started. Can you try to change the logging
> level for ActiveMQ? Also, on the MySQL website I found that adding the
> property 'profileSQL=true' to the URL should give you more information
> about the SQL statements that are being executed (statements + timing).
> Can you try that for more information?
>
>
> Gert
>
> Arif Mohd wrote:
>> Hi Gert,
>>
>> After removing this property also iam getting the same error, what
>> could
>> be the reason?.
>>
>>
>> Gert Vanthienen wrote:
>>
>>> Arif,
>>>
>>> Are you sure you need the relaxAutoCommit property? I thought you only
>>> needed that one if you are connecting to older MySQL DB servers. If you
>>> do need it, there is a typo in the property.
>>>
>>> The stack trace seems to indicate that a rollback is issued, when no
>>> transaction has previously been started. Are there any previous
>>> warnings/errors on the console?
>>>
>>> Gert
>>>
>>> Arif Mohd wrote:
>>>
>>>> My configuration is as follows,
>>>>
>>>> <?xml version="1.0" encoding="UTF-8"?>
>>>> <!--
>>>>
>>>> Licensed to the Apache Software Foundation (ASF) under one or more
>>>> contributor license agreements. See the NOTICE file distributed
>>>> with
>>>> this work for additional information regarding copyright ownership.
>>>> The ASF licenses this file to You under the Apache License, Version
>>>> 2.0
>>>> (the "License"); you may not use this file except in compliance
>>>> with
>>>> the License. You may obtain a copy of the License at
>>>>
>>>> http://www.apache.org/licenses/LICENSE-2.0
>>>>
>>>> Unless required by applicable law or agreed to in writing, software
>>>> distributed under the License is distributed on an "AS IS" BASIS,
>>>> WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
>>>> implied.
>>>> See the License for the specific language governing permissions and
>>>> limitations under the License.
>>>>
>>>> -->
>>>> <beans xmlns:amq="http://activemq.org/config/1.0";>
>>>>
>>>> <!-- ActiveMQ JMS Broker configuration -->
>>>> <amq:broker depends-on="jmxServer">
>>>>
>>>> <!-- Disable creation of the jmx connector
>>>> which is created in the jmx.xml configuration file -->
>>>> <amq:managementContext>
>>>> <bean class="org.apache.activemq.broker.jmx.ManagementContext">
>>>> <property name="createConnector" value="false" />
>>>> </bean>
>>>> </amq:managementContext>
>>>>
>>>> <!-- Use journaled JDBC persistence -->
>>>> <amq:persistenceAdapter>
>>>> <!--<amq:journaledJDBC journalLogFiles="5"
>>>> dataDirectory="./data/amq"/> -->
>>>> <!-- To use a different datasource, use th following syntax : -->
>>>>
>>>> <amq:journaledJDBC journalLogFiles="5" dataDirectory="../data"
>>>> dataSource="#mysql-ds"/>
>>>>
>>>> </amq:persistenceAdapter>
>>>>
>>>> <amq:transportConnectors>
>>>> <!-- Activate a TCP connector with multicast discovery.
>>>> Note that multicast may be disabled if your computer
>>>> is not on a network, which may prevent the broker to start.
>>>> In such a case, just remove the discoveryUri attribute.
>>>> -->
>>>> <amq:transportConnector uri="tcp://localhost:61616"
>>>> discoveryUri="multicast://default"/>
>>>> </amq:transportConnectors>
>>>>
>>>> <amq:networkConnectors>
>>>> <!-- by default just auto discover the other brokers -->
>>>> <amq:networkConnector uri="multicast://default"/>
>>>> <!--
>>>> <amq:networkConnector
>>>> uri="static://(tcp://host1:61616,tcp://host2:61616)"/>
>>>> -->
>>>> </amq:networkConnectors>
>>>>
>>>> </amq:broker>
>>>>
>>>> <!-- This xbean configuration file supports all the standard spring
>>>> xml
>>>> configuration options -->
>>>>
>>>> <!-- Postgres DataSource Sample Setup -->
>>>> <!--
>>>> <bean id="postgres-ds" class="org.postgresql.ds.PGPoolingDataSource">
>>>> <property name="serverName" value="localhost"/>
>>>> <property name="databaseName" value="activemq"/>
>>>> <property name="portNumber" value="0"/>
>>>> <property name="user" value="activemq"/>
>>>> <property name="password" value="activemq"/>
>>>> <property name="dataSourceName" value="postgres"/>
>>>> <property name="initialConnections" value="1"/>
>>>> <property name="maxConnections" value="10"/>
>>>> </bean>
>>>> -->
>>>>
>>>> <!-- MySql DataSource Sample Setup using the Commons DBCP pooler
>>>> (http://jakarta.apache.org/commons/dbcp/) -->
>>>>
>>>> <bean id="mysql-ds" class="org.apache.commons.dbcp.BasicDataSource"
>>>> destroy-method="close">
>>>> <property name="driverClassName" value="com.mysql.jdbc.Driver"/>
>>>> <property name="url"
>>>> value="jdbc:mysql://localhost:3306/test?relaxAutocCommit=true"/>
>>>> <property name="username" value="root"/>
>>>> <property name="password" value=""/>
>>>> <property name="poolPreparedStatements" value="true"/>
>>>> </bean>
>>>>
>>>>
>>>> <!-- MySql DataSource Sample Setup using the c3p0 pooler
>>>> (http://sf.net/projects/c3p0) -->
>>>> <!--
>>>> <bean id="mysql-ds" class="com.mchange.v2.c3p0.ComboPooledDataSource"
>>>> destroy-method="close">
>>>> <property name="driverClass" value="com.mysql.jdbc.Driver">
>>>> <property name="jdbcUrl"
>>>> value="jdbc:mysql://localhost:3306/activemq">
>>>> <property name="user" value="activemq">
>>>> <property name="password" value="activemq">
>>>> <property name="minPoolSize" value="5">
>>>> <property name="maxPoolSize" value="10">
>>>> <property name="acquireIncrement" value="3">
>>>> </bean>
>>>> -->
>>>>
>>>> <!-- Embedded Derby DataSource Sample Setup -->
>>>> <!--
>>>> <bean id="derby-ds" class="org.apache.derby.jdbc.EmbeddedDataSource">
>>>> <property name="databaseName" value="derbydb"/>
>>>> <property name="createDatabase" value="create"/>
>>>> </bean>
>>>> -->
>>>>
>>>> </beans>
>>>>
>>>>
>>>> Arif Mohd wrote:
>>>>
>>>>
>>>>> Hi all,
>>>>>
>>>>> - Iam using servicemix3.1 which is using activeMQ 4.1
>>>>> - Iam placing multiple requests on servicemix and these requests
>>>>> are
>>>>> served by http-bc and i will get the response and these responses are
>>>>> kept
>>>>> in topic.
>>>>> - iam using mySQL as persitence storage.
>>>>>
>>>>> Under the above condition(when multiple requests are placed)
>>>>> iam
>>>>> getting the following error
>>>>>
>>>>> ERROR - JournalPersistenceAdapter - Failed to checkpoint a
>>>>> message
>>>>> store: edu.emory.mathcs.backport.java.util.concurre
>>>>> cutionException: java.io.IOException: Not started.
>>>>> edu.emory.mathcs.backport.java.util.concurrent.ExecutionException:
>>>>> java.io.IOException: Not started.
>>>>> at
>>>>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.getResult(FutureTask.java:299)
>>>>>
>>>>> at
>>>>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.get(FutureTask.java:118)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.journal.JournalPersistenceAdapter.doCheckpoint(JournalPersistenceAdapter.java:386)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.journal.JournalPersistenceAdapter$2.iterate(JournalPersistenceAdapter.java:129)
>>>>>
>>>>> at
>>>>> org.apache.activemq.thread.PooledTaskRunner.runTask(PooledTaskRunner.java:111)
>>>>>
>>>>> at
>>>>> org.apache.activemq.thread.PooledTaskRunner.access$100(PooledTaskRunner.java:26)
>>>>>
>>>>> at
>>>>> org.apache.activemq.thread.PooledTaskRunner$1.run(PooledTaskRunner.java:44)
>>>>>
>>>>> at
>>>>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:665)
>>>>>
>>>>> at
>>>>> edu.emory.mathcs.backport.java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:690)
>>>>>
>>>>> at java.lang.Thread.run(Thread.java:595)
>>>>> Caused by: java.io.IOException: Not started.
>>>>> at
>>>>> org.apache.activemq.store.jdbc.TransactionContext.rollback(TransactionContext.java:168)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.jdbc.JDBCPersistenceAdapter.rollbackTransaction(JDBCPersistenceAdapter.java:368)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.journal.JournalPersistenceAdapter.rollbackTransaction(JournalPersistenceAdapter.java:1
>>>>>
>>>>> at
>>>>> org.apache.activemq.util.TransactionTemplate.run(TransactionTemplate.java:62)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:247)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.journal.JournalMessageStore.checkpoint(JournalMessageStore.java:221)
>>>>>
>>>>> at
>>>>> org.apache.activemq.store.journal.JournalPersistenceAdapter$4.call(JournalPersistenceAdapter.java:356)
>>>>>
>>>>> at
>>>>> edu.emory.mathcs.backport.java.util.concurrent.FutureTask.run(FutureTask.java:176)
>>>>>
>>>>> ... 3 more
>>>>>
>>>>>
>>>>> Could any body help me out .
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
>
--
View this message in context:
http://www.nabble.com/Is-it-a-servicemix-or-activemq-Problem-tf3927250s12049.html#a11142490
Sent from the ServiceMix - User mailing list archive at Nabble.com.
