Please use English, thank you. ------------------
Liang Zhang (John) Apache ShardingSphere & Dubbo 文光临 <[email protected]> 于2019年12月12日周四 下午5:56写道： > 您好！ > 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 > > > >
