CdbException from Mailwizz-mysql process failing, every 3 days

Kevin Tao

New Member
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

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

Kevin Tao

New Member
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.)
 

Attachments

Kevin Tao

New Member
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?
 
Top