Failed Upgrade v2.2.8 to v3.0 - Fatal Error /PEAR.php & DB Error: unknown error

[andrewg]

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]

[andrewg]

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]

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]

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.

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.

[andrewg]

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]

Hi,

With regards to this:

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]

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.

[Dave Greenberg]

Link to Database Utility tools has been fixed (FYI).

[andrewg]

Hi Deepak,

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

What next?

Cheers,


Andrew

[andrewg]

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]

Link to attachment within the document text was mis-formatted. Fixed now.

[andrewg]

Hi,

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]

please help.... I have a duplicate test site configured and presenting this issue currently... Anyone keen to have a look?

[Deepak Srivastava]

andrew, can you jump on irc and we can have a look.

[andrewg]

Hi, when should we meet on IRC? It is now 11:05pm in New Zealand... Shall we do it on Wednesday sometime?

Cheers, Andrew