Date: Sat, 15 Apr 2023 17:25:17 +0100 From: Mike Clarke <jmc-freebsd2@milibyte.co.uk> To: questions@freebsd.org Subject: MySQL server silently fails to start after upgrading from 5.7.40 to 8.0.32 Message-ID: <4381878.Iv3B0QcHgC@curlew>
next in thread | raw e-mail | index | archive | help
This is a multi-part message in MIME format. --nextPart2164183.PLFibm3KWW Content-Transfer-Encoding: 7Bit Content-Type: text/plain; charset="UTF-8" After upgrading packages to the the new quarterly release mysql was upgraded to 8.0.32 and it fails to start and does not produce any failure message on the console and I couldn't find any relevant failure message anywhere in /var/logs. I have updated my.cnf by copying the entire file from my.cnf.sample. I've reverted back to the earlier BE with my working mysql5 and here's the diff between / usr/local/etc/mysql/my.cnf and /tmp/my.cnf which was copied from the BE containing mysql8 --- /usr/local/etc/mysql/my.cnf 2019-07-16 14:41:30.000000000 +0100 +++ /tmp/my.cnf 2023-04-15 17:10:55.395944000 +0100 @@ -1,2 +0,0 @@ -# $FreeBSD: head/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $ - @@ -19 +17 @@ -slave-load-tmpdir = /var/db/mysql_tmpdir +replica-load-tmpdir = /var/db/mysql_tmpdir @@ -23,2 +20,0 @@ -master-info-repository = TABLE -relay-log-info-repository = TABLE @@ -31 +27 @@ -expire_logs_days = 30 +binlog_expire_logs_seconds = 2592000 @@ -45,2 +40,0 @@ -query_cache_type = 0 -query_cache_size = 0 @@ -51 +45 @@ -innodb_data_file_path = ibdata1:82M:autoextend +innodb_data_file_path = ibdata1:128M:autoextend @@ -54 +48 @@ -innodb_log_file_size = 256M +innodb_redo_log_capacity = 512M @@ -59 +52,0 @@ -skip-symbolic-links -- Mike Clarke --nextPart2164183.PLFibm3KWW Content-Transfer-Encoding: 7Bit Content-Type: text/html; charset="UTF-8" <html> <head> <meta http-equiv="content-type" content="text/html; charset=UTF-8"> </head> <body><br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">After upgrading packages to the the new quarterly release mysql was upgraded to 8.0.32 and it fails to start and does not produce any failure message on the console and I couldn't find any relevant failure message anywhere in /var/logs.</p> <br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">I have updated my.cnf by copying the entire file from my.cnf.sample.</p> <br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">I've reverted back to the earlier BE with my working mysql5 and here's the diff between /usr/local/etc/mysql/my.cnf and /tmp/my.cnf which was copied from the BE containing mysql8</p> <br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">--- /usr/local/etc/mysql/my.cnf 2019-07-16 14:41:30.000000000 +0100</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+++ /tmp/my.cnf 2023-04-15 17:10:55.395944000 +0100</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -1,2 +0,0 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-# $FreeBSD: head/databases/mysql57-server/files/my.cnf.sample.in 414707 2016-05-06 14:39:59Z riggs $</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -19 +17 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-slave-load-tmpdir = /var/db/mysql_tmpdir</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+replica-load-tmpdir = /var/db/mysql_tmpdir</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -23,2 +20,0 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-master-info-repository = TABLE</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-relay-log-info-repository = TABLE</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -31 +27 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-expire_logs_days = 30</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+binlog_expire_logs_seconds = 2592000</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -45,2 +40,0 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-query_cache_type = 0</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-query_cache_size = 0</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -51 +45 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-innodb_data_file_path = ibdata1:82M:autoextend</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+innodb_data_file_path = ibdata1:128M:autoextend</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -54 +48 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-innodb_log_file_size = 256M</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">+innodb_redo_log_capacity = 512M</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">@@ -59 +52,0 @@</p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-skip-symbolic-links</p> <br /><p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">-- </p> <p style="margin-top:0;margin-bottom:0;margin-left:0;margin-right:0;">Mike Clarke</p> </body> </html> --nextPart2164183.PLFibm3KWW--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4381878.Iv3B0QcHgC>