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 »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Exporting contact list in Search Builder results in Apache timeout message
Pages: [1]

Author Topic: Exporting contact list in Search Builder results in Apache timeout message  (Read 372 times)

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Exporting contact list in Search Builder results in Apache timeout message
June 18, 2014, 12:20:15 pm
We are running into an unexpected error trying to perform a Search for Export operation. This particular instance of CiviCRM is running version 4.3.4 on Drupal 6.

The steps we are using to attempt this export are as follows:

Search... \ Search Builder
Record Type: Contacts
Search Field: Email
Default: Home (left alone)
Operator: IS NOT EMPTY
Search, and quickly returns:

Code: [Select]
2390 Contacts
Email IS NOT EMPTY ''

Next we click the radio button: "All 2390 records"
Actions: Export Contacts then push the Go button.

On the next screen:

Code: [Select]
Export All or Selected Fields (step 2 of 3)
2390 records selected for export.

we check the box: "Exclude contacts with "do not mail" privacy, no street address, or who are deceased."

Then push the "CONTINUE >>" button which goes on FOREVER and then finally this apparently Apache error message comes up:

Code: [Select]
The connection has timed out

The server at members.orgname.org is taking too long to respond.

What might be causing this Search / Export failure? We have "Enable Drupal Watchdog Logging" set to Yes, and no error shows up in Watchdog, nor in the current CiviCRM.*.log file.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Exporting contact list in Search Builder results in Apache timeout message
June 18, 2014, 01:11:39 pm
Hi there,

You may want to use MySQL logging to log long-running queries - if you can isolate the query in question, it may have an easy solution!

Jon
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

mdlueck

  • Ask me questions
  • ****
  • Posts: 382
  • Karma: 4
  • CiviCRM version: 4.7.24
  • CMS version: Drupal 6.x
  • MySQL version: 5.5.54
  • PHP version: 5.3.10
Re: Exporting contact list in Search Builder results in Apache timeout message
June 18, 2014, 08:15:49 pm
Greetings Jon,

I spent time this evening trying to enable tracing / logging on this version of MySQL. The server is running: 5.0.95

I did not manage to get any sort of tracing / logging output, so commented out my attempts, and posting back for suggested configuration syntax for this old version of MySQL.

I am thankful,
--
Michael Lueck
Lueck Data Systems
http://www.lueckdatasystems.com/

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Exporting contact list in Search Builder results in Apache timeout message

This forum was archived on 2017-11-26.