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