You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by buddhasystem <po...@bnl.gov> on 2011/02/24 21:27:58 UTC

"null" vs "value not found"?

I'm doing insertion with a pycassa client. It seems to work in most cases,
but sometimes, when I go to Cassandra-cli, and query with key and column
that I inserted, I get "null" whereas I shouldn't. What could be causes for
that?
-- 
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/null-vs-value-not-found-tp6061828p6061828.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: "null" vs "value not found"?

Posted by Dan Kuebrich <da...@gmail.com>.

 I should mention that it took me a while to figure this out too. Might be a
candidate for an improvement in the cli?

On Thu, Feb 24, 2011 at 4:01 PM, buddhasystem <po...@bnl.gov> wrote:

>
> Thanks! You are right. I see exception but have no idea what went wrong.
>
>
> ERROR [ReadStage:14] 2011-02-24 21:51:29,374 AbstractCassandraDaemon.java
> (line 113) Fatal exception in thread Thread[ReadStage:14,5,main]
> java.io.IOError: java.io.EOFException
>        at
>
> org.apache.cassandra.db.columniterator.SSTableNamesIterator.<init>(SSTableNamesIterator.java:75)
>        at
>
> org.apache.cassandra.db.filter.NamesQueryFilter.getSSTableColumnIterator(NamesQueryFilter.java:59)
>        at
>
> org.apache.cassandra.db.filter.QueryFilter.getSSTableColumnIterator(QueryFilter.java:80)
>        at
>
> org.apache.cassandra.db.ColumnFamilyStore.getTopLevelColumns(ColumnFamilyStore.java:1316)
>        at
>
> org.apache.cassandra.db.ColumnFamilyStore.getColumnFamily(ColumnFamilyStore.java:1205)
>        at
>
> org.apache.cassandra.db.ColumnFamilyStore.getColumnFamily(ColumnFamilyStore.java:1134)
>        at org.apache.cassandra.db.Table.getRow(Table.java:386)
>        at
>
> org.apache.cassandra.db.SliceByNamesReadCommand.getRow(SliceByNamesReadCommand.java:60)
>        at
> org.apache.cassandra.db.ReadVerbHandler.doVerb(ReadVerbHandler.java:69)
>        at
>
> org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:70)
>        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
> Source)
>        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
> Source)
>        at java.lang.Thread.run(Unknown Source)
> Caused by: java.io.EOFException
>        at java.io.DataInputStream.readInt(Unknown Source)
>        at
>
> org.apache.cassandra.utils.BloomFilterSerializer.deserialize(BloomFilterSerializer.java:48)
>        at
>
> org.apache.cassandra.utils.BloomFilterSerializer.deserialize(BloomFilterSerializer.java:30)
>        at
>
> org.apache.cassandra.io.sstable.IndexHelper.defreezeBloomFilter(IndexHelper.java:108)
>        at
>
> org.apache.cassandra.db.columniterator.SSTableNamesIterator.read(SSTableNamesIterator.java:106)
>        at
>
> org.apache.cassandra.db.columniterator.SSTableNamesIterator.<init>(SSTableNamesIterator.java:71)
>        ... 12 more
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/null-vs-value-not-found-tp6061828p6061983.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at
> Nabble.com.
>

Re: "null" vs "value not found"?

Posted by buddhasystem <po...@bnl.gov>.

Thanks! You are right. I see exception but have no idea what went wrong.


ERROR [ReadStage:14] 2011-02-24 21:51:29,374 AbstractCassandraDaemon.java
(line 113) Fatal exception in thread Thread[ReadStage:14,5,main]
java.io.IOError: java.io.EOFException
        at
org.apache.cassandra.db.columniterator.SSTableNamesIterator.<init>(SSTableNamesIterator.java:75)
        at
org.apache.cassandra.db.filter.NamesQueryFilter.getSSTableColumnIterator(NamesQueryFilter.java:59)
        at
org.apache.cassandra.db.filter.QueryFilter.getSSTableColumnIterator(QueryFilter.java:80)
        at
org.apache.cassandra.db.ColumnFamilyStore.getTopLevelColumns(ColumnFamilyStore.java:1316)
        at
org.apache.cassandra.db.ColumnFamilyStore.getColumnFamily(ColumnFamilyStore.java:1205)
        at
org.apache.cassandra.db.ColumnFamilyStore.getColumnFamily(ColumnFamilyStore.java:1134)
        at org.apache.cassandra.db.Table.getRow(Table.java:386)
        at
org.apache.cassandra.db.SliceByNamesReadCommand.getRow(SliceByNamesReadCommand.java:60)
        at
org.apache.cassandra.db.ReadVerbHandler.doVerb(ReadVerbHandler.java:69)
        at
org.apache.cassandra.net.MessageDeliveryTask.run(MessageDeliveryTask.java:70)
        at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(Unknown
Source)
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown
Source)
        at java.lang.Thread.run(Unknown Source)
Caused by: java.io.EOFException
        at java.io.DataInputStream.readInt(Unknown Source)
        at
org.apache.cassandra.utils.BloomFilterSerializer.deserialize(BloomFilterSerializer.java:48)
        at
org.apache.cassandra.utils.BloomFilterSerializer.deserialize(BloomFilterSerializer.java:30)
        at
org.apache.cassandra.io.sstable.IndexHelper.defreezeBloomFilter(IndexHelper.java:108)
        at
org.apache.cassandra.db.columniterator.SSTableNamesIterator.read(SSTableNamesIterator.java:106)
        at
org.apache.cassandra.db.columniterator.SSTableNamesIterator.<init>(SSTableNamesIterator.java:71)
        ... 12 more

-- 
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/null-vs-value-not-found-tp6061828p6061983.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: "null" vs "value not found"?

Posted by Dan Kuebrich <da...@gmail.com>.

When I've gotten "null" as a result in cassandra-cli, it turned out to mean
that there were exceptions being thrown on the server side. Have you checked
your Cassandra logs?

On Thu, Feb 24, 2011 at 3:44 PM, buddhasystem <po...@bnl.gov> wrote:

>
> Thanks Tyler,
>
>    ColumnFamily: index1
>      Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
>      Row cache size / save period: 0.0/0
>      Key cache size / save period: 10000.0/3600
>      Memtable thresholds: 0.8765625/50/60
>      GC grace seconds: 864000
>      Compaction min/max thresholds: 4/32
>      Read repair chance: 1.0
>      Built indexes: []
>
> I pretty much went with the default settings, and the column name is
> 'CATALOG'.
>
> Maxim
>
>
>
>
> Tyler Hobbs-2 wrote:
> >
> > On Thu, Feb 24, 2011 at 2:27 PM, buddhasystem <po...@bnl.gov> wrote:
> >
> >>
> >> I'm doing insertion with a pycassa client. It seems to work in most
> >> cases,
> >> but sometimes, when I go to Cassandra-cli, and query with key and column
> >> that I inserted, I get "null" whereas I shouldn't. What could be causes
> >> for
> >> that?
> >>
> >
> > Could you clarify what column name and value you are using as well as the
> > comparator and validator types?
> >
> > --
> > Tyler Hobbs
> > Software Engineer, DataStax <http://datastax.com/>
> > Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
> > Python client library
> >
> >
>
> --
> View this message in context:
> http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/null-vs-value-not-found-tp6061828p6061900.html
> Sent from the cassandra-user@incubator.apache.org mailing list archive at
> Nabble.com.
>

Re: "null" vs "value not found"?

Posted by buddhasystem <po...@bnl.gov>.

Thanks Tyler,

    ColumnFamily: index1
      Columns sorted by: org.apache.cassandra.db.marshal.AsciiType
      Row cache size / save period: 0.0/0
      Key cache size / save period: 10000.0/3600
      Memtable thresholds: 0.8765625/50/60
      GC grace seconds: 864000
      Compaction min/max thresholds: 4/32
      Read repair chance: 1.0
      Built indexes: []

I pretty much went with the default settings, and the column name is
'CATALOG'.

Maxim




Tyler Hobbs-2 wrote:
> 
> On Thu, Feb 24, 2011 at 2:27 PM, buddhasystem <po...@bnl.gov> wrote:
> 
>>
>> I'm doing insertion with a pycassa client. It seems to work in most
>> cases,
>> but sometimes, when I go to Cassandra-cli, and query with key and column
>> that I inserted, I get "null" whereas I shouldn't. What could be causes
>> for
>> that?
>>
> 
> Could you clarify what column name and value you are using as well as the
> comparator and validator types?
> 
> -- 
> Tyler Hobbs
> Software Engineer, DataStax <http://datastax.com/>
> Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
> Python client library
> 
> 

-- 
View this message in context: http://cassandra-user-incubator-apache-org.3065146.n2.nabble.com/null-vs-value-not-found-tp6061828p6061900.html
Sent from the cassandra-user@incubator.apache.org mailing list archive at Nabble.com.

Re: "null" vs "value not found"?

Posted by Tyler Hobbs <ty...@datastax.com>.

On Thu, Feb 24, 2011 at 2:27 PM, buddhasystem <po...@bnl.gov> wrote:

>
> I'm doing insertion with a pycassa client. It seems to work in most cases,
> but sometimes, when I go to Cassandra-cli, and query with key and column
> that I inserted, I get "null" whereas I shouldn't. What could be causes for
> that?
>

Could you clarify what column name and value you are using as well as the
comparator and validator types?

-- 
Tyler Hobbs
Software Engineer, DataStax <http://datastax.com/>
Maintainer of the pycassa <http://github.com/pycassa/pycassa> Cassandra
Python client library