Upgrade from 4.1.5 to 4.2.beta5 under D7 fails on civicrm_contribution_page FK

[sonicthoughts]

Cross post at Totten's suggestion from:http://forum.civicrm.org/index.php?topic=25536.new;topicseen#new
 failed SQL statement:

ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id`
Single Drupal 7.14 DB and civicrm 4.15
WAMP
PHP 5.3.15
MYSQL 5.5.21


I didn't clear template files prior to upgrade but did clear the cache. 
This was a FIRST attempt to go to 4.2 (so no left over tables)
UI is a bit strange (i think it's my theme, skip/retry are off the page.
will try w/drush soon.
[Error: Upgrade DB to 4.2.alpha1: SQL]
DB Error: unknown error
#0 [internal function]: CRM_Core_Error::exceptionHandler(Object(DB_Error))
#1 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php(931): call_user_func(Array, Object(DB_Error))
#2 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB.php(968): PEAR_Error->PEAR_Error('DB Error: unkno...', -1, 16, Array, 'ALTER TABLE `ci...')
#3 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php(564): DB_Error->DB_Error(-1, 16, Array, 'ALTER TABLE `ci...')
#4 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php(1903): PEAR->raiseError(NULL, -1, NULL, NULL, 'ALTER TABLE `ci...', 'DB_Error', true)
#5 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php(898): DB_common->raiseError(-1, NULL, NULL, NULL, '1025 ** Error o...')
#6 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php(327): DB_mysql->mysqlRaiseError()
#7 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php(1216): DB_mysql->simpleQuery('ALTER TABLE `ci...')
#8 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Utils\File.php(285): DB_common->query('ALTER TABLE `ci...')
#9 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php(152): CRM_Utils_File->sourceSQLFile('mysql://drupalu...', '?  ?  SELECT @w...', NULL, true)
#10 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php(292): CRM_Upgrade_Form->source('?  ?  SELECT @w...', true)
#11 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php(316): CRM_Upgrade_Form->processLocales('G:\Users\Shawn\...', '4.2.alpha1')
#12 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourTwo.php(274): CRM_Upgrade_Form->processSQL('4.2.alpha1')
#13 [internal function]: CRM_Upgrade_Incremental_php_FourTwo::task_4_2_alpha1_runSql(Object(CRM_Queue_TaskContext), '4.2.alpha1')
#14 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Task.php(79): call_user_func_array(Array, Array)
#15 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Runner.php(173): CRM_Queue_Task->run(Object(CRM_Queue_TaskContext))
#16 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(44): CRM_Queue_Runner->runNext(true)
#17 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\ErrorPolicy.php(80): {closure}()
#18 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Page\AJAX.php(51): CRM_Queue_ErrorPolicy->call(Object(Closure))
#19 [internal function]: CRM_Queue_Page_AJAX::runNext(Array)
#20 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Core\Invoke.php(186): call_user_func(Array, Array)
#21 G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\drupal\civicrm.module(497): CRM_Core_Invoke::invoke(Array)
#22 [internal function]: civicrm_invoke('upgrade', 'queue', 'ajax', 'runNext')
#23 G:\Users\Shawn\Documents\drupal\shawntest\includes\menu.inc(516): call_user_func_array('civicrm_invoke', Array)
#24 G:\Users\Shawn\Documents\drupal\shawntest\index.php(21): menu_execute_active_handler()
#25 {main}

After I restored database and Drush upgrade also failed (after restore of fresh 4.1.5).  Note that I have been testing some views.  could this be related to recent change: http://issues.civicrm.org/jira/browse/CRM-10634?
$ drush cvupdb
file_get_contents(): Filename cannot be empty Form.php:554                                                                                                                                     [warning]

file_put_contents(): Filename cannot be empty Form.php:556                                                                                                                                     [warning]

<p>backTrace</p><p><pre>G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Core\Error.php, backtrace, 148
, handle,
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php, call_user_func, 931
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB.php, PEAR_Error, 968
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\PEAR.php, DB_Error, 564
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php, raiseError, 1903
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php, raiseError, 898
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\mysql.php, mysqlRaiseError, 327
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\packages\DB\common.php, simpleQuery, 1216
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Utils\File.php, query, 285
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, sourceSQLFile, 152
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, source, 292
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Form.php, processLocales, 316
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Incremental\php\FourTwo.php, processSQL, 274
, task_4_2_alpha1_runSql,
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Task.php, call_user_func_array, 79
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Runner.php, run, 173
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Queue\Runner.php, runNext, 136
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\CRM\Upgrade\Headless.php, runAll, 58
G:\Users\Shawn\Documents\drupal\shawntest\sites\all\modules\civicrm\drupal\drush\civicrm.drush.inc, run, 499
, drush_civicrm_upgrade_db,
K:\ProgramData\Drush\includes\command.inc, call_user_func_array, 324
K:\ProgramData\Drush\includes\command.inc, _drush_invoke_hooks, 198
, drush_command,
K:\ProgramData\Drush\includes\command.inc, call_user_func_array, 165
K:\ProgramData\Drush\drush.php, drush_dispatch, 90
K:\ProgramData\Drush\drush.php, _drush_bootstrap_and_dispatch, 59
K:\ProgramData\Drush\drush.php, drush_main, 14</pre></p><p></p><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
  <title></title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <base href="http://shofar1.localhost:8084/sites/all/modules/civicrm/" />
  <style type="text/css" media="screen">@import url(http://shofar1.localhost:8084/sites/all/modules/civicrm/css/civicrm.css);</style>
  <style type="text/css" media="screen">@import url(http://shofar1.localhost:8084/sites/all/modules/civicrm/css/extras.css);</style>
</head>
<body>
<div id="crm-container" lang="en" xml:lang="en">
<div class="messages status">  <div class="icon red-icon alert-icon"></div>
 <span class="status-fatal">Sorry but we are not able to provide this at the moment.</span>
    <div class="crm-section crm-error-message"></div>
            <hr style="solid 1px" />
        <div class="crm-section crm-error-message">DB Error: unknown error</div>
                <div class="crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block" onclick="toggle(this);";>
         <div class="crm-accordion-header">
          <div class="icon crm-accordion-pointer"></div>
                Error Details         </div><!-- /.crm-accordion-header -->
         <div class="crm-accordion-body">
                                        <div class="crm-section">Database Error Code: Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152), 1025</div>
                                        <div class="crm-section">Additional Details: <p><pre>Array
(
    [callback] =&gt; Array
        (
           
=&gt; CRM_Core_Error
[1] =&gt; handle
        )
 =&gt; -1
    [message] =&gt; DB Error: unknown error
    [mode] =&gt; 16
    [debug_info] =&gt; ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id` [nativecode=1025 ** Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152)]
    [type] =&gt; DB_Error
    [user_info] =&gt; ALTER TABLE `civicrm_contribution_page`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id` [nativecode=1025 ** Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152)]
    [to_string] =&gt; [db_error: message=&quot;DB Error: unknown error&quot; code=-1 mode=callback callback=CRM_Core_Error::handle prefix=&quot;&quot; info=&quot;ALTER TABLE `civicrm_contribution_page
`
  DROP FOREIGN KEY `FK_civicrm_contribution_page_payment_processor_id` [nativecode=1025 ** Error on rename of '.\shofar2\civicrm_contribution_page' to '.\shofar2\#sql2-1818-596' (errno: 152)]&quot;]
)
</pre></p><p></p></div>
                     </div><!-- /.crm-accordion-body -->
        </div><!-- /.crm-accordion-wrapper -->
        <p><a href="http://shofar1.localhost:8084/" title="Main Menu">Return to home page.</a></p>
</div>
</div>
<script language="JavaScript">
function toggle( element ) {
    var className = element.className;
    if ( className  == 'crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block') {
        element.className = 'crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-open crm-fatal-error-details-block';
    } else {
        element.className = 'crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block';
    }
}
</script>

</body>
</html>
Drush command terminated abnormally due to an unrecoverable error.                                                                                                                               [error]

[Deepak Srivastava]

Not sure why would that FK be missing, but given that there aren't too many FK drops would be good for upgrades to make sure they exist before dropping. Filed an issue here - http://issues.civicrm.org/jira/browse/CRM-10657.

[sonicthoughts]

note that this install didn't have any contribution pages.