oceanbase / oceanbase Goto Github PK

OceanBase is an enterprise distributed relational database with high availability, high performance, horizontal scalability, and compatibility with SQL standards.

Home Page: https://open.oceanbase.com

License: Other

CMake 0.17% Shell 0.10% C++ 96.72% C 0.38% Python 1.98% Lex 0.05% Yacc 0.45% PLSQL 0.07% Makefile 0.01% Perl 0.02% Dockerfile 0.01% Smarty 0.01% Go 0.05% NASL 0.01% HTML 0.01% PHP 0.01% Lua 0.01% Assembly 0.01% BitBake 0.01%

oceanbase paxos htap cloud-database cloud-native cplusplus databases distributed-computation distributed-databases distributed-transactions

oceanbase's Introduction

English | 中文版

OceanBase Database is a distributed relational database. It is developed entirely by Ant Group. The OceanBase Database is built on a common server cluster. Based on the Paxos protocol and its distributed structure, the OceanBase Database provides high availability and linear scalability. The OceanBase Database is not dependent on specific hardware architectures.

Key features

Transparent Scalability: 1,500 nodes, PB data and a trillion rows of records in one cluster.
Ultra-fast Performance: TPC-C 707 million tmpC and TPC-H 15.26 million QphH @30000GB.
Cost Efficiency: saves 70%–90% of storage costs.
Real-time Analytics: supports HTAP without additional cost.
Continuous Availability: RPO = 0(zero data loss) and RTO < 8s(recovery time)
MySQL Compatible: easily migrated from MySQL database.

Quick start

🔥 Start with all-in-one

You can quickly deploy a stand-alone OceanBase Database to experience with the following commands:

Note: Linux Only

# download and install all-in-one package (internet connection is required)
bash -c "$(curl -s https://obbusiness-private.oss-cn-shanghai.aliyuncs.com/download-center/opensource/oceanbase-all-in-one/installer.sh)"
source ~/.oceanbase-all-in-one/bin/env.sh

# quickly deploy OceanBase database
obd demo

🐳 Start with docker

Start an OceanBase Database instance:

# Deploy a mini standalone instance.
docker run -p 2881:2881 --name oceanbase-ce -e MODE=mini -d oceanbase/oceanbase-ce

Connect to the OceanBase Database instance:

docker exec -it oceanbase-ce ob-mysql sys # Connect to the root user of the sys tenant.

See also Quick experience or Quick Start (Simplified Chinese) for more details.

☸️ Start with Kubernetes

You can deploy and manage OceanBase Database instance in kubernetes cluster with ob-operator quickly. Refer to the document Quick Start for ob-operator to see details.

👨‍💻 Start developing

See OceanBase Developer Document to learn how to compile and deploy a manually compiled observer.

Roadmap

For future plans, see Product Iteration Progress. See also OceanBase Roadmap for more details.

Case study

OceanBase has been serving more than 1000 customers and upgraded their database from different industries, including Financial Services, Telecom, Retail, Internet, and more.

See also success stories and Who is using OceanBase for more details.

System architecture

Introduction to system architecture

Contributing

Contributions are highly appreciated. Read the development guide to get started.

License

OceanBase Database is licensed under the Mulan Public License, Version 2. See the LICENSE file for more info.

Community

Join the OceanBase community via:

Slack Workspace
Ask on Stack Overflow
Chinese User Forum
DingTalk Group: 33254054 (QR code)
WeChat Group (Add the assistant with WeChat ID: OBCE666)

oceanbase's People

Contributors

Stargazers

Watchers

Forkers

snorlaxrin earayu triump2020 blindpirate moonsphere sundy-li alonedba amber1990zhang hwzero corasql zhbdesign eliasyaoyc jiajunhuang dangzhonghua reminiscent raywill ives9638 perid007 leiysky shendachuan xunliu georgezhang68 trueeyu guo-shaoge shenli toukii windtalker xingyingone studywithjeffrey jerousrb lyndonyang1024 panda-sheep r-asou liuhaobupt tech-jum i-spark pisces225 kayaklee zsongshu tsthght tuohai666 he-xiaolong juaby zaorangyang viseen mydir coolfishchen junwen12221 yhilmare jackios jimmylovelife scsldb zn9f crazybin5848 wei930204 aylei an00 jiabosun pyson killme2008 airxiechao tutulove1234 muse117 kongxiu baixitou28 csunny yangze-yz seeflood bluepongo hsunboy luohongliang0921 qianchanger typedefstruct32 nettee liujunzhong alfred-lau luohaha soyoo jiadebin liweiyuan hahajeff xiongxiaoqing614 zacharylee88 taylor12805 bergwolf devillove084 taoyuanyuan wjzeng gitsrc mirrorfork eagle2016 simonjoylet maxlzc chaoxing102 zy-jordan rubyxu huster-ljw moonlight-zhao hhskylar adermxu

oceanbase's Issues

What is the protocol type, released version and the Mac OS compatibility

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Segmentation fault during cpack rpm build stage

$cpack
CPack: Create package using RPM
CPack: Install projects
CPack: - Run preinstall target for: OceanBase CE
CPack: - Install project: OceanBase CE
CPack: - Install component: libs
CPack: - Install component: server
CPack: - Install component: sql-parser
CPack: Create package
CPackRPM: Will use GENERATED spec file: ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/SPECS/oceanbase-ce-libs.spec
CPackRPM: Will use GENERATED spec file: ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/SPECS/oceanbase-ce-sql-parser.spec
CPackRPM:Debug: You may consult rpmbuild logs in:
CPackRPM:Debug: - ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/rpmbuildoceanbase-ce-sql-parser.err
CPackRPM:Debug: *** + umask 022

cd ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/BUILD
mv ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/tmpBBroot
exit 0
umask 022
cd ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/BUILD
'[' ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser '!=' / ']'
rm -rf ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser
++ dirname ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser
mkdir -p ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux
mkdir ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser
'[' -e ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser ']'
rm -rf ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser
mv ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/tmpBBroot ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/oceanbase-ce-3.1.0-Linux/sql-parser
/usr/lib/rpm/check-buildroot
/usr/lib/rpm/redhat/brp-compress
/usr/lib/rpm/redhat/brp-strip /usr/bin/strip
/usr/lib/rpm/redhat/brp-strip-comment-note /usr/bin/strip /usr/bin/objdump
/usr/lib/rpm/redhat/brp-strip-static-archive /usr/bin/strip
/usr/lib/rpm/redhat/brp-strip-static-archive: line 11: 18174 Segmentation fault $STRIP -g "$f"
error: Bad exit status from /var/tmp/rpm-tmp.IbNHwk (%install)
Bad exit status from /var/tmp/rpm-tmp.IbNHwk (%install)

CPackRPM:Debug: - ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/rpmbuildoceanbase-ce-sql-parser.out
CPackRPM:Debug: *** Building target platforms: x86_64
Building for target x86_64
Executing(%prep): /bin/sh -e /var/tmp/rpm-tmp.4TKeaI
Executing(%install): /bin/sh -e /var/tmp/rpm-tmp.IbNHwk

RPM build errors:

CPackRPM: Will use GENERATED spec file: ./oceanbase/build_rpm/_CPack_Packages/Linux/RPM/SPECS/oceanbase-ce.spec
CPack: - package: ./oceanbase/build_rpm/oceanbase-ce-3.1.0-1.alios7.x86_64.rpm generated.
CPack: - package: ./oceanbase/build_rpm/oceanbase-ce-libs-3.1.0-1.alios7.x86_64.rpm generated.

rpm install with 'warning: user admin does not exist - using root'

How To Reproduce(must be provided)

Steps to reproduce the behavior:

cd /etc/yum.repos.d/
wget https://mirrors.aliyun.com/oceanbase/OceanBase.repo
yum makecache fast
yum install oceanbase-ce oceanbase-ce-sql-parser obproxy obclient ob-deploy

Expected behavior

No warning when using yum install

Additional context

Provide logs and configs, or any other context to trace the problem.

Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
  正在安装    : libobclient-2.0.0-1.el7.x86_64                                                                                                                                                                1/7
  正在安装    : oceanbase-ce-libs-3.1.0-1.el7.x86_64                                                                                                                                                          2/7
warning: user admin does not exist - using root
warning: group admin does not exist - using root
warning: user admin does not exist - using root
warning: group admin does not exist - using root
warning: user admin does not exist - using root
warning: group admin does not exist - using root
warning: user admin does not exist - using root
warning: group admin does not exist - using root
warning: user admin does not exist - using root
warning: group admin does not exist - using root
warning: user admin does not exist - using root
warning: group admin does not exist - using root
warning: user admin does not exist - using root
warning: group admin does not exist - using root

单机, 一个observer, oracle租户. 下面没有指定partition, 报错是不是因为有默认partitions?

create table bmsql_config (
cfg_name    varchar2(30) primary key,
cfg_value   varchar2(50)
);
create tablegroup tpcc_group;
create table bmsql_warehouse (
w_id        integer   not null,
w_ytd       decimal(4,2),
w_tax       decimal(4,4),
w_name      varchar2(10),
w_street_1  varchar2(20),
w_street_2  varchar2(20),
w_city      varchar2(20),
w_state     char(2),
w_zip       char(9),
primary key(w_id)
)tablegroup='tpcc_group';
ORA-00600: internal error code, arguments: -4179, table and tablegroup use different partition options not allowed

没有原始commit记录，请问PR如何合并到主代码库里？

你们的联系方式是空的，不存在的？


找不到地址由于系统找不到电子邮件地址&nbsp;[email protected]，或该地址无法接收邮件，因此无法递送您的邮件。 | 找不到地址由于系统找不到电子邮件地址&nbsp;[email protected]，或该地址无法接收邮件，因此无法递送您的邮件。 | 找不到地址 | 由于系统找不到电子邮件地址&nbsp;[email protected]，或该地址无法接收邮件，因此无法递送您的邮件。
-- | -- | -- | --
找不到地址由于系统找不到电子邮件地址&nbsp;[email protected]，或该地址无法接收邮件，因此无法递送您的邮件。 | 找不到地址 | 由于系统找不到电子邮件地址&nbsp;[email protected]，或该地址无法接收邮件，因此无法递送您的邮件。
找不到地址
由于系统找不到电子邮件地址&nbsp;[email protected]，或该地址无法接收邮件，因此无法递送您的邮件。
以下为远程服务器的响应：554 RCPT ([email protected]) dosn't exist

Ob单机版安装失败，一直卡在最后一步

安装Ob单机版（中控和目标机器在一个机器上），按照步骤来的
最后一步一直失败

Observer.log搜索Error的地方也就这几处
`[2021-6-2 13:49:0.65497] INFO [cut@ob_memory_cutter.cpp:131] [3441][Y7369676E616C-0] free_chunk, freed: 0
CRASH ERROR!!! sig=6, sig_code=-6, sig_addr=ac3, timestamp=1622641740065385, tid=3281, tname=MultiTenant, trace_id=0-0, extra_info=((null)), lbt=0x90af028 0x90b0076 0x7f2b9868962f 0x7f2b97fe0387 0x7f2b97fe1a77 0x92925aa 0x92904b7 0x9291c3a 0x8ee80c1 0x8eb5429 0x2a50561 0x8a5b4ee 0x8a5b878 0x8a449cb 0x8a44133 0x8a43e05 0x8a3621d 0x41b49f3 0x2a55b13 0x8ebc474 0x8eb9e4d 0x8eb46ee

[2021-06-02 21:48:58.743777] ERROR [SERVER] init_io (ob_server.cpp:1062) [2755][0][Y0-0000000000000000] [lt=5] [dc=0] init io benchmark fail, (ret=-4027) BACKTRACE:0x90a107e 0x90090c1 0x24c1b14 0x24c176b 0x24c1583 0x24c04f6 0x870573a 0x86fe5c4 0x24be805 0x7f2b97fcc555 0x24bd4e9`
请问是什么原因呢

终于等到OB开源了！

熟悉的目录结构和代码风格，希望OB越来越好。

familiar directory structure and code style, hope ob more come more good.

TPC-C测试运行runBenchmark时失败

17:06:13,277 [Thread-10] ERROR jTPCCTData : Unexpected SQLException in PAYMENT
17:06:13,277 [Thread-10] ERROR jTPCCTData : Not supported feature or function
java.sql.SQLException: Not supported feature or function
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3978)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3914)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2530)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2683)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2495)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1903)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2124)
at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2058)
at com.mysql.jdbc.PreparedStatement.executeLargeUpdate(PreparedStatement.java:5158)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2043)
at jTPCCTData.executePayment(jTPCCTData.java:929)
at jTPCCTData.execute(jTPCCTData.java:99)
at jTPCCTerminal.executeTransactions(jTPCCTerminal.java:160)
at jTPCCTerminal.run(jTPCCTerminal.java:88)
at java.lang.Thread.run(Thread.java:748)

the version of mysql connector is 5.1.47 ，
the test process follows https://open.oceanbase.com/docs/community/oceanbase-database/V3.1.0/test-the-tpc-c-of-apsaradb-for-oceanbase

Can `oceanbase` be deployed in k8s environment?

For most the popular distributed database, they could be deployed in k8s environment by various operators like cockroach-operator, cass-operator, tidb-operator. I am curious if oceanbase has tools like these to deploy itself in k8s env? If it does, any documentation am I missing?

后续会出支持各种语言的 Client 吗？

when select a const from a derived table, subquery may not be executed. Is it intended?

This leads to inconsistencies with mysql.

For example, sleep() in subqueries can't work.

我要着变化有何用？

开了关，关了又开，本次开了还关吗？

How to merge pull requests (The current way is to create a merge commit)?

Merge PR的时候可以只有正常的那个commit msg记录，不要出现merge branch/merge pr这种commit吗？这样不利于查看提交记录
commit msg里面最好统一一下格式，最好可以带上issue号，这样后续再看这个提交的时候可以很清楚的知道这个提交的由来

是不是拿tidb 改的？

如果是拿tidb改的，请告知广大开发者

[Feature Request] MAC develop env

Hi,

I'm a newbee to OB and willing to have a try on it, however it seems that OB build.sh are only for Linux (especially redhat) currently.

Your Question

MAC dev tools are leak (specially the build script)

Your scenes

Your Advice

A guide on initiating the project for multi-platform.

Besides, I'll try to make my own build_on_mac.sh to see if it works(a PR will be provided once I got these done), but official scripts are still on my wish-list.

Thanks

机器关机后OBserver启动总是失败

每次都obd cluster start 指令启动不了，需要重新部署

套壳TiDB?

oceanbase::keybtree::ScanHandle::scan_forward

When I was performing the TPCC benchmark, the scan_forward was called a lot of times,
I want to know what this function does?

后续的开发会同步到开源仓里吗，开源仓里的提交会同步到内部仓里吗

如题。我本来想在 discussion 里面发，但是我发现我无法 New Discussion，请问这个功能是不是仅限 OB 内部使用，还是说我因为太菜被 OB block 了。

Install OBD with RPM failed, no package found

Describe the bug (must be provided)

Following the doc to install ODB, but failed:

$ sudo yum makecache
$ sudo yum install -y ob-deploy-1.0.0-1.el7.x86_64.rpm
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * base: mirror-hk.koddos.net
 * centos-sclo-rh: mirror.hkt.cc
 * centos-sclo-sclo: mirror.hkt.cc
 * epel: mirror2.totbb.net
 * extras: mirror-hk.koddos.net
 * updates: mirror-hk.koddos.net
No package ob-deploy-1.0.0-1.el7.x86_64.rpm available.
Error: Nothing to do

Your Environments (must be provided)

OS: 3.10.0-1160.el7.x86_64
Compliler: gcc/g++ 4.8.5
CPU: Intel(R) Xeon(R) CPU E5-2698 v4 @ 2.20GHz
Commit id (e.g. a3ffc7d8): 12676080774af2940e15911b9f2658f59c52899a

How To Reproduce(must be provided)
As described.

Expected behavior

Install successfully.

Additional context

$ cat /etc/os-release 
NAME="CentOS Linux"
VERSION="7 (Core)"
ID="centos"
ID_LIKE="rhel fedora"
VERSION_ID="7"
PRETTY_NAME="CentOS Linux 7 (Core)"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:centos:centos:7"
HOME_URL="https://www.centos.org/"
BUG_REPORT_URL="https://bugs.centos.org/"

CENTOS_MANTISBT_PROJECT="CentOS-7"
CENTOS_MANTISBT_PROJECT_VERSION="7"
REDHAT_SUPPORT_PRODUCT="centos"
REDHAT_SUPPORT_PRODUCT_VERSION="7"

Failed to connect oceanbase-ce

when i executed "obd cluster start lo", an error occured "[ERROR] Failed to connect oceanbase-ce"

obd cluster start lo
Get local repositories and plugins ok
[WARN] (127.0.0.1) fs.aio-max-nr must not be less than 1048576 (Current value: 65536)
[WARN] (127.0.0.1) open files number must not be less than 655350 (Current value: 1024)
Start observer ok
observer program health check ok
Connect to observer x
[ERROR] Failed to connect oceanbase-ce

error displayed in log file is
ERROR [SERVER] init_io (ob_server.cpp:1062) [6994][0][Y0-0000000000000000] [lt=4] [dc=0] init io benchmark fail, (ret=-4027) BACKTRACE:0x90a107e 0x90090c1 0x24c1b14 0x24c176b 0x24c1583 0x24c04f6 0x870573a 0x86fe5c4 0x24be805 0x7f36ec88c555 0x24bd4e9
ERROR [SERVER] init_multi_tenant (ob_server.cpp:1247) [6994][0][Y0-0000000000000000] [lt=19] [dc=0] Fail to set tenant mem limit(ret=-4002) BACKTRACE:0x90a107e 0x90090c1 0x24c1b14 0x24c176b 0x24c1583 0x24c04f6 0x8709feb 0x86fea10 0x24be805 0x7f36ec88c555 0x24bd4e9
ERROR [SERVER] init (ob_server.cpp:298) [6994][0][Y0-0000000000000000] [lt=49] [dc=0] init multi tenant fail(ret=-4002) BACKTRACE:0x90a107e 0x90090c1 0x24c1b14 0x24c176b 0x24c1583 0x24c04f6 0x8700741 0x24be805 0x7f36ec88c555 0x24bd4e9
ERROR [LIB] ob_malloc (ob_malloc.h:38) [7351][704][YB427F000001-0005C3AD4E9BEA99] [lt=3] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
**ERROR [SQL.ENG] create_physical_plan_ctx (ob_exec_context.cpp:611) [7103][214][YB427F000001-0005C3AD4EBBEA98] [lt=2] [dc=0] no more memory to create physical_plan_ctx BACKTRACE:0x90a107e 0x90090c1 0x8fffccf 0x24c0127 0x24bd7a5 0x3c01649 0x4a359c5 0x4a1639f 0x4a12e73
**

Observer cost too much CPU even if no user request at all

I am testing observer in a 12core machine. While there is no request, observer still cost 60% CPU of one core.

here are details:

I wrote a script to limit its cpu usage. seems that it works.

( this method requires that cgroup is enabled in your machine. create a cgroup named oceanbase)

PIDS=`top -d 10 -H -b -n1 | awk 'NR>6 { print $1,$12 }' | grep -E '(WeakReadSvr|LogStateDri|KVCacheWash|BRPC4|KVCacheRep|ObTimer|WeakReadService|ObLockWaitMgr|IODISK30|PartSerLargeCb3|CLGWR)' | awk '{print $1}'`
for i in $PIDS; do echo $i > /sys/fs/cgroup/cpu/oceanbase/tasks; done
echo 10000 > /sys/fs/cgroup/cpu/oceanbase/cpu.cfs_quota_us

# check
cat /sys/fs/cgroup/cpu/oceanbase/tasks

单机部署失败

错误日志如下，是有什么地方权限不对吗？

[2021-06-06 14:37:14.284488] ERROR [STORAGE] scan_store_dir (ob_raid_file_system.cpp:707) [395919][0][Y0-0000000000000000] [lt=5] [dc=0] disk num in store dir is not valid(ret=-4337, disk_num=-1, OB_MAX_DISK_NUMBER=32, sstable_dir="/home/yangce.yc/dev/observer/store/sstable", errno=2) BACKTRACE:0x90abade 0x9013b21 0x24dd851 0x24dd48b 0x24dd167 0x752d715 0x751086a 0x7512bc0 0x74f3fb8 0x7b3af82 0x8712f60 0x870901c 0x24c8155 0x7fb0e81e50b3 0x24c6e2e
[2021-06-06 14:37:14.284574] WARN [STORAGE] is_raid (ob_raid_file_system.cpp:651) [395919][0][Y0-0000000000000000] [lt=85] [dc=0] failed to scan store dir(ret=-4337, *sstable_dir=/)
[2021-06-06 14:37:14.284578] WARN [STORAGE] init (ob_store_file_system.cpp:820) [395919][0][Y0-0000000000000000] [lt=3] [dc=0] failed to check has raid disk(ret=-4337, sstable_dir_="/home/yangce.yc/dev/observer/store/sstable")
4,1 Top
[2021-06-06 14:37:14.284574] WARN [STORAGE] is_raid (ob_raid_file_system.cpp:651) [395919][0][Y0-0000000000000000] [lt=85] [dc=0] failed to scan store dir(ret=-4337, *sstable_dir=/)
[2021-06-06 14:37:14.284578] WARN [STORAGE] init (ob_store_file_system.cpp:820) [395919][0][Y0-0000000000000000] [lt=3] [dc=0] failed to check has raid disk(ret=-4337, sstable_dir_="/home/yangce.yc/dev/observer/store/sstable")
[2021-06-06 14:37:14.284597] WARN [STORAGE] init (ob_partition_service.cpp:412) [395919][0][Y0-0000000000000000] [lt=5] [dc=0] init store file system failed.(ret=-4337, env={data_dir:"/home/yangce.yc/dev/observer/store", default_block_size:2097152, disk_avail_space:8589934592, datafile_disk_percentage:20, redundancy_level:1, log_spec:{log_dir:"/home/yangce.yc/dev/observer/store/slog", max_log_size:268435456, log_sync_type:0}, clog_dir:"/home/yangce.yc/dev/observer/store/clog", ilog_dir:"/home/yangce.yc/dev/observer/store/ilog", clog_shm_path:"/home/yangce.yc/dev/observer/store/clog_shm", ilog_shm_path:"/home/yangce.yc/dev/observer/store/ilog_shm", index_cache_priority:10, user_block_cache_priority:1, user_row_cache_priority:1, fuse_row_cache_priority:1, bf_cache_priority:1, clog_cache_priority:1, index_clog_cache_priority:1, bf_cache_miss_count_threshold:100, ethernet_speed:131072000})

The CLA website is too slow for chinese users. Should we run a new server for CLA?

Is your feature request related to a problem? Please describe.
The CLA website is too slow for chinese users to open .
I can't sign it without VPN

Describe the solution you'd like
run a new server for CLA

Describe alternatives you've considered

Additional context

oceanbase::keybtree::MultibitSet::size

OB_INLINE int8_t size() const
{
return ATOMIC_LOAD((int16_t*)(&data_)) & ((1 << LEN_OF_COUNTER) - 1);
}

union {
RawType data_;
uint8_t buf_[0];
struct {
uint8_t count_ : LEN_OF_COUNTER;
RawType pending_data_ : (LEN_OF_TOTAL_INDEX - LEN_OF_COUNTER);
};
};

Why not return “count_” directly here?

是否可以支持Mac系统编译

is compatible with ORACLE protocol and syntax？

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

Failed to build or deploy on Ubuntu

On Ubuntu 20.04, build.sh complains:

➜  oceanbase git:(master) bash build.sh debug --init --make
grep: /etc/redhat-release: No such file or directory

Is it required to use RedHat or CentOS? If so, can it be clarified in README prerequisite?

No memory or reach tenant memory limit

环境：采用docker安装，给的内存8G

操作：将sql(100M)中的文件导入oceanbase中

问题：ERROR 4013 (HY001) at line 920: No memory or reach tenant memory limit

Any plan support PostgreSQL protocol and syntax

When was “OceanBase 代码风格指南“ completed?

I think it might be completed 10 years ago.

How to deploy OceanBase on Macos by docker

How to compile, deploy, debug OceanBase on Macos

obd安装oceanbase报错

Please check the FAQ documentation before raising an issue

Please check the old issues before raising an issue in case someone has asked the same question that you are asking.

Describe the bug (must be provided)

A clear and concise description of what the bug is.

Your Environments (must be provided)

OS: Linux 3.10.0-1127.13.1.el7.x86_64 #1 SMP Tue Jun 23 15:46:38 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
Compliler: g++ (GCC) 4.8.5 20150623 (Red Hat 4.8.5-39) or clang version 3.4.2 (tags/RELEASE_34/dot2-final)
CPU: Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 32 On-line CPU(s) list: 0-31 Thread(s) per core: 1 Core(s) per socket: 1 座： 32 NUMA 节点： 2 厂商 ID： GenuineIntel CPU 系列： 6 型号： 79 型号名称： Intel(R) Xeon(R) CPU E5-2620 v4 @ 2.10GHz 步进： 1 CPU MHz： 2099.998 BogoMIPS： 4199.99 超管理器厂商： VMware 虚拟化类型：完全 L1d 缓存： 32K L1i 缓存： 32K L2 缓存： 256K L3 缓存： 20480K NUMA 节点0 CPU： 0-15 NUMA 节点1 CPU： 16-31 Flags: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts mmx fxsr sse sse2 ss syscall nx pdpe1gb rdtscp lm constant_tsc arch_perfmon pebs bts nopl xtopology tsc_reliable nonstop_tsc aperfmperf eagerfpu pni pclmulqdq ssse3 fma cx16 pcid sse4_1 sse4_2 x2apic movbe popcnt tsc_deadline_timer aes xsave avx f16c rdrand hypervisor lahf_lm abm 3dnowprefetch epb invpcid_single fsgsbase tsc_adjust bmi1 hle avx2 smep bmi2 invpcid rtm rdseed adx smap xsaveopt dtherm ida
Commit id (e.g. a3ffc7d8)

How To Reproduce(must be provided)

Steps to reproduce the behavior:

mini-single.yml
"""
user:
username: root
key_file: /root/.ssh/id_rsa
oceanbase-ce:
servers:
Please don't use hostname, only IP can be supported
- 127.16.7.105
  global:
  home_path: /data/observer
Please set devname as the network adaptor's name whose ip is in the setting of severs.

if set severs as "127.0.0.1", please set devname as "lo"

if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"
devname: ens192
mysql_port: 2883
rpc_port: 2882
zone: zone1
cluster_id: 1
datafile_size: 8G
please set memory limit to a suitable value which is matching resource.
memory_limit: 16G
system_memory: 4G
stack_size: 512K
cpu_count: 16
cache_wash_threshold: 1G
__min_full_resource_pool_memory: 268435456
workers_per_cpu_quota: 10
schema_history_expire_time: 1d
The value of net_thread_count had better be same as cpu's core number.
net_thread_count: 4
major_freeze_duty_time: Disable
minor_freeze_times: 10
enable_separate_sys_clog: 0
enable_merge_by_turn: FALSE
datafile_disk_percentage: 20
"""
obd cluster deploy chenwh -c /root/mini-single.yaml
obd cluster start chenwh
obd mirror list
[root@frxs-archive-7-105 ~]# obd mirror list
+------------------------------------------------------------+
| Mirror Repository List |
+--------------------------------+--------+------------------+
| name | type | update time |
+--------------------------------+--------+------------------+
| OceanBase-community-stable-el7 | remote | 2021-06-02 09:11 |
| OceanBase-development-kit-el7 | remote | 2021-06-02 09:11 |
| local | local | 2021-06-04 19:53 |
+--------------------------------+--------+------------------+

Download oceanbase-ce-3.1.0-1.el7.x86_64.rpm (44.17 M): 100% [#######################################################################################################################################################################] Time: 0:00:13 3.49 MB/s
Package oceanbase-ce-3.1.0 is available
install oceanbase-ce-3.1.0 for local ok
+-------------------------------------------------------------------+
| Packages |
+--------------+---------+------------------------------------------+
| Repository | Version | Md5 |
+--------------+---------+------------------------------------------+
| oceanbase-ce | 3.1.0 | 56f57e9843e719d830ec03c206d914f4b3adc82b |
+--------------+---------+------------------------------------------+
Open ssh connection ok
Remote oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b repository install ok
Remote oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b repository lib check !!
[WARN] 127.16.7.105 oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b require: libmariadb.so.3

Try to get lib-repository
Download oceanbase-ce-libs-3.1.0-1.el7.x86_64.rpm (413.07 K): 100% [#################################################################################################################################################################] Time: 0:00:00 3.59 MB/s
Package oceanbase-ce-libs-3.1.0 is available
install oceanbase-ce-libs-3.1.0 for local ok
Use oceanbase-ce-libs-3.1.0-b70d3839280f145a86af26811bbfcdfaeb645509 for oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b
Remote oceanbase-ce-libs-3.1.0-b70d3839280f145a86af26811bbfcdfaeb645509 repository install ok
Remote oceanbase-ce-3.1.0-56f57e9843e719d830ec03c206d914f4b3adc82b repository lib check ok
127.16.7.105 initializes cluster work home
chenwh deployed

error:
[root@frxs-archive-7-105 data]# obd cluster start chenwh
Get local repositories and plugins ok
Start observer ok
observer program health check ok
Connect to observer ok
Initialize cluster
Cluster bootstrap x
Cluster init failed

conf: 如果您采用本地安装，即中控机器和目标机器是同一台机器

General development environment support

Seems like currently OB only supports RedHat distributions(#3). Will OB support more *nix-like distributions like Arch Linux, Ubuntu and even MacOS, WSL on windows?

These are commonly used dev-envs among developers.

Add compile support for ubuntu

请问有出源码解读相关博客的计划吗？

Why choose MulanPubL-2.0

增加了老外程序员的认知成本，如此高调的一个开源项目，用一个不知名的开源许可，难道只希望在国内发展？
自主可不是啥都使用自己的东西，那是闭门造车。被罚后这么不自信吗？

Limit the growth of log files

The log file keeps increasing even I do nothing , and "observer.log" reach 218M after running 30 minute， is that right ?

version ：3.1.0

deploy mode ： mini-single-example.yaml

memstore里active数据量比total多

在导入数据时，观察到gv$memstore里active的值比total多。
但是

Please add some comments

Where has the comments gone?

Before me，many people asked about the deployment environment support，what about centos？

Is your feature request related to a problem? Please describe.
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]

Describe the solution you'd like
A clear and concise description of what you want to happen.

Describe alternatives you've considered
A clear and concise description of any alternative solutions or features you've considered.

Additional context
Add any other context or screenshots about the feature request here.

The LSM-tree storage engine into OceanBase

请问OB现使用的LSM-tree存储引擎只有两层吗？这种做法系统内的写放大是不是比较严重，相对于传统的多层来说

Cannot start observer, ERROR malloc in log

Describe the bug (must be provided)

$ obd cluster start testdb
Get local repositories and plugins ok
Start observer ok
observer program health check ok
Connect to observer x

Your Environments (must be provided)

OS: CentOS 7, 3.10.0-1160.el7.x86_64
Compliler: gcc/g++ 4.8.5
CPU: Intel(R) Xeon(R) CPU E5-2698 v4 @ 2.20GHz
Commit id (e.g. a3ffc7d8): 12676080774af2940e15911b9f2658f59c52899a

How To Reproduce(must be provided)
Followed #87 to fix devname and followed #19 to fix warning https://github.com/oceanbase/oceanbase/issues/87

Expected behavior

Connect to the server

Additional context

......
./observer.log.wf:22427:[2021-06-07 19:38:53.589284] ERROR [LIB] ob_malloc (ob_malloc.h:38) [79518][226][YB427F000001-0005C42B7A0EFBCA] [lt=5] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6404e55 0x68b2a45 0x68880bd 0x4ff1a5d 0x4ff47ee 0x501630c 0x501482e 0x505dfc8 0x505b4d5 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22454:[2021-06-07 19:38:53.648402] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC2] [lt=3] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22487:[2021-06-07 19:38:53.708831] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC3] [lt=4] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22519:[2021-06-07 19:38:53.769141] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC4] [lt=3] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22552:[2021-06-07 19:38:53.829479] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC5] [lt=3] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22584:[2021-06-07 19:38:53.889796] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC6] [lt=4] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22615:[2021-06-07 19:38:53.950120] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC7] [lt=3] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
./observer.log.wf:22647:[2021-06-07 19:38:54.010839] ERROR [LIB] ob_malloc (ob_malloc.h:38) [80252][1440][YB427F000001-0005C42B79FEFDC8] [lt=6] [dc=0] allocate memory fail(attr=tenant_id=1, label=MysqlRequesReco, ctx_id=0, prio=0, nbyte=2088960) BACKTRACE:0x90a107e 0x90090c1 0x24d1eef 0x24d1b3b 0x24d1900 0x24d1552 0x24d130f 0x24dfe00 0x8692c6a 0x49ae651 0x86d10dd 0x86d2fd9 0x86d9194 0x8f8f342 0x6402731 0x68a72db 0x68a6dfc 0x6886091 0x4ff14ed 0x4ff3609 0x5004638 0x5005acd 0x5007e30 0x500993f 0x8725d90 0x8727cce 0x8727196 0x8726dc7 0x872798d 0x41b49f4 0x2a55b14 0x8ebc475 0x8eb9e4e 0x8eb46ef
......

My configuration was given in #87.

Violation of C++ code style

Describe the bug (must be provided)

While skimming through the source code, I found that visibility modifier (public, private) is indented two spaces (example), which has violated the official code style and the repo clang-format rule (AccessModifierOffset: 0).

There might be other violations that I haven't observed at first sight.

Your Environments (must be provided)

No need.

How To Reproduce(must be provided)

No need.

Expected behavior

Consistent specification of code style.

Since the open source code has already diverged with internal version (no comment and such), maybe we can do a global format? Or we can change the document and clang-format rule to be more consistent with existing codebase.

Additional context

No.

Ubuntu plz

Cannot do `obd cluster start xx`

Describe the bug (must be provided)

I was trying to start the cluster:

$ obd cluster start testdb
Get local repositories and plugins ok
[WARN] (127.0.0.1) fs.aio-max-nr must not be less than 1048576 (Current value: 65536)
Start observer ok
observer program health check x
[WARN] failed to start 127.0.0.1 observer
[ERROR] oceanbase-ce start failed

Your Environments (must be provided)

OS: CentOS 7, 3.10.0-1160.el7.x86_64
Compliler: gcc/g++ 4.8.5
CPU: Intel(R) Xeon(R) CPU E5-2698 v4 @ 2.20GHz
Commit id (e.g. a3ffc7d8): 12676080774af2940e15911b9f2658f59c52899a

How To Reproduce(must be provided)
Just followed the quickstart guide to install odb with yum and deployed a local cluster.

Expected behavior
Started.

Additional context
My configuration file:

user:
  username: 
  password: 

oceanbase-ce:
  servers:
    # Please don't use hostname, only IP can be supported
   - 127.0.0.1
  global:
    home_path: /home/zhangys/observer/
    # Please set devname as the network adaptor's name whose ip is  in the setting of severs.
    # if set severs as "127.0.0.1", please set devname as "lo"
    # if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"
    devname: eth0
    mysql_port: 2883
    rpc_port: 2882
    zone: zone1
    cluster_id: 1
    datafile_size: 8G
    # please set memory limit to a suitable value which is matching resource. 
    memory_limit: 8G
    system_memory: 256G
    stack_size: 512K
    cpu_count: 80
    cache_wash_threshold: 1G
    __min_full_resource_pool_memory: 268435456
    workers_per_cpu_quota: 10
    schema_history_expire_time: 1d
    # The value of net_thread_count had better be same as cpu's core number. 
    net_thread_count: 4
    major_freeze_duty_time: Disable
    minor_freeze_times: 10
    enable_separate_sys_clog: 0
    enable_merge_by_turn: FALSE
    datafile_disk_percentage: 5

root@host:/data/oceanbase# cat /etc/issue
Ubuntu 20.04.2 LTS \n \l

root@host:/data/oceanbase# build_debug/src/observer/observer --version
build_debug/src/observer/observer --version
observer (OceanBase CE 3.1.0)

REVISION: -377fa3d62f0b4a7a20dd2e7ebaaa0ef38f190759
BUILD_BRANCH: master
BUILD_TIME: Jun  2 2021 16:39:57
BUILD_FLAGS: Debug
BUILD_INFO:

Copyright (c) 2021 Ant Group Co., Ltd.

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.

root@host:/data/observer# obd cluster display ubuntu-test
Get local repositories and plugins ok
Connect to observer ok
Wait for observer init ok
+---------------------------------------------+
|                   observer                  |
+-----------+---------+------+-------+--------+
| ip        | version | port | zone  | status |
+-----------+---------+------+-------+--------+
| 127.0.0.1 | 3.1.0   | 5001 | zone1 | active |
+-----------+---------+------+-------+--------+

root@host:/data/observer#  mysql -h127.0.0.1 -uroot -P5001
Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MySQL connection id is 3221487781
Server version: 5.7.25 OceanBase 3.1.0 (r-377fa3d62f0b4a7a20dd2e7ebaaa0ef38f190759) (Built Jun  2 2021 16:39:57)

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MySQL [(none)]> use oceanbase
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MySQL [oceanbase]> select * from __all_server;
+----------------------------+----------------------------+-----------+----------+----+-------+------------+-----------------+--------+-----------------------+-----------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
| gmt_create                 | gmt_modified               | svr_ip    | svr_port | id | zone  | inner_port | with_rootserver | status | block_migrate_in_time | build_version                                                         | stop_time | start_service_time | first_sessid | with_partition | last_offline_time |
+----------------------------+----------------------------+-----------+----------+----+-------+------------+-----------------+--------+-----------------------+-----------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
| 2021-06-02 17:05:41.848472 | 2021-06-02 17:06:13.652835 | 127.0.0.1 |     5002 |  1 | zone1 |       5001 |               1 | active |                     0 | 3.1.0_-377fa3d62f0b4a7a20dd2e7ebaaa0ef38f190759(Jun  2 2021 16:39:57) |         0 |   1622624771655757 |            0 |              1 |                 0 |
+----------------------------+----------------------------+-----------+----------+----+-------+------------+-----------------+--------+-----------------------+-----------------------------------------------------------------------+-----------+--------------------+--------------+----------------+-------------------+
1 row in set (0.004 sec)

MySQL [oceanbase]> Ctrl-C -- exit!
Aborted

BTW, all mysqltest cases work well on Ubuntu :)

+---------------------------------------------------------------------------+
|                  Result (Total 152, Passed 152, Failed 0)                 |
+-------------------------------------------------------+----------+--------+
| Case                                                  | Cost (s) | Status |
+-------------------------------------------------------+----------+--------+
| alter.alter_log_archive_option                        |     0.40 | PASSED |
| delete.delete_from_mysql                              |     8.35 | PASSED |

oceanbase / oceanbase Goto Github PK

oceanbase's Introduction

Key features

Quick start

🔥 Start with all-in-one

🐳 Start with docker

☸️ Start with Kubernetes

👨‍💻 Start developing

Roadmap

Case study

System architecture

Contributing

License

Community

oceanbase's People

Contributors

Stargazers

Watchers

Forkers

oceanbase's Issues

Your Question

Your scenes

Your Advice

Please don't use hostname, only IP can be supported

Please set devname as the network adaptor's name whose ip is in the setting of severs.

if set severs as "127.0.0.1", please set devname as "lo"

if current ip is 192.168.1.10, and the ip's network adaptor's name is "eth0", please use "eth0"

please set memory limit to a suitable value which is matching resource.

The value of net_thread_count had better be same as cpu's core number.

Recommend Projects

Recommend Topics

Recommend Org