[jira] [Resolved] (CASSANDRA-6387) Prepared statements don't work with IBM Java

["Sylvain Lebresne (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/CASSANDRA-6387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Sylvain Lebresne resolved CASSANDRA-6387.
-----------------------------------------

       Resolution: Duplicate
    Reproduced In: 2.0.2, 1.2.11  (was: 1.2.11, 2.0.2)

This is not really related to IBM Java but is just another manifestation of CASSANDRA-6369. Basically, prepared statements are trashed from the cache way too easily which triggers the exception. It probably "works fine" with the Oracle JVM only because either it ends up starting with a bigger or the Oracle JVM just happen to have a smaller in-memory representation.

I highly suspect that if you try to prepare a bit more prepared statement with Oracle JVM you'll get the same exception.

> Prepared statements don't work with IBM Java
> --------------------------------------------
>
>                 Key: CASSANDRA-6387
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-6387
>             Project: Cassandra
>          Issue Type: Bug
>         Environment: SUSE Linux Enterprise Server 10, SP3. IBM Java 1.6.0 SR 13
>            Reporter: Michael Bock
>            Priority: Minor
>             Fix For: 1.2.11
>
>
> Starting with version 1.2.10, prepared statements don't work, if running Cassandra with IBM Java.
> For every prepared statement excution after a few one, we get the following error:
> com.netflix.astyanax.connectionpool.exceptions.BadRequestException: BadRequestException: [host=localhost(127.0.0.1):9160, latency=1(1), attempts=1]InvalidRequestException(why:Prepared query with ID 2077244094 not found (either the query was not prepared on this host (maybe the host has been restarted?) or you have prepared too many queries and it has been evicted from the internal cache))
> Astyanax version is 1.56.44.
> This error only occurs with IBM Java, with Oracle Java the same code works fine. 
> We did some investigation about the different Cassandra and JRE versions:
> Cassandra 1.2.9: works fine with any JRE-Version
> Cassandra 1.2.10, 1.2.11: does not work with IBM Java 1.6/1.7. Works find with Oracle Java 1.6/1.7
> Cassandra 2.0.0: works fine with any JRE-Version
> Cassandra 2.0.2: does not work with IBM Java 1.6/1.7. Works fine with Oracle Java 1.6/1.7



--
This message was sent by Atlassian JIRA
(v6.1#6144)