You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Peter Machon (Jira)" <ji...@apache.org> on 2025/01/14 21:20:00 UTC

[jira] [Created] (CASSANDRA-20205) Failed lightweight transaction leaves Paxos in apparently unresolvable state

Peter Machon created CASSANDRA-20205:
----------------------------------------

             Summary: Failed lightweight transaction leaves Paxos in apparently unresolvable state
                 Key: CASSANDRA-20205
                 URL: https://issues.apache.org/jira/browse/CASSANDRA-20205
             Project: Apache Cassandra
          Issue Type: Bug
            Reporter: Peter Machon


In three node Cassandra cluster I am consistently facing the same kind of fatal situation on tables that are solely written using Cassandra's lightweight transactions (CAS).

Whenever a lightweight transaction fails to reach quorum (1/2), e.g. due to high load, any following attempt to write data within a transactions fails, i.e. does not return {{{}"[applied]"=true{}}}.

Using {{{}select * from system.paxos where cf_id=<id of table>{}}}, I see that there are entries, which I assume to be pending transactions.

Further, in {{/var/log/Cassandra/system.log}} I see logs like:
{quote}INFO [ScheduledTasks:1] 2025-01-12 21:46:53,005 UncommittedTableData.java:567 - Scheduling uncommitted paxos data merge task for {{<any other table>}}
{quote}
{quote}INFO [OptionalTasks:1] 2025-01-12 21:46:53,006 PaxosCleanupLocalCoordinator.java:89 - Completing uncommitted paxos instances for {{<table in stalled state>}} on ranges
{quote}
However, I can't figure how to resolve the state {{nodetool repair -full <keyspace>}} (and variations), as well as restarting all nodes did not resolve the issue.

_Further information:_
 * Cassandra version: 4.1.5
 * OS: Ubuntu 22.04
 * replication strategy: SimpleStrategy
 * replication factor: 3



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org