Uploaded image for project: 'Infinispan'
  1. Infinispan
  2. ISPN-3618

Cannot retrieve evicted entries from Microsoft SQL Server 2012/2008R2

    XMLWordPrintable

Details

    Description

      When using this configuration:

      <local-cache name="default" start="EAGER" batching="false">
          <locking isolation="READ_COMMITTED" acquire-timeout="20000" concurrency-level="500" striping="false" />
          <transaction mode="NONE" />
          <eviction strategy="LRU" max-entries="2"/>
          <string-keyed-jdbc-store name="defaultStoreName" datasource="java:jboss/datasources/JdbcDS" passivation="false" preload="true" purge="false">
              <string-keyed-table prefix="EDG_STRING">
                  <id-column name="id" type="VARCHAR(255)"/>
                  <data-column name="datum" type="VARBINARY(1000)"/>
                  <timestamp-column name="version" type="BIGINT"/>
              </string-keyed-table>
          </string-keyed-jdbc-store>
      </local-cache>
      

      and running this code:

      RemoteCache<Object, Object> cache = new RemoteCacheManager(conf).getCache();
      cache.clear();
      cache.put(new Double(10), new Double(10));
      cache.put(new Double(20), new Double(20));
      cache.put(new Double(30), new Double(30)); // key 10 is evicted
      System.out.println(cache.get(new Double(10)));
      System.out.println(cache.get(new Double(20)));
      System.out.println(cache.get(new Double(30)));
      

      output:

      null
      20.0
      30.0

      Attached are logs for mssql2012 and mysql55 (where it works).

      Attachments

        Issue Links

          Activity

            People

              remerson@redhat.com Ryan Emerson
              jmarkos Jakub Markos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: