as Chovatia mentioned, the keyspaces seems to be different. try "Describe keyspace SN_KEYSPACE" and "describe keyspace MY_KEYSPACE" from CQL. This will give you an idea about how many replicas are there for these keyspaces.
On Wed, May 28, 2014 at 11:49 AM, chovatia jaydeep < chovatia_jayd...@yahoo.co.in> wrote: > What is your partition type? Is > it org.apache.cassandra.dht.Murmur3Partitioner? > In your repair command i do see there are two different KeySpaces > "MY_KEYSPACE" > and "SN_KEYSPACE", are these two separate key spaces or typo? > > -jaydeep > > > On Tuesday, 27 May 2014 10:26 PM, Matthew Allen < > matthew.j.al...@gmail.com> wrote: > > > Hi, > > Am a bit confused regarding data ownership in a multi-dc environment. > > I have the following setup in a test cluster with a keyspace with > (placement_strategy = 'NetworkTopologyStrategy' and strategy_options = > {'DC_NSW':2,'DC_VIC':2};) > > Datacenter: DC_NSW > ========== > Replicas: 2 > Address Rack Status State Load > Owns Token > > 0 > nsw1 rack1 Up Normal 1007.43 MB 100.00% > -9223372036854775808 > nsw2 rack1 Up Normal 1008.08 MB 100.00% 0 > > > Datacenter: DC_VIC > ========== > Replicas: 2 > Address Rack Status State Load > Owns Token > > 100 > vic1 rack1 Up Normal 1015.1 MB 100.00% > -9223372036854775708 > vic2 rack1 Up Normal 1015.13 MB 100.00% 100 > > My understanding is that both Datacenters have a complete copy of the > data, but when I run a repair -pr on each of the nodes, the vic hosts only > take a couple of seconds, while the nsw nodes take about 5 minutes each. > > Does this mean that nsw nodes "own" the majority of the data given their > key ranges and that repairs will need to cross datacenters ? > > Thanks > > Matt > > command>nodetool -h vic1 repair -pr (takes seconds) > Starting NodeTool > [2014-05-28 15:11:02,783] Starting repair command #1, repairing 1 ranges > for keyspace MY_KEYSPACE > [2014-05-28 15:11:03,110] Repair session > 76d170f0-e626-11e3-af4e-218541ad23a1 for range > (-9223372036854775808,-9223372036854775708] finished > [2014-05-28 15:11:03,110] Repair command #1 finished > [2014-05-28 15:11:03,126] Nothing to repair for keyspace 'system' > [2014-05-28 15:11:03,126] Nothing to repair for keyspace 'system_traces' > > command>nodetool -h vic2 repair -pr (takes seconds) > Starting NodeTool > [2014-05-28 15:11:28,746] Starting repair command #1, repairing 1 ranges > for keyspace MY_KEYSPACE > [2014-05-28 15:11:28,840] Repair session > 864b14a0-e626-11e3-9612-07b0c029e3c7 for range (0,100] finished > [2014-05-28 15:11:28,840] Repair command #1 finished > [2014-05-28 15:11:28,866] Nothing to repair for keyspace 'system' > [2014-05-28 15:11:28,866] Nothing to repair for keyspace 'system_traces' > > command>nodetool -h nsw1 repair -pr (takes minutes) > Starting NodeTool > [2014-05-28 15:11:32,579] Starting repair command #1, repairing 1 ranges > for keyspace SN_KEYSPACE > [2014-05-28 15:14:07,187] Repair session > 88966430-e626-11e3-81eb-c991646ac2bf for range (100,-9223372036854775808] > finished > [2014-05-28 15:14:07,187] Repair command #1 finished > [2014-05-28 15:14:11,393] Nothing to repair for keyspace 'system' > [2014-05-28 15:14:11,440] Nothing to repair for keyspace 'system_traces' > > command>nodetool -h nsw2 repair -pr (takes minutes) > Starting NodeTool > [2014-05-28 15:14:18,670] Starting repair command #1, repairing 1 ranges > for keyspace SN_KEYSPACE > [2014-05-28 15:17:27,300] Repair session > eb936ce0-e626-11e3-81e2-8790242f886e for range (-9223372036854775708,0] > finished > [2014-05-28 15:17:27,300] Repair command #1 finished > [2014-05-28 15:17:32,017] Nothing to repair for keyspace 'system' > [2014-05-28 15:17:32,064] Nothing to repair for keyspace 'system_traces' > > >