[infinispan-issues] [JBoss JIRA] (ISPN-3618) Cannot retrieve evicted entries from Microsoft SQL Server 2012/2008R2

[Jakub Markos (JIRA)]

    [ https://issues.jboss.org/browse/ISPN-3618?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12813426#comment-12813426 ] 

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