| Hi,
Sorry, I think the original question I
had asked still seems to have been
unanswered.
This is the question I had.
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?
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.
In other words, just the war file has
been recompiled. we also deleted the
workspace and repository directories
previously created by Guvnor.
The DBA had locked the userid
permissions to prevent any new table
creation in the Guvnor database.
During Guvnor startup, Guvnor had
complained about not having permission to
create Tables.
My question is :
why does Guvnor need to create any
additional tables and not use the existing
Table structure in the database.
I would appreciate any thoughts on
this.
--- On Sun, 9/4/11, Nicolas Héron <nicolas.heron.java@gmail.com>
wrote:
From: Nicolas Héron <nicolas.heron.java@gmail.com>
Subject: Re: [rules-users] Guvnor
repository database use to store assets
To: "Rules Users List" <rules-users@lists.jboss.org>
Date: Sunday, September 4, 2011, 10:52
PM
Hi,
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.
May be it is recommended. But
when you modify a lot the
assets, rename, copy,
delete,etc.. Guvnor gets lost.
At startup,
Jackrabbit (containent
in Guvnor) reads all the
database and creates the
two directories. You do
not need to backup them.
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.
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.
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.
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.
Thanks
Nicolas
-----Inline Attachment Follows-----
|