dble

dble copied to clipboard

Raised by: @FlyingMao **Steps:** 1. Prepare a vm with 4-core 2. Start dble 3. Sysbench 100-threads test with following lua: ``` function event(thread_id) local table_name local a=sb_rand(1, oltp_table_size-1) local b=a+1...

actiontech-bot

Backend socket error, and client hang

1

Raised by: @yanhuqing666 As titled.

actiontech-bot

version: 5.6.29-dble-2.18.02.0-dev-20180321063015 expect: switch useSqlStat state in server.xml can work by "reload @@config_all" or sth like.

irene-coming

Using date algorithm,default node is not useful for the values which is greater than the boundary with no 'sEndDate'

1

1. ``` current sharding-date-alg yyyy-MM-dd 2000-01-01 15 1 ``` 2. ``` mysql> insert into history values('2000-01-31',1,'aa'); ERROR 1064 (HY000): Index: 2, Size: 2 mysql> insert into history values('1000-01-31',1,'aa'); Query OK,...

zhunina

Incorrect result on `show table status`when using `like`

2

version: 5.6.29-dble-2.18.02.1-dev-20180427184625 steps step1:prepare table ``` mysql> create table aly_order (ID int(11),O_ORDERKEY varchar(20) primary key,O_CUSTKEY varchar(20),O_TOTALPRICE int(20),MYDATE date); Query OK, 0 rows affected (0.25 sec) mysql> create table aly_test (ID...

FlyingMao

Raised by: @zhunina 1. server.xml, ``` 0 ``` It should be `useGlobalTableCheck` 2. There are "加班" in the comments 3. server.xml, `sequnceHandlerType` should be `sequenceHandlerType` 4. cacheservice.properties, `EnchachePooFactory ` should...

actiontech-bot

The messages is misunderstood when 'insert syntax' has spelling mistakes

3

``` mysql> insert into t5 vlaues('aa'); ERROR 1064 (HY000): NullPointerException mysql> insert into t3 vlaues(3,'aa'); ERROR 1064 (HY000): bad insert sql, sharding column/joinKey:ID not provided,INSERT INTO t3 vlaues (3, 'aa')...

zhunina

Split the server.xml ,according the properties if it can be changed in some instances of a same dble group(cluster )

1

For example, the global sequence type,it can not be changed after setting.

yanhuqing666

The folder of dble contains a lot of tmp files. Need to konw if there is an OOM error.

yanhuqing666

steps ``` mysql> select * from test_shard where 'A' in (select NAME from test_shard where id =18); ERROR 1105 (HY000): Correlated Sub Queries is not supported mysql> explain select *...

FlyingMao