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) »
  • Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
Pages: [1] 2

Author Topic: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error  (Read 5986 times)

andrewg

  • Guest
Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 04, 2009, 01:25:22 pm
I tried to do the upgrade from v2.2.8 to v3.0 and got the following error message:

Fatal error: Out of memory (allocated 176422912) (tried to allocate 35 bytes) in /home/motutapu/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php on line 872

I initially got the errors relating to the Database with regards to this:

 ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id`

see full error below:
Code: [Select]
Sorry. A non-recoverable error has occurred.
________________________________________
DB Error: unknown error
Database Error Code: Error on rename of './motutapu_motu/civicrm_group_organization' to './motutapu_motu/#sql2-3fe5-105e95' (errno: 152), 1025
Return to home page.
Error Details:
Array
(
    [callback] => Array
        (
            [0] => CRM_Core_Error
            [1] => handle
        )

    [code] => -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => -- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './motutapu_motu/civicrm_group_organization' to './motutapu_motu/#sql2-3fe5-105e95' (errno: 152)]
    [type] => DB_Error
    [user_info] => -- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './motutapu_motu/civicrm_group_organization' to './motutapu_motu/#sql2-3fe5-105e95' (errno: 152)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="-- CRM-4610
    ALTER TABLE `civicrm_group_organization`
        DROP FOREIGN KEY `FK_civicrm_group_organization_group_id`,
        DROP FOREIGN KEY `FK_civicrm_group_organization_organization_id` [nativecode=1025 ** Error on rename of './motutapu_motu/civicrm_group_organization' to './motutapu_motu/#sql2-3fe5-105e95' (errno: 152)]"]
)

after which I tried to do it mannually as per Lobo's comments in this post, http://forum.civicrm.org/index.php/topic,10141.0.html.

It is only after that which I received the error I have now:

Fatal error: Out of memory (allocated 176422912) (tried to allocate 35 bytes) in /home/motutapu/public_html/administrator/components/com_civicrm/civicrm/packages/PEAR.php on line 872

Any ideas on how to get this fixed?

I have already checked php memory allocation (currently set to 256M) and everything else I could find in the forum...

Please assist... It would be appreciated.

Cheers,


Andrew
[/code]
« Last Edit: October 04, 2009, 07:53:20 pm by andrewg »

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 04, 2009, 03:54:11 pm
Also wanted to try the Civi Database Utility, but it seems to have disappeared...

http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools

the link does not go to the file...

cheers,

Andrew

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 04, 2009, 09:40:24 pm
Hi,

Got this once again:

Code: [Select]
Fatal error: Out of memory (allocated 176422912) (tried to allocate 41 bytes) in /home/motutapu/public_html/testsite/administrator/components/com_civicrm/civicrm/packages/PEAR.php on line 872
Tried again from scratch, as follows:

Fixed site
Cloned Site
Upgraded site successfully from 2.2.7 to 2.2.9
Tried upgrade again to 3.0.0
Failed - Unsuccessful

Please help...

Cheers,


Andrew

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown er
October 04, 2009, 11:26:06 pm
Quote
Fatal error: Out of memory (allocated 176422912) (tried to allocate 41 bytes) in /home/motutapu/public_html/testsite/administrator/components/com_civicrm/civicrm/packages/PEAR.php on line 872
At what step of the doc you get this error ? - http://wiki.civicrm.org/confluence/display/CRMDOC/Upgrade+Joomla+Sites+to+3.0
Most likely civicrm can't find the database. Check your apache logs.

Quote
Database Error Code: Error on rename of './motutapu_motu/civicrm_group_organization' to './motutapu_motu/#sql2-3fe5-105e95' (errno: 152), 1025
W.r.t foreign key failures you can get away by adding the foreign keys, But a suggested solution would be to rebuilding your schema for 2.2 database. Refer this doc on how to do it - http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades. Please note this requires some sql knowledge.
« Last Edit: October 05, 2009, 02:10:32 am by Deepak Srivastava »
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 02:00:48 am
Hi I get the "Fatal Error" at Step 4 of the Upgrade Process... (4. Run the Database Upgrade script).

Will check rebuilding our schema for 2.2 database and see if that works...

This issue is only happening with the v3.0.0 upgrade not with any of the others...

cheers,


Andrew

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 02:18:49 am
Hi,

With regards to this:

Quote
Database Error Code: Error on rename of './motutapu_motu/civicrm_group_organization' to './motutapu_motu/#sql2-3fe5-105e95' (errno: 152), 1025
W.r.t foreign key failures you can get away by adding the foreign keys, But a suggested solution would be to rebuilding your schema for 2.2 database. Refer this doc on how to it - http://wiki.civicrm.org/confluence/display/CRMDOC/Ensuring+Schema+Integrity+on+Upgrades. Please note this requires some sql knowledge.

I don't have this error anymore, it is only this one I still have:

Code: [Select]
Fatal error: Out of memory (allocated 176422912) (tried to allocate 16 bytes) in /home/motutapu/public_html/testsite/administrator/components/com_civicrm/civicrm/packages/PEAR.php on line 872
Cheers,


Andrew


Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown er
October 05, 2009, 02:44:09 am
Check your civicrm settings file. Is the civicrm database set to old one or changed or not present ?
Also check (at this point) if your civicrm database has all the records/tables.
« Last Edit: October 05, 2009, 02:46:49 am by Deepak Srivastava »
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 12:15:04 pm
Link to Database Utility tools has been fixed (FYI).
Protect your investment in CiviCRM by  becoming a Member!

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 03:36:00 pm
Hi Deepak,

All seems fine with the civicrm.settings.php file. And database also looks fine...

What next?

Cheers,


Andrew

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 04:31:21 pm
Database utility tool link still broken:

http://wiki.civicrm.org/confluence/download/attachments/14452230/civicrm_dbtools-1.1.4.tar.gz


http://wiki.civicrm.org/confluence/display/CRMDOC/Database+Troubleshooting+Tools

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 06:15:17 pm
Link to attachment within the document text was mis-formatted. Fixed now.
Protect your investment in CiviCRM by  becoming a Member!

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 06:58:30 pm
Hi,

Quote
Check your civicrm settings file. Is the civicrm database set to old one or changed or not present ?
Also check (at this point) if your civicrm database has all the records/tables.

All seems fine with the civicrm.settings.php file. And database also looks fine...

What next?

Cheers,


Andrew

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 05, 2009, 09:33:02 pm
please help.... I have a duplicate test site configured and presenting this issue currently... Anyone keen to have a look?

Deepak Srivastava

  • Moderator
  • Ask me questions
  • *****
  • Posts: 677
  • Karma: 65
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown er
October 05, 2009, 10:49:51 pm
andrew, can you jump on irc and we can have a look.
Found this reply helpful? Contribute NOW and help us improve CiviCRM with the Make it Happen! initiative.

andrewg

  • Guest
Re: Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error
October 06, 2009, 03:05:53 am
Hi, when should we meet on IRC? It is now 11:05pm in New Zealand... Shall we do it on Wednesday sometime?

Cheers, Andrew
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Upgrading CiviCRM (Moderator: Deepak Srivastava) »
  • Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error

This forum was archived on 2017-11-26.