You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/04/23 04:00:29 UTC
[GitHub] [shardingsphere] fengyunhe edited a comment on issue #5274: order by not support string column when query more than one database
fengyunhe edited a comment on issue #5274:
URL: https://github.com/apache/shardingsphere/issues/5274#issuecomment-618162993
use arthas can watch the params :
```bash
watch org.apache.shardingsphere.shardingproxy.backend.response.query.QueryHeader * "{params}" -x 6 -b
```
execute sql:
```
select * from `order` limit 2
```
watch logs:
```
ts=2020-04-23 03:57:10; [cost=0.019566ms] result=@ArrayList[
@Object[][
@ResultSetMetaData[
session=@NativeSession[
serialVersionUID=@Long[5323638898749073419],
serverConfigCache=@[com.mysql.cj.util.PerVmServerConfigCacheFactory$1@5572c575],
customIndexToCharsetMapByUrl=@HashMap[isEmpty=true;size=0],
customCharsetToMblenMapByUrl=@HashMap[isEmpty=true;size=0],
requiresEscapingEncoder=@Boolean[false],
lastQueryFinishedTime=@Long[0],
needsPing=@Boolean[false],
commandBuilder=@NativeMessageBuilder[com.mysql.cj.protocol.a.NativeMessageBuilder@2dced2f8],
isClosed=@Boolean[false],
forceClosedReason=null,
listeners=@CopyOnWriteArrayList[isEmpty=false;size=1],
cancelTimer=null,
SERVER_VERSION_STRING_VAR_NAME=@String[server_version_string],
propertySet=@JdbcPropertySetImpl[com.mysql.cj.jdbc.JdbcPropertySetImpl@690dbeda],
exceptionInterceptor=@[com.mysql.cj.NativeSession$1@545bc27b],
log=@StandardLogger[com.mysql.cj.log.StandardLogger@17c1ece8],
NULL_LOGGER=@NullLogger[com.mysql.cj.log.NullLogger@4cc3a5fa],
protocol=@NativeProtocol[com.mysql.cj.protocol.a.NativeProtocol@483c39d6],
messageBuilder=null,
connectionCreationTimeMillis=@Long[1587611780475],
hostInfo=@HostInfo[com.mysql.cj.conf.HostInfo@427e62b0 :: {host: "mysql8_4", port: 3306, hostProperties: {maintainTimeStats=false, rewriteBatchedStatements=true, cacheResultSetMetadata=false, tinyInt1isBit=false, useServerPrepStmts=true, netTimeoutForStreamingResults=0, useSSL=false, useUnicode=true, prepStmtCacheSqlLimit=2048, dbname=test, allowPublicKeyRetrieval=true, elideSetAutoCommits=true, cachePrepStmts=true, serverTimezone=UTC, characterEncoding=utf8, prepStmtCacheSize=250, useLocalSessionState=true, cacheServerConfiguration=true}}],
gatherPerfMetrics=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@5ac060bb],
characterEncoding=@StringProperty[com.mysql.cj.conf.StringProperty@b7df26c],
disconnectOnExpiredPasswords=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2226885c],
cacheServerConfiguration=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@13fc154a],
autoReconnect=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@4a606a36],
autoReconnectForPools=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2e6a1f84],
maintainTimeStats=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@3898067d],
sessionMaxRows=@Integer[-1],
eventSink=null,
],
fields=@Field[][
@Field[com.mysql.cj.result.Field@5ce919ae[dbName=test,tableName=order0,originalTableName=order0,columnName=id,originalColumnName=id,mysqlType=8(FIELD_TYPE_BIGINT),sqlType=-5,flags= PRIMARY_KEY UNIQUE_KEY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@9cd3cac[dbName=test,tableName=order0,originalTableName=order0,columnName=user_id,originalColumnName=user_id,mysqlType=3(FIELD_TYPE_INT),sqlType=4,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@3a99001[dbName=test,tableName=order0,originalTableName=order0,columnName=fee,originalColumnName=fee,mysqlType=246(FIELD_TYPE_DECIMAL),sqlType=3,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@4c9775a3[dbName=test,tableName=order0,originalTableName=order0,columnName=create_time,originalColumnName=create_time,mysqlType=7(FIELD_TYPE_TIMESTAMP),sqlType=93,flags= BINARY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@58a721f6[dbName=test,tableName=order0,originalTableName=order0,columnName=note,originalColumnName=note,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
@Field[com.mysql.cj.result.Field@38ef4e12[dbName=test,tableName=order0,originalTableName=order0,columnName=address,originalColumnName=address,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
],
useOldAliasBehavior=@Boolean[false],
treatYearAsDate=@Boolean[true],
exceptionInterceptor=null,
],
@ShardingSchema[
shardingRule=@OrchestrationShardingRule[
masterSlaveRules=@LinkedList[isEmpty=true;size=0],
ruleConfiguration=@ShardingRuleConfiguration[org.apache.shardingsphere.api.config.sharding.ShardingRuleConfiguration@520b84f6],
shardingDataSourceNames=@ShardingDataSourceNames[org.apache.shardingsphere.core.rule.ShardingDataSourceNames@3a75b141],
tableRules=@ArrayList[isEmpty=false;size=4],
bindingTableRules=@ArrayList[isEmpty=false;size=1],
broadcastTables=@LinkedList[isEmpty=false;size=1],
defaultDatabaseShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5fdbe91f],
defaultTableShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5a701e4b],
defaultShardingKeyGenerator=@SnowflakeShardingKeyGenerator[org.apache.shardingsphere.core.strategy.keygen.SnowflakeShardingKeyGenerator@54520dc7],
masterSlaveRules=@ArrayList[isEmpty=true;size=0],
encryptRule=@EncryptRule[org.apache.shardingsphere.core.rule.EncryptRule@43ba41b5],
],
metaData=@ShardingSphereMetaData[
dataSources=@DataSourceMetas[org.apache.shardingsphere.core.metadata.datasource.DataSourceMetas@197107a4],
tables=@TableMetas[org.apache.shardingsphere.core.metadata.table.TableMetas@5d891d78],
relationMetas=@RelationMetas[org.apache.shardingsphere.sql.parser.relation.metadata.RelationMetas@4caf4895],
],
name=@String[master_slave_db],
parseEngine=@SQLParseEngine[
databaseTypeName=@String[MySQL],
cache=@SQLParseResultCache[org.apache.shardingsphere.sql.parser.cache.SQLParseResultCache@5088fede],
],
backendDataSource=@JDBCBackendDataSource[
dataSources=@LinkedHashMap[isEmpty=false;size=6],
dataSourceParameters=@LinkedHashMap[isEmpty=false;size=6],
dataSourceFactory=@JDBCRawBackendDataSourceFactory[org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory@73a248a0],
shardingTransactionManagerEngine=@ShardingTransactionManagerEngine[org.apache.shardingsphere.transaction.ShardingTransactionManagerEngine@1e714d06],
],
],
@Integer[1],
],
]
ts=2020-04-23 03:57:10; [cost=0.002936ms] result=@ArrayList[
@Object[][
@ResultSetMetaData[
session=@NativeSession[
serialVersionUID=@Long[5323638898749073419],
serverConfigCache=@[com.mysql.cj.util.PerVmServerConfigCacheFactory$1@5572c575],
customIndexToCharsetMapByUrl=@HashMap[isEmpty=true;size=0],
customCharsetToMblenMapByUrl=@HashMap[isEmpty=true;size=0],
requiresEscapingEncoder=@Boolean[false],
lastQueryFinishedTime=@Long[0],
needsPing=@Boolean[false],
commandBuilder=@NativeMessageBuilder[com.mysql.cj.protocol.a.NativeMessageBuilder@2dced2f8],
isClosed=@Boolean[false],
forceClosedReason=null,
listeners=@CopyOnWriteArrayList[isEmpty=false;size=1],
cancelTimer=null,
SERVER_VERSION_STRING_VAR_NAME=@String[server_version_string],
propertySet=@JdbcPropertySetImpl[com.mysql.cj.jdbc.JdbcPropertySetImpl@690dbeda],
exceptionInterceptor=@[com.mysql.cj.NativeSession$1@545bc27b],
log=@StandardLogger[com.mysql.cj.log.StandardLogger@17c1ece8],
NULL_LOGGER=@NullLogger[com.mysql.cj.log.NullLogger@4cc3a5fa],
protocol=@NativeProtocol[com.mysql.cj.protocol.a.NativeProtocol@483c39d6],
messageBuilder=null,
connectionCreationTimeMillis=@Long[1587611780475],
hostInfo=@HostInfo[com.mysql.cj.conf.HostInfo@427e62b0 :: {host: "mysql8_4", port: 3306, hostProperties: {maintainTimeStats=false, rewriteBatchedStatements=true, cacheResultSetMetadata=false, tinyInt1isBit=false, useServerPrepStmts=true, netTimeoutForStreamingResults=0, useSSL=false, useUnicode=true, prepStmtCacheSqlLimit=2048, dbname=test, allowPublicKeyRetrieval=true, elideSetAutoCommits=true, cachePrepStmts=true, serverTimezone=UTC, characterEncoding=utf8, prepStmtCacheSize=250, useLocalSessionState=true, cacheServerConfiguration=true}}],
gatherPerfMetrics=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@5ac060bb],
characterEncoding=@StringProperty[com.mysql.cj.conf.StringProperty@b7df26c],
disconnectOnExpiredPasswords=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2226885c],
cacheServerConfiguration=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@13fc154a],
autoReconnect=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@4a606a36],
autoReconnectForPools=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2e6a1f84],
maintainTimeStats=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@3898067d],
sessionMaxRows=@Integer[-1],
eventSink=null,
],
fields=@Field[][
@Field[com.mysql.cj.result.Field@5ce919ae[dbName=test,tableName=order0,originalTableName=order0,columnName=id,originalColumnName=id,mysqlType=8(FIELD_TYPE_BIGINT),sqlType=-5,flags= PRIMARY_KEY UNIQUE_KEY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@9cd3cac[dbName=test,tableName=order0,originalTableName=order0,columnName=user_id,originalColumnName=user_id,mysqlType=3(FIELD_TYPE_INT),sqlType=4,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@3a99001[dbName=test,tableName=order0,originalTableName=order0,columnName=fee,originalColumnName=fee,mysqlType=246(FIELD_TYPE_DECIMAL),sqlType=3,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@4c9775a3[dbName=test,tableName=order0,originalTableName=order0,columnName=create_time,originalColumnName=create_time,mysqlType=7(FIELD_TYPE_TIMESTAMP),sqlType=93,flags= BINARY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@58a721f6[dbName=test,tableName=order0,originalTableName=order0,columnName=note,originalColumnName=note,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
@Field[com.mysql.cj.result.Field@38ef4e12[dbName=test,tableName=order0,originalTableName=order0,columnName=address,originalColumnName=address,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
],
useOldAliasBehavior=@Boolean[false],
treatYearAsDate=@Boolean[true],
exceptionInterceptor=null,
],
@ShardingSchema[
shardingRule=@OrchestrationShardingRule[
masterSlaveRules=@LinkedList[isEmpty=true;size=0],
ruleConfiguration=@ShardingRuleConfiguration[org.apache.shardingsphere.api.config.sharding.ShardingRuleConfiguration@520b84f6],
shardingDataSourceNames=@ShardingDataSourceNames[org.apache.shardingsphere.core.rule.ShardingDataSourceNames@3a75b141],
tableRules=@ArrayList[isEmpty=false;size=4],
bindingTableRules=@ArrayList[isEmpty=false;size=1],
broadcastTables=@LinkedList[isEmpty=false;size=1],
defaultDatabaseShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5fdbe91f],
defaultTableShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5a701e4b],
defaultShardingKeyGenerator=@SnowflakeShardingKeyGenerator[org.apache.shardingsphere.core.strategy.keygen.SnowflakeShardingKeyGenerator@54520dc7],
masterSlaveRules=@ArrayList[isEmpty=true;size=0],
encryptRule=@EncryptRule[org.apache.shardingsphere.core.rule.EncryptRule@43ba41b5],
],
metaData=@ShardingSphereMetaData[
dataSources=@DataSourceMetas[org.apache.shardingsphere.core.metadata.datasource.DataSourceMetas@197107a4],
tables=@TableMetas[org.apache.shardingsphere.core.metadata.table.TableMetas@5d891d78],
relationMetas=@RelationMetas[org.apache.shardingsphere.sql.parser.relation.metadata.RelationMetas@4caf4895],
],
name=@String[master_slave_db],
parseEngine=@SQLParseEngine[
databaseTypeName=@String[MySQL],
cache=@SQLParseResultCache[org.apache.shardingsphere.sql.parser.cache.SQLParseResultCache@5088fede],
],
backendDataSource=@JDBCBackendDataSource[
dataSources=@LinkedHashMap[isEmpty=false;size=6],
dataSourceParameters=@LinkedHashMap[isEmpty=false;size=6],
dataSourceFactory=@JDBCRawBackendDataSourceFactory[org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory@73a248a0],
shardingTransactionManagerEngine=@ShardingTransactionManagerEngine[org.apache.shardingsphere.transaction.ShardingTransactionManagerEngine@1e714d06],
],
],
@Integer[2],
],
]
ts=2020-04-23 03:57:10; [cost=0.002444ms] result=@ArrayList[
@Object[][
@ResultSetMetaData[
session=@NativeSession[
serialVersionUID=@Long[5323638898749073419],
serverConfigCache=@[com.mysql.cj.util.PerVmServerConfigCacheFactory$1@5572c575],
customIndexToCharsetMapByUrl=@HashMap[isEmpty=true;size=0],
customCharsetToMblenMapByUrl=@HashMap[isEmpty=true;size=0],
requiresEscapingEncoder=@Boolean[false],
lastQueryFinishedTime=@Long[0],
needsPing=@Boolean[false],
commandBuilder=@NativeMessageBuilder[com.mysql.cj.protocol.a.NativeMessageBuilder@2dced2f8],
isClosed=@Boolean[false],
forceClosedReason=null,
listeners=@CopyOnWriteArrayList[isEmpty=false;size=1],
cancelTimer=null,
SERVER_VERSION_STRING_VAR_NAME=@String[server_version_string],
propertySet=@JdbcPropertySetImpl[com.mysql.cj.jdbc.JdbcPropertySetImpl@690dbeda],
exceptionInterceptor=@[com.mysql.cj.NativeSession$1@545bc27b],
log=@StandardLogger[com.mysql.cj.log.StandardLogger@17c1ece8],
NULL_LOGGER=@NullLogger[com.mysql.cj.log.NullLogger@4cc3a5fa],
protocol=@NativeProtocol[com.mysql.cj.protocol.a.NativeProtocol@483c39d6],
messageBuilder=null,
connectionCreationTimeMillis=@Long[1587611780475],
hostInfo=@HostInfo[com.mysql.cj.conf.HostInfo@427e62b0 :: {host: "mysql8_4", port: 3306, hostProperties: {maintainTimeStats=false, rewriteBatchedStatements=true, cacheResultSetMetadata=false, tinyInt1isBit=false, useServerPrepStmts=true, netTimeoutForStreamingResults=0, useSSL=false, useUnicode=true, prepStmtCacheSqlLimit=2048, dbname=test, allowPublicKeyRetrieval=true, elideSetAutoCommits=true, cachePrepStmts=true, serverTimezone=UTC, characterEncoding=utf8, prepStmtCacheSize=250, useLocalSessionState=true, cacheServerConfiguration=true}}],
gatherPerfMetrics=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@5ac060bb],
characterEncoding=@StringProperty[com.mysql.cj.conf.StringProperty@b7df26c],
disconnectOnExpiredPasswords=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2226885c],
cacheServerConfiguration=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@13fc154a],
autoReconnect=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@4a606a36],
autoReconnectForPools=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2e6a1f84],
maintainTimeStats=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@3898067d],
sessionMaxRows=@Integer[-1],
eventSink=null,
],
fields=@Field[][
@Field[com.mysql.cj.result.Field@5ce919ae[dbName=test,tableName=order0,originalTableName=order0,columnName=id,originalColumnName=id,mysqlType=8(FIELD_TYPE_BIGINT),sqlType=-5,flags= PRIMARY_KEY UNIQUE_KEY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@9cd3cac[dbName=test,tableName=order0,originalTableName=order0,columnName=user_id,originalColumnName=user_id,mysqlType=3(FIELD_TYPE_INT),sqlType=4,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@3a99001[dbName=test,tableName=order0,originalTableName=order0,columnName=fee,originalColumnName=fee,mysqlType=246(FIELD_TYPE_DECIMAL),sqlType=3,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@4c9775a3[dbName=test,tableName=order0,originalTableName=order0,columnName=create_time,originalColumnName=create_time,mysqlType=7(FIELD_TYPE_TIMESTAMP),sqlType=93,flags= BINARY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@58a721f6[dbName=test,tableName=order0,originalTableName=order0,columnName=note,originalColumnName=note,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
@Field[com.mysql.cj.result.Field@38ef4e12[dbName=test,tableName=order0,originalTableName=order0,columnName=address,originalColumnName=address,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
],
useOldAliasBehavior=@Boolean[false],
treatYearAsDate=@Boolean[true],
exceptionInterceptor=null,
],
@ShardingSchema[
shardingRule=@OrchestrationShardingRule[
masterSlaveRules=@LinkedList[isEmpty=true;size=0],
ruleConfiguration=@ShardingRuleConfiguration[org.apache.shardingsphere.api.config.sharding.ShardingRuleConfiguration@520b84f6],
shardingDataSourceNames=@ShardingDataSourceNames[org.apache.shardingsphere.core.rule.ShardingDataSourceNames@3a75b141],
tableRules=@ArrayList[isEmpty=false;size=4],
bindingTableRules=@ArrayList[isEmpty=false;size=1],
broadcastTables=@LinkedList[isEmpty=false;size=1],
defaultDatabaseShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5fdbe91f],
defaultTableShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5a701e4b],
defaultShardingKeyGenerator=@SnowflakeShardingKeyGenerator[org.apache.shardingsphere.core.strategy.keygen.SnowflakeShardingKeyGenerator@54520dc7],
masterSlaveRules=@ArrayList[isEmpty=true;size=0],
encryptRule=@EncryptRule[org.apache.shardingsphere.core.rule.EncryptRule@43ba41b5],
],
metaData=@ShardingSphereMetaData[
dataSources=@DataSourceMetas[org.apache.shardingsphere.core.metadata.datasource.DataSourceMetas@197107a4],
tables=@TableMetas[org.apache.shardingsphere.core.metadata.table.TableMetas@5d891d78],
relationMetas=@RelationMetas[org.apache.shardingsphere.sql.parser.relation.metadata.RelationMetas@4caf4895],
],
name=@String[master_slave_db],
parseEngine=@SQLParseEngine[
databaseTypeName=@String[MySQL],
cache=@SQLParseResultCache[org.apache.shardingsphere.sql.parser.cache.SQLParseResultCache@5088fede],
],
backendDataSource=@JDBCBackendDataSource[
dataSources=@LinkedHashMap[isEmpty=false;size=6],
dataSourceParameters=@LinkedHashMap[isEmpty=false;size=6],
dataSourceFactory=@JDBCRawBackendDataSourceFactory[org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory@73a248a0],
shardingTransactionManagerEngine=@ShardingTransactionManagerEngine[org.apache.shardingsphere.transaction.ShardingTransactionManagerEngine@1e714d06],
],
],
@Integer[3],
],
]
ts=2020-04-23 03:57:10; [cost=0.002605ms] result=@ArrayList[
@Object[][
@ResultSetMetaData[
session=@NativeSession[
serialVersionUID=@Long[5323638898749073419],
serverConfigCache=@[com.mysql.cj.util.PerVmServerConfigCacheFactory$1@5572c575],
customIndexToCharsetMapByUrl=@HashMap[isEmpty=true;size=0],
customCharsetToMblenMapByUrl=@HashMap[isEmpty=true;size=0],
requiresEscapingEncoder=@Boolean[false],
lastQueryFinishedTime=@Long[0],
needsPing=@Boolean[false],
commandBuilder=@NativeMessageBuilder[com.mysql.cj.protocol.a.NativeMessageBuilder@2dced2f8],
isClosed=@Boolean[false],
forceClosedReason=null,
listeners=@CopyOnWriteArrayList[isEmpty=false;size=1],
cancelTimer=null,
SERVER_VERSION_STRING_VAR_NAME=@String[server_version_string],
propertySet=@JdbcPropertySetImpl[com.mysql.cj.jdbc.JdbcPropertySetImpl@690dbeda],
exceptionInterceptor=@[com.mysql.cj.NativeSession$1@545bc27b],
log=@StandardLogger[com.mysql.cj.log.StandardLogger@17c1ece8],
NULL_LOGGER=@NullLogger[com.mysql.cj.log.NullLogger@4cc3a5fa],
protocol=@NativeProtocol[com.mysql.cj.protocol.a.NativeProtocol@483c39d6],
messageBuilder=null,
connectionCreationTimeMillis=@Long[1587611780475],
hostInfo=@HostInfo[com.mysql.cj.conf.HostInfo@427e62b0 :: {host: "mysql8_4", port: 3306, hostProperties: {maintainTimeStats=false, rewriteBatchedStatements=true, cacheResultSetMetadata=false, tinyInt1isBit=false, useServerPrepStmts=true, netTimeoutForStreamingResults=0, useSSL=false, useUnicode=true, prepStmtCacheSqlLimit=2048, dbname=test, allowPublicKeyRetrieval=true, elideSetAutoCommits=true, cachePrepStmts=true, serverTimezone=UTC, characterEncoding=utf8, prepStmtCacheSize=250, useLocalSessionState=true, cacheServerConfiguration=true}}],
gatherPerfMetrics=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@5ac060bb],
characterEncoding=@StringProperty[com.mysql.cj.conf.StringProperty@b7df26c],
disconnectOnExpiredPasswords=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2226885c],
cacheServerConfiguration=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@13fc154a],
autoReconnect=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@4a606a36],
autoReconnectForPools=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2e6a1f84],
maintainTimeStats=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@3898067d],
sessionMaxRows=@Integer[-1],
eventSink=null,
],
fields=@Field[][
@Field[com.mysql.cj.result.Field@5ce919ae[dbName=test,tableName=order0,originalTableName=order0,columnName=id,originalColumnName=id,mysqlType=8(FIELD_TYPE_BIGINT),sqlType=-5,flags= PRIMARY_KEY UNIQUE_KEY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@9cd3cac[dbName=test,tableName=order0,originalTableName=order0,columnName=user_id,originalColumnName=user_id,mysqlType=3(FIELD_TYPE_INT),sqlType=4,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@3a99001[dbName=test,tableName=order0,originalTableName=order0,columnName=fee,originalColumnName=fee,mysqlType=246(FIELD_TYPE_DECIMAL),sqlType=3,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@4c9775a3[dbName=test,tableName=order0,originalTableName=order0,columnName=create_time,originalColumnName=create_time,mysqlType=7(FIELD_TYPE_TIMESTAMP),sqlType=93,flags= BINARY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@58a721f6[dbName=test,tableName=order0,originalTableName=order0,columnName=note,originalColumnName=note,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
@Field[com.mysql.cj.result.Field@38ef4e12[dbName=test,tableName=order0,originalTableName=order0,columnName=address,originalColumnName=address,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
],
useOldAliasBehavior=@Boolean[false],
treatYearAsDate=@Boolean[true],
exceptionInterceptor=null,
],
@ShardingSchema[
shardingRule=@OrchestrationShardingRule[
masterSlaveRules=@LinkedList[isEmpty=true;size=0],
ruleConfiguration=@ShardingRuleConfiguration[org.apache.shardingsphere.api.config.sharding.ShardingRuleConfiguration@520b84f6],
shardingDataSourceNames=@ShardingDataSourceNames[org.apache.shardingsphere.core.rule.ShardingDataSourceNames@3a75b141],
tableRules=@ArrayList[isEmpty=false;size=4],
bindingTableRules=@ArrayList[isEmpty=false;size=1],
broadcastTables=@LinkedList[isEmpty=false;size=1],
defaultDatabaseShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5fdbe91f],
defaultTableShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5a701e4b],
defaultShardingKeyGenerator=@SnowflakeShardingKeyGenerator[org.apache.shardingsphere.core.strategy.keygen.SnowflakeShardingKeyGenerator@54520dc7],
masterSlaveRules=@ArrayList[isEmpty=true;size=0],
encryptRule=@EncryptRule[org.apache.shardingsphere.core.rule.EncryptRule@43ba41b5],
],
metaData=@ShardingSphereMetaData[
dataSources=@DataSourceMetas[org.apache.shardingsphere.core.metadata.datasource.DataSourceMetas@197107a4],
tables=@TableMetas[org.apache.shardingsphere.core.metadata.table.TableMetas@5d891d78],
relationMetas=@RelationMetas[org.apache.shardingsphere.sql.parser.relation.metadata.RelationMetas@4caf4895],
],
name=@String[master_slave_db],
parseEngine=@SQLParseEngine[
databaseTypeName=@String[MySQL],
cache=@SQLParseResultCache[org.apache.shardingsphere.sql.parser.cache.SQLParseResultCache@5088fede],
],
backendDataSource=@JDBCBackendDataSource[
dataSources=@LinkedHashMap[isEmpty=false;size=6],
dataSourceParameters=@LinkedHashMap[isEmpty=false;size=6],
dataSourceFactory=@JDBCRawBackendDataSourceFactory[org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory@73a248a0],
shardingTransactionManagerEngine=@ShardingTransactionManagerEngine[org.apache.shardingsphere.transaction.ShardingTransactionManagerEngine@1e714d06],
],
],
@Integer[4],
],
]
ts=2020-04-23 03:57:10; [cost=0.002765ms] result=@ArrayList[
@Object[][
@ResultSetMetaData[
session=@NativeSession[
serialVersionUID=@Long[5323638898749073419],
serverConfigCache=@[com.mysql.cj.util.PerVmServerConfigCacheFactory$1@5572c575],
customIndexToCharsetMapByUrl=@HashMap[isEmpty=true;size=0],
customCharsetToMblenMapByUrl=@HashMap[isEmpty=true;size=0],
requiresEscapingEncoder=@Boolean[false],
lastQueryFinishedTime=@Long[0],
needsPing=@Boolean[false],
commandBuilder=@NativeMessageBuilder[com.mysql.cj.protocol.a.NativeMessageBuilder@2dced2f8],
isClosed=@Boolean[false],
forceClosedReason=null,
listeners=@CopyOnWriteArrayList[isEmpty=false;size=1],
cancelTimer=null,
SERVER_VERSION_STRING_VAR_NAME=@String[server_version_string],
propertySet=@JdbcPropertySetImpl[com.mysql.cj.jdbc.JdbcPropertySetImpl@690dbeda],
exceptionInterceptor=@[com.mysql.cj.NativeSession$1@545bc27b],
log=@StandardLogger[com.mysql.cj.log.StandardLogger@17c1ece8],
NULL_LOGGER=@NullLogger[com.mysql.cj.log.NullLogger@4cc3a5fa],
protocol=@NativeProtocol[com.mysql.cj.protocol.a.NativeProtocol@483c39d6],
messageBuilder=null,
connectionCreationTimeMillis=@Long[1587611780475],
hostInfo=@HostInfo[com.mysql.cj.conf.HostInfo@427e62b0 :: {host: "mysql8_4", port: 3306, hostProperties: {maintainTimeStats=false, rewriteBatchedStatements=true, cacheResultSetMetadata=false, tinyInt1isBit=false, useServerPrepStmts=true, netTimeoutForStreamingResults=0, useSSL=false, useUnicode=true, prepStmtCacheSqlLimit=2048, dbname=test, allowPublicKeyRetrieval=true, elideSetAutoCommits=true, cachePrepStmts=true, serverTimezone=UTC, characterEncoding=utf8, prepStmtCacheSize=250, useLocalSessionState=true, cacheServerConfiguration=true}}],
gatherPerfMetrics=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@5ac060bb],
characterEncoding=@StringProperty[com.mysql.cj.conf.StringProperty@b7df26c],
disconnectOnExpiredPasswords=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2226885c],
cacheServerConfiguration=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@13fc154a],
autoReconnect=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@4a606a36],
autoReconnectForPools=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2e6a1f84],
maintainTimeStats=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@3898067d],
sessionMaxRows=@Integer[-1],
eventSink=null,
],
fields=@Field[][
@Field[com.mysql.cj.result.Field@5ce919ae[dbName=test,tableName=order0,originalTableName=order0,columnName=id,originalColumnName=id,mysqlType=8(FIELD_TYPE_BIGINT),sqlType=-5,flags= PRIMARY_KEY UNIQUE_KEY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@9cd3cac[dbName=test,tableName=order0,originalTableName=order0,columnName=user_id,originalColumnName=user_id,mysqlType=3(FIELD_TYPE_INT),sqlType=4,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@3a99001[dbName=test,tableName=order0,originalTableName=order0,columnName=fee,originalColumnName=fee,mysqlType=246(FIELD_TYPE_DECIMAL),sqlType=3,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@4c9775a3[dbName=test,tableName=order0,originalTableName=order0,columnName=create_time,originalColumnName=create_time,mysqlType=7(FIELD_TYPE_TIMESTAMP),sqlType=93,flags= BINARY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@58a721f6[dbName=test,tableName=order0,originalTableName=order0,columnName=note,originalColumnName=note,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
@Field[com.mysql.cj.result.Field@38ef4e12[dbName=test,tableName=order0,originalTableName=order0,columnName=address,originalColumnName=address,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
],
useOldAliasBehavior=@Boolean[false],
treatYearAsDate=@Boolean[true],
exceptionInterceptor=null,
],
@ShardingSchema[
shardingRule=@OrchestrationShardingRule[
masterSlaveRules=@LinkedList[isEmpty=true;size=0],
ruleConfiguration=@ShardingRuleConfiguration[org.apache.shardingsphere.api.config.sharding.ShardingRuleConfiguration@520b84f6],
shardingDataSourceNames=@ShardingDataSourceNames[org.apache.shardingsphere.core.rule.ShardingDataSourceNames@3a75b141],
tableRules=@ArrayList[isEmpty=false;size=4],
bindingTableRules=@ArrayList[isEmpty=false;size=1],
broadcastTables=@LinkedList[isEmpty=false;size=1],
defaultDatabaseShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5fdbe91f],
defaultTableShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5a701e4b],
defaultShardingKeyGenerator=@SnowflakeShardingKeyGenerator[org.apache.shardingsphere.core.strategy.keygen.SnowflakeShardingKeyGenerator@54520dc7],
masterSlaveRules=@ArrayList[isEmpty=true;size=0],
encryptRule=@EncryptRule[org.apache.shardingsphere.core.rule.EncryptRule@43ba41b5],
],
metaData=@ShardingSphereMetaData[
dataSources=@DataSourceMetas[org.apache.shardingsphere.core.metadata.datasource.DataSourceMetas@197107a4],
tables=@TableMetas[org.apache.shardingsphere.core.metadata.table.TableMetas@5d891d78],
relationMetas=@RelationMetas[org.apache.shardingsphere.sql.parser.relation.metadata.RelationMetas@4caf4895],
],
name=@String[master_slave_db],
parseEngine=@SQLParseEngine[
databaseTypeName=@String[MySQL],
cache=@SQLParseResultCache[org.apache.shardingsphere.sql.parser.cache.SQLParseResultCache@5088fede],
],
backendDataSource=@JDBCBackendDataSource[
dataSources=@LinkedHashMap[isEmpty=false;size=6],
dataSourceParameters=@LinkedHashMap[isEmpty=false;size=6],
dataSourceFactory=@JDBCRawBackendDataSourceFactory[org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory@73a248a0],
shardingTransactionManagerEngine=@ShardingTransactionManagerEngine[org.apache.shardingsphere.transaction.ShardingTransactionManagerEngine@1e714d06],
],
],
@Integer[5],
],
]
ts=2020-04-23 03:57:10; [cost=0.001833ms] result=@ArrayList[
@Object[][
@ResultSetMetaData[
session=@NativeSession[
serialVersionUID=@Long[5323638898749073419],
serverConfigCache=@[com.mysql.cj.util.PerVmServerConfigCacheFactory$1@5572c575],
customIndexToCharsetMapByUrl=@HashMap[isEmpty=true;size=0],
customCharsetToMblenMapByUrl=@HashMap[isEmpty=true;size=0],
requiresEscapingEncoder=@Boolean[false],
lastQueryFinishedTime=@Long[0],
needsPing=@Boolean[false],
commandBuilder=@NativeMessageBuilder[com.mysql.cj.protocol.a.NativeMessageBuilder@2dced2f8],
isClosed=@Boolean[false],
forceClosedReason=null,
listeners=@CopyOnWriteArrayList[isEmpty=false;size=1],
cancelTimer=null,
SERVER_VERSION_STRING_VAR_NAME=@String[server_version_string],
propertySet=@JdbcPropertySetImpl[com.mysql.cj.jdbc.JdbcPropertySetImpl@690dbeda],
exceptionInterceptor=@[com.mysql.cj.NativeSession$1@545bc27b],
log=@StandardLogger[com.mysql.cj.log.StandardLogger@17c1ece8],
NULL_LOGGER=@NullLogger[com.mysql.cj.log.NullLogger@4cc3a5fa],
protocol=@NativeProtocol[com.mysql.cj.protocol.a.NativeProtocol@483c39d6],
messageBuilder=null,
connectionCreationTimeMillis=@Long[1587611780475],
hostInfo=@HostInfo[com.mysql.cj.conf.HostInfo@427e62b0 :: {host: "mysql8_4", port: 3306, hostProperties: {maintainTimeStats=false, rewriteBatchedStatements=true, cacheResultSetMetadata=false, tinyInt1isBit=false, useServerPrepStmts=true, netTimeoutForStreamingResults=0, useSSL=false, useUnicode=true, prepStmtCacheSqlLimit=2048, dbname=test, allowPublicKeyRetrieval=true, elideSetAutoCommits=true, cachePrepStmts=true, serverTimezone=UTC, characterEncoding=utf8, prepStmtCacheSize=250, useLocalSessionState=true, cacheServerConfiguration=true}}],
gatherPerfMetrics=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@5ac060bb],
characterEncoding=@StringProperty[com.mysql.cj.conf.StringProperty@b7df26c],
disconnectOnExpiredPasswords=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2226885c],
cacheServerConfiguration=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@13fc154a],
autoReconnect=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@4a606a36],
autoReconnectForPools=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@2e6a1f84],
maintainTimeStats=@BooleanProperty[com.mysql.cj.conf.BooleanProperty@3898067d],
sessionMaxRows=@Integer[-1],
eventSink=null,
],
fields=@Field[][
@Field[com.mysql.cj.result.Field@5ce919ae[dbName=test,tableName=order0,originalTableName=order0,columnName=id,originalColumnName=id,mysqlType=8(FIELD_TYPE_BIGINT),sqlType=-5,flags= PRIMARY_KEY UNIQUE_KEY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@9cd3cac[dbName=test,tableName=order0,originalTableName=order0,columnName=user_id,originalColumnName=user_id,mysqlType=3(FIELD_TYPE_INT),sqlType=4,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@3a99001[dbName=test,tableName=order0,originalTableName=order0,columnName=fee,originalColumnName=fee,mysqlType=246(FIELD_TYPE_DECIMAL),sqlType=3,flags=, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@4c9775a3[dbName=test,tableName=order0,originalTableName=order0,columnName=create_time,originalColumnName=create_time,mysqlType=7(FIELD_TYPE_TIMESTAMP),sqlType=93,flags= BINARY, charsetIndex=63, charsetName=ISO-8859-1]],
@Field[com.mysql.cj.result.Field@58a721f6[dbName=test,tableName=order0,originalTableName=order0,columnName=note,originalColumnName=note,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
@Field[com.mysql.cj.result.Field@38ef4e12[dbName=test,tableName=order0,originalTableName=order0,columnName=address,originalColumnName=address,mysqlType=253(FIELD_TYPE_VARCHAR),sqlType=12,flags=, charsetIndex=255, charsetName=utf8]],
],
useOldAliasBehavior=@Boolean[false],
treatYearAsDate=@Boolean[true],
exceptionInterceptor=null,
],
@ShardingSchema[
shardingRule=@OrchestrationShardingRule[
masterSlaveRules=@LinkedList[isEmpty=true;size=0],
ruleConfiguration=@ShardingRuleConfiguration[org.apache.shardingsphere.api.config.sharding.ShardingRuleConfiguration@520b84f6],
shardingDataSourceNames=@ShardingDataSourceNames[org.apache.shardingsphere.core.rule.ShardingDataSourceNames@3a75b141],
tableRules=@ArrayList[isEmpty=false;size=4],
bindingTableRules=@ArrayList[isEmpty=false;size=1],
broadcastTables=@LinkedList[isEmpty=false;size=1],
defaultDatabaseShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5fdbe91f],
defaultTableShardingStrategy=@NoneShardingStrategy[org.apache.shardingsphere.core.strategy.route.none.NoneShardingStrategy@5a701e4b],
defaultShardingKeyGenerator=@SnowflakeShardingKeyGenerator[org.apache.shardingsphere.core.strategy.keygen.SnowflakeShardingKeyGenerator@54520dc7],
masterSlaveRules=@ArrayList[isEmpty=true;size=0],
encryptRule=@EncryptRule[org.apache.shardingsphere.core.rule.EncryptRule@43ba41b5],
],
metaData=@ShardingSphereMetaData[
dataSources=@DataSourceMetas[org.apache.shardingsphere.core.metadata.datasource.DataSourceMetas@197107a4],
tables=@TableMetas[org.apache.shardingsphere.core.metadata.table.TableMetas@5d891d78],
relationMetas=@RelationMetas[org.apache.shardingsphere.sql.parser.relation.metadata.RelationMetas@4caf4895],
],
name=@String[master_slave_db],
parseEngine=@SQLParseEngine[
databaseTypeName=@String[MySQL],
cache=@SQLParseResultCache[org.apache.shardingsphere.sql.parser.cache.SQLParseResultCache@5088fede],
],
backendDataSource=@JDBCBackendDataSource[
dataSources=@LinkedHashMap[isEmpty=false;size=6],
dataSourceParameters=@LinkedHashMap[isEmpty=false;size=6],
dataSourceFactory=@JDBCRawBackendDataSourceFactory[org.apache.shardingsphere.shardingproxy.backend.communication.jdbc.datasource.JDBCRawBackendDataSourceFactory@73a248a0],
shardingTransactionManagerEngine=@ShardingTransactionManagerEngine[org.apache.shardingsphere.transaction.ShardingTransactionManagerEngine@1e714d06],
],
],
@Integer[6],
],
]
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org