Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@cassandra.apache.org
Received-SPF: pass (athena.apache.org: domain of charlieandrews.cwa@gmail.com
 designates 209.85.213.47 as permitted sender)
From: Charlie Andrews <charlieandrews.cwa@gmail.com>
Content-Type: multipart/alternative;
 boundary="Apple-Mail=_505CB4FF-7CAA-4B01-BAF0-DC4BB9A14ABA"
Message-Id: <127DCC03-4C33-43AC-9203-0ABDDA86EF2C@gmail.com>
Mime-Version: 1.0 (Mac OS X Mail 7.0 \(1822\))
Subject: Re: Table Creation Error
Date: Mon, 2 Dec 2013 15:24:16 -0500
References: <C1F0CEA0-09F7-429B-83C2-577C53D49CB8@gmail.com>
 <CAEDUwd0e1f0JnVxku-sMOZGaU5GjCNZvGARZo6VdH=Svmo4Kgg@mail.gmail.com>
 <6A189B4A-D3FB-4BA9-9638-A976153C3142@gmail.com>
 <CAEDUwd1oDUy6qHfUOSONVW3A2yhfD+ar6j-DT9pmmn9M4B3eiw@mail.gmail.com>
 <78157CBC-9FD8-4FD5-B70F-6C591365CC47@gmail.com>
 <CAEDUwd0msB9sumsARn=CFGmH7gzR7R8J7OaEXav7VnFD81KPuw@mail.gmail.com>
To: user@cassandra.apache.org
In-Reply-To: 
 <CAEDUwd0msB9sumsARn=CFGmH7gzR7R8J7OaEXav7VnFD81KPuw@mail.gmail.com>


--Apple-Mail=_505CB4FF-7CAA-4B01-BAF0-DC4BB9A14ABA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=windows-1252

Just out of curiosity, what do you think occurred to cause this problem? =
I thought it was quite strange that I didn=92t get a useable error since =
my experience with this project has always been pretty helpful errors.

Thanks,
Charlie

On Dec 2, 2013, at 3:20 PM, Robert Coli <rcoli@eventbrite.com> wrote:

> On Mon, Dec 2, 2013 at 12:14 PM, Charlie Andrews =
<charlieandrews.cwa@gmail.com> wrote:
> Maybe a stupid question, but doesn=92t dropping a keyspace drop all =
data? Or is the keyspace schema separate from the data it describes?
>=20
> Lol, sorry, yes. You will have to restore the data from the =
automatically created snapshot.
>=20
> 1) echo "DESCRIBE KEYSPACE <keyspace_name>;" | cqlsh > =
keyspace_name.schema.cqlsh
> 2) DROP KEYSPACE <keyspace_name>;
> 3) restore keyspace's data from the snapshots created automatically =
when you DROP
> 4) use the contents of keyspace_name.schema.cqlsh to re-create your =
schema
> 5) rolling restart of all nodes (or use "nodetool refresh")
> =20
> =3DRob
>=20


--Apple-Mail=_505CB4FF-7CAA-4B01-BAF0-DC4BB9A14ABA
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
	charset=windows-1252

<html><head><meta http-equiv=3D"Content-Type" content=3D"text/html =
charset=3Dwindows-1252"></head><body style=3D"word-wrap: break-word; =
-webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">Just =
out of curiosity, what do you think occurred to cause this problem? I =
thought it was quite strange that I didn=92t get a useable error since =
my experience with this project has always been pretty helpful =
errors.<div><br></div><div>Thanks,</div><div>Charlie</div><div><br><div><d=
iv>On Dec 2, 2013, at 3:20 PM, Robert Coli &lt;<a =
href=3D"mailto:rcoli@eventbrite.com">rcoli@eventbrite.com</a>&gt; =
wrote:</div><br class=3D"Apple-interchange-newline"><blockquote =
type=3D"cite"><div dir=3D"ltr">On Mon, Dec 2, 2013 at 12:14 PM, Charlie =
Andrews <span dir=3D"ltr">&lt;<a =
href=3D"mailto:charlieandrews.cwa@gmail.com" =
target=3D"_blank">charlieandrews.cwa@gmail.com</a>&gt;</span> =
wrote:<br><div class=3D"gmail_extra">
<div class=3D"gmail_quote"><blockquote class=3D"gmail_quote" =
style=3D"margin:0px 0px 0px =
0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left=
-style:solid;padding-left:1ex"><div style=3D"word-wrap:break-word">
Maybe a stupid question, but doesn=92t dropping a keyspace drop all =
data? Or is the keyspace schema separate from the data it =
describes?</div></blockquote><div><br></div><div>Lol, sorry, yes. You =
will have to restore the data from the automatically created =
snapshot.</div>
<div><br></div><div =
style=3D"font-family:arial,sans-serif;font-size:12.666666984558105px">1) =
echo "DESCRIBE KEYSPACE &lt;keyspace_name&gt;;" | cqlsh &gt; =
keyspace_name.schema.cqlsh</div><div =
style=3D"font-family:arial,sans-serif;font-size:12.666666984558105px">
2) DROP KEYSPACE &lt;keyspace_name&gt;;</div><div =
style=3D"font-family:arial,sans-serif;font-size:12.666666984558105px">3) =
restore keyspace's data from the snapshots created automatically when =
you DROP</div><div =
style=3D"font-family:arial,sans-serif;font-size:12.666666984558105px">
4) use the contents of keyspace_name.schema.cqlsh to re-create your =
schema</div><div>5) rolling restart of all nodes (or use "nodetool =
refresh")</div><div>&nbsp;</div><div>=3DRob</div><div><br></div></div></di=
v></div>
</blockquote></div><br></div></body></html>=

--Apple-Mail=_505CB4FF-7CAA-4B01-BAF0-DC4BB9A14ABA--