[jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6
[
https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14635542#comment-14635542
]
Aleksey Yeschenko commented on CASSANDRA-9582:
--
The ticket reference in the comment is wrong (9562 is not this ticket) - make
it #9582. Otherwise +1.
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
Assignee: Sylvain Lebresne
Fix For: 2.1.x
Attachments: 9582.txt
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.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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
[jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6
[
https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14635559#comment-14635559
]
Aleksey Yeschenko commented on CASSANDRA-9582:
--
[~philipthompson] How come our upgrade tests aren't catching this? (or, weren't
catching this) I thought we had some Thrift coverage in there. If not, can we
add some? Thanks.
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
Assignee: Sylvain Lebresne
Fix For: 2.1.x
Attachments: 9582.txt
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.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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)
[jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6
[
https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14635157#comment-14635157
]
Michael Frisch commented on CASSANDRA-9582:
---
I have the same problem and did some digging because it worked in our one
environment but not another. Note that this is a column definition within a
super column family, same as the other user is experiencing.
Here's the row key and the super column definitions, it's the same in both
environments:
MyKeyspace | MyColumnFamily | key | null | null | null | null | partition_key |
org.apache.cassandra.db.marshal.TimeUUIDType
MyKeyspace | MyColumnFamily | column1 | 0 | null | null | null | clustering_key
| org.apache.cassandra.db.marshal.TimeUUIDType
Broken column definition:
MyKeyspace | MyColumnFamily | MyColumn | null | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
Working column definition:
MyKeyspace | MyColumnFamily | MyColumn | 1 | null | null | null | regular |
org.apache.cassandra.db.marshal.UTF8Type
Note that the only difference between working and broken is that component
index is set to 1 instead of null. Which brings me to ask about the code in
ColumnDefinition.java. It would seem to me that the logic for public static
ListColumnDefinition fromSchema(...) is broken.
Original component index code (starting at line 389 in v2.1.8):
if (row.has(COMPONENT_INDEX))
componentIndex = row.getInt(COMPONENT_INDEX);
else if (kind == Kind.CLUSTERING_COLUMN isSuper)
componentIndex = 1; // A ColumnDefinition for super columns
applies to the column component
Should it not be:
if (row.has(COMPONENT_INDEX))
componentIndex = row.getInt(COMPONENT_INDEX);
else if (kind == Kind.REGULAR isSuper)
componentIndex = 1; // A ColumnDefinition for super columns
applies to the column component
Or even:
if (row.has(COMPONENT_INDEX))
componentIndex = row.getInt(COMPONENT_INDEX);
else if (kind == Kind.CLUSTERING_COLUMN isSuper)
componentIndex = 0;
else if (kind == Kind.REGULAR isSuper)
componentIndex = 1;
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.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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]
[jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6
[
https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=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
[jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6
[
https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14582125#comment-14582125
]
Tom van den Berge commented on CASSANDRA-9582:
--
This table is created as a super column family using cassandra-cli.
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:
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.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={};
The stack trace when starting up:
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
[jira] [Commented] (CASSANDRA-9582) MarshalException after upgrading to 2.1.6
[
https://issues.apache.org/jira/browse/CASSANDRA-9582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14582145#comment-14582145
]
Robert Stupp commented on CASSANDRA-9582:
-
[~tomvandenberge], can you post the rows from {{system.schema_columns}} and
{{system.schema_columnfamilies}} for that table and the script to create the
table?
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:
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.01 AND
caching='KEYS_ONLY' AND
comment='' AND
dclocal_read_repair_chance=0.00 AND
gc_grace_seconds=864000 AND
index_interval=128 AND
read_repair_chance=1.00 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={};
The stack trace when starting up:
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)
