Re: Table not updating

2020-03-24 Thread Oliver Herrmann
Hi Erick, thank you for the hint with NTP. For some reasons ntpd was not running on a few nodes and time was off by 2 Minutes. After restarting ntpd and adjusting the time everything is working as expected. Thank you very much. Al the best. Am Di., 24. März 2020 um 01:47 Uhr schrieb Erick Ramirez

Table not updating

2020-03-23 Thread Oliver Herrmann
Hello, we are facing a strange issue in one of our Cassandra clusters. We are using prepared statements to update a table with consistency local quorum. When updating some tables it happes very often that data values are not written to the database. When verifying the table using cqlsh (with consi

repair failed

2019-12-28 Thread Oliver Herrmann
Hello, today the second time our weekly repair job failed which was working for many month without a problem. We are having multiple Cassandra nodes in two data center. The repair command is started only on one node with the following parameters: nodetool repair -full -dcpar Is it problematic i

Re: Table dropped during repair

2019-05-20 Thread Oliver Herrmann
op table statement? > > -- > Jeff Jirsa > > > > On May 20, 2019, at 9:14 AM, Oliver Herrmann > wrote: > > > > Hi, > > > > while we were running 'nodetool repair -full -dcpar' on one node we got > the following error: > > > > ERROR

Table dropped during repair

2019-05-20 Thread Oliver Herrmann
Hi, while we were running 'nodetool repair -full -dcpar' on one node we got the following error: ERROR [AntiEntropyStage:1] 2019-05-18 16:00:04,808 RepairMessageVerbHandler.java:177 - Table with id 5fb6b730-4ec3-11e9-b426-c3afc7dfebf6 was dropped during prepare phase of repair It looks like the

Sometimes DELETE of a row that was INSERT shortly before does not work

2018-12-10 Thread Oliver Herrmann
Hi, we are having an issue that sometimes a row is not deleted when it was inserted a short time before. The cluster has two datacenter each with 3 nodes running C* 3.11.3. The clients are using Datastax cpp driver 2.10.0 on RHEL-7 with consistency level quorum for INSERT, DELETE and SELECT. When

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

AW:Problem with restoring a snapshot using sstableloader

2018-11-30 Thread Oliver Herrmann
ses 2 last path components as keyspace and table names.On Fri, Nov 30, 2018 at 11:54 AM Oliver Herrmann <o.herrmann...@gmail.com> wrote: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 woul

Re: Problem with restoring a snapshot using sstableloader

2018-11-30 Thread Oliver Herrmann
hul...@zalando.de>: > 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 >> fold

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 node