/** * Copyright (c) 2021 OceanBase * OceanBase CE is licensed under Mulan PubL v2. * You can use this software according to the terms and conditions of the Mulan PubL v2. * You may obtain a copy of Mulan PubL v2 at: * http://license.coscl.org.cn/MulanPubL-2.0 * THIS SOFTWARE IS PROVIDED ON AN "AS IS" BASIS, WITHOUT WARRANTIES OF ANY KIND, * EITHER EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO NON-INFRINGEMENT, * MERCHANTABILITY OR FIT FOR A PARTICULAR PURPOSE. * See the Mulan PubL v2 for more details. */ #define USING_LOG_PREFIX SHARE #include #include #include "env/ob_simple_cluster_test_base.h" #include "lib/ob_errno.h" #include "share/arbitration_service/ob_arbitration_service_table_operator.h" // for ObArbitrationServiceTableOperator namespace oceanbase { using namespace unittest; namespace share { using ::testing::_; using ::testing::Invoke; using ::testing::Return; using namespace schema; using namespace common; class TestAddRemoveReplaceArbitrationService : public unittest::ObSimpleClusterTestBase { public: TestAddRemoveReplaceArbitrationService() : unittest::ObSimpleClusterTestBase("test_add_remove_replace_arbitration_service") {} protected: ObArbitrationServiceTableOperator arb_service_table_operator_; }; TEST_F(TestAddRemoveReplaceArbitrationService, test_add_remove_replace) { int ret = OB_SUCCESS; // 0. prepare initial members common::ObMySQLProxy &sql_proxy = get_curr_observer().get_mysql_proxy(); int64_t affected_rows = 0; ObSqlString sql; int64_t tenant_id = OB_INVALID_ID; int64_t tmp_cnt = 0; // 1. create tenant without arbitration service ASSERT_EQ(OB_SUCCESS, sql.assign("create resource unit arbitration_unit max_cpu 2, memory_size '2G', log_disk_size='2G';")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); ASSERT_EQ(OB_SUCCESS, sql.assign("create resource pool arbitration_pool unit = 'arbitration_unit', unit_num = 1;")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); ASSERT_EQ(OB_SUCCESS, sql.assign("create tenant arbitration_tenant_1 resource_pool_list=('arbitration_pool');")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); ASSERT_EQ(OB_SUCCESS, sql.assign("select tenant_id " "from __all_tenant " "where tenant_name = 'arbitration_tenant_1';")); SMART_VAR(ObMySQLProxy::MySQLResult, res) { ASSERT_EQ(OB_SUCCESS, sql_proxy.read(res, sql.ptr())); sqlclient::ObMySQLResult *result = res.get_result(); ASSERT_NE(nullptr, result); ASSERT_EQ(OB_SUCCESS, result->next()); ASSERT_EQ(OB_SUCCESS, result->get_int("tenant_id", tenant_id)); } ASSERT_EQ(OB_SUCCESS, sql.assign_fmt("select count(*) as cnt " "from __all_tenant " "where tenant_id = %ld and arbitration_service_status = 'DISABLED';", tenant_id)); SMART_VAR(ObMySQLProxy::MySQLResult, res1) { ASSERT_EQ(OB_SUCCESS, sql_proxy.read(res1, sql.ptr())); sqlclient::ObMySQLResult *result1 = res1.get_result(); ASSERT_NE(nullptr, result1); ASSERT_EQ(OB_SUCCESS, result1->next()); ASSERT_EQ(OB_SUCCESS, result1->get_int("cnt", tmp_cnt)); ASSERT_EQ(1, tmp_cnt); } ASSERT_EQ(OB_SUCCESS, sql.assign_fmt("select count(*) as cnt " "from __all_tenant " "where tenant_id = %ld and arbitration_service_status = 'DISABLED';", gen_meta_tenant_id(tenant_id))); SMART_VAR(ObMySQLProxy::MySQLResult, res2) { ASSERT_EQ(OB_SUCCESS, sql_proxy.read(res2, sql.ptr())); sqlclient::ObMySQLResult *result2 = res2.get_result(); ASSERT_NE(nullptr, result2); ASSERT_EQ(OB_SUCCESS, result2->next()); ASSERT_EQ(OB_SUCCESS, result2->get_int("cnt", tmp_cnt)); ASSERT_EQ(1, tmp_cnt); } ASSERT_EQ(OB_SUCCESS, sql.assign("drop tenant arbitration_tenant_1 force")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); // 2. create tenant with disabled arbitration service ASSERT_EQ(OB_SUCCESS, sql.assign("create tenant arbitration_tenant_2 resource_pool_list=('arbitration_pool'), enable_arbitration_service = false;")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); ASSERT_EQ(OB_SUCCESS, sql.assign("select tenant_id " "from __all_tenant " "where tenant_name = 'arbitration_tenant_2';")); SMART_VAR(ObMySQLProxy::MySQLResult, res3) { ASSERT_EQ(OB_SUCCESS, sql_proxy.read(res3, sql.ptr())); sqlclient::ObMySQLResult *result3 = res3.get_result(); ASSERT_NE(nullptr, result3); ASSERT_EQ(OB_SUCCESS, result3->next()); ASSERT_EQ(OB_SUCCESS, result3->get_int("tenant_id", tenant_id)); } ASSERT_EQ(OB_SUCCESS, sql.assign_fmt("select count(*) as cnt " "from __all_tenant " "where tenant_id = %ld and arbitration_service_status = 'DISABLED';", tenant_id)); SMART_VAR(ObMySQLProxy::MySQLResult, res4) { ASSERT_EQ(OB_SUCCESS, sql_proxy.read(res4, sql.ptr())); sqlclient::ObMySQLResult *result4 = res4.get_result(); ASSERT_NE(nullptr, result4); ASSERT_EQ(OB_SUCCESS, result4->next()); ASSERT_EQ(OB_SUCCESS, result4->get_int("cnt", tmp_cnt)); ASSERT_EQ(1, tmp_cnt); } ASSERT_EQ(OB_SUCCESS, sql.assign_fmt("select count(*) as cnt " "from __all_tenant " "where tenant_id = %ld and arbitration_service_status = 'DISABLED';", gen_meta_tenant_id(tenant_id))); SMART_VAR(ObMySQLProxy::MySQLResult, res5) { ASSERT_EQ(OB_SUCCESS, sql_proxy.read(res5, sql.ptr())); sqlclient::ObMySQLResult *result5 = res5.get_result(); ASSERT_NE(nullptr, result5); ASSERT_EQ(OB_SUCCESS, result5->next()); ASSERT_EQ(OB_SUCCESS, result5->get_int("cnt", tmp_cnt)); ASSERT_EQ(1, tmp_cnt); } ASSERT_EQ(OB_SUCCESS, sql.assign("drop tenant arbitration_tenant_2 force")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); // 3. create tenant with disabled arbitration service, but __all_arbitration_service is null ASSERT_EQ(OB_SUCCESS, sql.assign("create tenant arbitration_tenant_3 resource_pool_list=('arbitration_pool'), enable_arbitration_service = true;")); ASSERT_EQ(OB_OP_NOT_ALLOW, sql_proxy.write(sql.ptr(), affected_rows)); // 4. create tenant with disabled arbitration service, and __all_arbitration_service not null ASSERT_EQ(OB_SUCCESS, sql.assign("insert into __all_arbitration_service " "(arbitration_service_key, arbitration_service, previous_arbitration_service, type) " "values " "('default', '127.0.0.1:1000', '', 'ADDR');")); ASSERT_EQ(OB_SUCCESS, sql_proxy.write(sql.ptr(), affected_rows)); ASSERT_EQ(OB_SUCCESS, sql.assign("create tenant arbitration_tenant_4 resource_pool_list=('arbitration_pool'), enable_arbitration_service = true;")); ASSERT_EQ(OB_OP_NOT_ALLOW, sql_proxy.write(sql.ptr(), affected_rows)); } } // namespace share } // namespace oceanbase int main(int argc, char **argv) { init_log_and_gtest(argc, argv); OB_LOGGER.set_log_level("INFO"); ::testing::InitGoogleTest(&argc, argv); return RUN_ALL_TESTS(); }