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 CiviMail (Moderator: Piotr Szotkowski) »
  • out of memory error at mail Upload step
Pages: [1]

Author Topic: out of memory error at mail Upload step  (Read 4827 times)

chrism

  • Guest
out of memory error at mail Upload step
May 23, 2007, 09:33:12 am
I have installed CiviCRM 1.7.9379 and am attempted to send a mailing, but after the selecting "Next" at the Upload step I get the following error:

Quote
Fatal error: out of dynamic memory in yy_create_buffer() in /home/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php on line 1453

Warning: MySQL client ran out of memory query: SELECT * FROM system WHERE type = 'theme' in /home/includes/database.mysql.inc on line 172

I had a 1.6 version of CiviMail working on the same host previously, and I have an custom install of PHP with memory_limit set to 90M.  The group just consists of a small number of contacts.  Any suggestions as to the cause of this and how to resolve? 

Much appreciated,
Chris

Piotr Szotkowski

  • Moderator
  • I live on this forum
  • *****
  • Posts: 1497
  • Karma: 57
Re: out of memory error at mail Upload step
May 23, 2007, 10:32:01 pm
This is very strange. Can you get access to your MySQL logs? Note that this is an error on a Drupal query…
If you found the above helpful, please consider helping us in return – you can even steer CiviCRM’s future and help us extend CiviCRM in ways useful to you.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: out of memory error at mail Upload step
May 23, 2007, 10:41:10 pm

Chris:

we've not seen this error in the past, so are a bit lost here. can u get on IRC and we can chat and hopefully make more progress on it

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

chrism

  • Guest
Re: out of memory error at mail Upload step
May 26, 2007, 09:56:03 pm
Thanks Piotr, Lobo,

I investigated a bit more, and discovered that the Upload step failure appears when the number of contacts in the civicrm database increases.  With 800 contacts (7.0MB database) it worked fine, but with 1000 contacts (7.5 MB database) the error message appeared. 

The second time I got a different message:
Quote
Fatal error: Out of memory (allocated 31457280) (tried to allocate 40961 bytes) in /home/sites/all/modules/civicrm/packages/Smarty/Smarty.class.php on line 1261
and other times I just got a blank screen, so I think this is a general out-of-memory problem on the server rather than a specific line of code problem.

I inquired into memory limits and SQL logs with my host and got this response:
Quote
There are several limits in place that you may be hitting. We have an
apache memory limit, a php memory limit, and a few others, but I think
those two are what's causing the issue.

Both limits are set at 90 megs, but they're a total limit, so any sum of
memory you're using, will get added up. Once you hit that, you'll be
throttled. You'll need to reduce your memory consumption in order to
proceed.

Unfortunately, we do not provide access to mysql logs.

It is surprising to me that a memory error on the Upload step should be dependant on the total size of the database, since the mailing group that I was sending to in all cases had only one member (i.e. shouldn't be a big query).

Chris

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: out of memory error at mail Upload step
May 27, 2007, 01:26:59 am

Chris:

i took a look at the queries we generate during the upload postprocess and dont see any queries that are a function of the database. Obviously your experiments below indicate that we seem to be hitting some bug that consumes a fair amount of memory

Not having access to your mysql logs makes things a bit more difficult to diagnose and debug. I'm not sure what we can do at this stage. would be cool to get ssh access to your box so we can instrument the code and see what queries we are
generating and trace the flow

if this is possible, please get on IRC and we can discuss details / get access etc

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

chrism

  • Guest
Re: out of memory error at mail Upload step
June 09, 2007, 03:47:42 pm
An issue has been filed: http://issues.civicrm.org/jira/browse/CRM-1989
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviMail (Moderator: Piotr Szotkowski) »
  • out of memory error at mail Upload step

This forum was archived on 2017-11-26.