Email stays at "Not finished sending" (Even when finished)

Forum to discuss Installation and Configuration Issues

Email stays at "Not finished sending" (Even when finished)

Postby Osensnolf » Wed Aug 26, 2015 10:05 am

All of my emails show "Not finished sending" on the Statistics page. The emails are complete though. This happens if I send a test email to myself or to a list of 50k.

What would cause this to happen?
Osensnolf
 
Posts: 82
Joined: Tue Dec 24, 2013 3:28 pm

Re: Email stays at "Not finished sending" (Even when finishe

Postby Osensnolf » Wed Aug 26, 2015 7:30 pm

Was able to fix the issue be clearing the stats_newsletter table in SQL.
Osensnolf
 
Posts: 82
Joined: Tue Dec 24, 2013 3:28 pm

Re: Email stays at "Not finished sending" (Even when finishe

Postby mmm » Fri Aug 28, 2015 8:55 am

Osensnolf wrote:Was able to fix the issue be clearing the stats_newsletter table in SQL.


Thanks again!
:)
mmm
 
Posts: 106
Joined: Sat Apr 11, 2015 4:36 pm

Re: Email stays at "Not finished sending" (Even when finishe

Postby MaBoRaK » Mon Aug 31, 2015 3:18 pm

Osensnolf wrote:All of my emails show "Not finished sending" on the Statistics page. The emails are complete though. This happens if I send a test email to myself or to a list of 50k.

What would cause this to happen?


this error is related to "MySQL server has gone away" , that means Your Mysql server crashed or the query connection was killed before to register the Campaign as completed. Is the same history to the "Sent more emails than total".

The possible reason to have mysql killed connection is ( probably you have this values in: /etc/my.cnf ):

wait_timeout
innodb_lock_wait_timeout

The default values are: 300 ( seconds )

That means, if there is a transaction more than 300 seconds, the connection is killed and Interspire receive an error and progress is not updated in the system. So, next time Interspire needs to continue the sending from last saved point. Or if there is no save-point, the campaign will stuck as NOT FINISHED.
CEO in Maborak Technologies and Interspire Addons Developer
MaBoRaK
Site Admin
 
Posts: 120
Joined: Thu Jul 18, 2013 10:41 am

Re: Email stays at "Not finished sending" (Even when finishe

Postby Osensnolf » Mon Aug 31, 2015 5:14 pm

That is great to know. Should I change the value from 300 to something else?
Osensnolf
 
Posts: 82
Joined: Tue Dec 24, 2013 3:28 pm

Re: Email stays at "Not finished sending" (Even when finishe

Postby MaBoRaK » Wed Sep 02, 2015 2:49 am

Osensnolf wrote:That is great to know. Should I change the value from 300 to something else?



Yes, increase to 900 or 1200, more than this value will cause to have ZOMBIE connections using your MAX_CONNECTIONS.
CEO in Maborak Technologies and Interspire Addons Developer
MaBoRaK
Site Admin
 
Posts: 120
Joined: Thu Jul 18, 2013 10:41 am

Re: Email stays at "Not finished sending" (Even when finishe

Postby Osensnolf » Wed Sep 02, 2015 10:56 am

Thank you very much. :-)
Osensnolf
 
Posts: 82
Joined: Tue Dec 24, 2013 3:28 pm

Re: Email stays at "Not finished sending" (Even when finishe

Postby mmm » Thu Sep 03, 2015 5:31 am

Should actually
innodb_log_file_size = ¼ x innodb_buffer_pool_size
and
max_heap_table_size = tmp_table_size
or what is best?
Any other tips re optimizing /etc/my.cnf?
mmm
 
Posts: 106
Joined: Sat Apr 11, 2015 4:36 pm


Return to Installation and Configuration

 


  • Related topics
    Replies
    Views
    Last post

Who is online

Users browsing this forum: No registered users and 1 guest