cassandra-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From kooljava2 <koolja...@yahoo.com.INVALID>
Subject Re: Cassandra upgrade from 2.1 to 3.0
Date Fri, 11 May 2018 02:49:36 GMT
 Hello Jeff,
2.1.19 to 3.0.15.
Thank you. 

    On Thursday, 10 May 2018, 17:43:58 GMT-7, Jeff Jirsa <jjirsa@gmail.com> wrote: 

 
 Which minor version of 3.0

-- Jeff Jirsa

On May 11, 2018, at 2:54 AM, kooljava2 <kooljava2@yahoo.com.INVALID> wrote:



Hello,

Upgraded Cassandra 2.1 to 3.0.  We see certain data in few columns being set to "null". These
null columns were created during the row creation time.

After looking at the data see a pattern where update was done on these rows. Rows which were
updated has data but rows which were not part of the update are set to null.

 created_on                    | created_by          | id
---------------------------------+---------------------+-----------------------------------------
                            null |               
null |                        12345



sstabledump:- 

WARN  20:47:38,741 Small cdc volume detected at /var/lib/cassandra/cdc_raw; setting cdc_total_space_in_mb
to 1278.  You can override this in cassandra.yaml
[
  {
    "partition" : {
      "key" : [ "12345" ],
      "position" : 5155159
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 5168738,
        "deletion_info" : { "marked_deleted" : "2018-03-28T20:38:08.059999Z", "local_delete_time"
: "2018-03-28T20:38:08Z" },
        "cells" : [
          { "name" : "doc_type", "value" : false, "tstamp" : "2018-03-28T20:38:08.060Z"
},
          { "name" : "industry", "deletion_info" : { "local_delete_time" : "2018-03-28T20:38:08Z"
},
            "tstamp" : "2018-03-28T20:38:08.060Z"
          },
          { "name" : "last_modified_by", "value" : "12345", "tstamp" : "2018-03-28T20:38:08.060Z"
},
          { "name" : "last_modified_date", "value" : "2018-03-28 20:38:08.059Z",
"tstamp" : "2018-03-28T20:38:08.060Z" },
          { "name" : "locale", "deletion_info" : { "local_delete_time" : "2018-03-28T20:38:08Z"
},
            "tstamp" : "2018-03-28T20:38:08.060Z"
          },
          { "name" : "postal_code", "deletion_info" : { "local_delete_time" : "2018-03-28T20:38:08Z"
},
            "tstamp" : "2018-03-28T20:38:08.060Z"
          },
          { "name" : "ticket", "deletion_info" : { "marked_deleted" : "2018-03-28T20:38:08.059999Z",
"local_delete_time" : "2018-03-28T20:38:08Z" } },
          { "name" : "ticket", "path" : [ "TEMP_DATA" ], "value" : "{\"name\":\"TEMP_DATA\",\"ticket\":\"a42638dae8350e889f2603be1427ac6f5dec5e486d4db164a76bf80820cdf68d635cff5e7d555e6d4eabb9b5b82597b68bec0fcd735fcca\",\"lastRenewedDate\":\"2018-03-28T20:38:08Z\"}",
"tstamp" : "2018-03-28T20:38:08.060Z" },
          { "name" : "ticket", "path" : [ "TEMP_TEMP2" ], "value" : "{\"name\":\"TEMP_TEMP2\",\"ticket\":\"a4263b7350d1f2683\",\"lastRenewedDate\":\"2018-03-28T20:38:07Z\"}",
"tstamp" : "2018-03-28T20:38:08.060Z" },
          { "name" : "ppstatus_pf", "deletion_info" : { "marked_deleted" : "2018-03-28T20:38:08.059999Z",
"local_delete_time" : "2018-03-28T20:38:08Z" } },
          { "name" : "ppstatus_pers", "deletion_info" : { "marked_deleted" : "2018-03-28T20:38:08.059999Z",
"local_delete_time" : "2018-03-28T20:38:08Z" } }
        ]
      }
    ]
  }
]WARN  20:47:41,325 Small cdc volume detected at /var/lib/cassandra/cdc_raw; setting cdc_total_space_in_mb
to 1278.  You can override this in cassandra.yaml
[
  {
    "partition" : {
      "key" : [ "12345" ],
      "position" : 18743072
    },
    "rows" : [
      {
        "type" : "row",
        "position" : 18751808,
        "liveness_info" : { "tstamp" : "2017-10-25T10:22:41.612Z" },
        "cells" : [
          { "name" : "created_by", "value" : "12345" },
          { "name" : "created_on", "value" : "2017-10-25 10:22:41.637Z" },
          { "name" : "doc_type", "value" : false, "tstamp" : "2017-10-25T10:22:42.487Z"
},
          { "name" : "last_modified_by", "value" : "12345", "tstamp" : "2017-10-25T10:22:42.487Z"
},
          { "name" : "last_modified_date", "value" : "2017-11-10 00:09:52.668Z",
"tstamp" : "2017-11-10T00:09:52.668Z" },
          { "name" : "per_type", "value" : "user" },
          { "name" : "lists", "path" : [ "cn.cncn.bpnp" ], "value" : "[\"::accid:ab\",\"::accid:e1\",\"::accid:d2\",\"::accid:d3\",\"::accid:f3\",\"::accid:g3\",\"::accid:f4\",\"::accid:9c486ae5-00b2-3c63-af70-cff2950c4181\"]",
"tstamp" : "2017-10-25T10:22:42.782Z" },
          { "name" : "ticket", "path" : [ "TEMP_TEMP2" ], "value" : "{\"name\":\"TEMP_TEMP2\",\"ticket\":\"a4263820be49c3a222e0248532bcefc80c773194a804057561a97382e595b51f36bb46b8675589fc89dea4a5c0ceb944d63861b39d63c0067161e84c79328077c650df33530c7625857444711dc4b1051638123694ba6e9e29b1f906663f3\",\"lastRenewedDate\":\"2017-11-10T00:09:52Z\"}",
"tstamp" : "2017-11-10T00:09:52.668Z" }
        ]
      }
    ]
  }
]
  
Mime
View raw message