How recovery Cassandra from deserializing mutation error:












0















I have a single cassandra, now this error appears when I start the server:



ERROR 11:18:45 Exiting due to error while processing commit log during initialization.
org.apache.cassandra.db.commitlog.CommitLogReadHandler$CommitLogReadException: Unexpected error deserializing mutation; saved to /tmp/mutation4787806670239768067dat. This may be caused by replaying a mutation against a table with the same name but incompatible schema. Exception follows: org.apache.cassandra.serializers.MarshalException: A local deletion time should not be negative


If I delete all the commitlog and saved_cached files the server goes up, but the next day when I reboot the cassandra, the error occurs again.



What's wrong? How to make cassandra stable again?



I use cassandra 3.9, but I tried to upgrade to 3.11 and nothing has changed.










share|improve this question























  • A local deletion time should not be negative Is there large TTLs or deletes in your application? Why are you rebooting cassandra (unrelated question)?

    – Chris Lohfink
    Nov 26 '18 at 3:30













  • Because I use the same server to cassandra and tomcat, I reboot all system 1x day. In my application I use TTL > 5 minutes.

    – Edson Vicente Carli Junior
    Nov 26 '18 at 21:54






  • 1





    should open a jira at issues.apache.org/jira/browse/CASSANDRA including your /tmp/mutation4787806670239768067dat

    – Chris Lohfink
    Nov 27 '18 at 3:21











  • Created issues.apache.org/jira/browse/…

    – Edson Vicente Carli Junior
    Nov 29 '18 at 10:21
















0















I have a single cassandra, now this error appears when I start the server:



ERROR 11:18:45 Exiting due to error while processing commit log during initialization.
org.apache.cassandra.db.commitlog.CommitLogReadHandler$CommitLogReadException: Unexpected error deserializing mutation; saved to /tmp/mutation4787806670239768067dat. This may be caused by replaying a mutation against a table with the same name but incompatible schema. Exception follows: org.apache.cassandra.serializers.MarshalException: A local deletion time should not be negative


If I delete all the commitlog and saved_cached files the server goes up, but the next day when I reboot the cassandra, the error occurs again.



What's wrong? How to make cassandra stable again?



I use cassandra 3.9, but I tried to upgrade to 3.11 and nothing has changed.










share|improve this question























  • A local deletion time should not be negative Is there large TTLs or deletes in your application? Why are you rebooting cassandra (unrelated question)?

    – Chris Lohfink
    Nov 26 '18 at 3:30













  • Because I use the same server to cassandra and tomcat, I reboot all system 1x day. In my application I use TTL > 5 minutes.

    – Edson Vicente Carli Junior
    Nov 26 '18 at 21:54






  • 1





    should open a jira at issues.apache.org/jira/browse/CASSANDRA including your /tmp/mutation4787806670239768067dat

    – Chris Lohfink
    Nov 27 '18 at 3:21











  • Created issues.apache.org/jira/browse/…

    – Edson Vicente Carli Junior
    Nov 29 '18 at 10:21














0












0








0








I have a single cassandra, now this error appears when I start the server:



ERROR 11:18:45 Exiting due to error while processing commit log during initialization.
org.apache.cassandra.db.commitlog.CommitLogReadHandler$CommitLogReadException: Unexpected error deserializing mutation; saved to /tmp/mutation4787806670239768067dat. This may be caused by replaying a mutation against a table with the same name but incompatible schema. Exception follows: org.apache.cassandra.serializers.MarshalException: A local deletion time should not be negative


If I delete all the commitlog and saved_cached files the server goes up, but the next day when I reboot the cassandra, the error occurs again.



What's wrong? How to make cassandra stable again?



I use cassandra 3.9, but I tried to upgrade to 3.11 and nothing has changed.










share|improve this question














I have a single cassandra, now this error appears when I start the server:



ERROR 11:18:45 Exiting due to error while processing commit log during initialization.
org.apache.cassandra.db.commitlog.CommitLogReadHandler$CommitLogReadException: Unexpected error deserializing mutation; saved to /tmp/mutation4787806670239768067dat. This may be caused by replaying a mutation against a table with the same name but incompatible schema. Exception follows: org.apache.cassandra.serializers.MarshalException: A local deletion time should not be negative


If I delete all the commitlog and saved_cached files the server goes up, but the next day when I reboot the cassandra, the error occurs again.



What's wrong? How to make cassandra stable again?



I use cassandra 3.9, but I tried to upgrade to 3.11 and nothing has changed.







database cassandra nosql






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Nov 25 '18 at 19:49









Edson Vicente Carli JuniorEdson Vicente Carli Junior

162




162













  • A local deletion time should not be negative Is there large TTLs or deletes in your application? Why are you rebooting cassandra (unrelated question)?

    – Chris Lohfink
    Nov 26 '18 at 3:30













  • Because I use the same server to cassandra and tomcat, I reboot all system 1x day. In my application I use TTL > 5 minutes.

    – Edson Vicente Carli Junior
    Nov 26 '18 at 21:54






  • 1





    should open a jira at issues.apache.org/jira/browse/CASSANDRA including your /tmp/mutation4787806670239768067dat

    – Chris Lohfink
    Nov 27 '18 at 3:21











  • Created issues.apache.org/jira/browse/…

    – Edson Vicente Carli Junior
    Nov 29 '18 at 10:21



















  • A local deletion time should not be negative Is there large TTLs or deletes in your application? Why are you rebooting cassandra (unrelated question)?

    – Chris Lohfink
    Nov 26 '18 at 3:30













  • Because I use the same server to cassandra and tomcat, I reboot all system 1x day. In my application I use TTL > 5 minutes.

    – Edson Vicente Carli Junior
    Nov 26 '18 at 21:54






  • 1





    should open a jira at issues.apache.org/jira/browse/CASSANDRA including your /tmp/mutation4787806670239768067dat

    – Chris Lohfink
    Nov 27 '18 at 3:21











  • Created issues.apache.org/jira/browse/…

    – Edson Vicente Carli Junior
    Nov 29 '18 at 10:21

















A local deletion time should not be negative Is there large TTLs or deletes in your application? Why are you rebooting cassandra (unrelated question)?

– Chris Lohfink
Nov 26 '18 at 3:30







A local deletion time should not be negative Is there large TTLs or deletes in your application? Why are you rebooting cassandra (unrelated question)?

– Chris Lohfink
Nov 26 '18 at 3:30















Because I use the same server to cassandra and tomcat, I reboot all system 1x day. In my application I use TTL > 5 minutes.

– Edson Vicente Carli Junior
Nov 26 '18 at 21:54





Because I use the same server to cassandra and tomcat, I reboot all system 1x day. In my application I use TTL > 5 minutes.

– Edson Vicente Carli Junior
Nov 26 '18 at 21:54




1




1





should open a jira at issues.apache.org/jira/browse/CASSANDRA including your /tmp/mutation4787806670239768067dat

– Chris Lohfink
Nov 27 '18 at 3:21





should open a jira at issues.apache.org/jira/browse/CASSANDRA including your /tmp/mutation4787806670239768067dat

– Chris Lohfink
Nov 27 '18 at 3:21













Created issues.apache.org/jira/browse/…

– Edson Vicente Carli Junior
Nov 29 '18 at 10:21





Created issues.apache.org/jira/browse/…

– Edson Vicente Carli Junior
Nov 29 '18 at 10:21












0






active

oldest

votes











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53471256%2fhow-recovery-cassandra-from-deserializing-mutation-error%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes
















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53471256%2fhow-recovery-cassandra-from-deserializing-mutation-error%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

A CLEAN and SIMPLE way to add appendices to Table of Contents and bookmarks

Calculate evaluation metrics using cross_val_predict sklearn

Insert data from modal to MySQL (multiple modal on website)