0.7.2 choking on a 5 MB column

[buddhasystem <po...@bnl.gov>]

I'm writing a row with about 45k columns. Most of them are quite small, and
there are a few of 2 MB and one of 5 MB. The write procedure times out.
Total data load is 9 MB.

What would be the cause?


--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/0-7-2-choking-on-a-5-MB-column-tp6198387p6198387.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: 0.7.2 choking on a 5 MB column

[Robert Coli <rc...@digg.com>]

On Tue, Mar 22, 2011 at 6:49 PM, buddhasystem <po...@bnl.gov> wrote:
> I see. I'm doing something even more drastic then, because I'm only inserting
> one row in this case, and just use cf.insert(), without batch mutator. It
> didn't occur to me that was a bad idea.

Everything in a given RPC has to complete before RPC timeout or it
will except. RpcTimeoutInMillis defaults to 5 seconds. There are a lot
of things you can ask any version of cassandra to do which will take
longer than 5 seconds. It is not reccomended that you do so! ;D

=Rob
PS - Why do these buddhasystem threads always cc cassandra-user@incubator?

Re: 0.7.2 choking on a 5 MB column

[buddhasystem <po...@bnl.gov>]

I see. I'm doing something even more drastic then, because I'm only inserting
one row in this case, and just use cf.insert(), without batch mutator. It
didn't occur to me that was a bad idea.

So I take it, this method will fail. Hmm.


--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/0-7-2-choking-on-a-5-MB-column-tp6198387p6198618.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: 0.7.2 choking on a 5 MB column

[Edward Capriolo <ed...@gmail.com>]

On Tue, Mar 22, 2011 at 8:59 PM, buddhasystem <po...@bnl.gov> wrote:
> Jonathan, wide rows have been discussed. I thought that the limit on number
> of columns is way bigger than 45k. What can one expect in reality?
>
> --
> View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/0-7-2-choking-on-a-5-MB-column-tp6198387p6198548.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.
>

I believe Jonathan is pointing out that writing 45K columns in a
single batch_mutate may be your problem.

Re: 0.7.2 choking on a 5 MB column

[buddhasystem <po...@bnl.gov>]

Jonathan, wide rows have been discussed. I thought that the limit on number
of columns is way bigger than 45k. What can one expect in reality?

--
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/0-7-2-choking-on-a-5-MB-column-tp6198387p6198548.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: 0.7.2 choking on a 5 MB column

[Jonathan Ellis <jb...@gmail.com>]

"I'm writing a row with about 45k columns."

On Tue, Mar 22, 2011 at 7:39 PM, buddhasystem <po...@bnl.gov> wrote:
> I'm writing a row with about 45k columns. Most of them are quite small, and
> there are a few of 2 MB and one of 5 MB. The write procedure times out.
> Total data load is 9 MB.
>
> What would be the cause?
>
>
> --
> View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/0-7-2-choking-on-a-5-MB-column-tp6198387p6198387.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.
>



-- 
Jonathan Ellis
Project Chair, Apache Cassandra
co-founder of DataStax, the source for professional Cassandra support
http://www.datastax.com