声纳错误超时试图锁定表"PROJECT_MEASURES"；SQL语句：

Question

我使用的是SonarQube 5.1 (使用默认数据库H2)和Gradle 2.3/4。

在SonarQube中，我使用了视图组合管理插件的试用版本(将SonarQube项目的度量作为一个组件组合起来，并允许您创建视图，就像给定团队、部门、经理、所有应用程序项目、所有服务项目等下的所有项目一样)。

sonarRunner任务正在Gradle中成功地工作。分析完成后，我必须运行另一个命令来选择“视图组合插件”的最新分析，而我每2分钟运行一次的命令(使用Jenkins作业)是:声纳跑步视图。

sonarRunner任务工作了几天，但是今天我在Jenkins看到了一个错误。

知道我在这里错过了什么吗？

PS：当我每2分钟运行一次作业时，它会在几分钟后自动工作。

00:00:05.987 23:29:38.207 INFO  - Load module settings
00:00:06.382 23:29:38.603 INFO  - Load rules
00:00:07.456 23:29:39.677 INFO  - Index files
00:00:07.463 23:29:39.683 INFO  - 0 files indexed
00:00:07.913 23:29:40.134 INFO  - Sensor ViewsSensor
00:00:09.935 23:29:42.155 WARN  - SQL Error: 50200, SQLState: HYT00
00:00:09.935 23:29:42.156 ERROR - Timeout trying to lock table "PROJECT_MEASURES"; SQL statement:
00:00:09.935 select measuremod0_.id as id5_, measuremod0_.alert_status as alert2_5_, measuremod0_.alert_text as alert3_5_, measuremod0_.characteristic_id as characte4_5_, measuremod0_.measure_data as measure5_5_, measuremod0_.description as descript6_5_, measuremod0_.metric_id as metric7_5_, measuremod0_.person_id as person8_5_, measuremod0_.project_id as project9_5_, measuremod0_.rule_id as rule10_5_, measuremod0_.rule_priority as rule11_5_, measuremod0_.snapshot_id as snapshot12_5_, measuremod0_.tendency as tendency5_, measuremod0_.text_value as text14_5_, measuremod0_.url as url5_, measuremod0_.value as value5_, measuremod0_.variation_value_1 as variation17_5_, measuremod0_.variation_value_2 as variation18_5_, measuremod0_.variation_value_3 as variation19_5_, measuremod0_.variation_value_4 as variation20_5_, measuremod0_.variation_value_5 as variation21_5_ from project_measures measuremod0_ where measuremod0_.snapshot_id=? and (measuremod0_.person_id is null) [50200-176]
00:00:09.972 INFO: ------------------------------------------------------------------------
00:00:09.972 INFO: EXECUTION FAILURE
00:00:09.972 INFO: ------------------------------------------------------------------------
00:00:09.973 Total time: 9.802s
00:00:10.234 Final Memory: 43M/1448M
00:00:10.235 INFO: ------------------------------------------------------------------------
00:00:10.236 ERROR: Error during Sonar runner execution
00:00:10.237 ERROR: Unable to execute Sonar
00:00:10.237 ERROR: Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
00:00:10.237 ERROR: Caused by: could not execute query
00:00:10.238 ERROR: Caused by: Timeout trying to lock table "PROJECT_MEASURES"; SQL statement:
00:00:10.238 select measuremod0_.id as id5_, measuremod0_.alert_status as alert2_5_, measuremod0_.alert_text as alert3_5_, measuremod0_.characteristic_id as characte4_5_, measuremod0_.measure_data as measure5_5_, measuremod0_.description as descript6_5_, measuremod0_.metric_id as metric7_5_, measuremod0_.person_id as person8_5_, measuremod0_.project_id as project9_5_, measuremod0_.rule_id as rule10_5_, measuremod0_.rule_priority as rule11_5_, measuremod0_.snapshot_id as snapshot12_5_, measuremod0_.tendency as tendency5_, measuremod0_.text_value as text14_5_, measuremod0_.url as url5_, measuremod0_.value as value5_, measuremod0_.variation_value_1 as variation17_5_, measuremod0_.variation_value_2 as variation18_5_, measuremod0_.variation_value_3 as variation19_5_, measuremod0_.variation_value_4 as variation20_5_, measuremod0_.variation_value_5 as variation21_5_ from project_measures measuremod0_ where measuremod0_.snapshot_id=? and (measuremod0_.person_id is null) [50200-176]
00:00:10.238 ERROR: 
00:00:10.239 ERROR: To see the full stack trace of the errors, re-run SonarQube Runner with the -e switch.
00:00:10.239 ERROR: Re-run SonarQube Runner using the -X switch to enable full debug logging.
00:00:10.271 Build step 'Execute shell' marked build as failure

对于这个项目，当我试图在SonarQube中看到项目本身时，我看到了下面的黄色背景行：

No analysis has been performed since creation. The only available section is the configuration.

所有其他项目都显示有效的SonarQube仪表板页面。

Answer 1

找到了第一个问题的解决方案。我在使用视图组合插件时做了一个POC，它需要定期运行“声纳-运行视图”命令来发布/获取用于视图的新数据。

有一个Jenkins作业，每2分钟只运行一次“声纳跑步者视图”，同时，其他Jenkins作业(对于一个项目)正在执行sonarRunner (分析)，然后这个错误就出现了。

为了解决这个问题，我将运行声纳运行视图命令的作业更改为不运行，如果其他Jenkins作业正在进行中(中的retrict复选框)。

现在我没有得到那个SQL错误。

我仍然在研究为什么即使sonarRunner任务(Gradle)成功了，它也不会在SonarQube主页中生成特定的项目。也就是说我得到了：

No analysis has been performed since creation. The only available section is the configuration.

PS：所有其他项目的sonarRunner任务都显示相同的成功运行，它们在SonarQube中可见。

找到了第二个问题的解决方案，即

要解决“自创建以来没有执行任何分析。唯一可用的部分是配置”。

我发现几天前，我更新了几个插件(即声呐-api插件等，从X.X到X.Y版本)，但它们都处于待定安装状态，也就是说，在我下载它们之后，我没有重新启动声纳实例来选择它们。

我刚刚重新启动声纳实例，错误消失了，现在一切都正常了。