Uploaded image for project: 'Cassandra'
  1. Cassandra
  2. CASSANDRA-13478

SASI Sparse mode overflow corrupts the SSTable

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Low
    • Resolution: Unresolved
    • Fix Version/s: None
    • Component/s: Feature/SASI
    • Labels:
      None
    • Environment:

      cqlsh 5.0.1 | Cassandra 3.10 | CQL spec 3.4.4 | Native protocol v4 | ubuntu 14.04

    • Severity:
      Low
    • Since Version:

      Description

      I have a table, the schema can be seen in attach file

      I would like to search the data using the timestamp data type with lt gt eq as a query condition,
      Ex:

      CREATE TABLE XXX.userlist (
          userid text PRIMARY KEY,
          lastposttime timestamp
      )
      Select * from userlist where lastposttime> '2017-04-01 16:00:00+0000';
      

      There are 2 conditions :
      If I insert the data and then select it, the result will be correct
      But in case I insert data and then the next day I restart Cassandra, and after that select the data, there will be no data selected

      The difference is that there is no Service restart on th next day in the first manner. Actually, the data are still living in Cassandra, but TimeStamp can’t be used as the query condition

        Attachments

        1. schema
          4 kB
          jack chen

          Issue Links

            Activity

              People

              • Assignee:
                ifesdjeen Alex Petrov
                Reporter:
                arliang jack chen
                Authors:
                Alex Petrov
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: