YugabyteDB (2.13.1.0-b60, 21121d69985fbf76aa6958d8f04a9bfa936293b5)

// 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.

//

// The following only applies to changes made to this file as part of YugaByte development.

//

// Portions Copyright (c) YugaByte, Inc.

//

// Licensed 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.

//

#include "yb/integration-tests/test_workload.h"

#include <memory>

#include <string>

#include <unordered_set>

#include <vector>

#include "yb/client/client-test-util.h"

#include "yb/client/client.h"

#include "yb/client/error.h"

#include "yb/client/schema.h"

#include "yb/client/session.h"

#include "yb/client/table_creator.h"

#include "yb/client/table_handle.h"

#include "yb/client/table_info.h"

#include "yb/client/transaction.h"

#include "yb/client/transaction_pool.h"

#include "yb/client/yb_op.h"

#include "yb/common/wire_protocol-test-util.h"

#include "yb/gutil/casts.h"

#include "yb/gutil/stl_util.h"

#include "yb/gutil/strings/substitute.h"

#include "yb/integration-tests/mini_cluster_base.h"

#include "yb/master/master_util.h"

#include "yb/util/env.h"

#include "yb/util/monotime.h"

#include "yb/util/random.h"

#include "yb/util/random_util.h"

#include "yb/util/status_log.h"

#include "yb/util/thread.h"

#include "yb/util/tsan_util.h"

#include "yb/yql/cql/ql/util/statement_result.h"

using namespace std::literals;

namespace yb {

using client::YBClient;

using client::YBClientBuilder;

using client::YBSchema;

using client::YBSchemaBuilder;

using client::YBSchemaFromSchema;

using client::YBSession;

using client::YBTable;

using client::YBTableCreator;

using client::YBTableType;

using client::YBTableName;

using std::shared_ptr;

const YBTableName TestWorkloadOptions::kDefaultTableName(

    YQL_DATABASE_CQL, "my_keyspace", "test-workload");

class TestWorkload::State {

 public:

  explicit State(MiniClusterBase* cluster) : cluster_(cluster) {}

  void Start(const TestWorkloadOptions& options);

  void Setup(YBTableType table_type, const TestWorkloadOptions& options);

  void Stop() {

    should_run_.store(false, std::memory_order_release);

    start_latch_.Reset(0);

  }

  void Join() {

    for (const auto& thr : threads_) {

      CHECK_OK(ThreadJoiner(thr.get()).Join());

    }

    threads_.clear();

  }

  void set_transaction_pool(client::TransactionPool* pool) {

    transaction_pool_ = pool;

  }

  int64_t rows_inserted() const {

    return rows_inserted_.load(std::memory_order_acquire);

  }

  int64_t rows_insert_failed() const {

    return rows_insert_failed_.load(std::memory_order_acquire);

  }

  int64_t rows_read_ok() const {

    return rows_read_ok_.load(std::memory_order_acquire);

  }

  int64_t rows_read_empty() const {

    return rows_read_empty_.load(std::memory_order_acquire);

  }

  int64_t rows_read_error() const {

    return rows_read_error_.load(std::memory_order_acquire);

  }

  int64_t rows_read_try_again() const {

    return rows_read_try_again_.load(std::memory_order_acquire);

  }

  int64_t batches_completed() const {

    return batches_completed_.load(std::memory_order_acquire);

  }

  client::YBClient& client() const {

    return *client_;

  }

 private:

  CHECKED_STATUS Flush(client::YBSession* session, const TestWorkloadOptions& options);

  Result<client::YBTransactionPtr> MayBeStartNewTransaction(

      client::YBSession* session, const TestWorkloadOptions& options);

  Result<client::TableHandle> OpenTable(const TestWorkloadOptions& options);

  void WaitAllThreads();

  void WriteThread(const TestWorkloadOptions& options);

  void ReadThread(const TestWorkloadOptions& options);

  MiniClusterBase* cluster_;

  std::unique_ptr<client::YBClient> client_;

  client::TransactionPool* transaction_pool_;

  CountDownLatch start_latch_{0};

  std::atomic<bool> should_run_{false};

  std::atomic<int64_t> pathological_one_row_counter_{0};

  std::atomic<bool> pathological_one_row_inserted_{false};

  std::atomic<int64_t> rows_inserted_{0};

  std::atomic<int64_t> rows_insert_failed_{0};

  std::atomic<int64_t> batches_completed_{0};

  std::atomic<int32_t> next_key_{0};

  std::atomic<int64_t> rows_read_ok_{0};

  std::atomic<int64_t> rows_read_empty_{0};

  std::atomic<int64_t> rows_read_error_{0};

  std::atomic<int64_t> rows_read_try_again_{0};

  // Invariant: if sequential_write and read_only_written_keys are set then

  // keys in [1 ... next_key_] and not in keys_in_write_progress_ are guaranteed to be written.

  std::mutex keys_in_write_progress_mutex_;

  std::set<int32_t> keys_in_write_progress_ GUARDED_BY(keys_in_write_progress_mutex_);

  std::vector<scoped_refptr<Thread> > threads_;

};

TestWorkload::TestWorkload(MiniClusterBase* cluster)

  : state_(new State(cluster)) {}

TestWorkload::~TestWorkload() {

  StopAndJoin();

}

TestWorkload::TestWorkload(TestWorkload&& rhs)

    : options_(rhs.options_), state_(std::move(rhs.state_)) {}

void TestWorkload::operator=(TestWorkload&& rhs) {

  options_ = rhs.options_;

  state_ = std::move(rhs.state_);

}

Result<client::YBTransactionPtr> TestWorkload::State::MayBeStartNewTransaction(

    client::YBSession* session, const TestWorkloadOptions& options) {

  client::YBTransactionPtr txn;

  if (options.is_transactional()) {

    txn = VERIFY_RESULT(transaction_pool_->TakeAndInit(

        options.isolation_level, TransactionRpcDeadline()));

    session->SetTransaction(txn);

  }

  return txn;

}

Result<client::TableHandle> TestWorkload::State::OpenTable(const TestWorkloadOptions& options) {

  client::TableHandle table;

  // Loop trying to open up the table. In some tests we set up very

  // low RPC timeouts to test those behaviors, so this might fail and

  // need retrying.

  for(;;) {

    auto s = table.Open(options.table_name, client_.get());

    if (s.ok()) {

      return table;

    }

    if (!should_run_.load(std::memory_order_acquire)) {

      LOG(ERROR) << "Failed to open table: " << s;

      return s;

    }

    if (options.timeout_allowed && 
s.IsTimedOut()0
) {

      SleepFor(MonoDelta::FromMilliseconds(50));

      continue;

    }

    LOG(FATAL) << "Failed to open table: " << s;

    return s;

  }

}

void TestWorkload::State::WaitAllThreads() {

  // Wait for all of the workload threads to be ready to go. This maximizes the chance

  // that they all send a flood of requests at exactly the same time.

  //

  // This also minimizes the chance that we see failures to call OpenTable() if

  // a late-starting thread overlaps with the flood of outbound traffic from the

  // ones that are already writing data.

  start_latch_.CountDown();

  start_latch_.Wait();

}

void TestWorkload::State::WriteThread(const TestWorkloadOptions& options) {

  auto next_random = [rng = &ThreadLocalRandom()] {

    return RandomUniformInt<int32_t>(rng);

  };

  auto table_result = OpenTable(options);

  if (!table_result.ok()) {

    return;

  }

  auto table = *table_result;

  shared_ptr<YBSession> session = client_->NewSession();

  session->SetTimeout(options.write_timeout);

  WaitAllThreads();

  std::string test_payload("hello world");

  if (options.payload_bytes != 11) {

    // We fill with zeros if you change the default.

    test_payload.assign(options.payload_bytes, '0');

  }

  bool inserting_one_row = false;

  std::vector<client::YBqlWriteOpPtr> retry_ops;

  for (;;) {

    const auto should_run = should_run_.load(std::memory_order_acquire);

    if (!should_run) {

      if (options.sequential_write && 
options.read_only_written_keys12
) {

        // In this case we want to complete writing of keys_in_write_progress_, so we don't have

        // gaps after workload is stopped.

        std::lock_guard<std::mutex> lock(keys_in_write_progress_mutex_);

        if (keys_in_write_progress_.empty()) {

          break;

        }

      } else {

        break;

      }

    }

    auto txn = CHECK_RESULT(MayBeStartNewTransaction(session.get(), options));

    std::vector<client::YBqlWriteOpPtr> ops;

    ops.swap(retry_ops);

    const auto num_more_keys_to_insert = should_run ? 
options.write_batch_size - ops.size()7.46k
 : 
07
;

    for (size_t i = 0; i < num_more_keys_to_insert; 
i++1.72M
) {

      if (options.pathological_one_row_enabled) {

        if (!pathological_one_row_inserted_) {

          if (++pathological_one_row_counter_ != 1) {

            continue;

          }

        } else {

          inserting_one_row = true;

          auto update = table.NewUpdateOp();

          auto req = update->mutable_request();

          QLAddInt32HashValue(req, 0);

          table.AddInt32ColumnValue(req, table.schema().columns()[1].name(), next_random());

          if (options.ttl >= 0) {

            req->set_ttl(options.ttl * MonoTime::kMillisecondsPerSecond);

          }

          ops.push_back(update);

          session->Apply(update);

          break;

        }

      }

      auto insert = table.NewInsertOp();

      auto req = insert->mutable_request();

      int32_t key;

      if (options.sequential_write) {

        if (options.read_only_written_keys) {

          std::lock_guard<std::mutex> lock(keys_in_write_progress_mutex_);

          key = ++next_key_;

          keys_in_write_progress_.insert(key);

        } else {

          key = ++next_key_;

        }

      } else {

        key = options.pathological_one_row_enabled ? 
00
 : next_random();

      }

      QLAddInt32HashValue(req, key);

      table.AddInt32ColumnValue(req, table.schema().columns()[1].name(), next_random());

      table.AddStringColumnValue(req, table.schema().columns()[2].name(), test_payload);

      if (options.ttl >= 0) {

        req->set_ttl(options.ttl);

      }

      ops.push_back(insert);

    }

    for (const auto& op : ops) {

      session->Apply(op);

    }

    const auto flush_status = session->FlushAndGetOpsErrors();

    if (!flush_status.status.ok()) {

      VLOG
(1) << "Flush error: " << AsString(flush_status.status)0
;

      for (const auto& error : flush_status.errors) {

        auto* resp = down_cast<client::YBqlOp*>(&error->failed_op())->mutable_response();

        resp->Clear();

        resp->set_status(

            error->status().IsTryAgain() ? 
QLResponsePB::YQL_STATUS_RESTART_REQUIRED_ERROR0

                                         : QLResponsePB::YQL_STATUS_RUNTIME_ERROR);

        resp->set_error_message(error->status().message().ToBuffer());

      }

    }

    if (txn) {

      CHECK_OK(txn->CommitFuture().get());

    }

    int inserted = 0;

    for (const auto& op : ops) {

      if (op->response().status() == QLResponsePB::YQL_STATUS_OK) {

        VLOG
(2) << "Op succeeded: " << op->ToString()3
;

        if (options.read_only_written_keys) {

          std::lock_guard<std::mutex> lock(keys_in_write_progress_mutex_);

          keys_in_write_progress_.erase(

              op->request().hashed_column_values(0).value().int32_value());

        }

        ++inserted;

      } else if (

          options.retry_on_restart_required_error &&

          
op->response().status() == QLResponsePB::YQL_STATUS_RESTART_REQUIRED_ERROR0
) {

        VLOG(1) << "Op restart required: " << op->ToString() << ": "

                << op->response().ShortDebugString();

        auto retry_op = table.NewInsertOp();

        *retry_op->mutable_request() = op->request();

        retry_ops.push_back(retry_op);

      } else 
if (10.5k
options.insert_failures_allowed10.5k
) {

        VLOG
(1) << "Op failed: " << op->ToString() << ": " << op->response().ShortDebugString()1
;

        ++rows_insert_failed_;

      } else {

        LOG(FATAL) << "Op failed: " << op->ToString() << ": " << op->response().ShortDebugString();

      }

    }

    rows_inserted_.fetch_add(inserted, std::memory_order_acq_rel);

    if (inserted > 0) {

      batches_completed_.fetch_add(1, std::memory_order_acq_rel);

    }

    if (inserting_one_row && 
inserted <= 00
) {

      pathological_one_row_counter_ = 0;

    }

    if (PREDICT_FALSE(options.write_interval_millis > 0)) {

      SleepFor(MonoDelta::FromMilliseconds(options.write_interval_millis));

    }

  }

}

void TestWorkload::State::ReadThread(const TestWorkloadOptions& options) {

  Random r(narrow_cast<uint32_t>(Env::Default()->gettid()));

  auto table_result = OpenTable(options);

  if (!table_result.ok()) {

    return;

  }

  auto table = *table_result;

  shared_ptr<YBSession> session = client_->NewSession();

  session->SetTimeout(options.default_rpc_timeout);

  WaitAllThreads();

  while (should_run_.load(std::memory_order_acquire)) {

    auto txn = CHECK_RESULT(MayBeStartNewTransaction(session.get(), options));

    auto op = table.NewReadOp();

    auto req = op->mutable_request();

    const int32_t next_key = next_key_;

    int32_t key;

    if (options.sequential_write) {

      if (next_key == 0) {

        std::this_thread::sleep_for(100ms);

        continue;

      }

      for (;;) {

        key = 1 + r.Uniform(next_key);

        if (!options.read_only_written_keys) {

          break;

        }

        std::lock_guard<std::mutex> lock(keys_in_write_progress_mutex_);

        if (keys_in_write_progress_.count(key) == 0) {

          break;

        }

      }

    } else {

      key = r.Next();

    }

    QLAddInt32HashValue(req, key);

    session->Apply(op);

    const auto flush_status = session->FlushAndGetOpsErrors();

    const auto& s = flush_status.status;

    if (s.ok()) {

      if (op->response().status() == QLResponsePB::YQL_STATUS_OK) {

        ++rows_read_ok_;

        if (ql::RowsResult(op.get()).GetRowBlock()->row_count() == 0) {

          ++rows_read_empty_;

          if (options.read_only_written_keys) {

            LOG(ERROR) << "Got empty result for key: " << key << " next_key: " << next_key;

          }

        }

      } else {

        ++rows_read_error_;

      }

    } else {

      if (s.IsTryAgain()) {

        ++rows_read_try_again_;

        LOG(INFO) << s;

      } else {

        LOG(FATAL) << s;

      }

    }

    if (txn) {

      CHECK_OK(txn->CommitFuture().get());

    }

  }

}

void TestWorkload::Setup(YBTableType table_type) {

  state_->Setup(table_type, options_);

}

void TestWorkload::set_transactional(

    IsolationLevel isolation_level, client::TransactionPool* pool) {

  options_.isolation_level = isolation_level;

  state_->set_transaction_pool(pool);

}

void TestWorkload::State::Setup(YBTableType table_type, const TestWorkloadOptions& options) {

  client::YBClientBuilder client_builder;

  client_builder.default_rpc_timeout(options.default_rpc_timeout);

  client_ = CHECK_RESULT(cluster_->CreateClient(&client_builder));

  CHECK_OK(client_->CreateNamespaceIfNotExists(

      options.table_name.namespace_name(),

      master::GetDatabaseTypeForTable(client::ClientToPBTableType(table_type))));

  // Retry YBClient::TableExists() until we make that call retry reliably.

  // See KUDU-1074.

  MonoTime deadline(MonoTime::Now());

  deadline.AddDelta(MonoDelta::FromSeconds(10));

  Result<bool> table_exists(false);

  while (true) {

    table_exists = client_->TableExists(options.table_name);

    if (table_exists.ok() || 
deadline.ComesBefore(MonoTime::Now())0
) break;

    SleepFor(MonoDelta::FromMilliseconds(10));

  }

  CHECK_OK(table_exists);

  if (!table_exists.get()) {

    auto schema = GetSimpleTestSchema();

    schema.SetTransactional(options.is_transactional());

    if (options.has_table_ttl()) {

      schema.SetDefaultTimeToLive(

          options.table_ttl * MonoTime::kMillisecondsPerSecond);

    }

    YBSchema client_schema(YBSchemaFromSchema(schema));

    std::unique_ptr<YBTableCreator> table_creator(client_->NewTableCreator());

    CHECK_OK(table_creator->table_name(options.table_name)

             .schema(&client_schema)

             .num_tablets(options.num_tablets)

             // NOTE: this is quite high as a timeout, but the default (5 sec) does not

             // seem to be high enough in some cases (see KUDU-550). We should remove

             // this once that ticket is addressed.

             .timeout(MonoDelta::FromSeconds(NonTsanVsTsan(20, 60)))

             .table_type(table_type)

             .Create());

  } else {

    LOG(INFO) << "TestWorkload: Skipping table creation because table "

              << options.table_name.ToString() << " already exists";

  }

}

void TestWorkload::Start() {

  state_->Start(options_);

}

void TestWorkload::State::Start(const TestWorkloadOptions& options) {

  bool expected = false;

  should_run_.compare_exchange_strong(expected, true, std::memory_order_acq_rel);

  CHECK
(!expected) << "Already started"0
;

  should_run_.store(true, std::memory_order_release);

  start_latch_.Reset(options.num_write_threads + options.num_read_threads);

  for (int i = 0; i < options.num_write_threads; 
++i165
) {

    scoped_refptr<yb::Thread> new_thread;

    CHECK_OK(yb::Thread::Create("test", strings::Substitute("test-writer-$0", i),

                                &State::WriteThread, this, options, &new_thread));

    threads_.push_back(new_thread);

  }

  for (int i = 0; i < options.num_read_threads; 
++i0
) {

    scoped_refptr<yb::Thread> new_thread;

    CHECK_OK(yb::Thread::Create("test", strings::Substitute("test-reader-$0", i),

                                &State::ReadThread, this, options, &new_thread));

    threads_.push_back(new_thread);

  }

}

void TestWorkload::Stop() {

  state_->Stop();

}

void TestWorkload::Join() {

  state_->Join();

}

void TestWorkload::StopAndJoin() {

  Stop();

  Join();

}

void TestWorkload::WaitInserted(int64_t required) {

  while (rows_inserted() < required) {

    std::this_thread::sleep_for(100ms);

  }

}

int64_t TestWorkload::rows_inserted() const {

  return state_->rows_inserted();

}

int64_t TestWorkload::rows_insert_failed() const {

  return state_->rows_insert_failed();

}

int64_t TestWorkload::rows_read_ok() const {

  return state_->rows_read_ok();

}

int64_t TestWorkload::rows_read_empty() const {

  return state_->rows_read_empty();

}

int64_t TestWorkload::rows_read_error() const {

  return state_->rows_read_error();

}

int64_t TestWorkload::rows_read_try_again() const {

  return state_->rows_read_try_again();

}

int64_t TestWorkload::batches_completed() const {

  return state_->batches_completed();

}

client::YBClient& TestWorkload::client() const {

  return state_->client();

}

}  // namespace yb