zhaohongjie

dble version:5.6.29-dble-2.18.09.1-2b298cd-20180904021034 

possible errors: run sysbench prepare got error like: ``` Creating table 'sbtest1'... Inserting 1000 records into 'sbtest1' ALERT: mysql_drv_query() returned error 1064 (bad insert sql, sharding column/joinKey:ID not provided,INSERT INTO...

**Possible errors:** ``` ALERT: mysql_drv_query() returned error 3009 (the max active Connections size can not be max than maxCon for data host[host_3.hostM3]) for query 'SELECT pad FROM sbtest1 WHERE id=497924'...

sample for how about a sysbench-testing-quick-start: https://github.com/actiontech/dble-docs-cn/blob/master/9.Sysbench_samples/9.0_overview.md

possible errors: run sysbench(1.0.11,oltp_read_write.lua) got error like: ``` FATAL: mysql_stmt_execute() returned error 0 () for query 'SELECT DISTINCT c FROM sbtest1 WHERE id BETWEEN ? AND ? ORDER BY c'...

**possible errors:** run sysbench(1.0.11, sysbench-1.0.11/tests/include/oltp_legacy/oltp.lua) got error like: ``` FATAL: mysql_drv_query() returned error 1003 (Transaction error, need to rollback.Reason:[ errNo:1213 Deadlock found when trying to get lock; try restarting transaction])...

**possible errors:** ``` FATAL: mysql_drv_query() returned error 1062 (Duplicate entry '498' for key 'PRIMARY') for query 'INSERT INTO sbtest1 (id, k, c, pad) VALUES (498, 503, '78048930153-94181240857-75597183294-81342632734-65934497887-34807677303-07059064328-72381079605-19115287036-95210524363', '82457926437-09239344213-29678561090-53923192433-97263217683')' ``` **error...

purpose: select *, （select 3） from a_test order by id;

another problem with enum datatype: dble version: 5.6.29-dble-9.9.9.9-a68f557-20181119123440 step1: ```mysql mysql> create table aly_test(id int, c1 enum('a','b','c')); Query OK, 0 rows affected (0.01 sec) mysql> insert into aly_test values(1, 'a'),(2,'b'),(null,null),(4,...