Re: Problem with restoring a snapshot using sstableloader

2018-12-03 Thread Oleksandr Shulgin
On Mon, Dec 3, 2018 at 4:24 PM Oliver Herrmann wrote: > > You are right. The number of nodes in our cluster is equal to the > replication factor. For that reason I think it should be sufficient to call > sstableloader only from one node. > The next question is then: do you care about

Re: Problem with restoring a snapshot using sstableloader

2018-12-03 Thread Oliver Herrmann
Am So., 2. Dez. 2018 um 06:24 Uhr schrieb Oleksandr Shulgin < oleksandr.shul...@zalando.de>: > On Fri, 30 Nov 2018, 17:54 Oliver Herrmann >> When using nodetool refresh I must have write access to the data folder >> and I have to do it on every node. In our production environment the user >>

Re: Problem with restoring a snapshot using sstableloader

2018-12-02 Thread Alex Ott
It's a bug in the sstableloader introduced many years ago - before that, it worked as described in documentation... Oliver Herrmann at "Fri, 30 Nov 2018 17:05:43 +0100" wrote: OH> Hi, OH> I'm having some problems to restore a snapshot using sstableloader. I'm using cassandra 3.11.1 and

Re: Problem with restoring a snapshot using sstableloader

2018-12-01 Thread Oleksandr Shulgin
On Fri, 30 Nov 2018, 17:54 Oliver Herrmann When using nodetool refresh I must have write access to the data folder > and I have to do it on every node. In our production environment the user > that would do the restore does not have write access to the data folder. > OK, not entirely sure that's

Re: Problem with restoring a snapshot using sstableloader

2018-11-30 Thread Dmitry Saprykin
You need to move you files into directory named 'cass_testapp/table3/'. sstable loader uses 2 last path components as keyspace and table names. On Fri, Nov 30, 2018 at 11:54 AM Oliver Herrmann wrote: > When using nodetool refresh I must have write access to the data folder > and I have to do it

Re: Problem with restoring a snapshot using sstableloader

2018-11-30 Thread Oliver Herrmann
When using nodetool refresh I must have write access to the data folder and I have to do it on every node. In our production environment the user that would do the restore does not have write access to the data folder. Am Fr., 30. Nov. 2018 um 17:39 Uhr schrieb Oleksandr Shulgin <

Re: Problem with restoring a snapshot using sstableloader

2018-11-30 Thread Oleksandr Shulgin
On Fri, Nov 30, 2018 at 5:13 PM Oliver Herrmann wrote: > > I'm always getting the message "Skipping file mc-11-big-Data.db: table > snapshots.table3 doesn't exist". I also tried to rename the snapshots > folder into the keyspace name (cass_testapp) but then I get the message > "Skipping file

Problem with restoring a snapshot using sstableloader

2018-11-30 Thread Oliver Herrmann
Hi, I'm having some problems to restore a snapshot using sstableloader. I'm using cassandra 3.11.1 and followed the instructions for a creating and restoring from this page: https://docs.datastax.com/en/dse/6.0/dse-admin/datastax_enterprise/tools/toolsSStables/toolsBulkloader.html 1. Called