Body: <p>I'm having strange issues with bulk emails since upgrade to 5.48.0. I'm using the traditional mailer, and not Mosaico. These issues do not appear if the list is small (or maybe it's certain configurations?? Maybe it's the use of variables in the template?).</p>
  <ol>
  <li><p>A scheduled mailing does not show in the list. But then I go and flush the cache (cv flush) and it shows up as scheduled.</p>
  </li>
  <li><p>Have to cancel mailing if it hangs. I have now throttled sending to batches of 200, and then it can manage to go, but takes forever.</p>
  </li>
  </ol>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-05-11T01:53:10.323Z
Comments.Text: Are you seeing any errors in your CiviCRM Config and Log file that correspond to when the mailing hangs?
Comments.UserDisplayName: Luke Stewart
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-05-12T08:43:26.300Z
Comments.Text: If it works when you limit to 200, you may be hitting memory or processing time limits.
Comments.UserDisplayName: Aidan
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-05-12T14:29:08.747Z
Comments.Text: I did not have this problem before upgrade to the current version, so something is creating a new load on the server. I wondered if it was potential handling of lots of errors/warnings.
Comments.UserDisplayName: TimETown
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2022-05-12T14:36:13.543Z
Comments.Text: config/error log when failed before batching:
  https://drive.google.com/file/d/1tjKkj8UWS6VFOwAGKKnj3Nnind3jAlX4/view?usp=sharing
  
  config/error log when mailing sent AFTER batching:
  https://drive.google.com/file/d/1XX81BC_9HCI3JpPeq2gqWms7hbBLDW9X/view?usp=sharing
Comments.UserDisplayName: TimETown
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-20T15:26:40.023Z
Comments.Text: We have a similar problem. php_error.log writes:
  
  PHP Fatal error:  Allowed memory size of 2147483648 bytes exhausted (tried to allocate 20480 bytes) in /html/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Utils/Cache/SqlGroup.php on line 185
  
  @TimETown did you find a solution for that?
Comments.UserDisplayName: Detlev Sieber
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2023-01-21T16:47:06.320Z
Comments.Text: I was able to increase batches to 250, I think, and then create a cron job in the server to run every five minutes. This is really a work around. I haven't checked status of this during the past few upgrades to see if there problem is now gone.
Comments.UserDisplayName: TimETown
Tags: <civimail>
Title: Upgrade to 5.48.0 seems to cause many CiviMail errors; mailings hanging
ThreadText: # Upgrade to 5.48.0 seems to cause many CiviMail errors; mailings hanging
  
  (Asked by: username_0 on 2022-05-10)
  
  I'm having strange issues with bulk emails since upgrade to 5.48.0. I'm using the traditional mailer, and not Mosaico. These issues do not appear if the list is small (or maybe it's certain configurations?? Maybe it's the use of variables in the template?).
  
  1. A scheduled mailing does not show in the list. But then I go and flush the cache (cv flush) and it shows up as scheduled.
  2. Have to cancel mailing if it hangs. I have now throttled sending to batches of 200, and then it can manage to go, but takes forever.
  
  **Tags:** civimail
  
  > **Comments:**
  > **username_1**: Are you seeing any errors in your CiviCRM Config and Log file that correspond to when the mailing hangs?  
  > **username_2**: If it works when you limit to 200, you may be hitting memory or processing time limits.  
  > **username_0**: I did not have this problem before upgrade to the current version, so something is creating a new load on the server. I wondered if it was potential handling of lots of errors/warnings.  
  > **username_0**: config/error log when failed before batching: https://drive.google.com/file/d/1tjKkj8UWS6VFOwAGKKnj3Nnind3jAlX4/view?usp=sharing  config/error log when mailing sent AFTER batching: https://drive.google.com/file/d/1XX81BC_9HCI3JpPeq2gqWms7hbBLDW9X/view?usp=sharing  
  > **username_3**: We have a similar problem. php_error.log writes:  PHP Fatal error:  Allowed memory size of 2147483648 bytes exhausted (tried to allocate 20480 bytes) in /html/wordpress/wp-content/plugins/civicrm/civicrm/CRM/Utils/Cache/SqlGroup.php on line 185  @username_0 did you find a solution for that?  
  > **username_0**: I was able to increase batches to 250, I think, and then create a cron job in the server to run every five minutes. This is really a work around. I haven't checked status of this during the past few upgrades to see if there problem is now gone.  
  
  ---
  
  ## 0 answers
  
  