-
Choerodon平台版本：0.8.0
-
运行环境：自主搭建
-
问题描述：
打开项目下的测试管理，
个别项目会出现空白页面，以下是前端和后端服务报错截图:
2018-07-24 14:05:25.050 DEBUG [test-manager-service,deae91c84abcffa6,08eb0ef51992fcd9,true] 1 --- [ XNIO-3 task-24] i.c.t.m.i.m.T.selectCyclesInVersions : ==> Preparing: SELECT DISTINCT cycle_id FROM test_cycle WHERE version_id IN ( ? , ? , ? , ? , ? )
2018-07-24 14:05:25.050 DEBUG [test-manager-service,deae91c84abcffa6,08eb0ef51992fcd9,true] 1 --- [ XNIO-3 task-24] i.c.t.m.i.m.T.selectCyclesInVersions : ==> Parameters: 2(Long), 3(Long), 5(Long), 8(Long), 9(Long)
2018-07-24 14:05:25.052 DEBUG [test-manager-service,deae91c84abcffa6,08eb0ef51992fcd9,true] 1 --- [ XNIO-3 task-24] i.c.t.m.i.m.T.selectCyclesInVersions : <== Total: 0
2018-07-24 14:05:25.052 DEBUG [test-manager-service,deae91c84abcffa6,08eb0ef51992fcd9,true] 1 --- [ XNIO-3 task-24] i.c.t.m.i.m.T.countCaseNotRun : ==> Preparing: select count(*) from test_cycle_case left join test_status st on execution_status=st.status_id where st.status_name='未执行' and cycle_id in
2018-07-24 14:05:25.052 DEBUG [test-manager-service,deae91c84abcffa6,08eb0ef51992fcd9,true] 1 --- [ XNIO-3 task-24] i.c.t.m.i.m.T.countCaseNotRun : ==> Parameters:
2018-07-24 14:05:25.056 DEBUG [test-manager-service,261f466b0cc13811,cb0f9ee43389c70f,true] 1 --- [ XNIO-3 task-26] i.c.t.m.i.m.T.selectCyclesInVersions : ==> Preparing: SELECT DISTINCT cycle_id FROM test_cycle WHERE version_id IN ( ? , ? , ? , ? , ? )
2018-07-24 14:05:25.056 DEBUG [test-manager-service,261f466b0cc13811,cb0f9ee43389c70f,true] 1 --- [ XNIO-3 task-26] i.c.t.m.i.m.T.selectCyclesInVersions : ==> Parameters: 2(Long), 3(Long), 5(Long), 8(Long), 9(Long)
2018-07-24 14:05:25.056 DEBUG [test-manager-service,21e6579322ed9bc7,71361746305c15c4,true] 1 --- [ XNIO-3 task-22] i.c.t.m.i.m.T.selectCyclesInVersions : ==> Preparing: SELECT DISTINCT cycle_id FROM test_cycle WHERE version_id IN ( ? , ? , ? , ? , ? )
2018-07-24 14:05:25.056 DEBUG [test-manager-service,21e6579322ed9bc7,71361746305c15c4,true] 1 --- [ XNIO-3 task-22] i.c.t.m.i.m.T.selectCyclesInVersions : ==> Parameters: 2(Long), 3(Long), 5(Long), 8(Long), 9(Long)
2018-07-24 14:05:25.057 DEBUG [test-manager-service,261f466b0cc13811,cb0f9ee43389c70f,true] 1 --- [ XNIO-3 task-26] i.c.t.m.i.m.T.selectCyclesInVersions : <== Total: 0
2018-07-24 14:05:25.057 DEBUG [test-manager-service,261f466b0cc13811,cb0f9ee43389c70f,true] 1 --- [ XNIO-3 task-26] i.c.t.m.i.m.T.countCaseSum : ==> Preparing: SELECT count(*) FROM test_cycle_case where cycle_id in
2018-07-24 14:05:25.057 DEBUG [test-manager-service,261f466b0cc13811,cb0f9ee43389c70f,true] 1 --- [ XNIO-3 task-26] i.c.t.m.i.m.T.countCaseSum : ==> Parameters:
2018-07-24 14:05:25.057 DEBUG [test-manager-service,21e6579322ed9bc7,71361746305c15c4,true] 1 --- [ XNIO-3 task-22] i.c.t.m.i.m.T.selectCyclesInVersions : <== Total: 0
2018-07-24 14:05:25.058 DEBUG [test-manager-service,21e6579322ed9bc7,71361746305c15c4,true] 1 --- [ XNIO-3 task-22] i.c.t.m.i.m.T.countCaseNotPlain : ==> Preparing: SELECT count( DISTINCT ( issue_id ) ) FROM test_cycle_case where cycle_id in
2018-07-24 14:05:25.058 DEBUG [test-manager-service,21e6579322ed9bc7,71361746305c15c4,true] 1 --- [ XNIO-3 task-22] i.c.t.m.i.m.T.countCaseNotPlain : ==> Parameters:
2018-07-24 14:05:25.060 INFO [test-manager-service,deae91c84abcffa6,08eb0ef51992fcd9,true] 1 --- [ XNIO-3 task-24] i.c.r.h.ControllerExceptionHandler : exception process
org.springframework.jdbc.BadSqlGrammarException:
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
### The error may exist in URL [jar:file:/test-manager-service.jar!/BOOT-INF/classes!/mapper/TestCycleCaseMapper.xml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select count(*) from test_cycle_case left join test_status st on execution_status=st.status_id where st.status_name='未执行' and cycle_id in
### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
; bad SQL grammar []; nested exception is com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3
at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:231) ~[spring-jdbc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:73) ~[spring-jdbc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:73) ~[mybatis-spring-1.3.1.jar!/:1.3.1]
at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446) ~[mybatis-spring-1.3.1.jar!/:1.3.1]
at com.sun.proxy.$Proxy168.selectOne(Unknown Source) ~[na:na]
at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166) ~[mybatis-spring-1.3.1.jar!/:1.3.1]
at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:82) ~[mybatis-3.4.2.jar!/:3.4.2]
at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59) ~[mybatis-3.4.2.jar!/:3.4.2]
at com.sun.proxy.$Proxy190.countCaseNotRun(Unknown Source) ~[na:na]
at io.choerodon.test.manager.infra.repository.impl.TestCycleCaseRepositoryImpl.countCaseNotRun(TestCycleCaseRepositoryImpl.java:108) ~[classes!/:0.8.0]
at io.choerodon.test.manager.domain.service.impl.ITestCycleCaseServiceImpl.countCaseNotRun(ITestCycleCaseServiceImpl.java:156) ~[classes!/:0.8.0]
at io.choerodon.test.manager.app.service.impl.TestCycleCaseServiceImpl.countCaseNotRun(TestCycleCaseServiceImpl.java:295) ~[classes!/:0.8.0]
at io.choerodon.test.manager.app.service.impl.TestCycleCaseServiceImpl$$FastClassBySpringCGLIB$$9b59afa7.invoke(<generated>) ~[classes!/:0.8.0]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:204) ~[spring-core-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:738) ~[spring-aop-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) ~[spring-aop-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) ~[spring-aop-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) ~[spring-aop-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:673) ~[spring-aop-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at io.choerodon.test.manager.app.service.impl.TestCycleCaseServiceImpl$$EnhancerBySpringCGLIB$$d8ecebc8.countCaseNotRun(<generated>) ~[classes!/:0.8.0]
at io.choerodon.test.manager.api.controller.v1.TestCycleCaseController.countCaseNotRun(TestCycleCaseController.java:174) ~[classes!/:0.8.0]
at sun.reflect.GeneratedMethodAccessor489.invoke(Unknown Source) ~[na:na]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_121]
at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_121]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) ~[spring-web-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:133) ~[spring-web-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:97) ~[spring-webmvc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:827) ~[spring-webmvc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:738) ~[spring-webmvc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:85) ~[spring-webmvc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:963) ~[spring-webmvc-4.3.8.RELEASE.jar!/:4.3.8.RELEASE]
