您好！ Sharding-Proxy 连接 mysql8.0.18 报错，读取元数据出错。 报错信息如下（配置和报错日志 在附件。多谢了）
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.recovery_delay = 300000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.client_demarcation = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.threaded_2pc = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.rmi_export_class = none
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.max_actives = 10000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.enable_logging = true
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.max_timeout = 300000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.trust_client_tm = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.tm_unique_name = 127.0.1.1.tm
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
java.naming.provider.url = rmi://localhost:1099
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 15:36:31.680 [main] c.a.icatch.provider.imp.AssemblerImp - Using
default (local) logging and recovery...
[INFO ] 15:36:31.701 [main] c.a.d.xa.XATransactionalResource - resource-1-ds_0:
refreshed XAResource
[INFO ] 15:36:31.720 [main] c.a.d.xa.XATransactionalResource - resource-2-ds_1:
refreshed XAResource
Exception in thread "main" java.sql.SQLDataException: Cannot determine value
type from string 'NO'
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:114)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1382)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getBoolean(ResultSetImpl.java:663)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getBoolean(ResultSetImpl.java:669)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.getColumnMetaDataList(TableMetaDataLoader.java:169)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.createTableMetaData(TableMetaDataLoader.java:147)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.load(TableMetaDataLoader.java:112)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.access$100(TableMetaDataLoader.java:56)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader$1.execute(TableMetaDataLoader.java:101)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:125)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.parallelExecute(ShardingExecuteEngine.java:102)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:83)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:62)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.load(TableMetaDataLoader.java:94)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.load(TableMetaDataLoader.java:87)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataInitializer.loadShardingTables(TableMetaDataInitializer.java:86)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataInitializer.load(TableMetaDataInitializer.java:78)
at
org.apache.shardingsphere.shardingproxy.backend.schema.impl.ShardingSchema.createMetaData(ShardingSchema.java:81)
at
org.apache.shardingsphere.shardingproxy.backend.schema.impl.ShardingSchema.<init>(ShardingSchema.java:72)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemaFactory.newInstance(LogicSchemaFactory.java:56)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemas.initSchemas(LogicSchemas.java:104)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemas.init(LogicSchemas.java:94)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemas.init(LogicSchemas.java:78)
at
org.apache.shardingsphere.shardingproxy.Bootstrap.startWithoutRegistryCenter(Bootstrap.java:101)
at
org.apache.shardingsphere.shardingproxy.Bootstrap.main(Bootstrap.java:81)
Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine
value type from string 'NO'
at
com.mysql.cj.result.BooleanValueFactory.createFromBytes(BooleanValueFactory.java:116)
at
com.mysql.cj.result.BooleanValueFactory.createFromBytes(BooleanValueFactory.java:47)
at
com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:132)
at
com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:196)
at
com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241)
at
com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1270)
... 23 more
--
=================================
文光临
TEL:15821698254<<attachment: conf.zip>>
15:36:31,246 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback-test.xml]
15:36:31,246 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could
NOT find resource [logback.groovy]
15:36:31,246 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found
resource [logback.xml] at
[file:/home/vm/apache-shardingsphere-incubating-4.0.0-RC3-sharding-proxy-bin/conf/logback.xml]
15:36:31,247 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource
[logback.xml] occurs multiple times on the classpath.
15:36:31,247 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource
[logback.xml] occurs at
[jar:file:/home/vm/apache-shardingsphere-incubating-4.0.0-RC3-sharding-proxy-bin/lib/sharding-proxy-bootstrap-4.0.0-RC3.jar!/logback.xml]
15:36:31,247 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource
[logback.xml] occurs at
[jar:file:/home/vm/apache-shardingsphere-incubating-4.0.0-RC3-sharding-proxy-bin/lib/sharding-proxy-distribution-4.0.0-RC3.jar!/logback.xml]
15:36:31,247 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource
[logback.xml] occurs at
[file:/home/vm/apache-shardingsphere-incubating-4.0.0-RC3-sharding-proxy-bin/conf/logback.xml]
15:36:31,277 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction
- debug attribute not set
15:36:31,278 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About
to instantiate appender of type [ch.qos.logback.core.ConsoleAppender]
15:36:31,281 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming
appender as [console]
15:36:31,284 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA
- Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder]
for [encoder] property
15:36:31,307 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction -
Setting level of logger [org.apache.shardingsphere] to INFO
15:36:31,307 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction -
Setting additivity of logger [org.apache.shardingsphere] to false
15:36:31,308 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [console] to Logger[org.apache.shardingsphere]
15:36:31,308 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT
level set to INFO
15:36:31,308 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction -
Attaching appender named [console] to Logger[ROOT]
15:36:31,308 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction
- End of configuration.
15:36:31,308 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@5ae63ade
- Registering current configuration as safe fallback point
[INFO ] 15:36:31.318 [main] o.a.s.core.util.ConfigurationLogger -
ShardingRuleConfiguration
tables:
cart:
actualDataNodes: ds_${0..1}.cart_${0..2}
databaseStrategy:
inline:
algorithmExpression: ds_${user_id % 2}
shardingColumn: user_id
logicTable: cart
tableStrategy:
inline:
algorithmExpression: cart_${user_id % 3}
shardingColumn: user_id
[INFO ] 15:36:31.332 [main] o.a.s.core.util.ConfigurationLogger - Authentication
users:
root:
authorizedSchemas: ''
password: root
sharding:
authorizedSchemas: sharding_db
password: sharding
[INFO ] 15:36:31.333 [main] o.a.s.core.util.ConfigurationLogger - Properties
{}
[INFO ] 15:36:31.414 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 -
Starting...
[INFO ] 15:36:31.642 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-1 -
Start completed.
[INFO ] 15:36:31.643 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 -
Starting...
[INFO ] 15:36:31.653 [main] com.zaxxer.hikari.HikariDataSource - HikariPool-2 -
Start completed.
[INFO ] 15:36:31.672 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded
jar:file:/home/vm/apache-shardingsphere-incubating-4.0.0-RC3-sharding-proxy-bin/lib/transactions-4.0.6.jar!/transactions-defaults.properties
[INFO ] 15:36:31.673 [main] c.a.icatch.provider.imp.AssemblerImp - Loaded
jar:file:/home/vm/apache-shardingsphere-incubating-4.0.0-RC3-sharding-proxy-bin/lib/sharding-transaction-xa-atomikos-manager-4.0.0-RC3.jar!/jta.properties
[WARN ] 15:36:31.676 [main] c.a.icatch.provider.imp.AssemblerImp - Thanks for
using Atomikos! Evaluate http://www.atomikos.com/Main/ExtremeTransactions for
advanced features and professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable
this message and receive FREE tips & advice
Thanks for using Atomikos! Evaluate
http://www.atomikos.com/Main/ExtremeTransactions for advanced features and
professional support
or register at http://www.atomikos.com/Main/RegisterYourDownload to disable
this message and receive FREE tips & advice
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.default_max_wait_time_on_shutdown = 9223372036854775807
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.allow_subtransactions = true
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.recovery_delay = 300000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.automatic_resource_registration = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.oltp_max_retries = 5
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.client_demarcation = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.threaded_2pc = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.serial_jta_transactions = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.log_base_dir = ./logs
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.rmi_export_class = none
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.max_actives = 10000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.checkpoint_interval = 50000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.enable_logging = true
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.log_base_name = xa_tx
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.max_timeout = 300000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.trust_client_tm = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
java.naming.factory.initial = com.sun.jndi.rmi.registry.RegistryContextFactory
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.tm_unique_name = 127.0.1.1.tm
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.forget_orphaned_log_entries_delay = 86400000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.oltp_retry_interval = 10000
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
java.naming.provider.url = rmi://localhost:1099
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.force_shutdown_on_vm_exit = false
[INFO ] 15:36:31.679 [main] c.a.icatch.provider.imp.AssemblerImp - USING:
com.atomikos.icatch.default_jta_timeout = 300000
[INFO ] 15:36:31.680 [main] c.a.icatch.provider.imp.AssemblerImp - Using
default (local) logging and recovery...
[INFO ] 15:36:31.701 [main] c.a.d.xa.XATransactionalResource - resource-1-ds_0:
refreshed XAResource
[INFO ] 15:36:31.720 [main] c.a.d.xa.XATransactionalResource - resource-2-ds_1:
refreshed XAResource
Exception in thread "main" java.sql.SQLDataException: Cannot determine value
type from string 'NO'
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:114)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
at
com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
at
com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:96)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1382)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getBoolean(ResultSetImpl.java:663)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getBoolean(ResultSetImpl.java:669)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.getColumnMetaDataList(TableMetaDataLoader.java:169)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.createTableMetaData(TableMetaDataLoader.java:147)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.load(TableMetaDataLoader.java:112)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.access$100(TableMetaDataLoader.java:56)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader$1.execute(TableMetaDataLoader.java:101)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.syncGroupExecute(ShardingExecuteEngine.java:125)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.parallelExecute(ShardingExecuteEngine.java:102)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:83)
at
org.apache.shardingsphere.core.execute.ShardingExecuteEngine.groupExecute(ShardingExecuteEngine.java:62)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.load(TableMetaDataLoader.java:94)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataLoader.load(TableMetaDataLoader.java:87)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataInitializer.loadShardingTables(TableMetaDataInitializer.java:86)
at
org.apache.shardingsphere.core.execute.metadata.TableMetaDataInitializer.load(TableMetaDataInitializer.java:78)
at
org.apache.shardingsphere.shardingproxy.backend.schema.impl.ShardingSchema.createMetaData(ShardingSchema.java:81)
at
org.apache.shardingsphere.shardingproxy.backend.schema.impl.ShardingSchema.<init>(ShardingSchema.java:72)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemaFactory.newInstance(LogicSchemaFactory.java:56)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemas.initSchemas(LogicSchemas.java:104)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemas.init(LogicSchemas.java:94)
at
org.apache.shardingsphere.shardingproxy.backend.schema.LogicSchemas.init(LogicSchemas.java:78)
at
org.apache.shardingsphere.shardingproxy.Bootstrap.startWithoutRegistryCenter(Bootstrap.java:101)
at
org.apache.shardingsphere.shardingproxy.Bootstrap.main(Bootstrap.java:81)
Caused by: com.mysql.cj.exceptions.DataConversionException: Cannot determine
value type from string 'NO'
at
com.mysql.cj.result.BooleanValueFactory.createFromBytes(BooleanValueFactory.java:116)
at
com.mysql.cj.result.BooleanValueFactory.createFromBytes(BooleanValueFactory.java:47)
at
com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeByteArray(MysqlTextValueDecoder.java:132)
at
com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:196)
at
com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:241)
at
com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:132)
at
com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1270)
... 23 more
