josh-mckenzie commented on a change in pull request #1213:
URL: https://github.com/apache/cassandra/pull/1213#discussion_r722456676



##########
File path: src/java/org/apache/cassandra/schema/PartitionDenylist.java
##########
@@ -0,0 +1,462 @@
+/*
+ * Licensed to the Apache Software Foundation (ASF) under one
+ * or more contributor license agreements.  See the NOTICE file
+ * distributed with this work for additional information
+ * regarding copyright ownership.  The ASF licenses this file
+ * to you under the Apache License, Version 2.0 (the
+ * "License"); you may not use this file except in compliance
+ * with the License.  You may obtain a copy of the License at
+ *
+ *     http://www.apache.org/licenses/LICENSE-2.0
+ *
+ * Unless required by applicable law or agreed to in writing, software
+ * distributed under the License is distributed on an "AS IS" BASIS,
+ * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ * See the License for the specific language governing permissions and
+ * limitations under the License.
+ */
+
+package org.apache.cassandra.schema;
+
+import java.nio.ByteBuffer;
+import java.util.HashMap;
+import java.util.HashSet;
+import java.util.Map;
+import java.util.NavigableSet;
+import java.util.Set;
+import java.util.TreeSet;
+import java.util.concurrent.Callable;
+import java.util.concurrent.ExecutionException;
+import java.util.concurrent.ExecutorService;
+import java.util.concurrent.LinkedBlockingQueue;
+import java.util.concurrent.ThreadPoolExecutor;
+import java.util.concurrent.TimeUnit;
+
+import com.google.common.cache.CacheBuilder;
+import com.google.common.cache.CacheLoader;
+import com.google.common.cache.LoadingCache;
+import com.google.common.collect.ImmutableSet;
+import com.google.common.collect.ImmutableSortedSet;
+import com.google.common.util.concurrent.ListenableFuture;
+import com.google.common.util.concurrent.ListenableFutureTask;
+import org.slf4j.Logger;
+import org.slf4j.LoggerFactory;
+
+import org.apache.cassandra.concurrent.ScheduledExecutors;
+import org.apache.cassandra.config.DatabaseDescriptor;
+import org.apache.cassandra.cql3.UntypedResultSet;
+import org.apache.cassandra.db.PartitionPosition;
+import org.apache.cassandra.dht.AbstractBounds;
+import org.apache.cassandra.dht.Token;
+import org.apache.cassandra.exceptions.RequestExecutionException;
+import org.apache.cassandra.service.StorageService;
+import org.apache.cassandra.service.reads.range.RangeCommands;
+import org.apache.cassandra.utils.Hex;
+import org.apache.cassandra.utils.Pair;
+
+import static org.apache.cassandra.cql3.QueryProcessor.process;
+
+/**
+ * PartitionDenylist uses the system_distributed.partition_denylist table to 
maintain a list of denylisted partition keys
+ * for each keyspace/table.
+ *
+ * Keys can be entered manually into the partition_denylist table or via the 
JMX operation StorageProxyMBean.denylistKey
+ *
+ * The denylist is stored as one CQL partition per table, and the denylisted 
keys are column names in that partition. The denylisted
+ * keys for each table are cached in memory, and reloaded from the 
partition_denylist table every 24 hours (default) or when the
+ * StorageProxyMBean.loadPartitionDenylist is called via JMX.
+ *
+ * Concurrency of the cache is provided by the concurrency semantics of the 
guava LoadingCache. All values (DenylistEntry) are
+ * immutable collections of keys/tokens which are replaced in whole when the 
cache refreshes from disk.
+ */
+public class PartitionDenylist
+{
+    private static final Logger logger = 
LoggerFactory.getLogger(PartitionDenylist.class);
+    public static final String PARTITION_DENYLIST_TABLE = "partition_denylist";
+
+    private final ExecutorService executor = new ThreadPoolExecutor(2, 2, 
Long.MAX_VALUE, TimeUnit.SECONDS, new LinkedBlockingQueue<>());
+
+    /** We effectively don't use our initial empty cache to denylist until the 
{@link #load()} call which will replace it */
+    private volatile LoadingCache<TableId, DenylistEntry> denylist = 
buildEmptyCache();
+
+    /**
+     * Denylist entry is never mutated once constructed, only replaced with a 
new entry when the cache is refreshed
+     */
+    private static class DenylistEntry
+    {
+        public final ImmutableSet<ByteBuffer> keys;
+        public final ImmutableSortedSet<Token> tokens;
+
+        public DenylistEntry()
+        {
+            keys = ImmutableSet.of();
+            tokens = ImmutableSortedSet.of();
+        }
+
+        public DenylistEntry(final ImmutableSet<ByteBuffer> keys, final 
ImmutableSortedSet<Token> tokens)
+        {
+            this.keys = keys;
+            this.tokens = tokens;
+        }
+    }
+
+    // synchronized on this
+    private int loadAttempts = 0;
+    private int loadSuccesses = 0;
+
+    public synchronized int getLoadAttempts()
+    {
+        return loadAttempts;
+    }
+    public synchronized int getLoadSuccesses()
+    {
+        return loadSuccesses;
+    }
+
+    /**
+     * Performs initial load of the partition denylist.  Should be called at 
startup and only loads if the operation
+     * is expected to succeed.  If it is not possible to load at call time, a 
timer is set to retry.
+     */
+    public void initialLoad()
+    {
+        if (!DatabaseDescriptor.enablePartitionDenylist())
+            return;
+
+        synchronized (this)
+        {
+            loadAttempts++;
+        }
+
+        // Check if there are sufficient nodes to attempt reading all the 
denylist partitions before issuing the query.
+        // The pre-check prevents definite range-slice unavailables being 
marked and triggering an alert.  Nodes may still change
+        // state between the check and the query, but it should significantly 
reduce the alert volume.
+        String retryReason = "Insufficient nodes";
+        try
+        {
+            if (readAllHasSufficientNodes() && load())
+            {
+                return;
+            }
+        }
+        catch (Throwable tr)
+        {
+            logger.error("Failed to load partition denylist", tr);
+            retryReason = "Exception";
+        }
+
+        // This path will also be taken on other failures other than 
UnavailableException,
+        // but seems like a good idea to retry anyway.
+        int retryInSeconds = 
DatabaseDescriptor.getDenylistInitialLoadRetrySeconds();
+        logger.info(retryReason + " while loading partition denylist cache.  
Scheduled retry in {} seconds.",
+                    retryInSeconds);
+        ScheduledExecutors.optionalTasks.schedule(this::initialLoad, 
retryInSeconds, TimeUnit.SECONDS);
+    }
+
+    private boolean readAllHasSufficientNodes()
+    {
+        return 
RangeCommands.sufficientLiveNodesForSelectStar(SystemDistributedKeyspace.PartitionDenylistTable,
+                                                              
DatabaseDescriptor.getDenylistConsistencyLevel());
+    }
+
+    /** Helper method as we need to both build cache on initial init but also 
on reload of cache contents and params */
+    private LoadingCache<TableId, DenylistEntry> buildEmptyCache()
+    {
+        return CacheBuilder.newBuilder()
+                           
.refreshAfterWrite(DatabaseDescriptor.getDenylistRefreshSeconds(), 
TimeUnit.SECONDS)
+                           .build(new CacheLoader<TableId, DenylistEntry>()
+                           {
+                               @Override
+                               public DenylistEntry load(final TableId tid) 
throws Exception
+                               {
+                                   return getDenylistForTable(tid);
+                               }
+
+                               @Override
+                               public ListenableFuture<DenylistEntry> 
reload(final TableId tid, final DenylistEntry oldValue)
+                               {
+                                   ListenableFutureTask<DenylistEntry> task = 
ListenableFutureTask.create(new Callable<DenylistEntry>()
+                                   {
+                                       @Override
+                                       public DenylistEntry call()
+                                       {
+                                           final DenylistEntry newEntry = 
getDenylistForTable(tid);
+                                           if (newEntry != null)
+                                               return newEntry;
+                                           if (oldValue != null)
+                                               return oldValue;
+                                           return new DenylistEntry();
+                                       }
+                                   });
+                                   executor.execute(task);
+                                   return task;
+                               }
+                           });
+    }
+
+    /**
+     * We need to fully rebuild a new cache to accommodate deleting items from 
the denylist and potentially shrinking
+     * the max allowable size in the list. We do not serve queries out of this 
denylist until it is populated
+     * so as not to introduce a window of having a partially filled cache 
allow denylisted entries.
+     */
+    public boolean load()
+    {
+        final long start = System.currentTimeMillis();
+
+        final Map<TableId, DenylistEntry> allDenylists = 
getDenylistForAllTables();
+        if (allDenylists == null)
+            return false;
+
+        // On initial load we have the slight overhead of GC'ing our initial 
empty cache
+        LoadingCache<TableId, DenylistEntry> newDenylist = buildEmptyCache();
+        newDenylist.putAll(allDenylists);
+
+        synchronized (this)
+        {
+            loadSuccesses++;
+        }
+        denylist = newDenylist;
+        logger.info("Loaded partition denylist cache in {}ms", 
System.currentTimeMillis() - start);
+        return true;
+    }
+
+    /**
+     * We expect the caller to confirm that we are working with a valid 
keyspace and table. Further, we expect the usage
+     * pattern of this to be one-off key by key, not in a bulk process, so we 
relead the entire table's deny list entry
+     * on an addition or removal.
+     */
+    public boolean addKeyToDenylist(final String keyspace, final String table, 
final ByteBuffer key)
+    {
+        if (!isPermitted(keyspace))
+            return false;
+
+        final byte[] keyBytes = new byte[key.remaining()];
+        key.slice().get(keyBytes);
+
+        final String insert = String.format("INSERT INTO 
system_distributed.partition_denylist (ks_name, cf_name, key) VALUES ('%s', 
'%s', 0x%s)",
+                                            keyspace, table, 
Hex.bytesToHex(keyBytes));
+
+        try
+        {
+            process(insert, DatabaseDescriptor.getDenylistConsistencyLevel());
+
+            // On insert, we refresh the entire table's deny list data.
+            TableId denyTableId = getTableId(keyspace, table);
+            denylist.put(denyTableId, getDenylistForTable(getTableId(keyspace, 
table)));

Review comment:
       So the scenario causing the concern is:
   1. A denylist entry is added for PK N. Node A and B receive it, C does not 
due to unavailability. Quorum is achieved on the denylist change.
   2. A query comes in for PK N to Node B
   3. ???
   
   This would depend on the CL of the query on PK N right? If you ask for 
CL.ONE, you're definitely at risk of getting data that's not deny listed 
correctly for sure. If you query at any other CL, you should get rejection from 
Node A and C as they received the denylist update and properly reject the query.
   
   Our options to tighten this up would be to force CL.ALL for denylist 
modifications (which we effectively do right now in our codepaths for 
initialLoad relying on sufficientLiveNodes()...) which introduces availability 
issues to using the feature, or to for a higher CL for mutations to Keyspaces 
that have deny-listed keys which isn't really an option.
   
   Not updating the data in memory once the denylist CQL mutation succeeds 
broadens the window of time between the initial expression of intent of an 
operator (deny access to this key!) data being in CQL and data loading in your 
denylist cache. While we get the "RF-wide atomicity" property of calling 
`sufficientLiveNodesForSelectStar` on the cache reload JMX call, it's at the 
cost of forcing the operator to take another step when they denylist a key as 
well as not allowing cache refresh unless all nodes in the replica set for the 
cache are available.
   
   Hm... _I think we do have a problem though_. There's no mechanism for 
refreshing the in-memory cache based on post-hoc adjustments to the underlying 
system_distributed table (streaming, repair, hints). While we could hook into 
`Keyspaces.applyInternal `similarly to how we handle view mutations 
w/`requiresViewUpdate` and then push denylist changes through the 
PartitionDenylist mechanisms... I'm not sure we should.
   
   This puts us squarely in the "denylist cache refresh requires all nodes to 
be up in order for you to update the denied keys in memory" no matter how we 
slice it, so maybe the initial implementation of just having it be a two step 
process for operators (1. adjust CQL/JMX, 2. reload your cache) is the right 
way after all.
   
   Let me think on this a bit more. Interesting problem.




-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]



---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to