Hi, I have a problem with MySQL 8.0.15 which crashes every often.
This interrupts one of my services, which needs a active MySQL connection.
Could anybody tell me how to troubleshoot this, or where to look at ?
Here is a log:
2019-04-01T02:04:42.879073Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15-5' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server
(GPL), Release '5', Revision 'f8a9e99'.
2019-04-01T02:04:43.120129Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-04-03T12:03:57.695283Z 0 [Warning] [MY-010139] [Server] Changed limits: max_open_files: 10000 (requested 10010)
2019-04-03T12:03:57.695291Z 0 [Warning] [MY-010142] [Server] Changed limits: table_open_cache: 3995 (requested 4000)
2019-04-03T12:03:58.006330Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds ins
tead.
2019-04-03T12:03:58.008905Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15-5) starting as process 24242
2019-04-03T12:03:58.012574Z 0 [Warning] [MY-013242] [Server] --character-set-server: 'utf8' is currently an alias for the character set UTF8MB3, but will be an alias for UTF8MB4 in a futu
re release. Please consider using UTF8MB4 in order to be unambiguous.
2019-04-03T12:03:58.012732Z 0 [Warning] [MY-013244] [Server] --collation-server: 'utf8_unicode_ci' is a collation of the deprecated character set UTF8MB3. Please consider using UTF8MB4 with an appropriate collation instead.
2019-04-03T12:04:08.388329Z 0 [System] [MY-010229] [Server] Starting crash recovery...
2019-04-03T12:04:08.398401Z 0 [System] [MY-010232] [Server] Crash recovery finished.
2019-04-03T12:04:08.491054Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2019-04-03T12:04:08.519563Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.15-5' socket: '/var/run/mysqld/mysqld.sock' port: 3306 Percona Server (GPL), Release '5', Revision 'f8a9e99'.
2019-04-03T12:04:08.559832Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2019-04-03T21:26:43.565615Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 11109 user: 'anirena'.
2019-04-03T21:26:43.565892Z 0 [Warning] [MY-010909] [Server] /usr/sbin/mysqld: Forcing close of thread 14470 user: 'root'.
2019-04-03T21:26:46.144251Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.15-5) Percona Server (GPL), Release '5', Revision 'f8a9e99'.
2019-04-03T21:31:35.369494Z 0 [Warning] [MY-011068] [Server] The syntax 'expire-logs-days' is deprecated and will be removed in a future release. Please use binlog_expire_logs_seconds instead.
2019-04-03T21:31:35.370766Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.15-5) starting as process 26242