<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0">
	<channel>
		<title><![CDATA[Latest posts for the topic "QRTZ_LOCKS table"]]></title>
		<link>http://forums.terracotta.org/forums/posts/list/17.page</link>
		<description><![CDATA[Latest messages posted in the topic "QRTZ_LOCKS table"]]></description>
		<generator>JForum - http://www.jforum.net</generator>
			<item>
				<title>QRTZ_LOCKS table</title>
				<description><![CDATA[ Anybody has any idea why and how LOCKS table is used ?.

I have the following setup:

1. Set of 2 Schedulers with names A1, A1 running in clustered mode pointing to database (say QuartzDB)
2. Set of 2 Schedulers with names B1,B1 running in clustered mode pointing to database QuartzDB (same db as (1))

Since post Quartz 2.0 we have SCHED_NAME columns on all the tables, it seems we can point multiple schedulers both A1s and B1s to the same database.

However in LOCKS table, I only see the entry of the A1 scheduler. I am not sure if and how it affects the scheduling operation but wanted to understand that to avoid any future problems.

Thanks in advance]]></description>
				<guid isPermaLink="true">http://forums.terracotta.org/forums/posts/list/5490.page#27283</guid>
				<link>http://forums.terracotta.org/forums/posts/list/5490.page#27283</link>
				<pubDate><![CDATA[Wed, 25 May 2011 15:22:38]]> GMT</pubDate>
				<author><![CDATA[ gurizbac]]></author>
			</item>
			<item>
				<title>Re:QRTZ_LOCKS table</title>
				<description><![CDATA[ 
You should definitely have two sets of entries in the locks table - one for scheduler A1 and one for scheduler B1.

The entries should be automatically created, so it's very curious if you only see a row for A1 in the table.
]]></description>
				<guid isPermaLink="true">http://forums.terracotta.org/forums/posts/list/5490.page#27289</guid>
				<link>http://forums.terracotta.org/forums/posts/list/5490.page#27289</link>
				<pubDate><![CDATA[Wed, 25 May 2011 19:57:14]]> GMT</pubDate>
				<author><![CDATA[ jhouse]]></author>
			</item>
			<item>
				<title>Re:QRTZ_LOCKS table</title>
				<description><![CDATA[ Thanks. 

Do you know how many entries per scheduler should be there and how the locks table is used. 
Is it used only during clustered mode ?

Thanks]]></description>
				<guid isPermaLink="true">http://forums.terracotta.org/forums/posts/list/5490.page#27308</guid>
				<link>http://forums.terracotta.org/forums/posts/list/5490.page#27308</link>
				<pubDate><![CDATA[Thu, 26 May 2011 09:31:22]]> GMT</pubDate>
				<author><![CDATA[ gurizbac]]></author>
			</item>
			<item>
				<title>Re:QRTZ_LOCKS table</title>
				<description><![CDATA[ I deleted all the entries in the locks table.

1. If I start B1 set of schedulers first, locks table get B1 scheduler entries
2. If I then start A1 set of schedulers, no new entries are inserted into locks table for A1

The reverse happens :
1. If I start set of A1 set of schedulers first, locks table get A1 scheduler entries
2. If I then start B1 set of schedulers, no new entries are inserted into locks table for B1.

Seems to be a bug to me.]]></description>
				<guid isPermaLink="true">http://forums.terracotta.org/forums/posts/list/5490.page#27312</guid>
				<link>http://forums.terracotta.org/forums/posts/list/5490.page#27312</link>
				<pubDate><![CDATA[Thu, 26 May 2011 11:20:16]]> GMT</pubDate>
				<author><![CDATA[ gurizbac]]></author>
			</item>
			<item>
				<title>Re:QRTZ_LOCKS table</title>
				<description><![CDATA[ Sure sounds like it.  Can you please file an issue in Jira?
]]></description>
				<guid isPermaLink="true">http://forums.terracotta.org/forums/posts/list/5490.page#27324</guid>
				<link>http://forums.terracotta.org/forums/posts/list/5490.page#27324</link>
				<pubDate><![CDATA[Fri, 27 May 2011 06:36:32]]> GMT</pubDate>
				<author><![CDATA[ jhouse]]></author>
			</item>
			<item>
				<title>Re:QRTZ_LOCKS table</title>
				<description><![CDATA[ Filed the bug

https://jira.terracotta.org/jira/browse/QTZ-182]]></description>
				<guid isPermaLink="true">http://forums.terracotta.org/forums/posts/list/5490.page#27329</guid>
				<link>http://forums.terracotta.org/forums/posts/list/5490.page#27329</link>
				<pubDate><![CDATA[Fri, 27 May 2011 11:26:10]]> GMT</pubDate>
				<author><![CDATA[ gurizbac]]></author>
			</item>
	</channel>
</rss>