On Mon, Sep 25, 2017 at 11:16:36AM +0200, Michiel Buddingh wrote: > We are currently in the process of migrating data from an old Cassandra > cluster to a new one. When quering data from a table that was copied using > sstableloader, we find that even at consistency level ALL, results contain > 200% duplicate entries, or worse, keep paginating and repeating themselves > forever.
For what it's worth, this turned out to be due to the way Cassandra paginates. It considers the last page reached when the number of returned results is smaller than the page size. If duplicate entries make the last page larger than the page size, pagination never terminates. A 'nodetool scrub' cleared up the duplicate entries. -- Michiel --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@cassandra.apache.org For additional commands, e-mail: user-h...@cassandra.apache.org