分布式 | DBLE Release Notes 详细解读 2.19.05.0

Features:

• Change the default max size of frontend connection for each user #1218

• Support MySQL8.0’s default authentication plugin named ‘caching_sha2_password’ #1134

• Split Origin Merge to Merge And MERGE_AND_ORDER for Explain Plan  #1139  

• Optimize global sequence generated by distributed timestamp #1138

• Improve dble’s config template #1078

• The error messages should be more meaningful when dble instances are doing DDL simultaneously in one cluster #1105

• Support Stored procedure when connection enabled multiple statements

• Define alarm interface for developers to customize

Bug-fixes: 

• An error occurred while using Alibaba Cloud slb load balancing #1172

• Unknown pStmtId error when closing a prepared-statement that statement is the same as another in one connection #1236

• Backend conns will be closed when executing ‘log @@limit=0,5000’ in dble managed port #1220

• The network interrupt between dble and MySQL node before XA commit, the transaction lock in MySQL will always exist #1084

• Load data incorrect when the text contains a row with all null columns #1047

• SqlJob may finish more than once, and cause other problem #1231

• FetchStoreNodeOfChildTableHandler can cause serverConnection hang & leak of MySQL connection #1180

• NPE when using global sequence generated by MySQL-offset-step #1227

• MultiNodeQueryHandler#errorResponse add only one connection to errConnection list #1166, thanks @tankilo

• DateNode Idle Check Thread failed to fill empty dataSource when dataHost’s minCon is less than database size, thanks @tankilo

• When MultiNodeQueryHandler send multiple SQL statements to MySQL, if the middle part failed to execute, frontend session will hang #1164, thanks @tankilo

• When complex cross join contained in an XA-transaction, the statement commit can’t return #1116, thanks @kaikai2000

• multinode statement hang when setting statement error before executing

• Fail to recover XA Transaction on startup when XA log is not flushed and the server is down #1192

• Xa transaction commit failed due to network exception and could not be recovered by restarting dble #1113

• Even if the transaction is successfully restored, the state of the XA transaction in XA-log will always fail #1213

• Sending a statement to an uncreated physical database can cause thread safety problem #1144

• dble hang while inserting values into sharding table after executing “lock tables … write” #1203

• For sharding tables(the two tables have the ER relationship), now “left join” got the result from only one dataNode #1197

• Load data will cause an exception when the column content only has one ‘”‘ at the beginning #1182, thanks @ssxlulu

• When implicit XA transaction fails to commit and is automatically rollbacked, the real error should be returned to the user instead of OK packet #1170, thanks @tankilo

• `Load data` execution result error when the load data file is empty #1198

• XA Transaction failed to commit due to the previous one’s remaining error message((XACommitNodesHandler)MultiNodeHandler#isFailed) #1156, thanks @tankilo

• DDL lock can’t be released when the server connection is abnormally closed #1168

• when running Sysbench OLTP test, XA transaction can’t restore correctly after restarting dble #1114, thanks @kaikai2000

• It is recommended that `ZK` allow both uppercase and lowercase in the file of sequence_distributed_conf.properties #1162

• if where filter‘s length of complex query lager than 255, dble may return error #1120

• load data for a table using global sequence can not generate sequence column #1048

• Global sequence error when generated by distributed timestamps #1153

• show @@binlog.status query failed if all logic databases corresponding physical one’s not created #1088

• Some of the SQL Method params in a complex query must be uppercase #1132

• Need to optimize, when starting dble, the configuration does not include the tables involved in the view #1100

• SQL returns an error, after the MySQL node disconnects during DDL execution #1119

• `Select query` to get results from multiple nodes may lead to thread safety problem #1147

• Error when ` select * from sharding_2_t1 a right join sharding_4_t1 b on a.id=b.ID where a.id >0 and a.id <4` #1142

• manager cmd “create database” error when connecting to dble with JDBC #1245 

征稿主题：MySQL、分布式中间件DBLE、数据传输组件DTLE相关的技术内容

活动时间：2019年6月11日 – 7月11日

本期投稿奖励

投稿成功：京东卡200元*1

优秀稿件：京东卡200元*1+社区定制周边（包含：定制文化衫、定制伞、鼠标垫）

优秀稿件评选，文章获得“好看”数量排名前三的稿件为本期优秀稿件。