Mailing-List: contact user-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
MIME-Version: 1.0
From: Anshul Rathore <anshulrathore88@gmail.com>
Date: Wed, 03 May 2017 13:52:29 +0000
Message-ID: <CAJcYvKztrOed14aP79Vg_zxa=RbDPqRrCULCvX_i48=-wHCdLg@mail.gmail.com>
Subject: Prepared Statement Preloading in Cassandra
To: user@cassandra.apache.org
Content-Type: multipart/alternative; boundary=001a113cfe98330a38054e9ef880
archived-at: Wed, 03 May 2017 13:52:49 -0000

--001a113cfe98330a38054e9ef880
Content-Type: text/plain; charset=UTF-8

Hi

We are using Cassandra 3.10 version, one of the issue we encounter on
restart of a node is cassandra either gives Out of Memory error or goes
into GC cycle.

Able to identify the cause that in newer versions cassandra is preloading
all the prepared statements and we have one table which has around 200
columns , and not all values are set all the time, so there are lot of
prepared statements stored in system keyspace, so on startup it tries to
load all and not able to.

Temporary fix we are doing is truncating prepared statements table before
restart. Any thoughts on how to fix this ?

Thanks
Anshul

--001a113cfe98330a38054e9ef880
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi<div><br></div><div><font color=3D"#333333">We are using=
 Cassandra 3.10 version, one of the issue we encounter on restart of a node=
 is cassandra either gives Out of Memory error or goes into GC cycle.</font=
></div><div><font color=3D"#333333"><br></font></div><div><font color=3D"#3=
33333">Able to identify the cause that in newer versions cassandra is prelo=
ading all the prepared statements and we have one table which has around 20=
0 columns , and not all values are set all the time, so there are lot of pr=
epared statements stored in system keyspace, so on startup it tries to load=
 all and not able to.=C2=A0</font></div><div><font color=3D"#333333"><br></=
font></div><div><font color=3D"#333333">Temporary fix we are doing is trunc=
ating prepared statements table before restart. Any thoughts on how to fix =
this ?</font><br></div><div><font color=3D"#333333"><br></font></div><div><=
font color=3D"#333333">Thanks</font></div><div><font color=3D"#333333">Ansh=
ul</font></div></div>

--001a113cfe98330a38054e9ef880--