FW: queue gets stuck with MySQL

"David Edson" <[email protected]>
Newsgroups gmane.comp.java.openjms.devel
Message-ID <[email protected]>
 
 
 



________________________________________________ 
David Edson 
Chief Technical Officer
Newsnet.Com

Level 3, 6 O'Connell St
Sydney NSW 2000
Australia

office:    +612 9220 7586
fax:       +612 9220 7511
mobile : +614 0868 0808 
email:    [email protected]
web:      http://www.newsnet.com <http://www.newsnet.com/> 

 

-----Original Message-----
From: David Edson [mailto:DavidEdson-gISR/[email protected]] 
Sent: Tuesday, 15 October 2002 09:20
To: 'openjms-developer-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org'
Subject: queue gets stuck with MySQL


Hi,
 
I am using the latest OpenJMS v0.7.2, 
with the persistence provided by MySQL v3.23.49-nt
 
the test queues/topics work fine for 1-2 messages,
when I put in 1000 messages
and try to get them out, it locks up
the admin client shows messages in the queue,
however the runreceiver doesn't download them when retrying
 
I can stop the server and start it again and it works a bit
but it locks up again.
 
Has anybody experienced this phenomena ?
If so could you perhaps offer me some advice.
 
Cheers
Dave




________________________________________________ 
David Edson 
Chief Engineer 
Pocket Rocket Software 
mobile :        +614 0868 0808 
email:  mailto:DavidEdson-gISR/[email protected] 
web:    http://www.users.bigpond.com/DavidEdson
rmi_jms_mysql.xml (text/xml, 1.4 KB)
<?xml version="1.0"?>
<!-- edited with XML Spy v2.5 NT  - http://www.xmlspy.com -->
<!-- OpenJMS configuration:
     . RMI connectors  
     . JDBC persistency
     . embedded JNDI provider
     . embedded RMI registry, running on port 1099
     . preconfigured destinations
 -->
<Configuration>
	<!-- Required when using an RMI connector -->
	<Connectors>
		<Connector scheme="rmi">
			<ConnectionFactories>
				<QueueConnectionFactory name="JmsQueueConnectionFactory"/>
				<TopicConnectionFactory name="JmsTopicConnectionFactory"/>
			</ConnectionFactories>
		</Connector>
	</Connectors>
	<!-- Required -->
	<DatabaseConfiguration>
		<!-- Uncomment the appropriate RbmsDatabaseConfiguration and change the
       parameters to match your setup
   -->
		<RdbmsDatabaseConfiguration driver="org.gjt.mm.mysql.Driver" url="jdbc:mysql://localhost/test" user="user" password="pass"/>
	</DatabaseConfiguration>
	<!-- Required -->
	<AdminConfiguration script="${openjms.home}\bin\startjms.bat" config="${openjms.home}\config\rmi_jms_mysql.xml"/>
	<!-- Optional. If not specified, no destinations will be created -->
	<AdministeredDestinations>
		<AdministeredTopic name="topic1">
			<Subscriber name="sub1"/>
			<Subscriber name="sub2"/>
		</AdministeredTopic>
		<AdministeredQueue name="queue1"/>
		<AdministeredQueue name="queue2"/>
		<AdministeredQueue name="queue3"/>
	</AdministeredDestinations>
</Configuration>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.