you're right, i wasn't setting the timestamp on my insert. after fixing that everything works fine.
thanks, -mike On Dec 30, 2010, at 11:29 AM, Javier Canillas wrote: > Yeah, double check your are not using a constant on the timestamp, or the > second time you add the same column, such column contains the same timestamp > as the first one (that will be smaller than the one put on the delete > command). > > Can you share us your code example? > > On Thu, Dec 30, 2010 at 2:12 PM, Nate McCall <n...@riptano.com> wrote: > Extend your code to explicitly set the timestamp on the Column in > micro seconds. I think you are just defaulting to 0 and hitting the > condition previously described. > > On Thu, Dec 30, 2010 at 11:02 AM, mike dooley <doo...@apple.com> wrote: > > hmm, i added a sleep(1000) between each operation and still see the same > > behavior. > > but stranger still, if i do the exact same operations via the command line > > they work > > as expected. and the logs for the two runs look identical to me (aside from > > the different keys) > > -mike > > > > ----------------------------------- > > [defa...@unknown] use Harvest; > > Authenticated to keyspace: Harvest > > [defa...@harvest] > > [defa...@harvest] set Test1['row-c1']['dummy-col'] = 'value-a'; > > Value inserted. > > [defa...@harvest] get Test1['row-c1']['dummy-col']; > > => (column=dummy-col, value=76616c75652d61, timestamp=1293727499867000) > > [defa...@harvest] > > [defa...@harvest] del Test1['row-c1']; > > row removed. > > [defa...@harvest] get Test1['row-c1']['dummy-col']; > > Value was not found > > [defa...@harvest] > > [defa...@harvest] set Test1['row-c1']['dummy-col'] = 'value-a'; > > Value inserted. > > [defa...@harvest] get Test1['row-c1']['dummy-col']; > > => (column=dummy-col, value=76616c75652d61, timestamp=1293727499912000) > > DEBUG 08:44:59,872 insert > > DEBUG 08:44:59,876 insert writing local RowMutation(keyspace='Harvest', > > key='726f772d6331', modifications=[Test1]) > > DEBUG 08:44:59,882 applying mutation of row 726f772d6331 > > DEBUG 08:44:59,892 get > > DEBUG 08:44:59,893 Sorted endpoints are localhost/127.0.0.1 > > DEBUG 08:44:59,893 weakread reading SliceByNamesReadCommand(table='Harvest', > > key=726f772d6331, columnParent='QueryPath(columnFamilyName='Test1', > > superColumnName='null', columnName='null')', columns=[dummy-col,]) locally > > DEBUG 08:44:59,894 weakreadlocal reading > > SliceByNamesReadCommand(table='Harvest', key=726f772d6331, > > columnParent='QueryPath(columnFamilyName='Test1', superColumnName='null', > > columnName='null')', columns=[dummy-col,]) > > DEBUG 08:44:59,903 remove > > DEBUG 08:44:59,903 insert writing local RowMutation(keyspace='Harvest', > > key='726f772d6331', modifications=[Test1]) > > DEBUG 08:44:59,904 applying mutation of row 726f772d6331 > > DEBUG 08:44:59,908 get > > DEBUG 08:44:59,908 Sorted endpoints are localhost/127.0.0.1 > > DEBUG 08:44:59,909 weakread reading SliceByNamesReadCommand(table='Harvest', > > key=726f772d6331, columnParent='QueryPath(columnFamilyName='Test1', > > superColumnName='null', columnName='null')', columns=[dummy-col,]) locally > > DEBUG 08:44:59,909 weakreadlocal reading > > SliceByNamesReadCommand(table='Harvest', key=726f772d6331, > > columnParent='QueryPath(columnFamilyName='Test1', superColumnName='null', > > columnName='null')', columns=[dummy-col,]) > > DEBUG 08:44:59,912 insert > > DEBUG 08:44:59,913 insert writing local RowMutation(keyspace='Harvest', > > key='726f772d6331', modifications=[Test1]) > > DEBUG 08:44:59,913 applying mutation of row 726f772d6331 > > DEBUG 08:44:59,919 get > > DEBUG 08:44:59,919 Sorted endpoints are localhost/127.0.0.1 > > DEBUG 08:44:59,919 weakread reading SliceByNamesReadCommand(table='Harvest', > > key=726f772d6331, columnParent='QueryPath(columnFamilyName='Test1', > > superColumnName='null', columnName='null')', columns=[dummy-col,]) locally > > DEBUG 08:44:59,920 weakreadlocal reading > > SliceByNamesReadCommand(table='Harvest', key=726f772d6331, > > columnParent='QueryPath(columnFamilyName='Test1', superColumnName='null', > > columnName='null')', columns=[dummy-col,]) > > ------------------ > > === starting > > === inserting row: row-j1, value: value-a > > === about to retrieve data > > === got (dummy-col,value-a) > > === deleting row: row-j1 > > === data not found, as expected > > === re-inserting row: row-j1 > > === !!!! re-inserted data not found > > === crush all boxes > > DEBUG 08:46:20,131 insert > > DEBUG 08:46:20,132 insert writing local RowMutation(keyspace='Harvest', > > key='726f772d6a31', modifications=[Test1]) > > DEBUG 08:46:20,133 applying mutation of row 726f772d6a31 > > DEBUG 08:46:20,144 get > > DEBUG 08:46:20,144 Sorted endpoints are localhost/127.0.0.1 > > DEBUG 08:46:20,145 weakread reading SliceByNamesReadCommand(table='Harvest', > > key=726f772d6a31, columnParent='QueryPath(columnFamilyName='Test1', > > superColumnName='null', columnName='null')', columns=[dummy-col,]) locally > > DEBUG 08:46:20,145 weakreadlocal reading > > SliceByNamesReadCommand(table='Harvest', key=726f772d6a31, > > columnParent='QueryPath(columnFamilyName='Test1', superColumnName='null', > > columnName='null')', columns=[dummy-col,]) > > DEBUG 08:46:21,156 remove > > DEBUG 08:46:21,157 insert writing local RowMutation(keyspace='Harvest', > > key='726f772d6a31', modifications=[Test1]) > > DEBUG 08:46:21,157 applying mutation of row 726f772d6a31 > > DEBUG 08:46:21,160 get > > DEBUG 08:46:21,161 Sorted endpoints are localhost/127.0.0.1 > > DEBUG 08:46:21,161 weakread reading SliceByNamesReadCommand(table='Harvest', > > key=726f772d6a31, columnParent='QueryPath(columnFamilyName='Test1', > > superColumnName='null', columnName='null')', columns=[dummy-col,]) locally > > DEBUG 08:46:21,161 weakreadlocal reading > > SliceByNamesReadCommand(table='Harvest', key=726f772d6a31, > > columnParent='QueryPath(columnFamilyName='Test1', superColumnName='null', > > columnName='null')', columns=[dummy-col,]) > > DEBUG 08:46:22,164 insert > > DEBUG 08:46:22,167 insert writing local RowMutation(keyspace='Harvest', > > key='726f772d6a31', modifications=[Test1]) > > DEBUG 08:46:22,167 applying mutation of row 726f772d6a31 > > DEBUG 08:46:22,168 get > > DEBUG 08:46:22,169 Sorted endpoints are localhost/127.0.0.1 > > DEBUG 08:46:22,169 weakread reading SliceByNamesReadCommand(table='Harvest', > > key=726f772d6a31, columnParent='QueryPath(columnFamilyName='Test1', > > superColumnName='null', columnName='null')', columns=[dummy-col,]) locally > > DEBUG 08:46:22,169 weakreadlocal reading > > SliceByNamesReadCommand(table='Harvest', key=726f772d6a31, > > columnParent='QueryPath(columnFamilyName='Test1', superColumnName='null', > > columnName='null')', columns=[dummy-col,]) > > > > On Dec 29, 2010, at 8:27 PM, Jonathan Ellis wrote: > > > > deletes "win" races, so if 3) happens at the same timestamp as 2) then > > the delete takes precedence. > > > > On Wed, Dec 29, 2010 at 9:58 PM, mike dooley <doo...@apple.com> wrote: > > > > sorry, i forgot to mention that i am using 0.7-rc2 > > > > On Dec 29, 2010, at 7:56 PM, mike dooley wrote: > > > > things have not been going very well for me today, so maybe there's > > something > > > > that i'm missing, but here is a little test program that just: > > > > 1) inserts a single column in a row, > > > > 2) deletes the row, > > > > 3) re-inserts the row > > > > but it seems that the second insert fails to actually insert the data. here > > is the output > > > > of the test program > > > > === starting > > > > === inserting row: row-a, value: value-a > > > > === about to retrieve data > > > > === got (dummy-col,value-a) > > > > === deleting row: row-a > > > > === data not found, as expected > > > > === re-inserting row: row-a > > > > === !!!! re-inserted data not found > > > > === crush all boxes > > > > and subsequent inserts also fail (if you run the program again). > > > > here is the test program > > > > <CClient.java> > > > > i am just using a single node, with the following schema > > > > create keyspace Harvest with replication_factor = 1 and placement_strategy > > = 'org.apache.cassandra.locator.SimpleStrategy'; > > > > use Harvest; > > > > create column family Test1 with column_type = 'Standard' and comparator = > > 'UTF8Type'; > > > > thanks in advance. > > > > -mike > > > > > > > > > > > > -- > > Jonathan Ellis > > Project Chair, Apache Cassandra > > co-founder of Riptano, the source for professional Cassandra support > > http://riptano.com > > > > >
