Re: Data Deleted After a few days of being off

[Oleksandr Shulgin]

On 27 Feb 2018 20:58, "A"  wrote:

No. I inserted using USING TTL 86400;


Well, that answers your question I believe?

--
Alex

Re: Data Deleted After a few days of being off

[A]

 No. I inserted using USING TTL 86400; 
On Monday, February 26, 2018, 11:45:07 PM PST, Oleksandr Shulgin 
 wrote:  
 
 On Tue, Feb 27, 2018 at 7:37 AM, A  wrote:


I started going through the logs and haven't noticed anything yet... Very 
unexpected behavior.

Maybe I'm asking the obvious, but were your inserts *without* a TTL?
--Alex
  

Re: Data Deleted After a few days of being off

[Carl Mueller]

Does cassandra still function if the commitlog dir has no writes? Will the
data still go into the memtable and serve queries?

On Tue, Feb 27, 2018 at 1:37 AM, Oleksandr Shulgin <
oleksandr.shul...@zalando.de> wrote:

> On Tue, Feb 27, 2018 at 7:37 AM, A  wrote:
>
>>
>> I started going through the logs and haven't noticed anything yet... Very
>> unexpected behavior.
>>
>
> Maybe I'm asking the obvious, but were your inserts *without* a TTL?
>
> --
> Alex
>
>

Re: Data Deleted After a few days of being off

[Oleksandr Shulgin]

On Tue, Feb 27, 2018 at 7:37 AM, A  wrote:

>
> I started going through the logs and haven't noticed anything yet... Very
> unexpected behavior.
>

Maybe I'm asking the obvious, but were your inserts *without* a TTL?

--
Alex

Re: Data Deleted After a few days of being off

[@Nandan@]

Please check your error.log file once. As you checked it means Your data is
not coming into Data file. I will suggest you to check your error.log file
once.

On Tue, Feb 27, 2018 at 2:37 PM, A  wrote:

> Hey there. Thanks for your response.
>
> Yes.  I absolutely inserted the data correctly and queried it many times
> through cqlsh> as well as through node.js.
>
> I started going through the logs and haven't noticed anything yet... Very
> unexpected behavior.
>
> Thanks.
> A
>
>
> Sent from Yahoo Mail for iPad 
>
>
> On Monday, February 26, 2018, 9:23 PM, @Nandan@ <
> nandanpriyadarshi...@gmail.com> wrote:
>
> Hi A,
> As I am able to  understand your question :-
> 1) You inserted some data into your table and that was inserted
> successfully.
> 2) Then you stop the cassandra servie.
> 3) After few days you started your service and you checked your Table and
> there were no data.
> Did you cross verified once you inserted data that , data is inserted
> correctly or not. and Did you check system.log file , In case you got some
> message there.
> Please cross check once.
>
> On Tue, Feb 27, 2018 at 1:16 PM, A  wrote:
>
> I'm new to Cassandra.  Trying it out to see if it will work for my
> upcoming project.  I created a test keyspace and table on my dev laptop.
> Loaded it with some data on a Friday and closed her down.  Returned on
> Monday and looked up the data and it was gone.  The keyspace and table was
> there, but table was empty.  This has happened twice so far.
>
> Help...
>
> Thanks,
> Angel
>
>
>

Re: Data Deleted After a few days of being off

[Justin Cameron]

Cassandra data files are located at /var/lib/cassandra/data (
http://cassandra.apache.org/doc/latest/configuration/cassandra_config_file.html#data-file-directories
)

Can you double check that the Cassandra process has write access to this
directory? There should be a number of SSTable files in the directory if
Cassandra has written the data to disk. When you start Cassandra the system
log will also show each SSTable being loaded.

It could be possible that something is stopping the memtables from being
flushed to disk or being read by Cassandra.

On Tue, 27 Feb 2018 at 17:37 A  wrote:

> Hey there. Thanks for your response.
>
> Yes.  I absolutely inserted the data correctly and queried it many times
> through cqlsh> as well as through node.js.
>
> I started going through the logs and haven't noticed anything yet... Very
> unexpected behavior.
>
> Thanks.
> A
>
>
> Sent from Yahoo Mail for iPad 
>
>
> On Monday, February 26, 2018, 9:23 PM, @Nandan@ <
> nandanpriyadarshi...@gmail.com> wrote:
>
> Hi A,
> As I am able to  understand your question :-
> 1) You inserted some data into your table and that was inserted
> successfully.
> 2) Then you stop the cassandra servie.
> 3) After few days you started your service and you checked your Table and
> there were no data.
> Did you cross verified once you inserted data that , data is inserted
> correctly or not. and Did you check system.log file , In case you got some
> message there.
> Please cross check once.
>
> On Tue, Feb 27, 2018 at 1:16 PM, A  wrote:
>
> I'm new to Cassandra.  Trying it out to see if it will work for my
> upcoming project.  I created a test keyspace and table on my dev laptop.
> Loaded it with some data on a Friday and closed her down.  Returned on
> Monday and looked up the data and it was gone.  The keyspace and table was
> there, but table was empty.  This has happened twice so far.
>
> Help...
>
> Thanks,
> Angel
>
>
> --


*Justin Cameron*Senior Software Engineer





This email has been sent on behalf of Instaclustr Pty. Limited (Australia)
and Instaclustr Inc (USA).

This email and any attachments may contain confidential and legally
privileged information.  If you are not the intended recipient, do not copy
or disclose its content, but please reply to this email immediately and
highlight the error to the sender and then immediately delete the message.

Re: Data Deleted After a few days of being off

[A]

 blockquote, div.yahoo_quoted { margin-left: 0 !important; border-left:1px 
#715FFA solid !important; padding-left:1ex !important; background-color:white 
!important; } Hey there. Thanks for your response.
Yes.  I absolutely inserted the data correctly and queried it many times 
through cqlsh> as well as through node.js. 
I started going through the logs and haven't noticed anything yet... Very 
unexpected behavior.
Thanks.A

Sent from Yahoo Mail for iPad


On Monday, February 26, 2018, 9:23 PM, @Nandan@ 
 wrote:

Hi A,As I am able to  understand your question :-1) You inserted some data into 
your table and that was inserted successfully. 2) Then you stop the cassandra 
servie. 3) After few days you started your service and you checked your Table 
and there were no data. Did you cross verified once you inserted data that , 
data is inserted correctly or not. and Did you check system.log file , In case 
you got some message there. Please cross check once. 
On Tue, Feb 27, 2018 at 1:16 PM, A  wrote:

I'm new to Cassandra.  Trying it out to see if it will work for my upcoming 
project.  I created a test keyspace and table on my dev laptop.  Loaded it with 
some data on a Friday and closed her down.  Returned on Monday and looked up 
the data and it was gone.  The keyspace and table was there, but table was 
empty.  This has happened twice so far.
Help...
Thanks,Angel

Re: Data Deleted After a few days of being off

[@Nandan@]

Hi A,
As I am able to  understand your question :-
1) You inserted some data into your table and that was inserted
successfully.
2) Then you stop the cassandra servie.
3) After few days you started your service and you checked your Table and
there were no data.
Did you cross verified once you inserted data that , data is inserted
correctly or not. and Did you check system.log file , In case you got some
message there.
Please cross check once.

On Tue, Feb 27, 2018 at 1:16 PM, A  wrote:

> I'm new to Cassandra.  Trying it out to see if it will work for my
> upcoming project.  I created a test keyspace and table on my dev laptop.
> Loaded it with some data on a Friday and closed her down.  Returned on
> Monday and looked up the data and it was gone.  The keyspace and table was
> there, but table was empty.  This has happened twice so far.
>
> Help...
>
> Thanks,
> Angel
>

Data Deleted After a few days of being off

[A]

I'm new to Cassandra.  Trying it out to see if it will work for my upcoming 
project.  I created a test keyspace and table on my dev laptop.  Loaded it with 
some data on a Friday and closed her down.  Returned on Monday and looked up 
the data and it was gone.  The keyspace and table was there, but table was 
empty.  This has happened twice so far.
Help...
Thanks,Angel