Я использую SonarQube 5.1 (используя базу данных H2 по умолчанию) с Gradle 2.3/4.
В SonarQube я использую пробную версию для плагина управления портфелем Views, который (объединяет показатели проекта SonarQube как компонент и позволяет создавать представления, такие как все проекты в рамках данной команды, отдела, менеджера, все проекты приложений, все сервисные проекты и т. д. .
Задача sonarRunner успешно работает в Gradle. После завершения анализа мне нужно запустить другую команду, чтобы выбрать последний анализ для «Плагин Views Portfolio», и команда, которую я запускаю каждые 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.