slievrly
commented
4 years ago The name of the configuration item has been changed , ref:https://github.com/seata/seata/tree/develop/script/client/conf
Closed mufengCc closed 4 years ago
slievrly
commented
4 years ago The name of the configuration item has been changed , ref:https://github.com/seata/seata/tree/develop/script/client/conf
hermitcai
commented
4 years ago service.vgroupMapping.my_test_tx_group i use vgroupMapping.fsp_tx_group, but this customize, as long as it corresponds.
mufengCc
commented
4 years ago @slievrly 您好，更改配置之后是OK了，但是紧接着又有一个问题
-在类StorageService.java的deduct()方法结束后报java.sql.SQLSyntaxErrorException: Unknown column 'context' in 'field list' 本机环境一切OK，但是就是找不到原因，还请告知一下，谢谢咯
-以下为异常详细信息 `Hibernate: select storage0_.id as id10, storage0_.commodity_code as commodit20, storage0_.count as count30 from storagetbl storage0 where storage0_.commodity_code=? Hibernate: update storage_tbl set commodity_code=?, count=? where id=? 2020-04-28 22:47:33.526 DEBUG 20460 --- [nio-8081-exec-2] i.s.core.rpc.netty.AbstractRpcRemoting : offer message: xid=192.168.31.189:8091:2010274006,branchType=AT,resourceId=jdbc:mysql://127.0.0.1:3306/db_storage,lockKey=storage_tbl:1 2020-04-28 22:47:33.526 DEBUG 20460 --- [geSend_RMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:SeataMergeMessage xid=192.168.31.189:8091:2010274006,branchType=AT,resourceId=jdbc:mysql://127.0.0.1:3306/db_storage,lockKey=storage_tbl:1 , channel:[id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:33.530 DEBUG 20460 --- [nio-8081-exec-2] i.s.r.d.undo.AbstractUndoLogManager : Flushing UNDO LOG: {"@class":"io.seata.rm.datasource.undo.BranchUndoLog","xid":"192.168.31.189:8091:2010274006","branchId":2010274007,"sqlUndoLogs":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.undo.SQLUndoLog","sqlType":"UPDATE","tableName":"storage_tbl","beforeImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords","tableName":"storage_tbl","rows":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.sql.struct.Row","fields":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.sql.struct.Field","name":"id","keyType":"PRIMARY_KEY","type":4,"value":1},{"@class":"io.seata.rm.datasource.sql.struct.Field","name":"commodity_code","keyType":"NULL","type":12,"value":"2001"},{"@class":"io.seata.rm.datasource.sql.struct.Field","name":"count","keyType":"NULL","type":4,"value":1000}]]}]]},"afterImage":{"@class":"io.seata.rm.datasource.sql.struct.TableRecords","tableName":"storage_tbl","rows":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.sql.struct.Row","fields":["java.util.ArrayList",[{"@class":"io.seata.rm.datasource.sql.struct.Field","name":"id","keyType":"PRIMARY_KEY","type":4,"value":1},{"@class":"io.seata.rm.datasource.sql.struct.Field","name":"commodity_code","keyType":"NULL","type":12,"value":"2001"},{"@class":"io.seata.rm.datasource.sql.struct.Field","name":"count","keyType":"NULL","type":4,"value":999}]]}]]}}]]} 2020-04-28 22:47:33.531 ERROR 20460 --- [nio-8081-exec-2] io.seata.rm.datasource.ConnectionProxy : process connectionProxy commit error: Unknown column 'context' in 'field list'
java.sql.SQLSyntaxErrorException: Unknown column 'context' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1116) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1066) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1396) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1051) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:256) ~[druid-1.1.10.jar:1.1.10]
at io.seata.rm.datasource.undo.mysql.MySQLUndoLogManager.insertUndoLog(MySQLUndoLogManager.java:100) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.undo.mysql.MySQLUndoLogManager.insertUndoLogWithNormal(MySQLUndoLogManager.java:76) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.undo.AbstractUndoLogManager.flushUndoLogs(AbstractUndoLogManager.java:220) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:221) [seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.doCommit(ConnectionProxy.java:196) [seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.lambda$commit$0(ConnectionProxy.java:184) [seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.execute(ConnectionProxy.java:289) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.commit(ConnectionProxy.java:183) [seata-all-1.2.0.jar:1.2.0]
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:81) ~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:232) ~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68) ~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536) ~[spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:532) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) ~[spring-aop-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at io.seata.sample.service.StorageService$$EnhancerBySpringCGLIB$$1eaec3f3.deduct(
2020-04-28 22:47:33.532 DEBUG 20460 --- [nio-8081-exec-2] i.s.core.rpc.netty.AbstractRpcRemoting : offer message: xid=192.168.31.189:8091:2010274006,branchId=2010274007,resourceId=null,status=PhaseOne_Failed,applicationData=null 2020-04-28 22:47:33.532 DEBUG 20460 --- [geSend_RMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:SeataMergeMessage xid=192.168.31.189:8091:2010274006,branchId=2010274007,resourceId=null,status=PhaseOne_Failed,applicationData=null , channel:[id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:33.579 DEBUG 20460 --- [nio-8081-exec-2] i.s.core.rpc.netty.AbstractRpcRemoting : offer message: xid=192.168.31.189:8091:2010274006,branchId=2010274007,resourceId=null,status=PhaseOne_Failed,applicationData=null 2020-04-28 22:47:33.579 DEBUG 20460 --- [geSend_RMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:SeataMergeMessage xid=192.168.31.189:8091:2010274006,branchId=2010274007,resourceId=null,status=PhaseOne_Failed,applicationData=null , channel:[id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:33.583 DEBUG 20460 --- [nio-8081-exec-2] i.s.i.http.HttpHandlerExceptionResolver : Resolving exception from handler [public java.lang.Boolean io.seata.sample.controller.StorageController.deduct(java.lang.String,java.lang.Integer)]: org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection 2020-04-28 22:47:33.583 DEBUG 20460 --- [nio-8081-exec-2] io.seata.core.context.RootContext : unbind 192.168.31.189:8091:2010274006 2020-04-28 22:47:33.583 DEBUG 20460 --- [nio-8081-exec-2] io.seata.integration.http.XidResource : unbind[192.168.31.189:8091:2010274006] from RootContext 2020-04-28 22:47:33.583 DEBUG 20460 --- [nio-8081-exec-2] io.seata.core.context.RootContext : unbind null 2020-04-28 22:47:33.583 DEBUG 20460 --- [nio-8081-exec-2] o.s.c.a.s.web.SeataHandlerInterceptor : unbind null from RootContext 2020-04-28 22:47:33.583 WARN 20460 --- [nio-8081-exec-2] o.s.c.a.s.web.SeataHandlerInterceptor : xid in change during RPC from 192.168.31.189:8091:2010274006 to null 2020-04-28 22:47:33.584 ERROR 20460 --- [nio-8081-exec-2] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection] with root cause
java.sql.SQLSyntaxErrorException: Unknown column 'context' in 'field list'
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:95) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:960) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1116) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdateInternal(ClientPreparedStatement.java:1066) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeLargeUpdate(ClientPreparedStatement.java:1396) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.mysql.cj.jdbc.ClientPreparedStatement.executeUpdate(ClientPreparedStatement.java:1051) ~[mysql-connector-java-8.0.11.jar:8.0.11]
at com.alibaba.druid.pool.DruidPooledPreparedStatement.executeUpdate(DruidPooledPreparedStatement.java:256) ~[druid-1.1.10.jar:1.1.10]
at io.seata.rm.datasource.undo.mysql.MySQLUndoLogManager.insertUndoLog(MySQLUndoLogManager.java:100) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.undo.mysql.MySQLUndoLogManager.insertUndoLogWithNormal(MySQLUndoLogManager.java:76) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.undo.AbstractUndoLogManager.flushUndoLogs(AbstractUndoLogManager.java:220) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:221) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.doCommit(ConnectionProxy.java:196) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.lambda$commit$0(ConnectionProxy.java:184) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.execute(ConnectionProxy.java:289) ~[seata-all-1.2.0.jar:1.2.0]
at io.seata.rm.datasource.ConnectionProxy.commit(ConnectionProxy.java:183) ~[seata-all-1.2.0.jar:1.2.0]
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:81) ~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:232) ~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:68) ~[hibernate-core-5.2.14.Final.jar:5.2.14.Final]
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:536) ~[spring-orm-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:532) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:304) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98) ~[spring-tx-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) ~[spring-aop-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at io.seata.sample.service.StorageService$$EnhancerBySpringCGLIB$$1eaec3f3.deduct(
2020-04-28 22:47:33.586 DEBUG 20460 --- [nio-8081-exec-2] .s.i.h.TransactionPropagationIntercepter : xid in RootContext[null] xid in HttpContext[192.168.31.189:8091:2010274006] 2020-04-28 22:47:33.586 DEBUG 20460 --- [nio-8081-exec-2] io.seata.core.context.RootContext : bind 192.168.31.189:8091:2010274006 2020-04-28 22:47:33.586 DEBUG 20460 --- [nio-8081-exec-2] .s.i.h.TransactionPropagationIntercepter : bind[192.168.31.189:8091:2010274006] to RootContext 2020-04-28 22:47:33.586 DEBUG 20460 --- [nio-8081-exec-2] o.s.c.a.s.web.SeataHandlerInterceptor : xid in RootContext 192.168.31.189:8091:2010274006 xid in RpcContext 192.168.31.189:8091:2010274006 2020-04-28 22:47:33.588 DEBUG 20460 --- [nio-8081-exec-2] io.seata.core.context.RootContext : unbind 192.168.31.189:8091:2010274006 2020-04-28 22:47:33.588 DEBUG 20460 --- [nio-8081-exec-2] io.seata.integration.http.XidResource : unbind[192.168.31.189:8091:2010274006] from RootContext 2020-04-28 22:47:33.588 DEBUG 20460 --- [nio-8081-exec-2] io.seata.core.context.RootContext : unbind null 2020-04-28 22:47:33.588 DEBUG 20460 --- [nio-8081-exec-2] o.s.c.a.s.web.SeataHandlerInterceptor : unbind null from RootContext 2020-04-28 22:47:33.588 WARN 20460 --- [nio-8081-exec-2] o.s.c.a.s.web.SeataHandlerInterceptor : xid in change during RPC from 192.168.31.189:8091:2010274006 to null 2020-04-28 22:47:39.296 DEBUG 20460 --- [lector_TMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : will send ping msg,channel [id: 0x627f0077, L:/127.0.0.1:58662 - R:/127.0.0.1:8091] 2020-04-28 22:47:39.296 DEBUG 20460 --- [lector_TMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:services ping, channel:[id: 0x627f0077, L:/127.0.0.1:58662 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:39.296 DEBUG 20460 --- [lector_TMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : received PONG from /127.0.0.1:8091 2020-04-28 22:47:43.581 DEBUG 20460 --- [lector_RMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : will send ping msg,channel [id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091] 2020-04-28 22:47:43.581 DEBUG 20460 --- [lector_RMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:services ping, channel:[id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:43.582 DEBUG 20460 --- [lector_RMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : received PONG from /127.0.0.1:8091 2020-04-28 22:47:49.296 DEBUG 20460 --- [lector_TMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : will send ping msg,channel [id: 0x627f0077, L:/127.0.0.1:58662 - R:/127.0.0.1:8091] 2020-04-28 22:47:49.296 DEBUG 20460 --- [lector_TMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:services ping, channel:[id: 0x627f0077, L:/127.0.0.1:58662 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:49.296 DEBUG 20460 --- [lector_TMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : received PONG from /127.0.0.1:8091 2020-04-28 22:47:53.582 DEBUG 20460 --- [lector_RMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : will send ping msg,channel [id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091] 2020-04-28 22:47:53.582 DEBUG 20460 --- [lector_RMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:services ping, channel:[id: 0x6de4e16e, L:/127.0.0.1:58597 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:53.583 DEBUG 20460 --- [lector_RMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : received PONG from /127.0.0.1:8091 2020-04-28 22:47:59.299 DEBUG 20460 --- [lector_TMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : will send ping msg,channel [id: 0x627f0077, L:/127.0.0.1:58662 - R:/127.0.0.1:8091] 2020-04-28 22:47:59.299 DEBUG 20460 --- [lector_TMROLE_1] i.s.core.rpc.netty.AbstractRpcRemoting : write message:services ping, channel:[id: 0x627f0077, L:/127.0.0.1:58662 - R:/127.0.0.1:8091],active?true,writable?true,isopen?true 2020-04-28 22:47:59.300 DEBUG 20460 --- [lector_TMROLE_1] i.s.c.r.netty.AbstractRpcRemotingClient : received PONG from /127.0.0.1:8091 `
hermitcai
commented
4 years ago 字段可以对上吗？
mufengCc
commented
4 years ago @Garlichead 实体类和表都没有context字段，所以才很奇怪。还有就算不走save()方法，也是会报这个异常
jsbxyyx
commented
4 years ago update your business db's undo_log table struct.
hermitcai
commented
4 years ago 问题解决了吗
Ⅱ. 在 类 AbstractRpcRemotingClient.java 中的第 137行，获取到的为null，以下为详细信息
2020-04-25 18:25:41.281 DEBUG 24860 --- [nfigOperate_2_2] io.seata.config.FileConfiguration : Could not found property service.vgroupMapping.my_test_tx_group, try to use default value instead. exception:No configuration setting found for key 'service.vgroupMapping' 2020-04-25 18:25:41.281 DEBUG 24860 --- [nio-8084-exec-7] i.s.i.http.HttpHandlerExceptionResolver : Resolving exception from handler [public java.lang.Boolean io.seata.sample.controller.BusinessController.purchaseCommit()]: io.seata.common.exception.FrameworkException: No available service 2020-04-25 18:25:41.282 ERROR 24860 --- [nio-8084-exec-7] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Request processing failed; nested exception is io.seata.common.exception.FrameworkException: No available service] with root cause
io.seata.common.exception.FrameworkException: No available service at io.seata.core.rpc.netty.AbstractRpcRemotingClient.loadBalance(AbstractRpcRemotingClient.java:194) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.core.rpc.netty.AbstractRpcRemotingClient.sendMsgWithResponse(AbstractRpcRemotingClient.java:140) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.core.rpc.netty.AbstractRpcRemotingClient.sendMsgWithResponse(AbstractRpcRemotingClient.java:148) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.tm.DefaultTransactionManager.syncCall(DefaultTransactionManager.java:95) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.tm.DefaultTransactionManager.begin(DefaultTransactionManager.java:53) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.tm.api.DefaultGlobalTransaction.begin(DefaultGlobalTransaction.java:104) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.tm.api.TransactionalTemplate.beginTransaction(TransactionalTemplate.java:175) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.tm.api.TransactionalTemplate.execute(TransactionalTemplate.java:98) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.spring.annotation.GlobalTransactionalInterceptor.handleGlobalTransaction(GlobalTransactionalInterceptor.java:106) ~[seata-all-1.2.0.jar:1.2.0] at io.seata.spring.annotation.GlobalTransactionalInterceptor.invoke(GlobalTransactionalInterceptor.java:83) ~[seata-all-1.2.0.jar:1.2.0] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185) ~[spring-aop-5.0.4.RELEASE.jar:5.0.4.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.0.4.RELEASE.jar:5.0.4.RELEASE] at io.seata.sample.service.BusinessService$$EnhancerBySpringCGLIB$$bea8305a.purchase() ~[classes/:na]
at io.seata.sample.controller.BusinessController.purchaseCommit(BusinessController.java:21) ~[classes/:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_211]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_211]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_211]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_211]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:209) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:136) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:102) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:870) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:776) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:991) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:925) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:978) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:870) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:635) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:855) ~[spring-webmvc-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) ~[tomcat-embed-websocket-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:109) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:200) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107) ~[spring-web-5.0.4.RELEASE.jar:5.0.4.RELEASE]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:199) ~[tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:496) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:81) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:803) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:790) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1459) [tomcat-embed-core-8.5.28.jar:8.5.28]
at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-8.5.28.jar:8.5.28]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_211]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_211]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-8.5.28.jar:8.5.28]
at java.lang.Thread.run(Thread.java:748) [na:1.8.0_211]
Ⅳ. How to reproduce it (as minimally and precisely as possible)
1.从git下载的示例Demo](https://gitee.com/seata-io/seata-samples.git) 的springcloud-jpa-seata项目
Ⅵ. Environment: