Answers.Body: <p>Answer was patience - upgrade took 45 minutes.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-07T21:49:03.960Z
Answers.LastActivityDate: 2016-04-07T21:49:03.960Z
Answers.UserDisplayName: Robin Fenwick
Answers.Body: <p>Some upgrades can take a long time and do not die just because the screen isn't showing progress. </p>
  
  <p>Sometimes you can better see how things are going by copying the url and pasting in a new window and you may see progress on the new screen. </p>
  
  <p>Also you can check in the civicrm_domain table which will show you where it is at. </p>
  
  <p>Patience is often the issue here.</p>
  
  <p>And as Robin added "using the SQL command SHOW FULL PROCESSLIST I can see it is in fact whirring away doing a number of database structural changes, which is necessitating some very large tables to be copied to temporary tables"</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-20T21:39:57.597Z
Answers.Text: I followed you process here but not showing any activity for the above command. Result:Id     | User             | Host      | db                  | Command | Time | State | Info                  |
  +--------+------------------+-----------+---------------------+---------+------+-------+-----------------------+
  | 799758 | db_user | localhost | _newjoomla3x | Query   |    0 | NULL  | SHOW FULL PROCESSLIST
Answers.UserDisplayName: BruceW
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-20T22:01:10.707Z
Answers.Text: Also, MYTOP doesn't show any activity.                                                                                    
  
  MySQL on localhost (5.5.48-cll)                                                                                                                                up 25+21:38:27 [15:01:57]
   Queries: 440.0  qps:    0 Slow:     0.0         Se/In/Up/De(%):    2585933/00/00/00 
               qps now:    0 Slow qps: 0.0  Threads:    1 (   1/  35) 00/00/00/00 
   Key Efficiency: 100.0%  Bps in/out:   0.0/  0.9   Now in/out:   8.3/ 1.7k
Answers.UserDisplayName: BruceW
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-20T22:03:08.230Z
Answers.Text: Id      User         Host/IP         DB      Time    Cmd Query or State                                                                                                           
        --      ----         -------         --      ----    --- ----------                                                                                                               
    799853 alcohol_a       localhost alcohol_ne         0  Query show full processlist
Answers.UserDisplayName: BruceW
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-20T23:17:40.163Z
Answers.Text: hi . can't comment as that was a suggestion by Robin.
Answers.UserDisplayName: petednz - fuzion
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-07T23:32:50.510Z
Answers.LastActivityDate: 2016-04-07T23:32:50.510Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>We're on 4.7.3 on Drupal 7, and are being affected by some bugs that affect contributions made on behalf of an organisation and paid for by paypal.</p>
  
  <p>When I attempt the upgrade to 4.7.5, the upgrade script says it has updated to 4.7.4 without problems, but then hangs on Begin upgrade to 4.7.5 message</p>
  
  <p>See: <a href="https://i.sstatic.net/iBFkQ.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/iBFkQ.png" alt="Error"></a> </p>
  
  <p>I left it for 5 minutes (the php max runtime was set to 3 minutes) and then hit refresh, it emptied - no text or progress.  Re-opening the upgrade script then says it failed the integrity check. I've rolled back to a backup for now.</p>
  
  <p>There is no error in the HTTP error log, nothing seems to have run out of memory.</p>
  
  <p>I'd be grateful for any help in how to set about diagnosing this issue!</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-04-07T18:31:35.507Z
Comments.Text: Hi Robin. we have nursed upgrades through that have taken hours. Could you retry but leave the upgrade running for a lot longer? If you need to it can be helpful to copy the url and paste in a new window and you may see progress on that screen. Also checking in the civicrm_domain table will show you were it is at. But it may be that patience is the issue here.
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-04-07T21:38:58.070Z
Comments.Text: Thank you @petednz-fuzion I think you are right - using the SQL command SHOW FULL PROCESSLIST I can see it is in fact whirring away doing a number of database structural changes, which is necessitating some very large tables to be copied to temporary tables. I will leave it overnight and cross everything!
Comments.UserDisplayName: Robin Fenwick
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-04-07T23:33:33.637Z
Comments.Text: k - great to hear. i rewrote the above as an answer that might help others but good that you added your own ;-)
Comments.UserDisplayName: petednz - fuzion
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2016-04-07T23:36:17.030Z
Comments.Text: i tried to find a Title for this that might be more generically useful. by all means change it again if you can improve it
Comments.UserDisplayName: petednz - fuzion
Tags: <upgrade><error>
Title: Is my upgrade failing if the screen appears to hang
ThreadText: # Is my upgrade failing if the screen appears to hang
  
  (Asked by: username_0 on 2016-04-07)
  
  We're on 4.7.3 on Drupal 7, and are being affected by some bugs that affect contributions made on behalf of an organisation and paid for by paypal.
  
  When I attempt the upgrade to 4.7.5, the upgrade script says it has updated to 4.7.4 without problems, but then hangs on Begin upgrade to 4.7.5 message
  
  See: [![Error](https://i.sstatic.net/iBFkQ.png)](https://i.sstatic.net/iBFkQ.png)
  
  I left it for 5 minutes (the php max runtime was set to 3 minutes) and then hit refresh, it emptied - no text or progress. Re-opening the upgrade script then says it failed the integrity check. I've rolled back to a backup for now.
  
  There is no error in the HTTP error log, nothing seems to have run out of memory.
  
  I'd be grateful for any help in how to set about diagnosing this issue!
  
  **Tags:** upgrade, error
  
  > **Comments:**
  > **username_1**: Hi username_0. we have nursed upgrades through that have taken hours. Could you retry but leave the upgrade running for a lot longer? If you need to it can be helpful to copy the url and paste in a new window and you may see progress on that screen. Also checking in the civicrm_domain table will show you were it is at. But it may be that patience is the issue here.  
  > **username_0**: Thank you @username_1 I think you are right - using the SQL command SHOW FULL PROCESSLIST I can see it is in fact whirring away doing a number of database structural changes, which is necessitating some very large tables to be copied to temporary tables. I will leave it overnight and cross everything!  
  > **username_1**: k - great to hear. i rewrote the above as an answer that might help others but good that you added your own ;-)  
  > **username_1**: i tried to find a Title for this that might be more generically useful. by all means change it again if you can improve it  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-04-07. Score: 3 | Accepted answer
  
  Some upgrades can take a long time and do not die just because the screen isn't showing progress.
  
  Sometimes you can better see how things are going by copying the url and pasting in a new window and you may see progress on the new screen.
  
  Also you can check in the civicrm\_domain table which will show you where it is at.
  
  Patience is often the issue here.
  
  And as username_0 added "using the SQL command SHOW FULL PROCESSLIST I can see it is in fact whirring away doing a number of database structural changes, which is necessitating some very large tables to be copied to temporary tables"
  
  > **Comments:**
  > **username_2**: I followed you process here but not showing any activity for the above command. Result:Id     | User             | Host      | db                  | Command | Time | State | Info                  | +--------+------------------+-----------+---------------------+---------+------+-------+-----------------------+ | 799758 | db_user | localhost | _newjoomla3x | Query   |    0 | NULL  | SHOW FULL PROCESSLIST  
  > **username_2**: Also, MYTOP doesn't show any activity.                                                                                      MySQL on localhost (5.5.48-cll)                                                                                                                                up 25+21:38:27 [15:01:57]  Queries: 440.0  qps:    0 Slow:     0.0         Se/In/Up/De(%):    2585933/00/00/00               qps now:    0 Slow qps: 0.0  Threads:    1 (   1/  35) 00/00/00/00   Key Efficiency: 100.0%  Bps in/out:   0.0/  0.9   Now in/out:   8.3/ 1.7k  
  > **username_2**: Id      User         Host/IP         DB      Time    Cmd Query or State                                                                                                                  --      ----         -------         --      ----    --- ----------                                                                                                                  799853 alcohol_a       localhost alcohol_ne         0  Query show full processlist  
  > **username_1**: hi . can't comment as that was a suggestion by username_0.  
  
  ---
  
  ### Answer by username_0 on 2016-04-07. Score: 4
  
  Answer was patience - upgrade took 45 minutes.
  
  
  ---
  
  