Question
Help!!! MySQL keeps crashing - Error establishing a database connection
I have a One-Click WordPress Droplet, 10$ monthly/ 2GB/1CPU and I have a problem with my MySQL server that keeps crashing every day.
I will list below the last 100 lines from the myqsl/error.log file.
I can’t figure out what the problem/error is in order to fix it.
2020-10-24T07:31:01.856129Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 10073
2020-10-24T07:31:01.876064Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T07:31:02.620467Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T07:31:02.952053Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T07:31:02.982762Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T07:31:02.996709Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T07:31:03.093543Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T07:31:03.093860Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T07:31:03.132067Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T07:31:05.146700Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 10148
2020-10-24T07:31:05.169210Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T07:31:06.103789Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T07:31:07.264196Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 10180
2020-10-24T07:31:07.289518Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T07:31:08.277784Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T07:31:08.537337Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T07:31:08.607568Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T07:31:08.629252Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T07:31:08.745647Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T07:31:08.746301Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T07:31:08.905259Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T07:31:11.452640Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 10248
2020-10-24T07:31:11.465881Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T07:31:11.973403Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T07:31:12.174284Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T07:31:12.203740Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T07:31:12.232495Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T07:31:12.297819Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T07:31:12.298077Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T07:31:12.334587Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T07:31:13.997940Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 10316
2020-10-24T07:31:14.013881Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T07:31:14.552485Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T07:31:14.863655Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T07:31:14.889576Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T07:31:14.903368Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T07:31:14.981442Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T07:31:14.981683Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T07:31:15.018988Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T07:33:20.210922Z 0 [System] [MY-013172] [Server] Received SHUTDOWN from user <via user signal>. Shutting down mysqld (Version: 8.0.21-0ubuntu0.20.04.4).
2020-10-24T07:33:22.353969Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.21-0ubuntu0.20.04.4) (Ubuntu).
2020-10-24T07:33:38.665366Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 832
2020-10-24T07:33:38.746633Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T07:33:40.191389Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T07:33:40.885075Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T07:33:41.272997Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T07:33:41.273226Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T07:33:41.424955Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T11:00:05.273777Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3172
2020-10-24T11:00:05.309118Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T11:00:06.116308Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T11:00:06.461215Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T11:00:06.500785Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T11:00:06.540711Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T11:00:06.664386Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T11:00:06.667602Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T11:00:06.768605Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T11:00:10.347972Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3248
2020-10-24T11:00:10.373218Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T11:00:15.998583Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3298
2020-10-24T11:00:16.072693Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T11:00:17.879610Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3320
2020-10-24T11:00:17.897421Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T11:00:18.500327Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T11:00:18.714748Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T11:00:18.739013Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T11:00:18.766570Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T11:00:18.833908Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T11:00:18.834329Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T11:00:18.876799Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T11:00:21.372868Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3392
2020-10-24T11:00:21.386615Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T11:00:21.967532Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T11:00:22.178607Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T11:00:22.215765Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T11:00:22.235954Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T11:00:22.306862Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T11:00:22.307524Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T11:00:22.361595Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
2020-10-24T11:00:24.163291Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.21-0ubuntu0.20.04.4) starting as process 3467
2020-10-24T11:00:24.180379Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2020-10-24T11:00:24.739507Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2020-10-24T11:00:24.930210Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Bind-address: '::' port: 33060, socket: /var/run/mysqld/mysqlx.sock
2020-10-24T11:00:24.956663Z 0 [System] [MY-010229] [Server] Starting XA crash recovery...
2020-10-24T11:00:24.971527Z 0 [System] [MY-010232] [Server] XA crash recovery finished.
2020-10-24T11:00:25.030456Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-10-24T11:00:25.030717Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2020-10-24T11:00:25.068120Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.21-0ubuntu0.20.04.4' socket: '/var/run/mysqld/mysqld.sock' port: 3306 (Ubuntu).
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
×