Return-Path: X-Original-To: apmail-cassandra-user-archive@www.apache.org Delivered-To: apmail-cassandra-user-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 8839118087 for ; Thu, 11 Jun 2015 15:28:12 +0000 (UTC) Received: (qmail 95133 invoked by uid 500); 11 Jun 2015 15:28:09 -0000 Delivered-To: apmail-cassandra-user-archive@cassandra.apache.org Received: (qmail 95090 invoked by uid 500); 11 Jun 2015 15:28:09 -0000 Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cassandra.apache.org Delivered-To: mailing list user@cassandra.apache.org Received: (qmail 95080 invoked by uid 99); 11 Jun 2015 15:28:09 -0000 Received: from Unknown (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 11 Jun 2015 15:28:09 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id BB934C0613 for ; Thu, 11 Jun 2015 15:28:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: 2.901 X-Spam-Level: ** X-Spam-Status: No, score=2.901 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=3, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=datastax.com Received: from mx1-us-west.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id A-2JsQcRntly for ; Thu, 11 Jun 2015 15:27:56 +0000 (UTC) Received: from mail-ig0-f176.google.com (mail-ig0-f176.google.com [209.85.213.176]) by mx1-us-west.apache.org (ASF Mail Server at mx1-us-west.apache.org) with ESMTPS id C9AC32662E for ; Thu, 11 Jun 2015 15:27:55 +0000 (UTC) Received: by igbpi8 with SMTP id pi8so57776597igb.1 for ; Thu, 11 Jun 2015 08:27:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=datastax.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :content-type; bh=kQgeO8UDmcnts0Sd9Hv7nzg1oY/gxWYroWBorHN7oKk=; b=kYfGmQ/Y2rRM3hnA/dsUcDHoJnCMTo7MJ8wb43YEWEZ1txn0TER+Be22QtQDBOGAIS WNSeGkFT4XxAxBfIfqlXXfbZ+SXVGuz/yPE76S0WwvwQUPejq/YqOjdALtzx6RxurMk7 6BI1I+ltlyeJiUSECk2dKp8V/0ZMqW2Ceu8lg= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:content-type; bh=kQgeO8UDmcnts0Sd9Hv7nzg1oY/gxWYroWBorHN7oKk=; b=X6rjWrW5x3sH+Knx2PytiPvsbCBUDWQhkq7ME+t0v1H7dJq84+Wg09NV0PN0asTC+q UuTS/zaA0sMkfY9YuFVO2rJDuz3l6L1trmxmwmZ8VvI2emDDihMnzow96Xcys0YgpCvJ tKmxG4iT1OKxnkkHoOsUI3wGFI0aidD3Aq6hzEcGrVRxAHTNyyZsdJlsJMKbxG3HqWtU B8veszSvdpLLF4uf8EcOEz2el1oMGKkh50XyiMA5GnwV4YzH8qqzuzrqP4rbj6EKhHm0 zBGBJEFAOwtNTiEDIEEbChvsZ3b7JJ9Ku2EPLxlnaDTz+Z6erLQKaSPQaoZH1jIw1gq/ Rk1A== X-Gm-Message-State: ALoCoQlYEkIr5Sv1Kg3oWPMhtqlUzh8sIlGcMCQxOzLzPkfJggMpE2gZU3rGQzZMlyXcj1Phni6V X-Received: by 10.43.12.136 with SMTP id pi8mr11454374icb.6.1434036475003; Thu, 11 Jun 2015 08:27:55 -0700 (PDT) MIME-Version: 1.0 Received: by 10.36.103.74 with HTTP; Thu, 11 Jun 2015 08:27:34 -0700 (PDT) In-Reply-To: References: From: Tyler Hobbs Date: Thu, 11 Jun 2015 10:27:34 -0500 Message-ID: Subject: Re: MarshalException after upgrading to 2.1.6 To: user@cassandra.apache.org Content-Type: multipart/alternative; boundary=bcaec518242cb02ba305183fa228 --bcaec518242cb02ba305183fa228 Content-Type: text/plain; charset=UTF-8 Can you open a JIRA ticket with details and the schema for that table here? https://issues.apache.org/jira/browse/CASSANDRA On Thu, Jun 11, 2015 at 9:23 AM, Tom van den Berge wrote: > 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. Does anyone have an idea how this can be fixed? > > Thanks, > Tom > > 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' > > > > > -- Tyler Hobbs DataStax --bcaec518242cb02ba305183fa228 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Can you open a JIRA ticket with details and the schema for= that table here? https://issues.apache.org/jira/browse/CASSANDRA

On Thu, Jun 11, 2015 at 9:2= 3 AM, Tom van den Berge <tom@drillster.com> wrote:
I've upgraded a node from 2.0.10 to 2.1.6. Before takin= g down the node, I've run nodetool upgradesstables and nodetool scrub.<= /div>

When starting up the node with 2.1.6, I'm gett= ing a MarshalException (stacktrace included below). For some reason, it see= ms that C* is trying to convert a text value from the column 'currencyC= ode' to a UUID, which it isn't.
I've had similar erro= rs 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 a= gain. Does anyone have an idea how this can be fixed?

<= div>Thanks,
Tom

ERROR 13:51:57 Exception encountered during startup=
org.apache.cassandra.seriali= zers.MarshalException: unable to make version 1 UUID from 'currencyCode= '
at org.apache.cassandra.db.marshal.UUIDType.fr= omString(UUIDType.java:188) ~[apache-cassandra-2.1.6.jar:2.1.6]
at org.apache.cassandra.db.marshal.AbstractCompositeType.fromSt= ring(AbstractCompositeType.java:242) ~[apache-cassandra-2.1.6.jar:2.1.6]
at org.apache.cassandra.config.ColumnDefinition.fromSc= hema(ColumnDefinition.java:397) ~[apache-cassandra-2.1.6.jar:2.1.6]<= /div>
at org.apache.cassandra.config.CFMetaData.fromSchemaNoTrigg= ers(CFMetaData.java:1750) ~[apache-cassandra-2.1.6.jar:2.1.6]
<= div> at org.apache.cassandra.config.CFMetaData.fromSchema(CFMetaData.j= ava:1860) ~[apache-cassandra-2.1.6.jar:2.1.6]
at o= rg.apache.cassandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.= java:321) ~[apache-cassandra-2.1.6.jar:2.1.6]
at o= rg.apache.cassandra.config.KSMetaData.fromSchema(KSMetaData.java:302) ~[apa= che-cassandra-2.1.6.jar:2.1.6]
at org.apache.cassand= ra.db.DefsTables.loadFromKeyspace(DefsTables.java:133) ~[apache-cassandra-2= .1.6.jar:2.1.6]
at org.apache.cassandra.config.Datab= aseDescriptor.loadSchemas(DatabaseDescriptor.java:696) ~[apache-cassandra-2= .1.6.jar:2.1.6]
at org.apache.cassandra.config.Datab= aseDescriptor.loadSchemas(DatabaseDescriptor.java:672) ~[apache-cassandra-2= .1.6.jar:2.1.6]
at org.apache.cassandra.service.Cass= andraDaemon.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(Cass= andraDaemon.java:625) [apache-cassandra-2.1.6.jar:2.1.6]
<= font face=3D"monospace, monospace">Caused by: org.apache.cassandra.serializ= ers.MarshalException: unable to coerce 'currencyCode' to a =C2=A0fo= rmatted date (long)
at org.apache.cassandra.serializ= ers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:111)= ~[apache-cassandra-2.1.6.jar:2.1.6]
at org.apache.c= assandra.db.marshal.UUIDType.fromString(UUIDType.java:184) ~[apache-cassand= ra-2.1.6.jar:2.1.6]
... 12 common frames omitted
Caused by: java.text.Pars= eException: Unable to parse the date: currencyCode
a= t org.apache.commons.lang3.time.DateUtils.parseDateWithLeniency(DateUtils.j= ava:336) ~[commons-lang3-3.1.jar:3.1]
at org.apache.= commons.lang3.time.DateUtils.parseDateStrictly(DateUtils.java:286) ~[common= s-lang3-3.1.jar:3.1]
<= span style=3D"white-space:pre-wrap"> at org.apache.cassandra.seriali= zers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:107= ) ~[apache-cassandra-2.1.6.jar:2.1.6]
... 13 common = frames omitted
org.apa= che.cassandra.serializers.MarshalException: unable to make version 1 UUID f= rom 'currencyCode'
at org.apache.cassandra.d= b.marshal.UUIDType.fromString(UUIDType.java:188)
at = org.apache.cassandra.db.marshal.AbstractCompositeType.fromString(AbstractCo= mpositeType.java:242)
= at org.apache.cassandra.config= .ColumnDefinition.fromSchema(ColumnDefinition.java:397)
at org.apache.cassandra.config.CFMetaData.fromSchemaNoTriggers(CFMetaDa= ta.java:1750)
at org.apache.cassandra.config.CFMetaD= ata.fromSchema(CFMetaData.java:1860)
at org.apache.c= assandra.config.KSMetaData.deserializeColumnFamilies(KSMetaData.java:321)
at org.apache.cassandra.config.KSMetaData.fromSchema(= KSMetaData.java:302)
<= span style=3D"white-space:pre-wrap"> at org.apache.cassandra.db.Defs= Tables.loadFromKeyspace(DefsTables.java:133)
at org.= apache.cassandra.config.DatabaseDescriptor.loadSchemas(DatabaseDescriptor.j= ava:696)
at org.apache.cassandra.config.DatabaseDe= scriptor.loadSchemas(DatabaseDescriptor.java:672)
at= org.apache.cassandra.service.CassandraDaemon.setup(CassandraDaemon.java:29= 3)
at org.apache.cassandra.service.CassandraDaemon.a= ctivate(CassandraDaemon.java:536)
at org.apache.cass= andra.service.CassandraDaemon.main(CassandraDaemon.java:625)
Caused by: org.apache.cassandra.seri= alizers.MarshalException: unable to coerce 'currencyCode' to a =C2= =A0formatted date (long)
at org.apache.cassandra.ser= ializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java= :111)
at org.apache.cassandra.db.marshal.UUIDType.fr= omString(UUIDType.java:184)
... 12 more
=
Caused by: java.text.ParseExceptio= n: Unable to parse the date: currencyCode
at org.apa= che.commons.lang3.time.DateUtils.parseDateWithLeniency(DateUtils.java:336)<= /font>
at org.apache.commons.lang3.time.DateUtils.parseDate= Strictly(DateUtils.java:286)
at org.apache.cassandra= .serializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.= java:107)
... 13 more
Exception encountered during startup: unable to m= ake version 1 UUID from 'currencyCode'




<= /div>



--
Tyler Hobbs
DataStax
<= /div>
--bcaec518242cb02ba305183fa228--