[jira] [Updated] (CASSANDRA-11495) Rename of field in user defined type causes ArrayIndexOutOfBoundsException in select JSON *
[ https://issues.apache.org/jira/browse/CASSANDRA-11495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Timothy Wang updated CASSANDRA-11495: - Attachment: cassandra_log_output.txt Appended the error log output associated with this error. The final exception stack trace: ERROR 01:27:33 Unexpected exception during request java.lang.ArrayIndexOutOfBoundsException: 4 at org.apache.cassandra.db.marshal.UserType.toJSONString(UserType.java:212) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.selection.Selection$ResultSetBuilder.rowToJson(Selection.java:394) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.selection.Selection$ResultSetBuilder.getOutputRow(Selection.java:370) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.selection.Selection$ResultSetBuilder.build(Selection.java:357) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.statements.SelectStatement.process(SelectStatement.java:653) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.statements.SelectStatement.processResults(SelectStatement.java:387) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:340) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:214) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.statements.SelectStatement.execute(SelectStatement.java:76) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.QueryProcessor.processStatement(QueryProcessor.java:206) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:237) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.cql3.QueryProcessor.process(QueryProcessor.java:222) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.transport.messages.QueryMessage.execute(QueryMessage.java:115) ~[apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:507) [apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.transport.Message$Dispatcher.channelRead0(Message.java:401) [apache-cassandra-3.3.jar:3.3] at io.netty.channel.SimpleChannelInboundHandler.channelRead(SimpleChannelInboundHandler.java:105) [netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333) [netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext.access$700(AbstractChannelHandlerContext.java:32) [netty-all-4.0.23.Final.jar:4.0.23.Final] at io.netty.channel.AbstractChannelHandlerContext$8.run(AbstractChannelHandlerContext.java:324) [netty-all-4.0.23.Final.jar:4.0.23.Final] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511) [na:1.8.0_65] at org.apache.cassandra.concurrent.AbstractLocalAwareExecutorService$FutureTask.run(AbstractLocalAwareExecutorService.java:164) [apache-cassandra-3.3.jar:3.3] at org.apache.cassandra.concurrent.SEPWorker.run(SEPWorker.java:105) [apache-cassandra-3.3.jar:3.3] at java.lang.Thread.run(Thread.java:745) [na:1.8.0_65] > 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 Po
[jira] [Comment Edited] (CASSANDRA-11495) Rename of field in user defined type causes ArrayIndexOutOfBoundsException in select JSON *
[ https://issues.apache.org/jira/browse/CASSANDRA-11495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15225175#comment-15225175 ] Timothy Wang edited comment on CASSANDRA-11495 at 4/4/16 10:15 PM: --- For your convenience, here are 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; was (Author: timgojurn): 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"
[jira] [Commented] (CASSANDRA-11495) Rename of field in user defined type causes ArrayIndexOutOfBoundsException in select JSON *
[ https://issues.apache.org/jira/browse/CASSANDRA-11495?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=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)
[jira] [Created] (CASSANDRA-11495) Rename of field in user defined type causes ArrayIndexOutOfBoundsException in select JSON *
Timothy Wang created CASSANDRA-11495: Summary: 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: -- This message was sent by Atlassian JIRA (v6.3.4#6332)