Hi English communication is prerequisite.
Could you use 4.0.0-RC3 to test?
Juan Pan (Trista)
Senior DBA & PPMC of Apache ShardingSphere(Incubating)
email: panj...@apache.org
On 12/12/2019 16:05，文光临<wen164...@163.com> wrote：
您好！
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
