Campaign never stops "sending" status

[beberlei]

I cant seem to find out why this "sending" status never goes away. 1 e-mail seems to be unsent, but never gets sent (for days now).

[goaround]

Try to raise the timeout for the send-campaign queue. If the job times out, it will stay like you described it

[beberlei]

@goaround any pointers how that is done? I don't usually use Laravel only for Mailcoach.

[goaround]

In config/horizon.php I created a supervisor just for the queue send-campaign and there you can raise the timeout

Here is my supervisor:

            'mailcoach-send-campaign' => [
                'connection' => 'mailcoach-redis',
                'queue' => ['send-campaign'],
                'balance' => 'auto',
                'minProcesses' => 1,
                'maxProcesses' => 3,
                'tries' => 3,
                'timeout' => 60 * 60,
            ],

Be sure to remove the queue send-campaign from the default mailcoach supervisor

[riasvdv]

@goaround his solution should work! Thanks

@beberlei You could also check Horizon to see what went wrong with the send campaign job. If it's something other than a timeout please open a new issue

[beberlei]

@riasvdv can you explain what "checking horizon" entails? I have no clue

[riasvdv]

You can access horizon at https://your-mailcoach-domain.com/horizon and get information on the queues

[beberlei]

@riasvdv alright, then I think i have the bug. During attempting to send an email it fails, and the failure reason is stored, but that fails with a database column length error: