<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
On 9/13/11 4:13 PM, puja nandamuri wrote:
<blockquote
cite="mid:1315944791.80262.YahooMailClassic@web33806.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font: inherit;" valign="top">Initially, we had
Guvnor deployed to only one instance of weblogic and using
the database to store workspace, repository and versioning
information in the database . This configuration was
generated using the Manage Repository configuration
option in Guvnor <br>
<br>
later, Guvnor was mistakenly deployed to more than one
instance of weblogic in a cluster , but each of the Guvnor
using the same database through jndi datasource.<br>
<br>
The repository.xml remained the same without any
clustering setup.<br>
<br>
Now, we see that each Guvnor instance has created a
cluster_node.id file and also a revision.log file on the
local file system.<br>
<br>
could the multiple instances of Guvnor created a need for
jackrabbit to recreate/update the Table ? <br>
</td>
</tr>
</tbody>
</table>
</blockquote>
<br>
Yes this is very well possible. If the Jackrabbit instance thinks it
is a node in a Jackrabbit cluster, it will create and maintain its
own tables while also sharing its local data with the shared
journal. I did not think that this would happen automatically
without specifying the clustering information in each of the
instances repository.xml files ( see more here:
<a class="moz-txt-link-freetext" href="http://wiki.apache.org/jackrabbit/Clustering">http://wiki.apache.org/jackrabbit/Clustering</a>). It seems in your case
jackrabbit clustering seems to happen on it's own?<br>
<br>
<blockquote
cite="mid:1315944791.80262.YahooMailClassic@web33806.mail.mud.yahoo.com"
type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font: inherit;" valign="top"><br>
we see that this Table FS_WS_DEFAULT_FSENTRY seems to have
been recreated /updated after the permissions for the
Guvnor database user was changed back to db_owner from
db_datareader and db_datawriter.<br>
<br>
Could the multiple instances of Guvnor one each in a
weblogic cluster setup have required changes to the Table
structure ?<br>
<br>
As always,Thank you for your feedback .<br>
<br>
--- On <b>Fri, 9/9/11, Tihomir Surdilovic <i><a class="moz-txt-link-rfc2396E" href="mailto:tsurdilo@redhat.com"><tsurdilo@redhat.com></a></i></b>
wrote:<br>
<blockquote style="border-left: 2px solid rgb(16, 16,
255); margin-left: 5px; padding-left: 5px;"><br>
From: Tihomir Surdilovic <a class="moz-txt-link-rfc2396E" href="mailto:tsurdilo@redhat.com"><tsurdilo@redhat.com></a><br>
Subject: Re: [rules-users] Guvnor repository database
use to store assets<br>
To: <a class="moz-txt-link-abbreviated" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
Date: Friday, September 9, 2011, 12:06 PM<br>
<br>
<div id="yiv1832352979"> If you choose to store your
repository in an external db, then you should do it in
all places of your repository.xml. Mixing the file
system with external db in repository.xml is not
recommended. <br>
<br>
Regarding:<br>
>> we have another Guvnor which uses the
following setting for workspace.This seems to be
working without any issues when we delete the
workspace and repository directory and deploying
Guvnor again. it is likely that this setting does not
store workspace information in the database and hence
does not need to create additional tables? <br>
On 9/9/11 1:07 PM, puja nandamuri wrote: <<<br>
Well of course, If you use the LocalFileSystem, you
are not using your external database. The root of your
initial problem was as you mentioned: >> The DBA
had locked the userid permissions to prevent any new
table creation in the Guvnor database. << <br>
Also mentioned previously was that Jackrabbit will
create the tables in an external db only the first
time, so any consequent start will not as the tables
already exist. Also was mentioned that Jackrabbit will
still try to query the table metadata, and for you to
make sure the db user you specify in your
DroolsRepositoryDatasource config has the permissions
to do that.<br>
<br>
I would look on your end for couple of things:<br>
1) What repository.xml file is being accessed by
Guvnor when you deploy a new war? Is it really the one
you think it should?<br>
2) Check with your DBA so he can play with permissions
to see what is the least amount of permissions he can
give your db user in order for this to work.<br>
3) Check if this could be related to you importing a
repository xml file after re-deployment. AFAIK this
operation should not create any new tables, but you
could check.<br>
<br>
Since Jackrabbit has it's own db schema, I do not
really see a need to "lock down" permissions of the
user. Not sure why this is necessary on your end
tobegin with. Could you explain?<br>
<br>
Thanks.<br>
<br>
<blockquote type="cite">
<table border="0" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="font:inherit;" valign="top">I got
some additional details on the issue. i
would appreciate some advice on whether I
should be storing the workspace to a local
file system or database .<br>
<br>
In my repository.xml, I have the following
setting for the workspace file system.<br>
<br>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span
style=""> </span><Workspace
name="${wsp.name}"></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span
style=""> </span><!--</span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span
style=""> </span>virtual
file system of the workspace:</span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span
style=""> </span>class:
FQN of class implementing the FileSystem
interface</span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span
style=""> </span>--></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"> </span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"> </span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span
style=""> </span><span style="
background:yellow;"><FileSystem
class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem"></span></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span
style=""> </span><param
name="driver"
value="javax.naming.InitialContext"/></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span
style=""> </span><param
name="url"
value="droolsRepositoryDataSource"/></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span
style=""> </span><param
name="schema" value="mssql"/></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span
style=""> </span><param
name="schemaObjectPrefix"
value="FS_WS_${wsp.name}_"/></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10pt;color:navy;background:none
repeat scroll 0% 0% yellow;"><span
style=""> </span></FileSystem></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10pt;color:navy;background:none
repeat scroll 0% 0% yellow;"><br>
</span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10pt;color:navy;background:none
repeat scroll 0% 0% yellow;">Is it
likely that because Guvnor seems to be
storing the workspace information in the
database , it is trying to create the
database tables again for workspace
during guvnor restart after deleting
workspace and repository directories on
file system?</span></p>
<p class="yiv1832352979MsoNormal"><br>
<span style="font-size:10pt;
color:navy;background:none repeat scroll
0% 0% yellow;"></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10pt;color:navy;background:none
repeat scroll 0% 0% yellow;"><br>
</span></p>
<p class="yiv1832352979MsoNormal"><br>
</p>
<p class="yiv1832352979MsoNormal">we have
another Guvnor which uses the following
setting for workspace.This seems to be
working without any issues when we delete
the workspace and repository directory
and deploying Guvnor again. it is likely
that this setting does not store workspace
information in the database and hence does
not need to create additional tables?<br>
</p>
<p class="yiv1832352979MsoNormal"><br>
</p>
<p class="yiv1832352979MsoNormal"> </p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span
style=""> </span><param
name="path" value="${wsp.home}"/></span></p>
<p class="yiv1832352979MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span
style=""> </span></FileSystem></span><span
style="font-size:10.0pt;color:navy;"></span></p>
<p class="yiv1832352979MsoNormal"><br>
<span
style="font-size:10.0pt;color:navy;background:yellow;"></span><span
style="font-size:10.0pt;color:navy;"></span></p>
<br>
<br>
--- On <b>Tue, 9/6/11, Tihomir Surdilovic <i><a
moz-do-not-send="true" rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"
ymailto="mailto:tsurdilo@redhat.com"
target="_blank"
href="/mc/compose?to=tsurdilo@redhat.com"><tsurdilo@redhat.com></a></i></b>
wrote:<br>
<blockquote style="border-left:2px solid
rgb(16, 16,
255);margin-left:5px;padding-left:5px;"><br>
From: Tihomir Surdilovic <a
moz-do-not-send="true" rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"
ymailto="mailto:tsurdilo@redhat.com"
target="_blank"
href="/mc/compose?to=tsurdilo@redhat.com"><tsurdilo@redhat.com></a><br>
Subject: Re: [rules-users] Guvnor
repository database use to store assets<br>
To: <a moz-do-not-send="true"
rel="nofollow"
class="yiv1832352979moz-txt-link-abbreviated"
ymailto="mailto:rules-users@lists.jboss.org" target="_blank"
href="/mc/compose?to=rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
Date: Tuesday, September 6, 2011, 9:33 AM<br>
<br>
<div id="yiv1832352979"> All Jackrabbit
template ddl files are in the
jackrabbit-core jar. That would be a
good place to start. <br>
<br>
Thanks.<br>
On 9/6/11 12:18 PM, puja nandamuri
wrote:
<blockquote type="cite">
<table border="0" cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<td style="font:inherit;"
valign="top">the account
configured for the repository
database has the following
change of permissions after
the intial tables creation by
Guvnor.<br>
<br>
<span
style="font-size:11.0pt;color:#1F497D;">changed
db_owner to db_datareader,<span
style=""> </span>db_datawriter
and as usual, it has public
rights</span>.<br>
<br>
I am not an database expert
but, should not the above
permissions allow for (
DatabaseMetaData#getTables) ?<br>
<br>
any pointers on what exactly
might be the sql used in this
case ?<br>
<br>
Thanks,<br>
<br>
Ram<br>
<br>
--- On <b>Mon, 9/5/11,
Tihomir Surdilovic <i><a
moz-do-not-send="true"
rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"><tsurdilo@redhat.com></a></i></b>
wrote:<br>
<blockquote
style="border-left:2px solid
rgb(16, 16,
255);margin-left:5px;padding-left:5px;"><br>
From: Tihomir Surdilovic <a
moz-do-not-send="true"
rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"><tsurdilo@redhat.com></a><br>
Subject: Re: [rules-users]
Guvnor repository database
use to store assets<br>
To: <a
moz-do-not-send="true"
rel="nofollow"
class="yiv1832352979moz-txt-link-abbreviated">rules-users@lists.jboss.org</a><br>
Date: Monday, September 5,
2011, 11:02 AM<br>
<br>
<div id="yiv1832352979">
Jackrabbit will not try to
create any new tables
after it initially created
them. However it does call
a
*PersistenceManager.checkSchema()
method which AFAIK tries
to read from the db
metadata (
DatabaseMetaData#getTables).
If the user does not have
permissions to do that, it
will fail which I think is
the case in your scenario.<br>
<br>
Thanks.<br>
On 9/5/11 1:04 PM, puja
nandamuri wrote:
<blockquote type="cite">
<table border="0"
cellpadding="0"
cellspacing="0">
<tbody>
<tr>
<td
style="font:inherit;"
valign="top">Hi,
<div><br>
</div>
<div>Sorry, I
think the
original
question I had
asked still
seems to have
been
unanswered.</div>
<div><br>
</div>
<div>This is the
question I
had.</div>
<div><br>
</div>
<div>does Guvnor
keep creating
additional
tables as per
the need or is
the Table
structure that
Guvnor creates
in the
beginning
where all the
assets are
stored remains
the same until
we manually
delete the
Tables?</div>
<div><br>
</div>
<div><br>
</div>
<div>after
creating rules
and assets for
several days,
we had to re
deploy a
freshly
compiled
Guvnor war
file(
everything
remaining the
same) using
the same
repository xml
and same
database
connected
through jndi
datasource.</div>
<div><br>
</div>
<div>In other
words, just
the war file
has been
recompiled. we
also deleted
the workspace
and repository
directories
previously
created by
Guvnor. </div>
<div><br>
</div>
<div>The DBA had
locked the
userid
permissions to
prevent any
new table
creation in
the Guvnor
database.</div>
<div><br>
</div>
<div>During
Guvnor
startup,
Guvnor had
complained
about not
having
permission to
create Tables.</div>
<div><br>
</div>
<div>My question
is :</div>
<div><br>
</div>
<div>why does
Guvnor need to
create any
additional
tables and not
use the
existing Table
structure in
the database. </div>
<div><br>
</div>
<div> I would
appreciate any
thoughts on
this.</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
</div>
<div><br>
<br>
--- On <b>Sun,
9/4/11,
Nicolas Héron
<i><a
moz-do-not-send="true"
rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"><nicolas.heron.java@gmail.com></a></i></b>
wrote:<br>
<blockquote
style="border-left:2px
solid rgb(16,
16,
255);margin-left:5px;padding-left:5px;"><br>
From: Nicolas
Héron <a
moz-do-not-send="true"
rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"><nicolas.heron.java@gmail.com></a><br>
Subject: Re:
[rules-users]
Guvnor
repository
database use
to store
assets<br>
To: "Rules
Users List" <a
moz-do-not-send="true" rel="nofollow"
class="yiv1832352979moz-txt-link-rfc2396E"><rules-users@lists.jboss.org></a><br>
Date: Sunday,
September 4,
2011, 10:52 PM<br>
<br>
<div
id="yiv1832352979">Hi,
<div><br>
<div
class="yiv1832352979gmail_quote">
<blockquote
class="yiv1832352979gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex;">
<div>Sorry,
but you do not
have to delete
the workspace
directory. Not
sure where you
are getting
this from? In
cases where
you have a
large number
of
packages/assets
in Guvnor it
is rather
recommended
_not_ to
delete the
search indexes
written onto
the file
system,
because it
takes extra
time to
re-create
them. <br>
</div>
</blockquote>
<div> </div>
<div>May be it
is
recommended.
But when you
modify a lot
the assets,
rename, copy,
delete,etc..
Guvnor gets
lost.</div>
<div> </div>
<blockquote
class="yiv1832352979gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex;">
<div>
<div
class="yiv1832352979im">
<blockquote
type="cite">
<div>At
startup,
Jackrabbit
(containent in
Guvnor) reads
all the
database and
creates the
two
directories.
You do not
need to backup
them.</div>
</blockquote>
</div>
Again, I don't
know where you
are getting
this from.
Jackrabbit
does _not_
read the
entire DB on
startup and
does not write
any of the JCR
content stored
in an RDBMS to
the file
system if you
have
configured it
to store to
the RDBMS. If
you for any
weird reason
are seeing
this on your
end, you
should really
have another
look at your
repository.xml.<br>
</div>
</blockquote>
<div><br>
</div>
<div><br>
</div>
<div>The
search
indexes, they
are stored on
the file
system no ?
And with no
index, you
cannot reach
any of the
assets. So
when you
delete thoses
directories,
at startup,
they are
re-created and
the database
is read. I do
not know what
is read, but
it can take
quite some
times,
depending on
the size of
the package.
Now If there
is a way to
store thoses
indexes in the
database, I
would be happy
to know how.</div>
<div><br>
</div>
<div>The
project I am
on has many
rules and many
big web
decision
tables that
end up with
more than
100000 rules.
I am using
5.3 snapshot
with MVEL
beta6 =>
Startup time
=5 minutes and
building the
package, 3 to
5 minutes on a
HP G6
processor. On
my PC that has
an i5
processor and
a 32 bits
linux, I
cannot build
anymore the
package. </div>
<div>With
those sizes,
which is not
that much,
Guvnor/jackrabbits
gets lots on
the indexes :
it gives
jackrabbit
exceptioorn or
spaces are not
considered. So
then, what I
do is delete
those two
directories
and restart
guvnor and
everything is
fine again.</div>
<div>Thanks</div>
<div>Nicolas</div>
<div> </div>
<blockquote
class="yiv1832352979gmail_quote"
style="margin:0
0 0
.8ex;border-left:1px
#ccc
solid;padding-left:1ex;">
<div> <br>
</div>
</blockquote>
</div>
</div>
</div>
<br>
-----Inline
Attachment
Follows-----<br>
<br>
<div
class="yiv1832352979plainMail">_______________________________________________<br>
rules-users
mailing list<br>
<a
moz-do-not-send="true"
rel="nofollow">rules-users@lists.jboss.org</a><br>
<a
moz-do-not-send="true"
rel="nofollow"
target="_blank"
href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div>
</blockquote>
</div>
</td>
</tr>
</tbody>
</table>
<br>
<fieldset
class="yiv1832352979mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv1832352979moz-txt-link-abbreviated">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv1832352979moz-txt-link-freetext" target="_blank" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</div>
<br>
-----Inline Attachment
Follows-----<br>
<br>
<div
class="yiv1832352979plainMail">_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
rel="nofollow">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true"
rel="nofollow"
target="_blank"
href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div>
</blockquote>
</td>
</tr>
</tbody>
</table>
<br>
<fieldset
class="yiv1832352979mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv1832352979moz-txt-link-abbreviated">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv1832352979moz-txt-link-freetext" target="_blank" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="yiv1832352979plainMail">_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true" rel="nofollow">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true" rel="nofollow"
target="_blank"
href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div>
</blockquote>
</td>
</tr>
</tbody>
</table>
<br>
<fieldset class="yiv1832352979mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv1832352979moz-txt-link-abbreviated" ymailto="mailto:rules-users@lists.jboss.org" target="_blank" href="/mc/compose?to=rules-users@lists.jboss.org">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv1832352979moz-txt-link-freetext" target="_blank" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</div>
<br>
-----Inline Attachment Follows-----<br>
<br>
<div class="plainMail">_______________________________________________<br>
rules-users mailing list<br>
<a moz-do-not-send="true"
ymailto="mailto:rules-users@lists.jboss.org"
href="/mc/compose?to=rules-users@lists.jboss.org">rules-users@lists.jboss.org</a><br>
<a moz-do-not-send="true"
href="https://lists.jboss.org/mailman/listinfo/rules-users"
target="_blank">https://lists.jboss.org/mailman/listinfo/rules-users</a><br>
</div>
</blockquote>
</td>
</tr>
</tbody>
</table>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
rules-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:rules-users@lists.jboss.org">rules-users@lists.jboss.org</a>
<a class="moz-txt-link-freetext" href="https://lists.jboss.org/mailman/listinfo/rules-users">https://lists.jboss.org/mailman/listinfo/rules-users</a>
</pre>
</blockquote>
<br>
</body>
</html>