Hang when different sessions concurrently perform DDL on single comput node

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.

Apache License 2.0

143 stars 20 forks source link

Issue migrated from trac ticket # 161

component: computing nodes | priority: major | keywords: DDL

2021-09-16 09:39:37: @snowao created the issue

Description

Muliti client performing the DDL statement at same time on unique compute-node may cause the hang issue, Maybe the CREATE TABLE statement.

How to repeat

use sysbench1.0 can repeat easly.

#!/bin/sh
./bin/sysbench \
  --db-driver=pgsql \
  --db-ps-mode=disable \
  --pgsql-host=192.168.0.135 \
  --pgsql-port=15401 \
  --pgsql-user=sbtest \
  --pgsql-password=sbtest \
  --pgsql-db=sbtest \
  --oltp-table-size=100000 \
  --oltp-tables-count=24 \
  --threads=10 \
  ./share/sysbench/tests/include/oltp_legacy/parallel_prepare.lua \
  run

run the script like one mentioned upon. the script will never finish and quit with success.\ The output is described below :\

sysbench 1.0.20-6cb07f3 (using bundled LuaJIT 2.1.0-beta2)

Running the test with following options:
Number of threads: 10
Initializing random number generator from current time

Initializing worker threads...

Threads started!

thread prepare3thread prepare4
thread prepare8
thread prepare6
Creating table 'sbtest7'...
Creating table 'sbtest9'...

Creating table 'sbtest5'...
thread prepare5
Creating table 'sbtest6'...
thread prepare7thread prepare2
thread prepare1
thread prepare0
Creating table 'sbtest3'...
Creating table 'sbtest4'...
thread prepare9
Creating table 'sbtest2'...Creating table 'sbtest10'...Creating table 'sbtest1'...

Creating table 'sbtest8'...
FATAL: PQexec() failed: 7 Kunlun-db: MySQL client error from metadata shard primary node (192.168.0.135, 6001) : 1397, XAER_NOTA: Unknown XID.
FATAL: failed query was: CREATE TABLE sbtest9 (
id SERIAL NOT NULL,
k INTEGER DEFAULT '0' NOT NULL,
c CHAR(120) DEFAULT '' NOT NULL,
pad CHAR(60) DEFAULT '' NOT NULL,
PRIMARY KEY (id)
) PARTITION BY HASH (id)
FATAL: `thread_run' function failed: ./share/sysbench/tests/include/oltp_legacy/common.lua:74: db_query() failed
Inserting 100000 records into 'sbtest7'
Inserting 100000 records into 'sbtest10'
Inserting 100000 records into 'sbtest2'
Inserting 100000 records into 'sbtest8'
Inserting 100000 records into 'sbtest4'
Inserting 100000 records into 'sbtest1'
Inserting 100000 records into 'sbtest3'
Inserting 100000 records into 'sbtest5'
Inserting 100000 records into 'sbtest6'
^C

zettadb / kunlun