CiviCRM Community Forums (archive)

I have installed CiviCRM 2.2.2 on Joomla! 1.5.10 without error and have been working with it for about two weeks now. Today, I went to edit a individual record and got the following error:

Sorry. A non-recoverable error has occurred.
DB Error: unknown error
Database Error Code: Out of memory (Needed 8388580 bytes), 5
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] => (  SELECT count(DISTINCT civicrm_relationship.id) as cnt1, 0 as cnt2  FROM civicrm_relationship, civicrm_relationship_type, civicrm_contact                       
                        LEFT OUTER JOIN civicrm_address ON (civicrm_address.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1)
                        LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_b = 242 AND civicrm_relationship.contact_id_a = civicrm_contact.id  ) UNION (  SELECT 0 as cnt1, count(DISTINCT civicrm_relationship.id) as cnt2  FROM civicrm_relationship, civicrm_relationship_type, civicrm_contact                       
                        LEFT OUTER JOIN civicrm_address ON (civicrm_address.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1)
                        LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_a = 242 AND civicrm_relationship.contact_id_b = civicrm_contact.id  )  [nativecode=5 ** Out of memory (Needed 8388580 bytes)]
    [type] => DB_Error
    [user_info] => (  SELECT count(DISTINCT civicrm_relationship.id) as cnt1, 0 as cnt2  FROM civicrm_relationship, civicrm_relationship_type, civicrm_contact                       
                        LEFT OUTER JOIN civicrm_address ON (civicrm_address.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1)
                        LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_b = 242 AND civicrm_relationship.contact_id_a = civicrm_contact.id  ) UNION (  SELECT 0 as cnt1, count(DISTINCT civicrm_relationship.id) as cnt2  FROM civicrm_relationship, civicrm_relationship_type, civicrm_contact                       
                        LEFT OUTER JOIN civicrm_address ON (civicrm_address.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1)
                        LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_a = 242 AND civicrm_relationship.contact_id_b = civicrm_contact.id  )  [nativecode=5 ** Out of memory (Needed 8388580 bytes)]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="(  SELECT count(DISTINCT civicrm_relationship.id) as cnt1, 0 as cnt2  FROM civicrm_relationship, civicrm_relationship_type, civicrm_contact                       
                        LEFT OUTER JOIN civicrm_address ON (civicrm_address.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1)
                        LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_b = 242 AND civicrm_relationship.contact_id_a = civicrm_contact.id  ) UNION (  SELECT 0 as cnt1, count(DISTINCT civicrm_relationship.id) as cnt2  FROM civicrm_relationship, civicrm_relationship_type, civicrm_contact                       
                        LEFT OUTER JOIN civicrm_address ON (civicrm_address.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_phone ON (civicrm_phone.contact_id = civicrm_contact.id AND civicrm_phone.is_primary = 1)
                        LEFT JOIN civicrm_email ON (civicrm_email.contact_id = civicrm_contact.id )
                        LEFT OUTER JOIN civicrm_state_province ON (civicrm_address.state_province_id = civicrm_state_province.id)
                        LEFT OUTER JOIN civicrm_country ON (civicrm_address.country_id = civicrm_country.id)  WHERE civicrm_relationship.relationship_type_id = civicrm_relationship_type.id  AND civicrm_relationship.contact_id_a = 242 AND civicrm_relationship.contact_id_b = civicrm_contact.id  )  [nativecode=5 ** Out of memory (Needed 8388580 bytes)]"]

phpinfo validates memory is set to 128M. Any ideas what's going on here?  It was working just fine until today...

Thanks![/code]