Maborak Technologies - Community Forum

[Osensnolf]

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]

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

[mmm]

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

Thanks again!

[MaBoRaK]

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.

[Osensnolf]

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

[MaBoRaK]

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.

[Osensnolf]

Thank you very much.

[mmm]

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?