SonarQube jenkins作业因“无法执行请求”而失败

Question

我们正在运行SonarQube 4.5.1，并使用Jenkins和SonarQube插件运行项目分析。从三天前开始，我们在一些作业中遇到以下错误消息。

[ERROR] Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.6:sonar (default-cli) on project MYPROJECT: Fail to execute request [code=500, url=https://SONARQUBE/batch/project?key=com.myplugins.sonar.plugins:MYPROJECT&preview=false]: Fail to download [https://SONARQUBE/batch/project?key=com.myplugins.sonar.plugins:MYPROJECT&preview=false]. Response code: 500 -> [Help 1]
org.apache.maven.lifecycle.LifecycleExecutionException: Failed to execute goal org.codehaus.mojo:sonar-maven-plugin:2.6:sonar (default-cli) on project MYPROJECT: Fail to execute request [code=500, url=https://SONARQUBE/batch/project?key=com.myplugins.sonar.plugins:MYPROJECT&preview=false]

Caused by: org.apache.maven.plugin.MojoExecutionException: Fail to execute request [code=500, url=https://SONARQUBE/batch/project?key=com.myplugins.sonar.plugins:MYPROJECT&preview=false]

Caused by: java.lang.IllegalStateException: Fail to execute request [code=500, url=https://SONARQUBE/batch/project?key=com.myplugins.sonar.plugins:MYPROJECT&preview=false]

Caused by: org.sonar.api.utils.HttpDownloader$HttpException: Fail to download [https://SONARQUBE/batch/project?key=com.myplugins.sonar.plugins:MYPROJECT&preview=false]. Response code: 500

如果我将URL复制到浏览器，我会收到以下消息：

“您仅被授权执行本地（试运行）SonarQube分析，而无需将结果推送到SonarQube服务器。请与您的SonarQube管理员联系。”

背景

"期望selectOne（）返回一个结果（或null），但发现：2"

代码或设置没有更改。

项目在项目概述中列出两次，但链接到相同的项目看板（相同的键、相同的度量值等）

“批量删除”不显示重复项，也不列在“幽灵”选项卡下。

我们还查看了数据库并执行了以下语句：

SELECT * FROM projects where kee=MYPROJECT-KEY

仍然没有发现重复。

我们从来没有遇到过类似的问题，而且完全不知道。有什么建议吗？

Answer 1

当我作为服务运行sonar时，我遇到了这个错误，当我作为管理员从命令提示符运行时，一切都很好。

Answer 2

看起来上次成功的分析在数据库中留下了两个快照…原因未知。

mysql> SELECT rootProject.* , s.islast, s.id    FROM projects p     INNER JOIN snapshots s ON s.project_id=p.id AND s.islast=true INNER JOIN projects rootProject ON rootProject.id=s.root_project_id AND p.kee='PROJECTKEY';
+-------+---------------------------------------------------+---------+-------+-----------+------------+---------+----------+------------------+-----------+-----------+---------------------+------+------------------------------------+--------+----------+
| id    | name | description                                | enabled | scope | qualifier | kee        | root_id | language | copy_resource_id | long_name | person_id | created_at          | path | deprecated_kee                     | islast | id       |
+-------+---------------------------------------------------+---------+-------+-----------+------------+---------+----------+------------------+-----------+-----------+---------------------+------+------------------------------------+--------+----------+
| 12814 | NAME | DESC                                       |       1 | PRJ   | TRK       | PROJECTKEY |    NULL | NULL     |             NULL | NAME      |      NULL | 2014-07-08 16:57:46 | NULL | PROJECTKEY                         |      1 | 21507844 |
| 12814 | NAME | DESC                                       |       1 | PRJ   | TRK       | PROJECTKEY |    NULL | NULL     |             NULL | NAME      |      NULL | 2014-07-08 16:57:46 | NULL | PROJECTKEY                         |      1 | 21516010 |
+-------+---------------------------------------------------+---------+-------+-----------+------------+---------+----------+------------------+-----------+-----------+---------------------+------+------------------------------------+--------+----------+
2 rows in set (0.00 sec)

mysql> SELECT rootProject.id , s.islast, s.id, s.build_date    FROM projects p     INNER JOIN snapshots s ON s.project_id=p.id AND s.islast=true INNER JOIN projects rootProject ON rootProject.id=s.root_project_id AND p.kee='PROJECTKEY';
+-------+--------+----------+---------------------+
| id    | islast | id       | build_date          |
+-------+--------+----------+---------------------+
| 12814 |      1 | 21507844 | 2015-10-25 02:21:59 |
| 12814 |      1 | 21516010 | 2015-10-25 02:21:59 |
+-------+--------+----------+---------------------+
2 rows in set (0.01 sec)

删除SonarQube项目是唯一的解决方案（删除数据库条目会导致不同的错误）