You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Linux c0bae494cabb 6.5.0-18-generic #18~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Wed Feb 7 11:40:03 UTC 2 x86_64 x86_64 x86_64 GNU/Linux
commit 5eee31b32b97af9818b3ef342d951c2bc8837f82 (HEAD -> master, origin/master)
observer (OceanBase_CE 4.3.1.0)
REVISION: 1-5eee31b32b97af9818b3ef342d951c2bc8837f82
BUILD_BRANCH: master
BUILD_TIME: May 7 2024 14:39:32
BUILD_FLAGS: RelWithDebInfo
BUILD_INFO:
Copyright (c) 2011-present OceanBase Inc.
部署配置文件
user:
username: root
key_file: private_key
oceanbase-ce:
servers:
- name: server1
ip: 10.0.10.11
- name: server2
ip: 10.0.10.12
- name: server3
ip: 10.0.10.13
server1:
mysql_port: 10000
rpc_port: 10001
home_path: /root/data/observer1
zone: zone1
server2:
mysql_port: 10000
rpc_port: 10001
home_path: /root/data/observer2
zone: zone2
server3:
mysql_port: 10000
rpc_port: 10001
home_path: /root/data/observer3
zone: zone3
tag: latest
include: obd/observer.include.yaml
global:
# for default system config used by farm, please see tools/deploy/obd/observer.include.yaml
# You can also specify the configuration directly below (stored locally, switching the working directory and redeploying will still take effect)
production_mode: false
devname: eth0
syslog_level: 'WARN'
syslog_io_bandwidth_limit: '30M'
log_disk_size: '30G'
# diag_syslog_per_error_limit: '4'
max_syslog_file_count: '4'
cpu_count: '6'
datafile_size: '10G'
datafile_next: '5G'
datafile_maxsize: '30G'
root_password: ''
memory_limit: '9G'
system_memory: '1G'
obproxy-ce:
servers:
- 10.0.10.8
global:
listen_port: 10004
prometheus_listen_port: 10005
syslog_level: 'WARN'
home_path: /root/data/obproxy
root_password: ''
include: obd/obproxy.include.yaml
depends:
- oceanbase-ce
租户配置:
DROP TENANT mysql FORCE;
DROP RESOURCE POOL pool_for_tenant_mysql;
CREATE RESOURCE UNIT 4c7g MAX_CPU 4, MIN_CPU 4, MEMORY_SIZE '7G';
create resource pool pool_test unit='4c7g', unit_num=1, zone_list=('zone1' ,'zone2', 'zone3');
create tenant test resource_pool_list=('pool_test'), primary_zone='RANDOM',comment 'test tenant', charset='utf8' set ob_tcp_invited_nodes='%', recyclebin=OFF, ob_query_timeout=5000000;
Describe the bug
master分支版本,
sum
可能导致错误的结果Fast Reproduce Steps(Required)
init.sql.txt
error.sql.txt
Expected behavior
第二列不为123123时,结果来自第二个select。其第三列不应为一个大负数。
Actual Behavior
多节点版本的23、25行的第三列错误地输出了一个大负数,单节点版本输出了0.
output_re_main2.log
output_re_single2.log
Environment
部署配置文件
租户配置:
Additional Context
我们是来自北京航空航天大学网络空间安全学院的BASS团队,主要从事系统软件安全、操作系统和程序分析研究,研发自动化程序测试框架检测软件缺陷。我们使用自研的数据库漏洞测试工具在OceanBase中找到了上述可能的漏洞。
The text was updated successfully, but these errors were encountered: