<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal>I’m moving RT to a new server and taking the
opportunity to upgrade versions as well. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Currently, v3.6.3 on FC4 and MySql 4.1.16.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I backed up the db with<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>Mysqldump --opt
--add-drop-table --single-transaction –default-character-set=binary -u root
-pXXXXXXX rt3 >rt363.adhoc.bkup<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Copied the SQL dump to the new server running CentOS 5.5 and
MySql 5.0.77 and restored the RT3 db.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Last week, I successfully upgraded from 3.6.3 to 3.8.9
(patched the db to 3.7.87, applied the 3.8.0 schema changes, patched the
database up to 3.8.9 as per UPGRADING.mysql). Worked great, no problems. Was
just about to implement that when RT 4.0.0 was released…<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>So….I want to upgrade to that instead. There was no
UPGRADING.mysql, just the README saying to run rt-setup-database.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>When I try to upgrade from 3.6.3 all the way up to 4.0.0, I’m
getting:<o:p></o:p></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>Processing 3.7.81<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>Now populating
database schema.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>[Mon May 2
20:53:58 2011] [crit]: DBD::mysql::st execute failed: Duplicate key name
'CachedGroupMembers3' at /opt/rt4/sbin/../lib/RT/Handle.pm line 503. (/opt/rt4/sbin/../lib/RT.pm:340)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>DBD::mysql::st
execute failed: Duplicate key name 'CachedGroupMembers3' at
/opt/rt4/sbin/../lib/RT/Handle.pm line 503.<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Since the 3.8.9 upgrade worked fine (with the included
schema change queries), I used rt3.8.9 to upgrade my 3.6.3 to 3.8.9 (again,
going to 3.7.87, applying the schema change queries, then upgrading the db to
3.8.9). Which, again, worked fine.<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Then, using RT 4.0.0, I tried to update the database from
3.8.9 to 4.0.0 and am getting the error:<o:p></o:p></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>Processing 3.9.3<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>Now populating database
schema.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>[Mon May 2
20:31:51 2011] [crit]: DBD::mysql::st execute failed: Can't DROP 'DelegatedBy';
check that column/key exists at /opt/rt4/sbin/../lib/RT/Handle.pm line 503.
(/opt/rt4/sbin/../lib/RT.pm:340)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New"'>DBD::mysql::st
execute failed: Can't DROP 'DelegatedBy'; check that column/key exists at
/opt/rt4/sbin/../lib/RT/Handle.pm line 503.<o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Do I need to upgrade incrementally from 3.6.3 to 3.8.9 to
3.9.x and then to 4.0.0? Is there info on this that I missed? Or, should the
rt-setup-database handle the jump from 3.6.3 to 4.0.0 (including 3.8.0’s
schema changes)?<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>(I’m not a SQL expert in the least).<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks for any help!<o:p></o:p></p>
<p class=MsoNormal>Steve<o:p></o:p></p>
</div>
</body>
</html>