<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Drools-ant contains a task that can help you configure your Guvnor
    instances in a Jackrabbit cluster -&nbsp;
    <a class="moz-txt-link-freetext" href="http://blog.athico.com/2011/01/configuring-multiple-guvnor-instances.html">http://blog.athico.com/2011/01/configuring-multiple-guvnor-instances.html</a>
    . <br>
    <br>
    Hope this helps.<br>
    On 9/13/11 6:28 PM, puja nandamuri wrote:
    <blockquote
      cite="mid:1315952910.53766.YahooMailClassic@web33806.mail.mud.yahoo.com"
      type="cite">
      <table border="0" cellpadding="0" cellspacing="0">
        <tbody>
          <tr>
            <td style="font: inherit;" valign="top">Yes, the
              cluster_node.id has the same value for all guvnor&nbsp;
              instances which might have been created by jackrabbit
              automatically without the clustering information in the
              repository.xml.<br>
              <br>
              at this point, it looks like all I would need is the
              clustering setting in the repository.xml&nbsp; and that should
              create different cluster_node.ids.<br>
              <br>
              well atleast theoretically .<br>
              <br>
              Since my repository.xml stores workspace,repository and
              versioning information in the same sqlserver database, all
              I would need is to set the journal type settings in the
              repository.xml to use the database.<br>
              <br>
              <p class="line874">In order to use clustering, the
                following prerequisites must be met: <span
                  class="anchor" id="line-22"></span><span
                  class="anchor" id="line-23"></span></p>
              <ul>
                <li>Each cluster node must have its own repository
                  configuration. <span class="anchor" id="line-24"></span></li>
                <li>
                  <p class="line862">A <a moz-do-not-send="true"
                      href="http://wiki.apache.org/jackrabbit/DataStore">DataStore</a>
                    must always be shared between nodes, if used. <span
                      class="anchor" id="line-25"></span></p>
                </li>
                <li>
                  <p class="line862">The global <a
                      moz-do-not-send="true" class="nonexistent"
                      href="http://wiki.apache.org/jackrabbit/FileSystem">FileSystem</a>
                    on the repository level must be shared (only the one
                    that is on the same level as the data store; only in
                    the repository.xml file). <span class="anchor"
                      id="line-26"></span></p>
                </li>
                <li>
                  <p class="line862">Each cluster node needs its own
                    (private) workspace level and version <a
                      moz-do-not-send="true" class="nonexistent"
                      href="http://wiki.apache.org/jackrabbit/FileSystem">FileSystem</a>
                    (only those within the workspace and versioning
                    configuration; the ones in the repository.xml and
                    workspace.xml file). <span class="anchor"
                      id="line-27"></span></p>
                </li>
                <li>Each cluster node needs its own (private) Search
                  indexes. <span class="anchor" id="line-28"></span></li>
                <li>Every cluster node must be assigned a unique ID. <span
                    class="anchor" id="line-29"></span></li>
                <li>A journal type must be chosen, either based on files
                  or stored in a database. <span class="anchor"
                    id="line-30"></span></li>
                <li>Each cluster node must use the same (shared)
                  journal. <span class="anchor" id="line-31"></span></li>
                <li>
                  <p class="line862">The persistence managers must store
                    their data in the same, globally accessible location</p>
                </li>
              </ul>
              <br>
              anything else I might be missing ?<br>
              <br>
              <br>
              --- On <b>Tue, 9/13/11, Tihomir Surdilovic <i><a class="moz-txt-link-rfc2396E" href="mailto:tsurdilo@redhat.com">&lt;tsurdilo@redhat.com&gt;</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">&lt;tsurdilo@redhat.com&gt;</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: Tuesday, September 13, 2011, 1:29 PM<br>
                <br>
                <div id="yiv445070666"> On 9/13/11 4:13 PM, puja
                  nandamuri wrote:
                  <blockquote 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&nbsp; 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.&nbsp; 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
                    moz-do-not-send="true" rel="nofollow"
                    class="yiv445070666moz-txt-link-freetext"
                    target="_blank"
                    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 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&nbsp; 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
                                  moz-do-not-send="true" rel="nofollow"
class="yiv445070666moz-txt-link-rfc2396E"
                                  ymailto="mailto:tsurdilo@redhat.com"
                                  target="_blank"
                                  href="/mc/compose?to=tsurdilo@redhat.com">&lt;tsurdilo@redhat.com&gt;</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="yiv445070666moz-txt-link-rfc2396E"
                                ymailto="mailto:tsurdilo@redhat.com"
                                target="_blank"
                                href="/mc/compose?to=tsurdilo@redhat.com">&lt;tsurdilo@redhat.com&gt;</a><br>
                              Subject: Re: [rules-users] Guvnor
                              repository database use to store assets<br>
                              To: <a moz-do-not-send="true"
                                rel="nofollow"
                                class="yiv445070666moz-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: Friday, September 9, 2011, 12:06 PM<br>
                              <br>
                              <div id="yiv445070666"> 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>
                                &gt;&gt; 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&nbsp; 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:
                                &lt;&lt;<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:
                                &gt;&gt; The DBA had locked the userid
                                permissions to prevent any new table
                                creation in the Guvnor database.
                                &lt;&lt; <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="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span style="">&nbsp;&nbsp;&nbsp; </span>&lt;Workspace

                                              name="${wsp.name}"&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>&lt;!--</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>virtual

                                              file system of the
                                              workspace:</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>class:

                                              FQN of class implementing
                                              the FileSystem interface</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span>--&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;">&nbsp;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;">&nbsp;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;"><span style="">&nbsp;&nbsp;&nbsp; </span><span
                                                style="background:yellow;">&lt;FileSystem
class="org.apache.jackrabbit.core.fs.db.MSSqlFileSystem"&gt;</span></span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                              </span>&lt;param
                                              name="driver"
                                              value="javax.naming.InitialContext"/&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                              </span>&lt;param
                                              name="url"
                                              value="droolsRepositoryDataSource"/&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                              </span>&lt;param
                                              name="schema"
                                              value="mssql"/&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                              </span>&lt;param
                                              name="schemaObjectPrefix"
value="FS_WS_${wsp.name}_"/&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
                                              style="font-size:10pt;color:navy;background:none
                                              repeat scroll 0% 0%
                                              yellow;"><span style="">&nbsp;&nbsp;&nbsp;
                                              </span>&lt;/FileSystem&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
                                              style="font-size:10pt;color:navy;background:none
                                              repeat scroll 0% 0%
                                              yellow;"><br>
                                            </span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><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="yiv445070666MsoNormal"><br>
                                            <span
                                              style="font-size:10pt;color:navy;background:none
                                              repeat scroll 0% 0%
                                              yellow;"></span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
                                              style="font-size:10pt;color:navy;background:none
                                              repeat scroll 0% 0%
                                              yellow;"><br>
                                            </span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><br>
                                          </p>
                                          <p
                                            class="yiv445070666MsoNormal">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&nbsp;
                                            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="yiv445070666MsoNormal"><br>
                                          </p>
                                          <p
                                            class="yiv445070666MsoNormal">
                                          </p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;">&lt;FileSystem
class="org.apache.jackrabbit.core.fs.local.LocalFileSystem"&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                              </span>&lt;param
                                              name="path"
                                              value="${wsp.home}"/&gt;</span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><span
style="font-size:10.0pt;color:navy;background:yellow;"><span style="">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                              </span>&lt;/FileSystem&gt;</span><span
style="font-size:10.0pt;color:navy;"></span></p>
                                          <p
                                            class="yiv445070666MsoNormal"><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="yiv445070666moz-txt-link-rfc2396E">&lt;tsurdilo@redhat.com&gt;</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="yiv445070666moz-txt-link-rfc2396E">&lt;tsurdilo@redhat.com&gt;</a><br>
                                            Subject: Re: [rules-users]
                                            Guvnor repository database
                                            use to store assets<br>
                                            To: <a
                                              moz-do-not-send="true"
                                              rel="nofollow"
                                              class="yiv445070666moz-txt-link-abbreviated">rules-users@lists.jboss.org</a><br>
                                            Date: Tuesday, September 6,
                                            2011, 9:33 AM<br>
                                            <br>
                                            <div id="yiv445070666"> 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="">&nbsp; </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&nbsp; ?<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="yiv445070666moz-txt-link-rfc2396E">&lt;tsurdilo@redhat.com&gt;</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="yiv445070666moz-txt-link-rfc2396E">&lt;tsurdilo@redhat.com&gt;</a><br>
                                                          Subject: Re:
                                                          [rules-users]
                                                          Guvnor
                                                          repository
                                                          database use
                                                          to store
                                                          assets<br>
                                                          To: <a
                                                          moz-do-not-send="true"
                                                          rel="nofollow"
class="yiv445070666moz-txt-link-abbreviated">rules-users@lists.jboss.org</a><br>
                                                          Date: Monday,
                                                          September 5,
                                                          2011, 11:02 AM<br>
                                                          <br>
                                                          <div
                                                          id="yiv445070666">
                                                          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 &nbsp;a
                                                          freshly
                                                          compiled
                                                          Guvnor war
                                                          file(
                                                          everything
                                                          remaining the
                                                          same) &nbsp;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.&nbsp;</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.&nbsp;</div>
                                                          <div><br>
                                                          </div>
                                                          <div>&nbsp;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&eacute;ron
                                                          <i><a
                                                          moz-do-not-send="true"
                                                          rel="nofollow"
class="yiv445070666moz-txt-link-rfc2396E">&lt;nicolas.heron.java@gmail.com&gt;</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&eacute;ron <a
                                                          moz-do-not-send="true"
                                                          rel="nofollow"
class="yiv445070666moz-txt-link-rfc2396E">&lt;nicolas.heron.java@gmail.com&gt;</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="yiv445070666moz-txt-link-rfc2396E">&lt;rules-users@lists.jboss.org&gt;</a><br>
                                                          Date: Sunday,
                                                          September 4,
                                                          2011, 10:52 PM<br>
                                                          <br>
                                                          <div
                                                          id="yiv445070666">Hi,



                                                          <div><br>
                                                          <div
                                                          class="yiv445070666gmail_quote">
                                                          <blockquote
                                                          class="yiv445070666gmail_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>&nbsp;</div>
                                                          <div>May be it
                                                          is
                                                          recommended.
                                                          But when you
                                                          modify a lot
                                                          the assets,
                                                          rename, copy,
                                                          delete,etc..
                                                          Guvnor gets
                                                          lost.</div>
                                                          <div>&nbsp;</div>
                                                          <blockquote
                                                          class="yiv445070666gmail_quote"
                                                          style="margin:0
                                                          0 0
                                                          .8ex;border-left:1px
                                                          #ccc
                                                          solid;padding-left:1ex;">
                                                          <div>
                                                          <div
                                                          class="yiv445070666im">
                                                          <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.
                                                          &nbsp;I am using
                                                          5.3 snapshot
                                                          with MVEL
                                                          beta6 =&gt;
                                                          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.&nbsp;</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>&nbsp;</div>
                                                          <blockquote
                                                          class="yiv445070666gmail_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="yiv445070666plainMail">_______________________________________________<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="yiv445070666mimeAttachmentHeader"></fieldset>
                                                          <br>
                                                          <pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-txt-link-abbreviated">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-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="yiv445070666plainMail">_______________________________________________<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="yiv445070666mimeAttachmentHeader"></fieldset>
                                                <br>
                                                <pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-txt-link-abbreviated">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-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="yiv445070666plainMail">_______________________________________________<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="yiv445070666mimeAttachmentHeader"></fieldset>
                                  <br>
                                  <pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-txt-link-abbreviated">rules-users@lists.jboss.org</a>
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-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="yiv445070666plainMail">_______________________________________________<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="yiv445070666mimeAttachmentHeader"></fieldset>
                    <br>
                    <pre>_______________________________________________
rules-users mailing list
<a moz-do-not-send="true" rel="nofollow" class="yiv445070666moz-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="yiv445070666moz-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>