mysql server keeps restarting every 30 seconds

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
Post Reply
fuzzy115
Posts: 1
Joined: Tue Jun 18, 2019 10:41 am

mysql server keeps restarting every 30 seconds

Post by fuzzy115 »

Hi everyone,
your kind help needed.
After 2 weeks of trying everything I'm at a loss

I'm running Zimbra 8.7.11.GA.1854 on Ubuntu LTS 16.04, configuration with 2 servers, primary with approx 60 mailboxes and secondary 40 mailboxes most of which could be dropped
On the secondary server after major blackout mysql start failed, so I thought there's a usual database problem
and did as described here https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery
No result, mysql keeps restarting
After much googling and many retries...
It keeps restarting, even with freshly generated bases, no matter what. Sometimes it got stuck with innoDB, sometimes was shut down with sig 11, once or twice reported sigkill...
and right now what I get is simply weird
Снимок2.PNG
Снимок2.PNG (6.5 KiB) Viewed 1403 times
2019-06-18 14:46:20 140529632290624 [Note] InnoDB: Waiting for purge to start
2019-06-18 14:46:21 140529632290624 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 4425211
2019-06-18 14:46:21 140529632290624 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-18 14:46:21 140529632290624 [Note] Recovering after a crash using tc.log
2019-06-18 14:46:21 140529632290624 [Note] Starting crash recovery...
2019-06-18 14:46:21 140529632290624 [Note] Crash recovery finished.
2019-06-18 14:46:21 140525459359488 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-06-18 14:46:21 140529632290624 [Note] Server socket created on IP: '127.0.0.1'.
2019-06-18 14:46:21 140529632290624 [Note] /opt/zimbra/common/sbin/mysqld: ready for connections.
Version: '10.1.25-MariaDB' socket: '/opt/zimbra/data/tmp/mysql/mysql.sock' port: 7306 Zimbra MariaDB binary distribution
2019-06-18 14:46:54 140293251422016 [Note] InnoDB: Waiting for purge to start
2019-06-18 14:46:54 140293251422016 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.36-82.0 started; log sequence number 4425237
2019-06-18 14:46:55 140293251422016 [Note] Plugin 'FEEDBACK' is disabled.
2019-06-18 14:46:55 140293251422016 [Note] Recovering after a crash using tc.log
2019-06-18 14:46:55 140293251422016 [Note] Starting crash recovery...
2019-06-18 14:46:55 140293251422016 [Note] Crash recovery finished.
2019-06-18 14:46:55 140289078490880 [Note] InnoDB: Dumping buffer pool(s) not yet started
2019-06-18 14:46:55 140293251422016 [Note] Server socket created on IP: '127.0.0.1'.
2019-06-18 14:46:55 140293251422016 [Note] /opt/zimbra/common/sbin/mysqld: ready for connections.
Version: '10.1.25-MariaDB' socket: '/opt/zimbra/data/tmp/mysql/mysql.sock' port: 7306 Zimbra MariaDB binary distribution

Primary server keeps working although a bit slower...
Post Reply