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
/<[email protected]>
</mc/[email protected]>/* wrote:
From: Nicolas Héron <[email protected]>
</mc/[email protected]>
Subject: Re: [rules-users] Guvnor repository database use to
store assets
To: "Rules Users List" <[email protected]>
</mc/[email protected]>
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-----
_______________________________________________
rules-users mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/rules-users
_______________________________________________
rules-users mailing list
[email protected] </mc/[email protected]>
https://lists.jboss.org/mailman/listinfo/rules-users
