CiviCRM Community Forums (archive)

First time I try to invoke the relationship report, or if I haven't been using CiviCRM for a while ( > 15 minutes) I get an error message. If I immediately do it again, no error and I see every relationship in the system (5054 records, which doesn't seem excessive to me.) Perhaps the report should not launch before criteria are set? System information at bottom of post.

If this is not the correct way to post about an error, please point me in the right direction.

Procedure:
Click on "Reports"
Click on "Relationships Report"

Error:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">

<head>
  <title>Relationship Report</title>
  <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  <base href="/administrator/components/com_civicrm/civicrm/" />
  <style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/civicrm.css);</style>
  <style type="text/css" media="screen">@import url(/administrator/components/com_civicrm/civicrm/css/extras.css);</style>
</head>

<body>

<div id="crm-container" lang="en" xml:lang="en">

<div class="messages status">
  <dl>
  <dt><img src="/administrator/components/com_civicrm/civicrm/i/Error.gif" alt="unrecoverable error" /></dt>
  <dd>
      Sorry. A non-recoverable error has occurred.      <p></p>
    <hr style="solid 1px" />
    <p>DB Error: unknown error</p>
      <p>Database Error Code: Server shutdown in progress, 1053</p>
      <p><a href="http://grace.hakunamatataweb.net/administrator/" title="Main Menu">Return to home page.</a></p>
  </dd>
  </dl>
</div>

</div>
</body>
</html><p>Error Details:</p><p><pre>Array
(
    [callback] =&gt; Array
        (
           

• =&gt; CRM_Core_Error
[1] =&gt; handle
        )

   

=> -1
    [message] => DB Error: unknown error
    [mode] => 16
    [debug_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.display_name as civicrm_contact_display_name_a, contact_civireport.id as civicrm_contact_id, contact_b_civireport.display_name as civicrm_contact_b_display_name_b, contact_b_civireport.id as civicrm_contact_b_id, email_civireport.email as civicrm_email_email_a, relationship_type_civireport.label_a_b as civicrm_relationship_type_label_a_b 
        FROM civicrm_relationship relationship_civireport
 
             INNER JOIN civicrm_contact contact_civireport
                        ON ( relationship_civireport.contact_id_a =
                             contact_civireport.id )

             INNER JOIN civicrm_contact contact_b_civireport
                        ON ( relationship_civireport.contact_id_b =
                             contact_b_civireport.id )

             

             LEFT  JOIN civicrm_address address_civireport
                         ON (( address_civireport.contact_id =
                               contact_civireport.id  OR
                               address_civireport.contact_id =
                               contact_b_civireport.id ) AND
                             address_civireport.is_primary = 1 )

             LEFT  JOIN civicrm_relationship_type relationship_type_civireport
                        ON ( relationship_civireport.relationship_type_id  =
                             relationship_type_civireport.id  ) 
             LEFT JOIN civicrm_email email_civireport
                       ON ( contact_civireport.id =
                            email_civireport.contact_id AND
                            email_civireport.is_primary = 1 ) WHERE ( 1 )   GROUP BY relationship_civireport.id     LIMIT 0, 50 [nativecode=1053 ** Server shutdown in progress]
    [type] => DB_Error
    [user_info] => SELECT SQL_CALC_FOUND_ROWS contact_civireport.display_name as civicrm_contact_display_name_a, contact_civireport.id as civicrm_contact_id, contact_b_civireport.display_name as civicrm_contact_b_display_name_b, contact_b_civireport.id as civicrm_contact_b_id, email_civireport.email as civicrm_email_email_a, relationship_type_civireport.label_a_b as civicrm_relationship_type_label_a_b 
        FROM civicrm_relationship relationship_civireport
 
             INNER JOIN civicrm_contact contact_civireport
                        ON ( relationship_civireport.contact_id_a =
                             contact_civireport.id )

             INNER JOIN civicrm_contact contact_b_civireport
                        ON ( relationship_civireport.contact_id_b =
                             contact_b_civireport.id )

             

             LEFT  JOIN civicrm_address address_civireport
                         ON (( address_civireport.contact_id =
                               contact_civireport.id  OR
                               address_civireport.contact_id =
                               contact_b_civireport.id ) AND
                             address_civireport.is_primary = 1 )

             LEFT  JOIN civicrm_relationship_type relationship_type_civireport
                        ON ( relationship_civireport.relationship_type_id  =
                             relationship_type_civireport.id  ) 
             LEFT JOIN civicrm_email email_civireport
                       ON ( contact_civireport.id =
                            email_civireport.contact_id AND
                            email_civireport.is_primary = 1 ) WHERE ( 1 )   GROUP BY relationship_civireport.id     LIMIT 0, 50 [nativecode=1053 ** Server shutdown in progress]
    [to_string] => [db_error: message="DB Error: unknown error" code=-1 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT SQL_CALC_FOUND_ROWS contact_civireport.display_name as civicrm_contact_display_name_a, contact_civireport.id as civicrm_contact_id, contact_b_civireport.display_name as civicrm_contact_b_display_name_b, contact_b_civireport.id as civicrm_contact_b_id, email_civireport.email as civicrm_email_email_a, relationship_type_civireport.label_a_b as civicrm_relationship_type_label_a_b 
        FROM civicrm_relationship relationship_civireport
 
             INNER JOIN civicrm_contact contact_civireport
                        ON ( relationship_civireport.contact_id_a =
                             contact_civireport.id )

             INNER JOIN civicrm_contact contact_b_civireport
                        ON ( relationship_civireport.contact_id_b =
                             contact_b_civireport.id )

             

             LEFT  JOIN civicrm_address address_civireport
                         ON (( address_civireport.contact_id =
                               contact_civireport.id  OR
                               address_civireport.contact_id =
                               contact_b_civireport.id ) AND
                             address_civireport.is_primary = 1 )

             LEFT  JOIN civicrm_relationship_type relationship_type_civireport
                        ON ( relationship_civireport.relationship_type_id  =
                             relationship_type_civireport.id  ) 
             LEFT JOIN civicrm_email email_civireport
                       ON ( contact_civireport.id =
                            email_civireport.contact_id AND
                            email_civireport.is_primary = 1 ) WHERE ( 1 )   GROUP BY relationship_civireport.id     LIMIT 0, 50 [nativecode=1053 ** Server shutdown in progress]"]
)
</pre></p><p></p>[/tt]


[tt]PHP Built on:    Linux polo.websitewelcome.com 2.6.28.9 #41 SMP Fri Nov 27 22:14:58 CST 2009 i686
Database Version: 5.1.30
Database Collation: utf8_general_ci
PHP Version: 5.2.11
Web Server: Apache/2.2.14 (Unix) mod_ssl/2.2.14 OpenSSL/0.9.8i DAV/2 mod_auth_passthrough/2.1 mod_bwlimited/1.4 FrontPage/5.0.2.2635
Web Server to PHP interface: cgi-fcgi
Joomla! Version: Joomla! 1.5.15 Stable [ Wojmamni Ama Mamni ] 05-November-2009 04:00 GMT
User Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; en-US; rv:1.9.1.6) Gecko/20091201 Firefox/3.5.6 (.NET CLR 3.5.30729) [/tt]

[tt]Powered by CiviCRM 3.1.beta1. CiviCRM is openly available under the GNU Affero General Public License (GNU AGPL).[/tt]

Fixed! Thanks!