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

unknown system variables when using aurora as data storage shards #523

Open jd-zhang opened 3 years ago

jd-zhang commented 3 years ago

Issue migrated from trac ticket # 198

component: computing nodes | priority: major

2021-10-21 14:15:43: @jd-zhang created the issue

info:

psql:/home/ubuntu/kunlun_scripts/smoke/smokeTest.sql:7: ERROR: Kunlun-db: MySQL storage node (1, 1) returned error: 1193, Unknown system variable 'computing_node_id'.

related code: kunlun@kunlun-test2:~/httpsRepos/kunlun$ grep -r "computing_node_id" src src/backend/sharding/sharding_conn.c: "SET NAMES 'utf8'; set session autocommit = true; set computing_node_id=%u; set global_conn_id=%u", src/test/regress/expected/vars.out: computing_node_id

2021-10-21 13:55:14.171 CST [29704] LOG: Connected to mysql instance at kunlun-aurora-1-instance-1.ce15jbnan7m7.rds.cn-northwest-1.amazonaws.com.cn:3306 2021-10-21 13:55:14.172 CST [29704] WARNING: Kunlun-db: MySQL storage node (2, 2) returned error: 1193, Unknown system variable 'computing_node_id'. 2021-10-21 13:55:14.173 CST [29704] ERROR: Kunlun-db: MySQL storage node (2, 2) returned error: 1399, XAER_RMFAIL: The command cannot be executed when global transaction is in the NON-EXISTING state. 2021-10-21 13:55:14.173 CST [29704] WARNING: Error(2600) doing 1st phase prepare of transaction 1-1634795714-589, will abort it.

jd-zhang commented 3 years ago

2021-10-25 19:03:40: @david-zhao commented

Now only set the computing_node_id and global_conn_id when storage_ha_mode is HA_MGR or HA_RBR, both must require using kunlun-storage.

jd-zhang commented 3 years ago

2021-10-25 19:03:40: @david-zhao changed owner from david to kunlun

jd-zhang commented 3 years ago

2021-10-25 19:03:40: @david-zhao changed status from assigned to accepted