[jira] [Commented] (CASSANDRA-11495) Rename of field in user defined type causes ArrayIndexOutOfBoundsException in select JSON *

2016-04-19 Thread Andreas Jaekle (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-11495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15247464#comment-15247464
 ] 

Andreas Jaekle commented on CASSANDRA-11495:


i upgraded just one node from 3.3 to 3.5 and the error disappeared on 
consistency level ALL
(cluster of 3 nodes with replication factor 3)

> Rename of field in user defined type causes ArrayIndexOutOfBoundsException in 
> select JSON *
> ---
>
> Key: CASSANDRA-11495
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11495
> Project: Cassandra
>  Issue Type: Bug
>  Components: CQL
>Reporter: Timothy Wang
> Attachments: cassandra_log_output.txt, error.cql
>
>
> Executing the attached error.cql causes 
> java.lang.ArrayIndexOutOfBoundsException. This reproduces 100% of the time in 
> my environment.
> nodetool -h localhost version
> objc[14803]: Class JavaLaunchHelper is implemented in both 
> /Library/Java/JavaVirtualMachines/jdk1.8.0_65.jdk/Contents/Home/bin/java and 
> /Library/Java/JavaVirtualMachines/jdk1.8.0_65.jdk/Contents/Home/jre/lib/libinstrument.dylib.
>  One of the two will be used. Which one is undefined.
> ReleaseVersion: 3.3
> cqlsh -f error.cql 
>  [json]
> -
>  {"list_id": "3ae31af7-e72b-11e5-9f1c-77e17196cbff", "card_id": 
> "b2f059bb-ecc0-11e5-937c-4760eea11554", "owner_id": 
> "8c02459b-dcaf-42dd-874a-41e19ba15075", "book_name": "Hop on Pop  (I Can Read 
> It All By Myself)", "publication_info": {"author": "Dr. Seuss", "publisher": 
> "Beginner Books / Random House", "creative_roles": [], "publication_date": 
> "1963-02-12"}}
> (1 rows)
> twangs-MacBook-Pro:migrations twang$ cqlsh -f error.cql 
>  peer | release_version
> --+-
> (0 rows)
>  release_version
> -
>  3.3
> (1 rows)
>  [json]
> -
>  {"list_id": "3ae31af7-e72b-11e5-9f1c-77e17196cbff", "card_id": 
> "b2f059bb-ecc0-11e5-937c-4760eea11554", "owner_id": 
> "8c02459b-dcaf-42dd-874a-41e19ba15075", "book_name": "Hop on Pop  (I Can Read 
> It All By Myself)", "publication_info": {"author": "Dr. Seuss", "publisher": 
> "Beginner Books / Random House", "creative_roles": [], "publication_date": 
> "1963-02-12"}}
> (1 rows)
> error.cql:49:ServerError:  message="java.lang.ArrayIndexOutOfBoundsException: 4">



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)


[jira] [Commented] (CASSANDRA-11495) Rename of field in user defined type causes ArrayIndexOutOfBoundsException in select JSON *

2016-04-04 Thread Timothy Wang (JIRA)

[ 
https://issues.apache.org/jira/browse/CASSANDRA-11495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15225175#comment-15225175
 ] 

Timothy Wang commented on CASSANDRA-11495:
--

For your convenience, here is the contents of the error.cql file:



SELECT peer, release_version FROM system.peers;
SELECT release_version FROM system.local;

DROP KEYSPACE error_test;

CREATE KEYSPACE error_test
WITH REPLICATION = { 'class' : 'SimpleStrategy', 'replication_factor' : 1 }
AND DURABLE_WRITES = false;

USE error_test;

CREATE TYPE error_test.publication_info (
  author varchar,
  publisher varchar,
  creative_roles list,
  publication_date varchar
);

CREATE TABLE error_test.list_media (
  list_id timeuuid,
  card_id timeuuid,
  owner_id varchar STATIC,
  book_name varchar,
  publication_info frozen,
  PRIMARY KEY((list_id), card_id)
) WITH CLUSTERING ORDER BY (card_id DESC);

INSERT INTO error_test.list_media JSON '{
"list_id": "3ae31af7-e72b-11e5-9f1c-77e17196cbff",
"card_id": "b2f059bb-ecc0-11e5-937c-4760eea11554",
"owner_id": "8c02459b-dcaf-42dd-874a-41e19ba15075",
"book_name": "Hop on Pop  (I Can Read It All By Myself)",
"publication_info": {
"author": "Dr. Seuss",
"publisher": "Beginner Books / Random House",
"creative_roles": [],
"publication_date": "1963-02-12"}
}';

SELECT JSON * from error_test.list_media WHERE 
list_id=3ae31af7-e72b-11e5-9f1c-77e17196cbff;

ALTER TYPE error_test.publication_info rename publication_date to release_date;
ALTER TYPE error_test.publication_info add director varchar;
ALTER TYPE error_test.publication_info add creator varchar;
ALTER TYPE error_test.publication_info add brand varchar;

SELECT JSON * from error_test.list_media WHERE 
list_id=3ae31af7-e72b-11e5-9f1c-77e17196cbff;



> Rename of field in user defined type causes ArrayIndexOutOfBoundsException in 
> select JSON *
> ---
>
> Key: CASSANDRA-11495
> URL: https://issues.apache.org/jira/browse/CASSANDRA-11495
> Project: Cassandra
>  Issue Type: Bug
>  Components: CQL
>Reporter: Timothy Wang
> Attachments: error.cql
>
>
> Executing the attached error.cql causes 
> java.lang.ArrayIndexOutOfBoundsException. This reproduces 100% of the time in 
> my environment.
> nodetool -h localhost version
> objc[14803]: Class JavaLaunchHelper is implemented in both 
> /Library/Java/JavaVirtualMachines/jdk1.8.0_65.jdk/Contents/Home/bin/java and 
> /Library/Java/JavaVirtualMachines/jdk1.8.0_65.jdk/Contents/Home/jre/lib/libinstrument.dylib.
>  One of the two will be used. Which one is undefined.
> ReleaseVersion: 3.3
> cqlsh -f error.cql 
>  [json]
> -
>  {"list_id": "3ae31af7-e72b-11e5-9f1c-77e17196cbff", "card_id": 
> "b2f059bb-ecc0-11e5-937c-4760eea11554", "owner_id": 
> "8c02459b-dcaf-42dd-874a-41e19ba15075", "book_name": "Hop on Pop  (I Can Read 
> It All By Myself)", "publication_info": {"author": "Dr. Seuss", "publisher": 
> "Beginner Books / Random House", "creative_roles": [], "publication_date": 
> "1963-02-12"}}
> (1 rows)
> twangs-MacBook-Pro:migrations twang$ cqlsh -f error.cql 
>  peer | release_version
> --+-
> (0 rows)
>  release_version
> -
>  3.3
> (1 rows)
>  [json]
> -
>  {"list_id": "3ae31af7-e72b-11e5-9f1c-77e17196cbff", "card_id": 
> "b2f059bb-ecc0-11e5-937c-4760eea11554", "owner_id": 
> "8c02459b-dcaf-42dd-874a-41e19ba15075", "book_name": "Hop on Pop  (I Can Read 
> It All By Myself)", "publication_info": {"author": "Dr. Seuss", "publisher": 
> "Beginner Books / Random House", "creative_roles": [], "publication_date": 
> "1963-02-12"}}
> (1 rows)
> error.cql:49:ServerError:  message="java.lang.ArrayIndexOutOfBoundsException: 4">



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)