Author Topic: Problem upgrading from 2.2.2 to 3.0.2 (Read 1354 times)

samw3 · November 29, 2009, 11:12:31 am

No errors are returned. The browser spins endlessly (let it run overnight ~8hrs). When I do a "top" command from ssh there is no process activity after about 20mins.

I've checked apache error logs, mysql error logs and the CiviCRM.log file and none have any information for the current date (checked the server's date too).

It's really frustrating.. seems like the process just vanishes.

I've set the session and execution timeouts to practically infinite and have retried the process several times with the same result each time.

Our database is large with ~250,000 contacts and ~127,000 contributions.

Please help me track this down. I don't know where to go from here.

Thanks.

Donald Lobo · November 30, 2009, 12:23:14 pm

hey sam:

i would do the following:

1. enable mysql query log and check the progress of the upgrade via the log

2. most likely due to the size of your db, there are one (or more) bad upgrade queries which cause the process to go in a loop. Alternatively there could be some inconsistent data in your db

3. if you dont make too much progress with the above, please put your db in a location where we can pick it up and figure out whats happening. Please use this as a last alternative!

Would also be great if you could write up a case study of what you are using CiviCRM for, since you have a fairly good sized db

lobo

samw3 · November 30, 2009, 11:05:20 pm

Thanks for the pointers, Lobo! No progress, but at least something to look at now

Here are the last few queries before it crashes. Any ideas?

Thanks,

Sam

P.S. I've sent your request for a case study along to my client; the owner of the company and this data.

Code: [Select]

                     24 Init DB     supporx4_jml01
                     24 Query       UPDATE civicrm_contact
        SET
            addressee_display = household_name,
            addressee_id      = @value
    WHERE  contact_type      = 'Household'
                     24 Init DB     supporx4_jml01
                     24 Query       SELECT @value := value
    FROM civicrm_option_value
        WHERE civicrm_option_value.option_group_id = @og_id_addressee
            AND civicrm_option_value.filter        = 3
            AND civicrm_option_value.is_default    = 1
                     24 Init DB     supporx4_jml01
                     24 Query       UPDATE civicrm_contact
        SET
            addressee_display = organization_name,
           addressee_id      = @value
    WHERE  contact_type      = 'Organization'
                     24 Init DB     supporx4_jml01
                     24 Query       -- 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`
                     24 Query       select 1
                     24 Quit

Sunil · December 01, 2009, 01:30:42 am

Hi Sam,

Quote

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

Before Upgrade can you check the Foreign keys are present for civicrm_group_organization table in your Database.
If foreign keys are absent then remove the Quoted SQL from CRM/Upgrade/Incremental/sql/3.0.alpha1.mysql.tpl file (around line no. 808)
and then try the upgrade.

Sunil

CiviCRM Community Forums (archive)

News:

Author Topic: Problem upgrading from 2.2.2 to 3.0.2 (Read 1354 times)

samw3

Problem upgrading from 2.2.2 to 3.0.2

Donald Lobo

Re: Problem upgrading from 2.2.2 to 3.0.2

samw3

Re: Problem upgrading from 2.2.2 to 3.0.2

Sunil

Re: Problem upgrading from 2.2.2 to 3.0.2