Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0A481181D9 for ; Fri, 12 Jun 2015 07:21:06 +0000 (UTC) Received: (qmail 61918 invoked by uid 500); 12 Jun 2015 07:21:00 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 61884 invoked by uid 500); 12 Jun 2015 07:21:00 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 61873 invoked by uid 99); 12 Jun 2015 07:21:00 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 12 Jun 2015 07:21:00 +0000 Date: Fri, 12 Jun 2015 07:21:00 +0000 (UTC) From: "Tom van den Berge (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14583088#comment-14583088 ] Tom van den Berge commented on CASSANDRA-9582: ---------------------------------------------- {code} keyspace_name | columnfamily_name | column_name | component_index | index_name | index_options | index_type | type | validator ---------------+-------------------+--------------------+-----------------+------------+---------------+------------+----------------+--------------------------------------------- drillster | InvoiceItem | column1 | 0 | null | null | null | clustering_key | org.apache.cassandra.db.marshal.UUIDType drillster | InvoiceItem | currencyCode | null | null | null | null | regular | org.apache.cassandra.db.marshal.UTF8Type drillster | InvoiceItem | description | null | null | null | null | regular | org.apache.cassandra.db.marshal.UTF8Type drillster | InvoiceItem | key | null | null | null | null | partition_key | org.apache.cassandra.db.marshal.BytesType drillster | InvoiceItem | priceGross | null | null | null | null | regular | org.apache.cassandra.db.marshal.LongType drillster | InvoiceItem | priceNett | null | null | null | null | regular | org.apache.cassandra.db.marshal.LongType drillster | InvoiceItem | quantity | null | null | null | null | regular | org.apache.cassandra.db.marshal.IntegerType drillster | InvoiceItem | sku | null | null | null | null | regular | org.apache.cassandra.db.marshal.UTF8Type drillster | InvoiceItem | unitPriceGross | null | null | null | null | regular | org.apache.cassandra.db.marshal.LongType drillster | InvoiceItem | unitPriceNett | null | null | null | null | regular | org.apache.cassandra.db.marshal.LongType drillster | InvoiceItem | vat | null | null | null | null | regular | org.apache.cassandra.db.marshal.LongType drillster | InvoiceItem | vatRateBasisPoints | null | null | null | null | regular | org.apache.cassandra.db.marshal.IntegerType {code} {code} keyspace_name | columnfamily_name | bloom_filter_fp_chance | caching | column_aliases | comment | compaction_strategy_class | compaction_strategy_options | comparator | compression_parameters | default_time_to_live | default_validator | dropped_columns | gc_grace_seconds | index_interval | is_dense | key_aliases | key_validator | local_read_repair_chance | max_compaction_threshold | memtable_flush_period_in_ms | min_compaction_threshold | populate_io_cache_on_flush | read_repair_chance | replicate_on_write | speculative_retry | subcomparator | type | value_alias ---------------+-------------------+------------------------+-----------+----------------+---------+-----------------------------------------------------------------+-----------------------------+------------------------------------------+------------------------+----------------------+-------------------------------------------+-----------------+------------------+----------------+----------+-------------+-------------------------------------------+--------------------------+--------------------------+-----------------------------+--------------------------+----------------------------+--------------------+--------------------+-------------------+------------------------------------------+-------+------------- drillster | InvoiceItem | null | KEYS_ONLY | [] | | org.apache.cassandra.db.compaction.SizeTieredCompactionStrategy | {} | org.apache.cassandra.db.marshal.UUIDType | {} | 0 | org.apache.cassandra.db.marshal.BytesType | null | 864000 | 128 | False | [] | org.apache.cassandra.db.marshal.BytesType | 0 | 32 | 0 | 4 | False | 1 | True | 99.0PERCENTILE | org.apache.cassandra.db.marshal.UTF8Type | Super | null {code} > MarshalException after upgrading to 2.1.6 > ----------------------------------------- > > Key: CASSANDRA-9582 > URL: https://issues.apache.org/jira/browse/CASSANDRA-9582 > Project: Cassandra > Issue Type: Bug > Reporter: Tom van den Berge > > I've upgraded a node from 2.0.10 to 2.1.6. Before taking down the node, I've run nodetool upgradesstables and nodetool scrub. > When starting up the node with 2.1.6, I'm getting a MarshalException (stacktrace included below). For some reason, it seems that C* is trying to convert a text value from the column 'currencyCode' to a UUID, which it isn't. > I've had similar errors for two other columns as well, which I could work around by dropping the table, since it wasn't used anymore. > The only thing I could do was restoring a snapshot and starting up the old 2.0.10 again. > The schema of the table (I've got only one table containing a column named 'currencyCode') is: > {code} > CREATE TABLE "InvoiceItem" ( > key blob, > column1 uuid, > "currencyCode" text, > description text, > "priceGross" bigint, > "priceNett" bigint, > quantity varint, > sku text, > "unitPriceGross" bigint, > "unitPriceNett" bigint, > vat bigint, > "vatRateBasisPoints" varint, > PRIMARY KEY ((key), column1) > ) WITH COMPACT STORAGE AND > bloom_filter_fp_chance=0.010000 AND > caching='KEYS_ONLY' AND > comment='' AND > dclocal_read_repair_chance=0.000000 AND > gc_grace_seconds=864000 AND > index_interval=128 AND > read_repair_chance=1.000000 AND > replicate_on_write='true' AND > populate_io_cache_on_flush='false' AND > default_time_to_live=0 AND > speculative_retry='99.0PERCENTILE' AND > memtable_flush_period_in_ms=0 AND > compaction={'class': 'SizeTieredCompactionStrategy'} AND > compression={};{code} > The stack trace when starting up: > {code} > ERROR 13:51:57 Exception encountered during startup > org.apache.cassandra.serializers.MarshalException: unable to make version 1 UUID from 'currencyCode' > at org.apache.cassandra.db.marshal.UUIDType.fromString(UUIDType.java:188) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.db.marshal.AbstractCompositeType.fromString(AbstractCompositeType.java:242) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.ColumnDefinition.fromSchema(ColumnDefinition.java:397) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.CFMetaData.fromSchemaNoTriggers(CFMetaData.java:1750) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.java:1860) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:321) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.KSMetaData.fromSchema(KSMetaData.java:302) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.db.DefsTables.loadFromKeyspace(DefsTables.java:133) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.java:696) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.java:672) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:293) [apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:536) [apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:625) [apache-cassandra-2.1.6.jar:2.1.6] > Caused by: org.apache.cassandra.serializers.MarshalException: unable to coerce 'currencyCode' to a formatted date (long) > at org.apache.cassandra.serializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:111) ~[apache-cassandra-2.1.6.jar:2.1.6] > at org.apache.cassandra.db.marshal.UUIDType.fromString(UUIDType.java:184) ~[apache-cassandra-2.1.6.jar:2.1.6] > ... 12 common frames omitted > Caused by: java.text.ParseException: Unable to parse the date: currencyCode > at org.apache.commons.lang3.time.DateUtils.parseDateWithLeniency(DateUtils.java:336) ~[commons-lang3-3.1.jar:3.1] > at org.apache.commons.lang3.time.DateUtils.parseDateStrictly(DateUtils.java:286) ~[commons-lang3-3.1.jar:3.1] > at org.apache.cassandra.serializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:107) ~[apache-cassandra-2.1.6.jar:2.1.6] > ... 13 common frames omitted > org.apache.cassandra.serializers.MarshalException: unable to make version 1 UUID from 'currencyCode' > at org.apache.cassandra.db.marshal.UUIDType.fromString(UUIDType.java:188) > at org.apache.cassandra.db.marshal.AbstractCompositeType.fromString(AbstractCompositeType.java:242) > at org.apache.cassandra.config.ColumnDefinition.fromSchema(ColumnDefinition.java:397) > at org.apache.cassandra.config.CFMetaData.fromSchemaNoTriggers(CFMetaData.java:1750) > at org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.java:1860) > at org.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:321) > at org.apache.cassandra.config.KSMetaData.fromSchema(KSMetaData.java:302) > at org.apache.cassandra.db.DefsTables.loadFromKeyspace(DefsTables.java:133) > at org.apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.java:696) > at org.apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.java:672) > at org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:293) > at org.apache.cassandra.service.CassandraDaemon.activate(CassandraDaemon.java:536) > at org.apache.cassandra.service.CassandraDaemon.main(CassandraDaemon.java:625) > Caused by: org.apache.cassandra.serializers.MarshalException: unable to coerce 'currencyCode' to a formatted date (long) > at org.apache.cassandra.serializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:111) > at org.apache.cassandra.db.marshal.UUIDType.fromString(UUIDType.java:184) > ... 12 more > Caused by: java.text.ParseException: Unable to parse the date: currencyCode > at org.apache.commons.lang3.time.DateUtils.parseDateWithLeniency(DateUtils.java:336) > at org.apache.commons.lang3.time.DateUtils.parseDateStrictly(DateUtils.java:286) > at org.apache.cassandra.serializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:107) > ... 13 more > Exception encountered during startup: unable to make version 1 UUID from 'currencyCode'{code} -- This message was sent by Atlassian JIRA (v6.3.4#6332)