[
https://issues.jboss.org/browse/ISPN-3618?page=com.atlassian.jira.plugin....
]
Jakub Markos edited comment on ISPN-3618 at 10/11/13 9:54 AM:
--------------------------------------------------------------
This is the table from mysql55 (mssql looks the same):
select HEX(id),HEX(datum) from EDG_STRING_default;
| HEX(id) | HEX(datum)
|
| 3F39413039414A4141414141414141413D3D |
0301FE0367036A100301FE420A21034F4024000000000000036A220301FE0368FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03620003630000000000000001
|
| 3F39413039414E4141414141414141413D3D |
0301FE0367036A100301FE420A21034F4034000000000000036A220301FE0368FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03620003630000000000000002
|
| 3F3941303941506741414141414141413D3D |
0301FE0367036A100301FE420A21034F403E000000000000036A220301FE0368FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03620003630000000000000003
was (Author: jmarkos):
This is the table from mysql55:
select HEX(id),HEX(datum) from EDG_STRING_default;
| HEX(id) | HEX(datum)
|
| 3F39413039414A4141414141414141413D3D |
0301FE0367036A100301FE420A21034F4024000000000000036A220301FE0368FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03620003630000000000000001
|
| 3F39413039414E4141414141414141413D3D |
0301FE0367036A100301FE420A21034F4034000000000000036A220301FE0368FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03620003630000000000000002
|
| 3F3941303941506741414141414141413D3D |
0301FE0367036A100301FE420A21034F403E000000000000036A220301FE0368FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF03620003630000000000000003
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: Mircea Markus
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).
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see:
http://www.atlassian.com/software/jira