search

zettadb / kunlun

KunlunBase is a distributed relational database management system(RDBMS) with complete NewSQL capabilities and robust transaction ACID guarantees and is compatible with standard SQL. Applications which used PostgreSQL or MySQL can work with KunlunBase as-is without any code change or rebuild because KunlunBase supports both PostgreSQL and MySQL connection protocols and DML SQL grammars. MySQL DBAs can quickly work on a KunlunBase cluster because we use MySQL as storage nodes of KunlunBase. KunlunBase can elastically scale out as needed, and guarantees transaction ACID under error conditions, and KunlunBase fully passes TPC-C, TPC-H and TPC-DS test suites, so it not only support OLTP workloads but also OLAP workloads. Application developers can use KunlunBase to build IT systems that handles terabytes of data, without any effort on their part to implement data sharding, distributed transaction processing, distributed query processing, crash safety, high availability, strong consistency, horizontal scalability. All these powerful features are provided by KunlunBase. KunlunBase supports powerful and user friendly cluster management, monitor and provision features, can be readily used as DBaaS.
http://www.kunlunbase.com
Apache License 2.0
143 stars 20 forks source link

0.9.2-rbr:在连接上计算节点时，前几句sql都是会失败的，只要连接不中断后面的就正常了 #722

Open jd-zhang opened 2 years ago

jd-zhang commented 2 years ago

Issue migrated from trac ticket # 657

component: computing nodes | priority: major

2022-05-09 18:25:50: charles@zettadb.com created the issue

  • 在连接上计算节点时，前几句sql都是会失败的，只要连接不中断后面的就正常了，再断开然后连接上又出问题了

sql：

create table bmsql_config (
cfg_name    varchar(30) primary key,
cfg_value   varchar(50)
);

log:

ERROR: Kunlun-db: Shard (2) primary node(4) is not primary node now, retry in a few seconds.

sql:

create table bmsql_warehouse (
w_id        integer   not null,
w_ytd       decimal(12,2),
w_tax       decimal(4,4),
w_name      varchar(10),
w_street_1  varchar(20),
w_street_2  varchar(20),
w_city      varchar(20),
w_state     char(2),
w_zip       char(9)
);

log:

ERROR: Kunlun-db: Shard (1) primary node(1) is not primary node now, retry in a few seconds.
jd-zhang commented 2 years ago

2022-05-09 18:26:20: charles@zettadb.com edited the issue description

jd-zhang commented 2 years ago

2022-05-09 18:30:56: charles@zettadb.com edited the issue description

jd-zhang commented 2 years ago

2022-05-09 18:30:56: charles@zettadb.com changed title from 0.9.2-rbr:benchmarksql有两句创建表语句必然失败 to 0.9.2-rbr:刚建好集群时，benchmarksql有两句创建表语句必然失败

jd-zhang commented 2 years ago

2022-05-09 18:44:01: charles@zettadb.com edited the issue description

jd-zhang commented 2 years ago

2022-05-09 18:44:01: charles@zettadb.com changed title from 0.9.2-rbr:刚建好集群时，benchmarksql有两句创建表语句必然失败 to 0.9.2-rbr:benchmarksql有两句创建表语句大概率失败

jd-zhang commented 2 years ago

2022-05-09 19:07:32: charles@zettadb.com edited the issue description

jd-zhang commented 2 years ago

2022-05-09 19:07:32: charles@zettadb.com changed title from 0.9.2-rbr:benchmarksql有两句创建表语句大概率失败 to 0.9.2-rbr:在连接上计算节点时，前几句sql都是会失败的，只要连接不中断后面的就正常了

jd-zhang commented 2 years ago

2022-05-19 18:05:25: smith changed status from assigned to accepted