]
Tristan Tarrant updated ISPN-3618:
----------------------------------
Status: Resolved (was: Pull Request Sent)
Fix Version/s: 9.0.0.Beta2
9.0.0.Final
Resolution: Done
Cannot retrieve evicted entries from Microsoft SQL Server
2012/2008R2
---------------------------------------------------------------------
Key: ISPN-3618
URL:
https://issues.jboss.org/browse/ISPN-3618
Project: Infinispan
Issue Type: Bug
Components: Loaders and Stores, Server
Affects Versions: 6.0.0.CR1
Reporter: Jakub Markos
Assignee: Ryan Emerson
Fix For: 9.0.0.Beta2, 9.0.0.Final
Attachments: server_mssql2012_mysql55.log.zip
When using this configuration:
{code:xml}
<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>
{code}
and running this code:
{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)));
{code}
output:
{quote}
null
20.0
30.0
{quote}
Attached are logs for mssql2012 and mysql55 (where it works).