[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sonar-user
Subject:    [sonar-user] Sonar DB migration fails from sonar 2.10 to sonar 3.3
From:       Laurent Vanboquestal <laurent.vanboquestal () gmail ! com>
Date:       2012-10-31 10:59:41
Message-ID: CAJ6ekxRT=L1a=rUv4fWHCe64HvzZQraxNauhkeUYZ3+oOFHWDg () mail ! gmail ! com
[Download RAW message or body]

Hello,

While performing the migration of Sonar DB from 2.10 to version 3.3 ... we
got the following error:

The migration failed: An error has occurred, all later migrations canceled:

ActiveRecord::JDBCError: The total number of locks exceeds the lock table

size: UPDATE `project_measures` SET metric_id=58 WHERE (metric_id=53 AND
rule_id IS NOT NULL AND rule_priority=0) .
Please check the logs.

Well, Apparently, it is a well know problem when a lot of updates are
performed with too low mysql settings ....

We did updated the mysql values, but I just would like to know if Sonar
migration will recover normally or if it's better to restore the DB from
initial state (v2.10) and then retry the migration?  (FYI, DB dump files is
about 3GB)

What do you think?

Thanks for your support,

Laurent

[Attachment #3 (text/html)]

<div style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" \
face="Consolas">Hello,</font></div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas"></font> </div> <div \
style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" face="Consolas">While \
performing the migration of Sonar DB from 2.10 to version 3.3 ...</font><font \
size="3" face="Consolas"> we got the following error:</font></div>

<div style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" \
face="Consolas"></font> </div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas">The migration failed: An error \
has occurred, all later migrations canceled: </font></div> <p style="MARGIN:0cm 0cm \
0pt" class="MsoPlainText"><font size="3" face="Consolas">ActiveRecord::JDBCError: The \
total number of locks exceeds the lock table</font></p> <p style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas">size: UPDATE `project_measures` \
SET metric_id=58 WHERE (metric_id=53 AND rule_id IS NOT NULL AND rule_priority=0) \
.</font></p> <div style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" \
face="Consolas">Please check the logs.</font></div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas"></font> </div> <div \
style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" face="Consolas">Well, \
Apparently, it is a well know problem when a lot of updates are performed with too \
low mysql settings ....</font></div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas"></font> </div> <div \
style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" face="Consolas">We did \
updated the mysql values, but I just would like to know if Sonar migration will \
recover normally or if it&#39;s better to restore the DB from initial state (v2.10) \
and then retry the migration?  (FYI, DB dump files is about 3GB)</font></div>

<div style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" \
face="Consolas"></font> </div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas">What do you think?</font></div> \
<div style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font size="3" \
face="Consolas"></font> </div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas">Thanks for your \
support,</font></div> <div style="MARGIN:0cm 0cm 0pt" class="MsoPlainText"><font \
size="3" face="Consolas"></font> </div> <div style="MARGIN:0cm 0cm 0pt" \
class="MsoPlainText"><font size="3" face="Consolas">Laurent</font></div>



[prev in list] [next in list] [prev in thread] [next in thread]