CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site
This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn
Pages: [1]

Author Topic: Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn  (Read 653 times)

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn
April 18, 2013, 01:50:31 pm
Upgrading from 4.2.9 to 4.3.0 (or 4.3.1) my upgrade hangs during the 4.3.0 alpha 1 upgrade:

Executed: Check/Add indexes for civicrm_entity_financial_trxn.

Any ideas? Where to start debugging?

Brian

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn
April 18, 2013, 02:40:10 pm
Some of those queries run a *long* time. If you're using the web interface to upgrade, you may be hitting the maximum time a PHP script can run over HTTP. (This is configurable on most hosting environments - and the upgrader likely tries to do this - but maybe not successfully for your setup.)

I run upgrades from Drush, because using the CLI to trigger the upgrade avoids the timeout issue entirely (and is more scriptable, allowing tasks to be run before and after upgrade). If you can do the upgrade that way, you might have more success.

Monitoring MySQL queries during the upgrade gives an indication of progress - you might find that informative. (
Code: [Select]
mytop is a simple tool to monitor MySQL queries.)
@xurizaemon ● www.fuzion.co.nz

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn
April 18, 2013, 05:09:57 pm
Thanks grobot. I've disabled the maximum PHP script time manually, and viewing MySQL queries, I can see that as you mention, it isn't hanging - just some very long query's.

I'm going to leave it running for a while and see what happens. I've never used drush before, but maybe time to look into it as well.

Brian

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn
April 18, 2013, 05:15:44 pm
While it's running, and you're wondering, you might try a MySQL EXPLAIN on your query, and see if there's a way to improve the speed of the upgrader ...
@xurizaemon ● www.fuzion.co.nz

bpmccain

  • I post frequently
  • ***
  • Posts: 255
  • Karma: 5
  • CiviCRM version: 4.1
  • CMS version: Drupal 7.12
  • MySQL version: 5.2
  • PHP version: 5.2
Re: Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn
April 18, 2013, 05:45:15 pm
Upgrade complete. Took about 40 minutes.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Upgrade to 4.3.0 Hangs at "Check/Add indexes for civicrm_entity_financial_trxn

This forum was archived on 2017-11-26.