Skip to content

Instantly share code, notes, and snippets.

@lenards

lenards/shell_interactions.md

Last active August 29, 2015 14:05
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lenards/129f69751b0ab60dad6c to your computer and use it in GitHub Desktop.
Save lenards/129f69751b0ab60dad6c to your computer and use it in GitHub Desktop.
Download ZIP
Tracking attempting deletes of a cell within a given partition...
Raw
shell_interactions.md

So I have something like:

[
  {
    "key": "687374",
    "columns": [
      [
        "2014-08-26 14\\:02-0700:",
        "",
        1409086957259000
      ],
      [
        "2014-08-26 14\\:02-0700:service_name",
        "filed-download",
        1409086957259000
      ],
      [
        "2014-08-26 14\\:01-0700:",
        "",
        1409086915005000
      ],
      [
        "2014-08-26 14\\:01-0700:",
        "",
        1409086887597000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "file-share",
        1409086887597000
      ]
    ]
  }
]

Admin tab:

$ bin/sstable2json data/axos_star/service_activity/axos_star-service_activity-jb-5-Data.db

Output:

[
  {
    "key": "706174616b69",
    "metadata": {
      "deletionInfo": {
        "markedForDeleteAt": 1409086695882000,
        "localDeletionTime": 1409086695
      }
    },
    "columns": []
  },
  {
    "key": "687374",
    "columns": [
      [
        "2014-08-26 14\\:09-0700:",
        "",
        1409087342145000
      ],
      [
        "2014-08-26 14\\:09-0700:service_name",
        "file-download",
        1409087342145000
      ],
      [
        "2014-08-26 14\\:09-0700:",
        "",
        1409087341185000
      ],
      [
        "2014-08-26 14\\:09-0700:service_name",
        "file-download",
        1409087341185000
      ],
      [
        "2014-08-26 14\\:09-0700:",
        "",
        1409087340569000
      ],
      [
        "2014-08-26 14\\:09-0700:service_name",
        "file-download",
        1409087340569000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087339978000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087339978000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087339370000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087339370000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087338682000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087338682000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087336802000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087336802000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087336242000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087336242000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087335722000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087335722000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087335178000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087335178000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087334594000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087334594000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087334058000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087334058000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087333490000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087333490000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087332874000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087332874000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087332194000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087332194000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087331226000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087331226000
      ],
      [
        "2014-08-26 14\\:08-0700",
        "2014-08-26 14\\:08-0700:!",
        1409088040790000,
        "t",
        1409088040
      ],
      [
        "2014-08-26 14\\:02-0700:",
        "",
        1409086957259000
      ],
      [
        "2014-08-26 14\\:02-0700:service_name",
        "filed-download",
        1409086957259000
      ],
      [
        "2014-08-26 14\\:01-0700:",
        "",
        1409086915005000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "RAHR",
        1409087193398000
      ],
      [
        "2014-08-26 14\\:01-0700:",
        "",
        1409086887597000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "file-share",
        1409086887597000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "RAHR",
        1409087213789000
      ]
    ]
  }
]

CQL tab:

cqlsh> DELETE service_name FROM service_activity WHERE used_by = 'hst' and occurrence = '2014-08-26 14:08:51-0700';

Admin tab:

$ ccm flush
$ bin/sstable2json data/axos_star/service_activity/axos_star-service_activity-jb-6-Data.db

Output:

[
  {
    "key": "687374",
    "columns": [
      [
        "2014-08-26 14\\:08-0700:service_name",
        "53fcfb54",
        1409088340577000,
        "d"
      ]
    ]
  }
]

CQL tab:

cqlsh> DELETE service_name FROM service_activity WHERE used_by = 'hst' and occurrence = '2014-08-26 14:08:51-0700';

Admin tab:

$ ccm flush
$ bin/sstable2json data/axos_star/service_activity/axos_star-service_activity-jb-7-Data.db

Output:

[
  {
    "key": "687374",
    "columns": [
      [
        "2014-08-26 14\\:08-0700:service_name",
        "53fcfb98",
        1409088408336000,
        "d"
      ]
    ]
  }
]

Admin tab:

$ ccm node1 nodetool compact 
$ bin/sstable2json data/axos_star/service_activity/axos_star-service_activity-jb-8-Data.db

Output:

[
  {
    "key": "706174616b69",
    "metadata": {
      "deletionInfo": {
        "markedForDeleteAt": 1409086695882000,
        "localDeletionTime": 1409086695
      }
    },
    "columns": []
  },
  {
    "key": "687374",
    "columns": [
      [
        "2014-08-26 14\\:09-0700:",
        "",
        1409087342145000
      ],
      [
        "2014-08-26 14\\:09-0700:service_name",
        "file-download",
        1409087342145000
      ],
      [
        "2014-08-26 14\\:09-0700:",
        "",
        1409087341185000
      ],
      [
        "2014-08-26 14\\:09-0700:service_name",
        "file-download",
        1409087341185000
      ],
      [
        "2014-08-26 14\\:09-0700:",
        "",
        1409087340569000
      ],
      [
        "2014-08-26 14\\:09-0700:service_name",
        "file-download",
        1409087340569000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087339978000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087339978000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087339370000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087339370000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087338682000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087338682000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087336802000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087336802000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087336242000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087336242000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087335722000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087335722000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087335178000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087335178000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087334594000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087334594000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087334058000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087334058000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087333490000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087333490000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087332874000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087332874000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087332194000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087332194000
      ],
      [
        "2014-08-26 14\\:08-0700:",
        "",
        1409087331226000
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "file-download",
        1409087331226000
      ],
      [
        "2014-08-26 14\\:08-0700",
        "2014-08-26 14\\:08-0700:!",
        1409088040790000,
        "t",
        1409088040
      ],
      [
        "2014-08-26 14\\:08-0700:service_name",
        "53fcfb98",
        1409088408336000,
        "d"
      ],
      [
        "2014-08-26 14\\:02-0700:",
        "",
        1409086957259000
      ],
      [
        "2014-08-26 14\\:02-0700:service_name",
        "filed-download",
        1409086957259000
      ],
      [
        "2014-08-26 14\\:01-0700:",
        "",
        1409086915005000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "RAHR",
        1409087193398000
      ],
      [
        "2014-08-26 14\\:01-0700:",
        "",
        1409086887597000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "file-share",
        1409086887597000
      ],
      [
        "2014-08-26 14\\:01-0700:service_name",
        "RAHR",
        1409087213789000
      ]
    ]
  }
]

CQL tab:

cqlsh:axos_star> SELECT * FROM service_activity WHERE used_by = 'hst';

 used_by | occurrence               | service_name
---------+--------------------------+----------------
     hst | 2014-08-26 14:09:02-0700 |  file-download
     hst | 2014-08-26 14:09:01-0700 |  file-download
     hst | 2014-08-26 14:09:00-0700 |  file-download
     hst | 2014-08-26 14:08:59-0700 |  file-download
     hst | 2014-08-26 14:08:59-0700 |  file-download
     hst | 2014-08-26 14:08:58-0700 |  file-download
     hst | 2014-08-26 14:08:56-0700 |  file-download
     hst | 2014-08-26 14:08:56-0700 |  file-download
     hst | 2014-08-26 14:08:55-0700 |  file-download
     hst | 2014-08-26 14:08:55-0700 |  file-download
     hst | 2014-08-26 14:08:54-0700 |  file-download
     hst | 2014-08-26 14:08:54-0700 |  file-download
     hst | 2014-08-26 14:08:53-0700 |  file-download
     hst | 2014-08-26 14:08:52-0700 |  file-download
     hst | 2014-08-26 14:08:52-0700 |  file-download
     hst | 2014-08-26 14:08:51-0700 |  file-download
     hst | 2014-08-26 14:02:37-0700 | filed-download
     hst | 2014-08-26 14:01:55-0700 |           null
     hst | 2014-08-26 14:01:55-0700 |           RAHR
     hst | 2014-08-26 14:01:27-0700 |     file-share
     hst | 2014-08-26 14:01:00-0700 |           RAHR

(21 rows)

CQL tab;

cqlsh> DELETE service_name FROM service_activity WHERE used_by = 'hst' and occurrence = '2014-08-26 14:01:55-0700';

Admin tab:

$ ccm flush
$ bin/sstable2json data/axos_star/service_activity/axos_star-service_activity-jb-9-Data.db

Output:

[
  {
    "key": "687374",
    "columns": [
      [
        "2014-08-26 14\\:01-0700:service_name",
        "53fcfc75",
        1409088629938000,
        "d"
      ]
    ]
  }
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment