<div dir="ltr">Hello everyone,<div><br></div><div>I just upgraded from 4.0.6 to 4.2.3 using the Debian packages. During the database upgrade, I received a few errors:</div><div><br></div><div><p class="MsoNormal"> Processing 4.1.1</p>
<p class="MsoNormal">Now populating database schema.</p>
<p class="MsoNormal">[12453] [Wed May 21 03:19:36 2014] [critical]: DBD::Pg::st
execute failed: ERROR: cannot drop sequence objectscrips_id_seq because
other objects depend on it</p>
<p class="MsoNormal">DETAIL: default for table objectscrips column id
depends on sequence objectscrips_id_seq</p>
<p class="MsoNormal">HINT: Use DROP ... CASCADE to drop the dependent
objects too. at /usr/share/request-tracker4/lib/RT/Handle.pm line 529.
(/usr/share/request-tracker4/lib/RT.pm:394)</p>
<p class="MsoNormal">DBD::Pg::st execute failed: ERROR: cannot drop
sequence objectscrips_id_seq because other objects depend on it</p>
<p class="MsoNormal">DETAIL: default for table objectscrips column id
depends on sequence objectscrips_id_seq</p>
<p class="MsoNormal">HINT: Use DROP ... CASCADE to drop the dependent
objects too. at /usr/share/request-tracker4/lib/RT/Handle.pm line 529.</p>
<p class="MsoNormal">error encountered processing
/usr/share/dbconfig-common/scripts/request-tracker4/upgrade/pgsql/4.2.3:</p>
<p class="MsoNormal">/usr/share/dbconfig-common/scripts/request-tracker4/upgrade/pgsql/4.2.3
exited with non-zero status</p><p class="MsoNormal"><br></p><p class="MsoNormal">There could be an issue with the Debian packages (they are still in the testing branch), but I'm trying to figure out what state the database is in now. The system is working fine, and shows version 4.2.3. If I navigate to Admin -> Tools -> System Configuration, then in the "RT Upgrade History" section it looks like it might have tried to upgrade the database twice, and the second time it failed (understandably).</p>
<p class="MsoNormal"><br></p><p class="MsoNormal">Is there a way I can verify that the database schema is completely up to date? </p><p class="MsoNormal"><br></p><p class="MsoNormal">Here is what the "RT Upgrade History" section shows: (Sorry for the HTML, wasn't sure how else to show it)</p>
<h4 style="color:rgb(0,0,0);font-family:arial,helvetica,sans-serif;font-size:13px;line-height:16.003000259399414px">RT (Current version: 4.2.3)</h4><table border="0" cellspacing="0" cellpadding="5" width="100%" class="" style="font-size:13px;color:rgb(0,0,0);font-family:arial,helvetica,sans-serif;line-height:16.003000259399414px">
<thead><tr class=""><th class="" style="padding-right:0.5em;padding-left:1em"> </th><th class="" style="padding-right:0.5em">Action</th><th class="" style="padding-right:0.5em">Date</th><th class="" style="padding-right:0.5em">
Elapsed</th><th class="" style="padding-right:0.5em">RT Version</th></tr></thead><tbody><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)">
<td class="" id="parent-upgrade-history-4772257b-a8d8-4389-aaf7-9b74acc91fb5" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:1em"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:0em">
Insert from /usr/share/request-tracker4/etc/upgrade/4.0.9/content</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">Tue May 20 23:17:45 2014</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">1 second</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)"><td class="" id="parent-upgrade-history-49db66bc-841f-48e0-b1b9-41556396e519" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:1em">
</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:0em">Insert from /usr/share/request-tracker4/etc/upgrade/4.0.18/content</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">Tue May 20 23:17:53 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">
1 second</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)">
<td class="" id="parent-upgrade-history-17cb4848-e989-42cc-89bb-0d8b50d25ad3" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:1em"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:0em">
Insert from /usr/share/request-tracker4/etc/upgrade/4.0.19/content</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">Tue May 20 23:17:55 2014</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">0 seconds</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)"><td class="" id="parent-upgrade-history-767c73cb-2526-4dcf-a4dd-ed6cc18fb267" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:1em">
<span class=""><a href="http://rt/Admin/Tools/Configuration.html#" class="" style="color:rgb(102,102,102);text-decoration:none;display:block;margin:0px;width:20px;background-image:url(http://rt/static/images/css/rolldown-arrow.gif);padding:7px 0px 0px;overflow:hidden;background-repeat:no-repeat no-repeat"></a></span></td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:0em">Upgrade from 4.0.19 to 4.2.3</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">Tue May 20 23:17:56 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">
2 minutes</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)">
<td class="" id="parent-upgrade-history-b295a057-427f-4be8-9d63-df76049a7ab8" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:1em">
</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:0em">Insert from /usr/share/request-tracker4/etc/upgrade/4.0.9/content</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">Tue May 20 23:19:29 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">
0 seconds</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)">
<td class="" id="parent-upgrade-history-2a1aecf7-9e21-4eaf-a998-147bf05055f4" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:1em"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:0em">
Insert from /usr/share/request-tracker4/etc/upgrade/4.0.18/content</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">Tue May 20 23:19:34 2014</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">0 seconds</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)"><td class="" id="parent-upgrade-history-6bfc8347-eeb8-4faf-b69c-d8145a7b9e24" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:1em">
</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:0em">Insert from /usr/share/request-tracker4/etc/upgrade/4.0.19/content</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">Tue May 20 23:19:35 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">
0 seconds</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);font-weight:bold;color:rgb(153,0,0)">
<td class="" id="parent-upgrade-history-5a5bd15a-e225-4f42-962e-534baaaa1225" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:1em"><span class=""><a href="http://rt/Admin/Tools/Configuration.html#" style="color:rgb(102,102,102);text-decoration:none;display:block;margin:0px;width:20px;background-image:url(http://rt/static/images/css/rollup-arrow.gif);padding:7px 0px 0px;overflow:hidden;background-repeat:no-repeat no-repeat"></a></span></td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:0em">Upgrade from 4.0.19 to 4.2.3 (Incomplete)</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
Tue May 20 23:19:36 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)"><td class="" id="parent-upgrade-history-f3e4fa16-aa74-4f20-a25e-04548bfa0318" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:1em">
</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:3em">Upgrade from 4.0.19 to 4.1.0</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">Tue May 20 23:19:36 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">
0 seconds</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204)">
<td class="" id="parent-upgrade-history-7a059678-ad71-4dbf-8a5d-932d9c2ce491" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:1em"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:6em">
Insert from /usr/share/request-tracker4/etc/upgrade/4.1.0/content</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">Tue May 20 23:19:36 2014</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">0 seconds</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);font-weight:bold;color:rgb(153,0,0)">
<td class="" id="parent-upgrade-history-4fa80723-9a86-4674-a93e-1786e1060792" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:1em">
</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238);padding-left:3em">Upgrade from 4.1.0 to 4.1.1 (Incomplete)</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">Tue May 20 23:19:36 2014</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">
</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);background-color:rgb(238,238,238)">4.2.3</td></tr><tr class="" style="border-left-width:1px;border-left-style:solid;border-left-color:rgb(204,204,204);border-right-width:1px;border-right-style:solid;border-right-color:rgb(204,204,204);font-weight:bold;color:rgb(153,0,0)">
<td class="" id="parent-upgrade-history-f9c3ae71-7e82-4925-8fe3-72ef4dc8f515" style="padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:1em"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204);padding-left:6em">
Schema updates from /usr/share/request-tracker4/etc/upgrade/4.1.1 (Incomplete)</td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">Tue May 20 23:19:36 2014</td>
<td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)"></td><td class="" style="padding-right:0.5em;padding-top:0.5em;border-top-width:1px;border-top-style:solid;border-top-color:rgb(204,204,204)">
4.2.3</td></tr></tbody></table><br></div><div>Thanks,</div><div>Nate</div></div>