writing campaign constantly freezing

[Rodrigo]

Olá, eu tenho um problema.

Meu servidor não é muito poderoso. Então, quando eu agendá-lo para enviar uma campanha, que processa os dados e começa a enviar. Mas por alguma razão ele congela no caminho e não envia mais e-mails. Então eu tenho que manualmente empurrar o botão para forçá-lo a enviar. Ele re-enviar e algum tempo depois se congelar novamente.

Existe uma maneira de automatizar isso? Para possuir programa de certificar-se de que esta campanha congelados e re-apresentar?

Estou com a versão 1.3.4.9, não é um problema no upgrade para a versão mais recente, como há uma campanha em curso?

EN:
Hello, I have a problem.

My server is not very powerful. So when I schedule it to send a campaign, it processes the data and starts sending. But for some reason it freezes on the way and does not send more emails. So I have to manually push the button to force it to send. He re-submit and some time later it freezes again.

Is there a way to automate this? To own program make sure that this campaign frozen and re-submit?

I’m with the 1.3.4.9 version, there is a problem in upgrade to the latest version as there is a campaign underway?

 

[twisted1919]

Can you share a screenshot from backend -> settings -> cron ?

 

[Rodrigo]

 

[twisted1919]

Okay, let's try following settings:

Campaigns at once: 1
Subscribers at once: 50
Send at once: 0
Pause: 1
Email per minute: 0
Change server at: 0

Then save and see if the campaign gets stuck again.

 

[Rodrigo]

was better, but still freezing in the middle of sending.

 

[twisted1919]

Anything specific in the Backend -> Misc -> Application log?
I'd say you delete the log, then start the campaign again, and when it gets stuck again, take the contents of the log, put them in a .txt file and attach it here so i can see it.

You should really upgrade to latest version after you finis that campaign

 

[Rodrigo]

ready ... follows the log.

 

[twisted1919]

Well, i can see this:

2015/02/24 19:45:32 [error] [exception.CDbException] SQLSTATE[42000] [1203] User tupiniqu_01 already has more than 'max_user_connections' active connections

So you are reaching the max number of mysql allowed connections and then you can't do anything else and the campaign dies.
You should increase the number of mysql connections allowed for that user, usually, at least in my setup, i've set it to 500.

Thanks.

 

[Rodrigo]

I'm on a shared hosting, can not increase this limit ... = (

Would you have any solution for this? Even sending is done more slowly?

 

[Garret]

Yes, get an optimized VPS.

 

[twisted1919]

Beside what @Garret said, you can try to set Subscribers at once: 20 and see how that goes.
If that fails too, then change your host.

 

[Rodrigo]

you can show me some with a good price?

 

[twisted1919]

What does good price means, how many $/mo ?

 

[Rodrigo]

when I pay $ 15 a month. A service of Brazil, but I think out of the country can be anything better.

 

[twisted1919]

With $20 you get yourself a linode at 2GB of ram from linode.com, unmanaged.
With $21 you can also get a 18GB ram VPS from http://vpsdime.com/ , unmanaged.
For the above you have to install and setup everything.
If you need managed, prices are a bit higher.

You can also have a talk with the guys at http://www.visional-marketing.com/mailwizz-email-marketing-application/ and see their pricing.

Good luck

 

[Rodrigo]

tks

 

[Rodrigo]

Hi, I was talking to the VPSDIME support staff and they told me it would not be possible to configure the number of mysql connections to 500.

Am I expressing myself wrong with them? What should I keep in mind exactly the configuration of minimum viable server?

 

[twisted1919]

Hi, I was talking to the VPSDIME support staff and they told me it would not be possible to configure the number of mysql connections to 500.

That's a VPS where you are in full control, so how come you won't be able to set those settings when you'll have to install and setup the database server?
I think they're mistaken or they didn't properly understand your question.
You can direct them to this forum thread to see the discussion in case they have doubts.

 

[justme]

@Rodrigo interested for dedicated servers with dedicated ips

all our servers are optimized for Email Marketing, SMTP setups and ESP`s

PM me with details and happily assist you further.