SonarQube升级4.2 - > 4.3.2 UpdateMeasuresDebtToMinutes显示已挂起 [英] SonarQube upgrade 4.2 -> 4.3.2 UpdateMeasuresDebtToMinutes appears hung
本文介绍了SonarQube升级4.2 - > 4.3.2 UpdateMeasuresDebtToMinutes显示已挂起的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在Windows 7 Enterprise / SQL Server 2012 / Java 7 Update 51 64位JDK上将SonarQube 4.2升级到4.3.2
设置屏幕显示：
SonarQube数据库正在升级。
约22小时前开始（2014年7月14日11:45）
sonar.log文件如下：
- > Wrapper作为控制台启动
启动JVM ...
Wrapper（版本3.2.3）http://wrapper.tanukisoftware.org
版权所有1999-2006 Tanuki Software，Inc 。 版权所有。
2014.07.14 11:42:31 INFO [osaConnectors] HTTP连接器在端口9000上启用
2014.07.14 11:42:32 INFO [oachHttp11Protocol]初始化ProtocolHandler [http -bio-0.0.0.0-9000]
2014.07.14 11:42:32 INFO [oaccStandardService]启动服务Tomcat
2014.07.14 11:42:32 INFO [oaccStandardEngine]启动Servlet引擎：Apache Tomcat / 7.0.42
2014.07.14 11:42:32 INFO [oacsContextConfig]找不到全局web.xml
2014.07.14 11:42:33 INFO [osspServerImpl] SonarQube服务器/ 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:33 INFO [oscpDatabase]为jdbc创建JDBC数据源：jtds：sqlserver：// localhost / sonardb; SelectMethod = Cursor
2014.07.14 11： 42:34 INFO [osspDatabaseServerCompatibility]数据库必须升级。请浏览/设置
2014.07.14 11:42:34 INFO [osspDefaultServerFileSystem] SonarQube主页：C：\sonarqube-4.3.2
2014.07.14 11:42:34 INFO [osspDefaultServerFileSystem]部署dir：C：\sonarqube-4.3.2\web\deploy
2014.07.14 11:42:34 INFO [org.sonar.INFO]安装插件...
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件Findbugs / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件时间线/ 1.4 / 5dbb36d5db80475315f3f39ac3ec506ef92a9d6a
2014.07.14 11： 42:34 INFO [osspServerPluginJarsInstaller]部署插件构建稳定性/ 1.2 / 2b32f73fbe180e8b5b6f56271018e3b0cd2c477d
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件Clirr / 1.1
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller] Deploy plugin English Pack / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件SCM活动/ 1.7.1 / 233895448799dc2ab0274aa518a77cc1b93fed7f
2014.07.14 11 ：42：34 INFO [osspServerPluginJarsInstaller]部署插件复制/ 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件Doxygen / 0.1 / 6014
2014.07.14 11 ：42：34 INFO [osspServerPluginJarsInstaller]部署插件PMD / 2.2 / a5da0c1cde1bd7be862a09dbb743fd9367c849d6
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件Squid for Java / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf
2014.07.14 11 ：42：34 INFO [osspServerPluginJarsInstaller]部署插件电子邮件通知/ 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件运动图表/ 1.7 / e9c4a5c95c75564b3c3b5a887b63ef50fc59a156
2014.07。 14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件JavaScript / 1.6 / 854b85c280793d4f983742a37b33b0449e2a65d4
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件安全规则/0.3.2
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件XML / 1.2 / 8a0e3c61b4bf3568125302a7ac87d677e8566c1f
2014.07.14 11:42:34 INFO [osspServerPluginJarsInstaller]部署插件JaCoCo / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf
2014.07.14 11： 42:35 INFO [osspServerPluginJarsInstaller]部署插件Widget Lab / 1.4.1 / f4e93e520bbecc47db57d42010c8fd267bb6e675
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Scm Stats / 0.3.1 / fd4f129d8cc73da085723c50b94936d74b1dc975
2014.07 .14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Maven Batch Plugin / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Surefire / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Tab Metrics / 1.4 / fa240469a783a0fe5b76c752ed014add30a346df
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Checkstyle / 2.1 / 219b216223e3e2477d1588064f25fca77be922a9
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Java / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Core / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件数据库清理/ 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Cobertura / 1.6.2 / 97fa42dd2ec9396debeeee6622eaa1df59e71f12
2014.07.14 11:42:35 INFO [osspServerPluginJarsInstaller]部署插件Design / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392
2014.07.14 11:42:35 INFO [org.sonar.INFO]安装插件完成：405 ms
2014.07.14 11:42:35 INFO [osspRailsAppsDeployer]部署Ruby on Rails应用程序
2014.07.14 11:42:35 INFO [osspRailsAppsDeployer]部署应用程序：motionchart
2014.07。 14 11:42:35 INFO [jruby.rack] jruby 1.7.9（ruby-1.8.7p370）2013-12-06在Java HotSpot（TM）64位服务器VM上的87b108a 1.7.0_51-b13 [Windows 7-amd64 ]
2014.07.14 11:42:35 INFO [jruby.rack]使用共享（线程安全！）运行时
2014.07.14 11:42:46 INFO [jruby.rack]保持自定义（配置。 logger）Rails logger instance
数据库必须升级。请浏览/设置
2014.07.14 11:42:46 INFO [oachHttp11Protocol]启动ProtocolHandler [http-bio-0.0.0.0-9000]
2014.07.14 11:42:46 INFO Web服务器启动
2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGates：migrating ======================== ===================
2014.07.14 11:45:23 INFO [DbMigration] - create_table（：quality_gates，{}）
2014.07 .14 11:45:23 INFO [DbMigration] - > 0.0090s
2014.07.14 11:45:23 INFO [DbMigration] - > 0 rows
2014.07.14 11:45:23 INFO [DbMigration] - add_index（quality_gates，[name]，{：unique => true，：name =>uniq_quality_gates}）
2014.07.14 11:45:23 INFO [DbMigration] - > 0.0450s
2014.07.14 11:45:23 INFO [DbMigration] - > 0 rows
2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGates：migrated（0.0560s）========================= =============
2014.07.14 11:45:23 INFO [DbMigration]
2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGateConditions：migrating ==================================
2014.07.14 11:45:23 INFO [ DbMigration] - create_table（：quality_gate_conditions，{}）
2014.07.14 11:45:23 INFO [DbMigration] - > 0.0050s
2014.07.14 11:45:23 INFO [DbMigration] - > 0 rows
2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGateConditions：migrated（0.0050s）========================= ====
2014.07.14 11:45:23 INFO [DbMigration]
2014.07.14 11:45:23 INFO [DbMigration] == ConvertAlertsToQualityGates：migrating ========= =========================
2014.07.14 11:45:23 INFO [DbMigration] == ConvertAlertsToQualityGates：migrated（0.0730 s）=========================
2014.07.14 11:45:23 INFO [DbMigration]
2014.07 .14 11:45:23 INFO [DbMigration] == UpdateIssueDebtToMinutes：migrating ============================== =====
2014.07.14 11:45:34 INFO [ossdmMassUpdater] 447217行已更新
2014.07.14 11:45:34 INFO [DbMigration] == UpdateIssueDebtToMinutes：migrated（10.5750 s）===========================
2014.07.14 11:45:34 INFO [DbMigration]
2014.07.14 11:45:34 INFO [DbMigration] == UpdateIssueChangelogDebtToMinutes：migrating ==========================
2014.07.14 11:45:35 INFO [ossdmMassUpdater] 39行已更新
2014.07.14 11:45:35 INFO [DbMigration] == UpdateIssueChangelogDebtToMinutes：migrated（1.0090s）===== ================
2014.07.14 11:45:35 INFO [DbMigration]
2014.07.14 11:45:35 INFO [DbMigration] == UpdateMeasuresDebtToMinutes：migrating ==================================
运行SQL Server跟踪每隔几秒显示一个SELECT 1的唯一数据库活动 b
$ b已审核的SQL活动监视器并注意到以下阻塞的SQL语句：
：56被56阻止
选择pm.id，pm.value，pm.variation_value_1，pm.variation_value_2， pm.variation_value_3，pm.variation_value_4，pm.variation_value_5 FROM project_measures pm INNER JOIN metrics m on m.id = pm.metric_id WHERE（m.name ='sqale_index'or m.name ='new_technical_debt'or m.name ='sqale_effort_to_grade_a '或m.name ='sqale_effort_to_grade_b'或m.name ='sqale_effort_to_grade_c'或m.name ='sqale_effort_to_grade_d'或m.name ='blocker_remediation_cost'或m.name ='critical_remediation_cost'或m.name ='major_remediation_cost' m.name ='minor_remediation_cost'或m.name ='info_remediation_cost'）
：58被56阻止
（@ P0 float，@ P1 float，@ P2 float，@ P3 float， @ P4 float，@ P5 float，@ P6 bigint）UPDATE project_measures SET value = @ P0，variation_value_1 = @ P1，variation_value_2 = @ P2，variation_value_3 = @ P3，variation_value_4 = @ P4，variation_value_5 = @ P5 WHERE id = @ P6
等待22+小时杀死SQL进程58并注意到声纳中的以下stacktace。日志：
2014.07.15 10:13:50 INFO [ossdmMassUpdater] 8000行已更新
2014.07.15 10:13:50 ERROR [ossdmDatabaseMigrator]无法执行数据库迁移：org.sonar.server.db.migrations.v43.TechnicalDebtMeasuresMigration
org.sonar.api.utils.MessageException：Fail to迁移数据，错误是：服务器返回了未指定的错误。
任何人都可以告诉我升级是否已经挂起，
从4.2升级到4.3时，我已经审查了类似的问题，但我升级到4.3.2，其中
解决方案我已经通过应用以下数据库索引解决了这个问题：
CREATE NONCLUSTERED INDEX [exelidx_metric_id]
ON [dbo]。[project_measures]（[metric_id]）
INCLUDE ]，[value]，[variation_value_1]，[variation_value_2]，[variation_value_3]，[variation_value_4]，[variation_value_5]）
GO
CREATE NONCLUSTERED INDEX [exelidx_characteristic_id]
ON [dbo]。[project_measures]（[characteristic_id]）
INCLUDE（[id]）
GO
b $ b升级在8分钟内成功完成。
When upgrading SonarQube 4.2 to 4.3.2 on Windows 7 Enterprise / SQL Server 2012 / Java 7 Update 51 64bit JDK
The setup screen stated:
SonarQube Database is currenly upgrading.
Started about 22 hours ago (14 Jul 2014 11:45)
The sonar.log file is as follows:
--> Wrapper Started as Console Launching a JVM... Wrapper (Version 3.2.3) http://wrapper.tanukisoftware.org Copyright 1999-2006 Tanuki Software, Inc. All Rights Reserved. 2014.07.14 11:42:31 INFO [o.s.a.Connectors] HTTP connector is enabled on port 9000 2014.07.14 11:42:32 INFO [o.a.c.h.Http11Protocol] Initializing ProtocolHandler ["http-bio-0.0.0.0-9000"] 2014.07.14 11:42:32 INFO [o.a.c.c.StandardService] Starting service Tomcat 2014.07.14 11:42:32 INFO [o.a.c.c.StandardEngine] Starting Servlet Engine: Apache Tomcat/7.0.42 2014.07.14 11:42:32 INFO [o.a.c.s.ContextConfig] No global web.xml found 2014.07.14 11:42:33 INFO [o.s.s.p.ServerImpl] SonarQube Server / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:33 INFO [o.s.c.p.Database] Create JDBC datasource for jdbc:jtds:sqlserver://localhost/sonardb;SelectMethod=Cursor 2014.07.14 11:42:34 INFO [o.s.s.p.DatabaseServerCompatibility] Database must be upgraded. Please browse /setup 2014.07.14 11:42:34 INFO [o.s.s.p.DefaultServerFileSystem] SonarQube home: C:\sonarqube-4.3.2 2014.07.14 11:42:34 INFO [o.s.s.p.DefaultServerFileSystem] Deploy dir: C:\sonarqube-4.3.2\web\deploy 2014.07.14 11:42:34 INFO [org.sonar.INFO] Install plugins... 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Findbugs / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Timeline / 1.4 / 5dbb36d5db80475315f3f39ac3ec506ef92a9d6a 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Build Stability / 1.2 / 2b32f73fbe180e8b5b6f56271018e3b0cd2c477d 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Clirr / 1.1 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin English Pack / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin SCM Activity / 1.7.1 / 233895448799dc2ab0274aa518a77cc1b93fed7f 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Duplications / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Doxygen / 0.1 / 6014 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin PMD / 2.2 / a5da0c1cde1bd7be862a09dbb743fd9367c849d6 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Squid for Java / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Email notifications / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Motion Chart / 1.7 / e9c4a5c95c75564b3c3b5a887b63ef50fc59a156 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin JavaScript / 1.6 / 854b85c280793d4f983742a37b33b0449e2a65d4 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Security Rules / 0.3.2 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin XML / 1.2 / 8a0e3c61b4bf3568125302a7ac87d677e8566c1f 2014.07.14 11:42:34 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin JaCoCo / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Widget Lab / 1.4.1 / f4e93e520bbecc47db57d42010c8fd267bb6e675 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Scm Stats / 0.3.1 / fd4f129d8cc73da085723c50b94936d74b1dc975 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Maven Batch Plugin / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Surefire / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Tab Metrics / 1.4 / fa240469a783a0fe5b76c752ed014add30a346df 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Checkstyle / 2.1 / 219b216223e3e2477d1588064f25fca77be922a9 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Java / 2.3 / a231b7d2488255a3494a8704d8ebd3e92af7d0bf 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Core / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Database Cleaner / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Cobertura / 1.6.2 / 97fa42dd2ec9396debeeee6622eaa1df59e71f12 2014.07.14 11:42:35 INFO [o.s.s.p.ServerPluginJarsInstaller] Deploy plugin Design / 4.3.2 / a82ddddad45acebdce81bdf70767a4ee11147392 2014.07.14 11:42:35 INFO [org.sonar.INFO] Install plugins done: 405 ms 2014.07.14 11:42:35 INFO [o.s.s.p.RailsAppsDeployer] Deploy Ruby on Rails applications 2014.07.14 11:42:35 INFO [o.s.s.p.RailsAppsDeployer] Deploy app: motionchart 2014.07.14 11:42:35 INFO [jruby.rack] jruby 1.7.9 (ruby-1.8.7p370) 2013-12-06 87b108a on Java HotSpot(TM) 64-Bit Server VM 1.7.0_51-b13 [Windows 7-amd64] 2014.07.14 11:42:35 INFO [jruby.rack] using a shared (threadsafe!) runtime 2014.07.14 11:42:46 INFO [jruby.rack] keeping custom (config.logger) Rails logger instance Database must be upgraded. Please browse /setup 2014.07.14 11:42:46 INFO [o.a.c.h.Http11Protocol] Starting ProtocolHandler ["http-bio-0.0.0.0-9000"] 2014.07.14 11:42:46 INFO Web server is started 2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGates: migrating ============================================= 2014.07.14 11:45:23 INFO [DbMigration] -- create_table(:quality_gates, {}) 2014.07.14 11:45:23 INFO [DbMigration] -> 0.0090s 2014.07.14 11:45:23 INFO [DbMigration] -> 0 rows 2014.07.14 11:45:23 INFO [DbMigration] -- add_index("quality_gates", ["name"], {:unique=>true, :name=>"uniq_quality_gates"}) 2014.07.14 11:45:23 INFO [DbMigration] -> 0.0450s 2014.07.14 11:45:23 INFO [DbMigration] -> 0 rows 2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGates: migrated (0.0560s) ==================================== 2014.07.14 11:45:23 INFO [DbMigration] 2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGateConditions: migrating ==================================== 2014.07.14 11:45:23 INFO [DbMigration] -- create_table(:quality_gate_conditions, {}) 2014.07.14 11:45:23 INFO [DbMigration] -> 0.0050s 2014.07.14 11:45:23 INFO [DbMigration] -> 0 rows 2014.07.14 11:45:23 INFO [DbMigration] == CreateQualityGateConditions: migrated (0.0050s) =========================== 2014.07.14 11:45:23 INFO [DbMigration] 2014.07.14 11:45:23 INFO [DbMigration] == ConvertAlertsToQualityGates: migrating ==================================== 2014.07.14 11:45:23 INFO [DbMigration] == ConvertAlertsToQualityGates: migrated (0.0730s) =========================== 2014.07.14 11:45:23 INFO [DbMigration] 2014.07.14 11:45:23 INFO [DbMigration] == UpdateIssueDebtToMinutes: migrating ======================================= 2014.07.14 11:45:34 INFO [o.s.s.d.m.MassUpdater] 447217 rows have been updated 2014.07.14 11:45:34 INFO [DbMigration] == UpdateIssueDebtToMinutes: migrated (10.5750s) ============================= 2014.07.14 11:45:34 INFO [DbMigration] 2014.07.14 11:45:34 INFO [DbMigration] == UpdateIssueChangelogDebtToMinutes: migrating ============================== 2014.07.14 11:45:35 INFO [o.s.s.d.m.MassUpdater] 39 rows have been updated 2014.07.14 11:45:35 INFO [DbMigration] == UpdateIssueChangelogDebtToMinutes: migrated (1.0090s) ===================== 2014.07.14 11:45:35 INFO [DbMigration] 2014.07.14 11:45:35 INFO [DbMigration] == UpdateMeasuresDebtToMinutes: migrating ====================================Running a SQL Server Trace the only database activity that appears is a 'SELECT 1' every few seconds
Reviewed SQL Activity Monitor and noted the following SQL Statements where blocking:
SQL Process: 56 blocked by 56
SELECT pm.id, pm.value , pm.variation_value_1 , pm.variation_value_2, pm.variation_value_3 , pm.variation_value_4 , pm.variation_value_5 FROM project_measures pm INNER JOIN metrics m on m.id=pm.metric_id WHERE (m.name='sqale_index' or m.name='new_technical_debt' or m.name='sqale_effort_to_grade_a' or m.name='sqale_effort_to_grade_b' or m.name='sqale_effort_to_grade_c' or m.name='sqale_effort_to_grade_d' or m.name='blocker_remediation_cost' or m.name='critical_remediation_cost' or m.name='major_remediation_cost' or m.name='minor_remediation_cost' or m.name='info_remediation_cost' )SQL Process: 58 blocked by 56
(@P0 float,@P1 float,@P2 float,@P3 float,@P4 float,@P5 float,@P6 bigint)UPDATE project_measures SET value= @P0 ,variation_value_1= @P1 ,variation_value_2= @P2 ,variation_value_3= @P3 ,variation_value_4= @P4 ,variation_value_5= @P5 WHERE id= @P6After waiting for 22+ Hours killed SQL process 58 and noted the following stacktace in the sonar.log:
2014.07.15 10:13:50 INFO [o.s.s.d.m.MassUpdater] 8000 rows have been updated 2014.07.15 10:13:50 ERROR [o.s.s.d.m.DatabaseMigrator] Fail to execute database migration: org.sonar.server.db.migrations.v43.TechnicalDebtMeasuresMigration org.sonar.api.utils.MessageException: Fail to migrate data, error is : The server returned an unspecified error.Can anyone tell me if the upgrade had in fact hung or is it just slow, has anyone else encountered this and if so how was it resolved.
I have reviewed a similar post for this issue when upgrading from 4.2 to 4.3 but I am upgrading to 4.3.2, in which I thought this issue was resolved.
解决方案I have resolved this issue myself by applying the following database indexes:
CREATE NONCLUSTERED INDEX [exelidx_metric_id] ON [dbo].[project_measures] ([metric_id]) INCLUDE ([id],[value],[variation_value_1],[variation_value_2],[variation_value_3],[variation_value_4],[variation_value_5]) GO CREATE NONCLUSTERED INDEX [exelidx_characteristic_id] ON [dbo].[project_measures] ([characteristic_id]) INCLUDE ([id]) GOUpgrade completed sucessfully in 8 minutes.
这篇关于SonarQube升级4.2 - > 4.3.2 UpdateMeasuresDebtToMinutes显示已挂起的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
