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 2019/12/22 12:32:24 UTC
[GitHub] [incubator-shardingsphere] TonyLuo opened a new issue #3782: Unable
to commit against JDBC Connection when using read-write split
TonyLuo opened a new issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782
## Bug Report
**For English only**, other languages will not accept.
Before report a bug, make sure you have:
- Searched open and closed [GitHub issues](https://github.com/apache/incubator-shardingsphere/issues).
- Read documentation: [ShardingSphere Doc](https://shardingsphere.apache.org/document/current/en/overview).
Please pay attention on issues you submitted, because we maybe need more details.
If no response **more than 7 days** and we cannot reproduce it on current information, we will **close it**.
Please answer these questions before submitting your issue. Thanks!
### Which version of ShardingSphere did you use?
4.0.0-RC3
### Which project did you use? Sharding-JDBC or Sharding-Proxy?
Sharding-JDBC
### Expected behavior
### Actual behavior
```
2019-12-22 20:30:54.551 INFO 56674 --- [lientSelector_1] RocketmqRemoting : closeChannel: close the connection to remote address[] result: true
2019-12-22 20:30:55.042 INFO 56674 --- [ product-task-1] ShardingSphere-SQL : Rule Type: master-slave
2019-12-22 20:30:55.042 INFO 56674 --- [ product-task-1] ShardingSphere-SQL : SQL: SELECT `LOCKED` FROM DATABASECHANGELOGLOCK WHERE ID=1 ::: DataSources: slave0
2019-12-22 20:30:55.694 INFO 56674 --- [nfoReplicator-0] ShardingSphere-SQL : Rule Type: master-slave
2019-12-22 20:30:55.694 INFO 56674 --- [nfoReplicator-0] ShardingSphere-SQL : SQL: /* ping */ SELECT 1 ::: DataSources: slave0
2019-12-22 20:30:56.620 DEBUG 56674 --- [ XNIO-1 task-2] c.b.product.aop.logging.LoggingAspect : Enter: com.boss.product.service.SupplierService.list() with argument[s] = [Page request [number: 0, size 20, sort: UNSORTED]]
Hibernate: select supplier0_.id as id1_21_, supplier0_.created_by as created_2_21_, supplier0_.created_date as created_3_21_, supplier0_.last_modified_by as last_mod4_21_, supplier0_.last_modified_date as last_mod5_21_, supplier0_.contact as contact6_21_, supplier0_.contact_address as contact_7_21_, supplier0_.email as email8_21_, supplier0_.mobile as mobile9_21_, supplier0_.name as name10_21_, supplier0_.phone as phone11_21_, supplier0_.remark as remark12_21_, supplier0_.status as status13_21_ from supplier supplier0_ limit ?
2019-12-22 20:30:56.884 INFO 56674 --- [ XNIO-1 task-2] ShardingSphere-SQL : Rule Type: master-slave
2019-12-22 20:30:56.884 INFO 56674 --- [ XNIO-1 task-2] ShardingSphere-SQL : SQL: select supplier0_.id as id1_21_, supplier0_.created_by as created_2_21_, supplier0_.created_date as created_3_21_, supplier0_.last_modified_by as last_mod4_21_, supplier0_.last_modified_date as last_mod5_21_, supplier0_.contact as contact6_21_, supplier0_.contact_address as contact_7_21_, supplier0_.email as email8_21_, supplier0_.mobile as mobile9_21_, supplier0_.name as name10_21_, supplier0_.phone as phone11_21_, supplier0_.remark as remark12_21_, supplier0_.status as status13_21_ from supplier supplier0_ limit ? ::: DataSources: slave0
Hibernate: select count(supplier0_.id) as col_0_0_ from supplier supplier0_
2019-12-22 20:30:57.344 INFO 56674 --- [ XNIO-1 task-2] ShardingSphere-SQL : Rule Type: master-slave
2019-12-22 20:30:57.344 INFO 56674 --- [ XNIO-1 task-2] ShardingSphere-SQL : SQL: select count(supplier0_.id) as col_0_0_ from supplier supplier0_ ::: DataSources: slave0
2019-12-22 20:30:57.353 DEBUG 56674 --- [ XNIO-1 task-2] c.b.product.aop.logging.LoggingAspect : Exit: com.boss.product.service.SupplierService.list() with result = Page 1 of 7 containing com.boss.product.dto.SupplierDTO instances
2019-12-22 20:30:57.424 ERROR 56674 --- [ XNIO-1 task-2] o.z.problem.spring.common.AdviceTraits : Internal Server Error
org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:352)
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:254)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:537)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:746)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:714)
at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:534)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:305)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:98)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:93)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689)
at com.boss.product.service.SupplierService$$EnhancerBySpringCGLIB$$d0261135.list(<generated>)
at com.boss.product.controller.SupplierController.list(SupplierController.java:160)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:498)
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190)
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138)
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:893)
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:798)
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040)
at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943)
at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006)
at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:898)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:645)
at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:97)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.boot.actuate.web.trace.servlet.HttpTraceFilter.doFilterInternal(HttpTraceFilter.java:88)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:320)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)
at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at com.boss.product.security.jwt.JWTFilter.doFilter(JWTFilter.java:38)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:74)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:215)
at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:178)
at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:358)
at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:271)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:94)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.filterAndRecordMetrics(WebMvcMetricsFilter.java:114)
at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:104)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201)
at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119)
at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
at io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:132)
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
at io.undertow.servlet.handlers.SessionRestoringHandler.handleRequest(SessionRestoringHandler.java:119)
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
at io.undertow.server.Connectors.executeRootHandler(Connectors.java:376)
at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.hibernate.TransactionException: Unable to commit against JDBC Connection
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:87)
at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:272)
at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:104)
at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:533)
... 121 common frames omitted
Caused by: java.sql.SQLException: null
at org.apache.shardingsphere.shardingjdbc.jdbc.adapter.executor.ForceExecuteTemplate.throwSQLExceptionIfNecessary(ForceExecuteTemplate.java:56)
at org.apache.shardingsphere.shardingjdbc.jdbc.adapter.executor.ForceExecuteTemplate.execute(ForceExecuteTemplate.java:49)
at org.apache.shardingsphere.shardingjdbc.jdbc.adapter.AbstractConnectionAdapter.commit(AbstractConnectionAdapter.java:183)
at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:81)
... 124 common frames omitted
```
### Reason analyze (If you can)
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule configuration, when exception occur etc.
### Example codes for reproduce this issue (such as a github link).
```xml
pom.xml
<shardingsphere.version>4.0.0-RC3</shardingsphere.version>
<dependency>
<groupId>org.apache.shardingsphere</groupId>
<artifactId>sharding-jdbc-spring-boot-starter</artifactId>
<version>${shardingsphere.version}</version>
</dependency>
```
```yml
application.yml
## 读写分离配置
shardingsphere:
datasource:
master:
driver-class-name: com.mysql.jdbc.Driver
password: root
type: com.zaxxer.hikari.HikariDataSource
jdbc-url: jdbc:mysql://localhost:3306/product?useUnicode=true&characterEncoding=utf8&useSSL=false&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai
username: root
names: master,slave0
slave0:
driver-class-name: com.mysql.jdbc.Driver
password: root
type: com.zaxxer.hikari.HikariDataSource
jdbc-url: jdbc:mysql://localhost:3306/product?useUnicode=true&characterEncoding=utf8&useSSL=false&useLegacyDatetimeCode=false&serverTimezone=Asia/Shanghai
username: root
masterslave:
master-data-source-name: master
name: ms
slave-data-source-names: slave0
props:
sql:
show: true
```
```java
@SpringBootApplication(exclude = JtaAutoConfiguration.class)
@EnableConfigurationProperties({LiquibaseProperties.class, ApplicationProperties.class})
@EnableDiscoveryClient
public class ProductApp implements InitializingBean {
private static final Logger log = LoggerFactory.getLogger(ProductApp.class);
private final Environment env;
public ProductApp(Environment env) {
this.env = env;
}
/**
* Initializes product.
* <p>
* Spring profiles can be configured with a program argument --spring.profiles.active=your-active-profile
* <p>
* You can find more information on how profiles work with JHipster on <a href="https://www.jhipster.tech/profiles/">https://www.jhipster.tech/profiles/</a>.
*/
@Override
public void afterPropertiesSet() throws Exception {
Collection<String> activeProfiles = Arrays.asList(env.getActiveProfiles());
if (activeProfiles.contains(JHipsterConstants.SPRING_PROFILE_DEVELOPMENT) && activeProfiles.contains(JHipsterConstants.SPRING_PROFILE_PRODUCTION)) {
log.error("You have misconfigured your application! It should not run " +
"with both the 'dev' and 'prod' profiles at the same time.");
}
if (activeProfiles.contains(JHipsterConstants.SPRING_PROFILE_DEVELOPMENT) && activeProfiles.contains(JHipsterConstants.SPRING_PROFILE_CLOUD)) {
log.error("You have misconfigured your application! It should not " +
"run with both the 'dev' and 'cloud' profiles at the same time.");
}
}
/**
* Main method, used to run the application.
*
* @param args the command line arguments.
*/
public static void main(String[] args) {
SpringApplication app = new SpringApplication(ProductApp.class);
DefaultProfileUtil.addDefaultProfile(app);
Environment env = app.run(args).getEnvironment();
logApplicationStartup(env);
}
private static void logApplicationStartup(Environment env) {
String protocol = "http";
if (env.getProperty("server.ssl.key-store") != null) {
protocol = "https";
}
String serverPort = env.getProperty("server.port");
String contextPath = env.getProperty("server.servlet.context-path");
if (StringUtils.isBlank(contextPath)) {
contextPath = "/";
}
String hostAddress = "localhost";
try {
hostAddress = InetAddress.getLocalHost().getHostAddress();
} catch (UnknownHostException e) {
log.warn("The host name could not be determined, using `localhost` as fallback");
}
log.info("\n----------------------------------------------------------\n\t" +
"Application '{}' is running! Access URLs:\n\t" +
"Local: \t\t{}://localhost:{}{}\n\t" +
"External: \t{}://{}:{}{}\n\t" +
"Profile(s): \t{}\n----------------------------------------------------------",
env.getProperty("spring.application.name"),
protocol,
serverPort,
contextPath,
protocol,
hostAddress,
serverPort,
contextPath,
env.getActiveProfiles());
String configServerStatus = env.getProperty("configserver.status");
if (configServerStatus == null) {
configServerStatus = "Not found or not setup for this application";
}
log.info("\n----------------------------------------------------------\n\t" +
"Config Server: \t{}\n----------------------------------------------------------", configServerStatus);
}
}
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo commented on issue #3782: Unable
to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-570920573
hi guys, any update on this issue?
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo commented on issue #3782: Unable
to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-568628768
pls refer to this repository : https://github.com/TonyLuo/test-shardingsphere
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo closed issue #3782: Unable to
commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo closed issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo edited a comment on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo edited a comment on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-583757879
It works when I comment this jpa configuration entry : hibernate.connection.provider_disables_autocommit.
Will it have any impact to do this? @terrymanu
```
jpa:
database-platform: org.hibernate.dialect.MySQL8Dialect
database: MYSQL
show-sql: true
properties:
hibernate.id.new_generator_mappings: true
# hibernate.connection.provider_disables_autocommit: true
hibernate.cache.use_second_level_cache: true
hibernate.cache.use_query_cache: false
hibernate.generate_statistics: false
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo edited a comment on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo edited a comment on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-583757879
It works when I comment this jpa configuration entry : hibernate.connection.provider_disables_autocommit.
Will it have any impact to do so? @terrymanu
```
jpa:
database-platform: org.hibernate.dialect.MySQL8Dialect
database: MYSQL
show-sql: true
properties:
hibernate.id.new_generator_mappings: true
# hibernate.connection.provider_disables_autocommit: true
hibernate.cache.use_second_level_cache: true
hibernate.cache.use_query_cache: false
hibernate.generate_statistics: false
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-568491590
Can you try to analyze and just provide related code with database access code?
For example, the code of `ssl` and `log` is too confuse for debug.
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo commented on issue #3782: Unable
to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-583755474
I upgrade the shardingjdbc version to be 4.0.0, it still has the same issue...
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo commented on issue #3782: Unable
to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-583757879
It works when I comment this jpa configuration entry hibernate.connection.provider_disables_autocommit.
Will it have any impact to do so? @terrymanu
```
jpa:
database-platform: org.hibernate.dialect.MySQL8Dialect
database: MYSQL
show-sql: true
properties:
hibernate.id.new_generator_mappings: true
# hibernate.connection.provider_disables_autocommit: true
hibernate.cache.use_second_level_cache: true
hibernate.cache.use_query_cache: false
hibernate.generate_statistics: false
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo commented on issue #3782: Unable
to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-583756183
I found this exception:
```
java.sql.SQLException: Can''t call commit when autocommit=true
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] terrymanu commented on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
terrymanu commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-571151479
I just label this issue as volunteer wanted, anybody who interested with this issue, please discuss here.
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo edited a comment on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo edited a comment on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-568628768
pls refer to this repository : https://github.com/TonyLuo/test-shardingsphere
After server started, you can run following command to reproduce this issue:
```
curl 'http://localhost:8080/api/authenticate' -H 'Content-Type: application/json;charset=UTF-8' -H 'Accept: application/json, text/plain, */*' --data-binary '{"username":"admin","password":"admin","rememberMe":false}'
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo edited a comment on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo edited a comment on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-583756183
I found this exception:
```
java.sql.SQLException: Can''t call commit when autocommit=true
```
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-568559483
Can you submit a test-case to reproduce this issue, thx.
@TonyLuo
----------------------------------------------------------------
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
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] TonyLuo edited a comment on issue #3782:
Unable to commit against JDBC Connection when using read-write split
Posted by GitBox <gi...@apache.org>.
TonyLuo edited a comment on issue #3782: Unable to commit against JDBC Connection when using read-write split
URL: https://github.com/apache/incubator-shardingsphere/issues/3782#issuecomment-568628768
@terrymanu @kimmking pls refer to this repository : https://github.com/TonyLuo/test-shardingsphere
After server started, you can run following command to reproduce this issue:
```
curl 'http://localhost:8080/api/authenticate' -H 'Content-Type: application/json;charset=UTF-8' -H 'Accept: application/json, text/plain, */*' --data-binary '{"username":"admin","password":"admin","rememberMe":false}'
```
----------------------------------------------------------------
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
With regards,
Apache Git Services