获取"清除maxRows/queryTimeout"在sonarqube 4.5.1
Getting "exception clearing maxRows/queryTimeout" on sonarqube 4.5.1
我正在我的Ionic javascript项目上运行一个独立的声纳分析。扫描正在触发jenkins使用sonarqube插件2.1 mysql数据库和sonarqube是在同一台服务器上。Jenkins在独立的服务器上
扫描似乎运行正常,但在将结果存储在数据库中时抛出以下异常。似乎它试图在数据库中存储3+ HRS的结果,而不是抛出异常。
有人遇到过同样的问题吗?有人有什么建议来解决这个问题吗?
16:00:21.705 INFO - Sensor CPD Sensor (wrapped) done: 6413 ms
16:00:22.279 INFO - Execute decorators...
16:01:41.614 INFO - Store results in database
19:33:20.528 WARN - exception clearing maxRows/queryTimeout
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after statement closed.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.7.0_21]
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) ~[na:1.7.0_21]
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.7.0_21]
at java.lang.reflect.Constructor.newInstance(Constructor.java:525) ~[na:1.7.0_21]
at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.Util.getInstance(Util.java:386) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1015) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:989) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:975) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:920) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.StatementImpl.checkClosed(StatementImpl.java:461) ~[mysql-connector-java-5.1.27.jar:na]
at com.mysql.jdbc.StatementImpl.getMaxRows(StatementImpl.java:2216) ~[mysql-connector-java-5.1.27.jar:na]
at org.apache.commons.dbcp.DelegatingStatement.getMaxRows(DelegatingStatement.java:237) ~[sonar-batch-maven-compat-4.5.1.jar:na]
at org.apache.commons.dbcp.DelegatingStatement.getMaxRows(DelegatingStatement.java:237) ~[sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:234) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.Loader.getResultSet(Loader.java:1826) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.Loader.doQuery(Loader.java:697) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.Loader.doList(Loader.java:2232) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.Loader.list(Loader.java:2124) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:67) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.phases.UpdateStatusJob.disablePreviousSnapshot(UpdateStatusJob.java:91) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.phases.UpdateStatusJob.execute(UpdateStatusJob.java:66) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.phases.PhaseExecutor.updateStatusJob(PhaseExecutor.java:156) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.phases.PhaseExecutor.execute(PhaseExecutor.java:130) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.scan.ModuleScanContainer.doAfterStart(ModuleScanContainer.java:194) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:92) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.api.platform.ComponentContainer.execute(ComponentContainer.java:77) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.scan.ProjectScanContainer.scan(ProjectScanContainer.java:233) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.scan.ProjectScanContainer.scanRecursively(ProjectScanContainer.java:228) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.scan.ProjectScanContainer.doAfterStart(ProjectScanContainer.java:221) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:92) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.api.platform.ComponentContainer.execute(ComponentContainer.java:77) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.scan.ScanTask.scan(ScanTask.java:64) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.scan.ScanTask.execute(ScanTask.java:51) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.bootstrap.TaskContainer.doAfterStart(TaskContainer.java:125) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.api.platform.ComponentContainer.startComponents(ComponentContainer.java:92) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.api.platform.ComponentContainer.execute(ComponentContainer.java:77) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.bootstrap.BootstrapContainer.executeTask(BootstrapContainer.java:173) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.bootstrapper.Batch.executeTask(Batch.java:95) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.batch.bootstrapper.Batch.execute(Batch.java:67) [sonar-batch-maven-compat-4.5.1.jar:na]
at org.sonar.runner.batch.IsolatedLauncher.execute(IsolatedLauncher.java:48) [sonar-runner-batch3143046930648341546.jar:na]
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.7.0_21]
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) ~[na:1.7.0_21]
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.7.0_21]
at java.lang.reflect.Method.invoke(Method.java:601) ~[na:1.7.0_21]
at org.sonar.runner.impl.BatchLauncher$1.delegateExecution(BatchLauncher.java:87) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.impl.BatchLauncher$1.run(BatchLauncher.java:75) [sonar-runner-dist-2.4.jar:na]
at java.security.AccessController.doPrivileged(Native Method) [na:1.7.0_21]
at org.sonar.runner.impl.BatchLauncher.doExecute(BatchLauncher.java:69) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.impl.BatchLauncher.execute(BatchLauncher.java:50) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.api.EmbeddedRunner.doExecute(EmbeddedRunner.java:102) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.api.Runner.execute(Runner.java:100) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.Main.executeTask(Main.java:70) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.Main.execute(Main.java:59) [sonar-runner-dist-2.4.jar:na]
at org.sonar.runner.Main.main(Main.java:53) [sonar-runner-dist-2.4.jar:na]
19:33:20.530 WARN - SQL Error: 0, SQLState: 08S01
19:33:20.530 ERROR - Communications link failure
我也遇到了同样的问题。是由超时引起的。
我将MySQL服务器超时从180秒更改为900秒。(my.cnf: wait_timeout = 900,并重启MySQL服务器)
检查MySQL服务器超时时间和Sonar运行时间
相关文章:
- 铬:“;未捕获的语法错误:意外的标记:"
- 可以设置“;文件名"发生错误时显示的内联脚本标记的
- JS表单提交"无法使用Chrome数据保护程序加载此页面.尝试重新加载页面.调试信息:POST CISmtuK
- 检测电话窃听,即:<a href="电话:xxx">在UIWebview上
- 使用“+="操作人员
- //而不是在src=“”上使用http://"属性
- "未捕获的语法错误:意外的标记}"
- 可以<脚本类型=“;text/javascript”>window.location=“/"</
- "实例范围”;TypeScript类的getter/setter
- Javascript复选框函数:;缺少:在属性id之后"
- "“;变量未引用正确的对象
- "日期“;AJAX请求返回的类型值未定义
- 得到"TypeError:无法读取属性'filename'未定义的“;调用“npm start
- Soundcloud api"未捕获的类型错误:无法读取属性'uri'“未定义”;
- "工具提示"jQuery插件坏了
- "锻造;React中的表达式
- 图像可以从源<img src=""/>.TEXT可以在没有javascript的情况下从外部
- 如何提取“;href"最近列表项中的属性值
- CKEditor如何允许href="javascript:void(0)"在小部件中
- 插入“;img src"在javascript中