Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-1841

jdbc store fails if we use cache-index-storage and cache-binary-storage

    XMLWordPrintable

Details

    • Bug
    • Resolution: Cannot Reproduce
    • Blocker
    • 3.2.0.Final
    • 3.1.3.Final
    • Query, Storage
    • None

    Description

      ModeShape configuration:

                  <repository name="sample">
                      <authenticators>
                          <authenticator name="gatein-wcm-security" classname="org.gatein.wcm.impl.security.WcmModeShapeProvider"/>
                      </authenticators>
                      <cache-index-storage data-cache-name="index_data" cache-container="index_cache_container"/>
                      <cache-binary-storage data-cache-name="binary_fs" metadata-cache-name="binary_fs_meta" cache-container="binary_cache_container"/>
                  </repository>
      

      Infinispan configuration:

                  <cache-container name="modeshape" default-cache="sample">
                      <local-cache name="sample">
                          <transaction mode="NON_XA" locking="PESSIMISTIC"/>
                          <string-keyed-jdbc-store datasource="java:jboss/datasources/PostgresqlDS" shared="false" preload="false" passivation="false" purge="false">
                              <write-behind flush-lock-timeout="1" modification-queue-size="1024" shutdown-timeout="25000" thread-pool-size="1"/>
                              <property name="databaseType">
                                  POSTGRES
                              </property>
                              <string-keyed-table prefix="wcm_content">
                                  <id-column name="id" type="VARCHAR(200)"/>
                                  <data-column name="datum" type="BYTEA"/>
                                  <timestamp-column name="version" type="BIGINT"/>
                              </string-keyed-table>
                          </string-keyed-jdbc-store>
                      </local-cache>
                      <local-cache name="artifacts">
                          <transaction mode="NON_XA"/>
                          <file-store relative-to="jboss.server.data.dir" path="modeshape/store/artifacts" passivation="false" purge="false"/>
                      </local-cache>
                  </cache-container>
                  <cache-container name="index_cache_container" default-cache="index_data">
                      <local-cache name="index_data" batching="true">
                          <transaction mode="NON_XA"/>
                          <string-keyed-jdbc-store datasource="java:jboss/datasources/PostgresqlDS" shared="false" preload="false" passivation="false" purge="false">
                              <write-behind flush-lock-timeout="1" modification-queue-size="1024" shutdown-timeout="25000" thread-pool-size="1"/>
                              <property name="databaseType">
                                  POSTGRES
                              </property>
                              <string-keyed-table prefix="wcm_content">
                                  <id-column name="id" type="VARCHAR(200)"/>
                                  <data-column name="datum" type="BYTEA"/>
                                  <timestamp-column name="version" type="BIGINT"/>
                              </string-keyed-table>
                          </string-keyed-jdbc-store>
                      </local-cache>
                  </cache-container>
                  <cache-container name="binary_cache_container" default-cache="binary_fs">
                      <local-cache name="binary_fs">
                          <transaction mode="NON_XA"/>
                          <string-keyed-jdbc-store datasource="java:jboss/datasources/PostgresqlDS" shared="false" preload="false" passivation="false" purge="false">
                              <write-behind flush-lock-timeout="1" modification-queue-size="1024" shutdown-timeout="25000" thread-pool-size="1"/>
                              <property name="databaseType">
                                  POSTGRES
                              </property>
                              <string-keyed-table prefix="wcm_content">
                                  <id-column name="id" type="VARCHAR(200)"/>
                                  <data-column name="datum" type="BYTEA"/>
                                  <timestamp-column name="version" type="BIGINT"/>
                              </string-keyed-table>
                          </string-keyed-jdbc-store>
                      </local-cache>
                      <local-cache name="binary_fs_meta">
                          <transaction mode="NON_XA"/>
                          <eviction strategy="LRU" max-entries="100"/>
                          <expiration max-idle="5000" lifespan="10000" interval="1000"/>
                          <string-keyed-jdbc-store datasource="java:jboss/datasources/PostgresqlDS" shared="false" preload="false" passivation="false" purge="false">
                              <write-behind flush-lock-timeout="1" modification-queue-size="1024" shutdown-timeout="25000" thread-pool-size="1"/>
                              <property name="databaseType">
                                  POSTGRES
                              </property>
                              <string-keyed-table prefix="wcm_content">
                                  <id-column name="id" type="VARCHAR(200)"/>
                                  <data-column name="datum" type="BYTEA"/>
                                  <timestamp-column name="version" type="BIGINT"/>
                              </string-keyed-table>
                          </string-keyed-jdbc-store>
                      </local-cache>
                  </cache-container>
      

      Having some exceptions in binary and index cache storage.

      Repeating same test without jdbc storage in infinispan, just memory, example works fine.

      Test example is a mix of creating folders, file and updating binary content.

      I will update the full configuration and full log in the case

      Attachments

        Activity

          People

            hchiorean Horia Chiorean (Inactive)
            lponce@redhat.com Lucas Ponce
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: