CdbException from Mailwizz-mysql process failing, every 3 days

[Kevin Tao]

Hi there,

Every 3 days, my Mailwizz-mysql process keeps dying, and I have to manually restart the process.

Has anyone seen this before or know what might be happening?
My Mailwizz server is running on Amazon EC2, using docker.



[root@ip-172-31-85-112 mailwizz-docker]# docker ps
3 days ago:
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

844e107ea67f phpdockerio/nginx:latest "/usr/sbin/nginx" 2 weeks ago Up 3 days 0.0.0.0:80->80/tcp, 443/tcp mailwizz-webserver

1342d30b7c00 phpmyadmin/phpmyadmin "/run.sh phpmyadmin" 2 weeks ago Up 3 days 0.0.0.0:8181->80/tcp mailwizz-phpmyadmin

12d4469f0751 mailwizzdocker_mailwizz-php "/entrypoint.sh ph..." 2 weeks ago Up 3 days 9000/tcp mailwizz-php
[root@ip-172-31-85-112 mailwizz-docker]# docker-compose start

Starting mailwizz-mysql ... done

Starting mailwizz-php ... done

Starting mailwizz-phpmyadmin ... done

Starting mailwizz-webserver ... done

[root@ip-172-31-85-112 mailwizz-docker]# docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

844e107ea67f phpdockerio/nginx:latest "/usr/sbin/nginx" 2 weeks ago Up 3 days 0.0.0.0:80->80/tcp, 443/tcp mailwizz-webserver

1342d30b7c00 phpmyadmin/phpmyadmin "/run.sh phpmyadmin" 2 weeks ago Up 3 days 0.0.0.0:8181->80/tcp mailwizz-phpmyadmin

12d4469f0751 mailwizzdocker_mailwizz-php "/entrypoint.sh ph..." 2 weeks ago Up 3 days 9000/tcp mailwizz-php

4fe91ebb82fd mysql:5.7 "docker-entrypoint..." 2 weeks ago Up 5 seconds 3306/tcp mailwizz-mysql

And today:
[root@ip-172-31-85-112 mailwizz-docker]# docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

844e107ea67f phpdockerio/nginx:latest "/usr/sbin/nginx" 2 weeks ago Up 5 days 0.0.0.0:80->80/tcp, 443/tcp mailwizz-webserver

1342d30b7c00 phpmyadmin/phpmyadmin "/run.sh phpmyadmin" 2 weeks ago Up 5 days 0.0.0.0:8181->80/tcp mailwizz-phpmyadmin

12d4469f0751 mailwizzdocker_mailwizz-php "/entrypoint.sh ph..." 2 weeks ago Up 5 days 9000/tcp mailwizz-php

[root@ip-172-31-85-112 mailwizz-docker]# docker-compose start

Starting mailwizz-mysql ... done

Starting mailwizz-php ... done

Starting mailwizz-phpmyadmin ... done

Starting mailwizz-webserver ... done

[root@ip-172-31-85-112 mailwizz-docker]# docker ps

CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES

844e107ea67f phpdockerio/nginx:latest "/usr/sbin/nginx" 2 weeks ago Up 5 days 0.0.0.0:80->80/tcp, 443/tcp mailwizz-webserver

1342d30b7c00 phpmyadmin/phpmyadmin "/run.sh phpmyadmin" 2 weeks ago Up 5 days 0.0.0.0:8181->80/tcp mailwizz-phpmyadmin

12d4469f0751 mailwizzdocker_mailwizz-php "/entrypoint.sh ph..." 2 weeks ago Up 5 days 9000/tcp mailwizz-php

4fe91ebb82fd mysql:5.7 "docker-entrypoint..." 2 weeks ago Up 3 seconds 3306/tcp mailwizz-mysql

 

[twisted1919]

@Kevin Tao - What's the size of the ec2 instance ?

 

[Kevin Tao]

I think it's 4 gb?

 

[twisted1919]

I don't know the answer
If docker poses issues for you, you might want to look and install it in a regular way, without docker.

 

[Kevin Tao]

mailwizz-mysql just randomly died again just now. Here's an Amazon EC2 graph showing that CPU utilization spikes way up right when it crashes.

Here's what docker logs says:

2018-01-30T03:30:39.011911Z 0 [Note] InnoDB: page_cleaner: 1000ms intended loop took 30219ms. The settings might not be optimal. (flushed=39 and evicted=0, during the time.)

 

[Kevin Tao]

So I've decided I'm going to switch to using Amazon RDS to host my mysql database. Does anyone know how to change the configuration in the docker-compose.yml file to point to an external database?

 

[twisted1919]

@Kevin Tao - the file containing this info should be in /root/mailwizz-docker/mailwizz/html/apps/common/config/main-custom.php