Date: Fri, 11 Oct 2024 00:06:31 -0400 From: Juan Manuel Palacios <jmpalacios@gmail.com> To: Udo Pokojski <freebsd@upokojski.de> Cc: freebsd-questions@freebsd.org Subject: Re: Mysql-Server not starting Message-ID: <CBD261A5-6D51-47D0-9A89-CDA8205B62C1@gmail.com> In-Reply-To: <2b663bca-5579-41c8-9db3-02bf87424d0f@upokojski.de> References: <2b663bca-5579-41c8-9db3-02bf87424d0f@upokojski.de>
next in thread | previous in thread | raw e-mail | index | archive | help
--Apple-Mail=_12ACA1C8-469D-4E69-B98F-E03D366F738E Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=utf-8 Hi Udo, What I=E2=80=99d do in this case would be to, first and foremost, back = up your data directory (zfs snapshot of the host would suffice, if = you=E2=80=99re on that filesystem, with the service stopped of course = =E2=80=94but is a given in this case=E2=80=94), and then start the = service with InnoDB in recovery mode: https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.html=EF=BF= =BC I've seen similar errors to yours, but involving the InnoDB log files, = e.g. ib_logfile0, which could be safely moved to the side to have the = MySQL recreate it/them upon restart. But in your case it appears that = it=E2=80=99s the ibdata files what are corrupt, which are the = "system=E2=80=99s tablespace=E2=80=9D files, = https://dba.stackexchange.com/a/27106, so I=E2=80=99d definitely be more = careful with those. HTH! > On Oct 10, 2024, at 4:08=E2=80=AFPM, Udo Pokojski = <freebsd@upokojski.de> wrote: >=20 > Hallo, >=20 >=20 > after doing an pkg update and pkg upgrade on FreeBSD 13.3, I cannot = start the mysql-server. >=20 > The command service mysql-server start returns no error. >=20 >=20 > In the mysql error log, I can find the following messages: >=20 > 2024-10-10T19:55:15.913147Z 1 [System] [MY-013576] [InnoDB] InnoDB = initialization has started. > 2024-10-10T19:55:16.148244Z 1 [ERROR] [MY-012263] [InnoDB] The = Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of a = different size 768 pages (rounded down to MB) than specified in the .cnf = file: initial 8192 pages, max 0 (relevant if non-zero) pages! > 2024-10-10T19:55:16.148370Z 1 [ERROR] [MY-012930] [InnoDB] Plugin = initialization aborted with error Generic error. > 2024-10-10T19:55:16.149901Z 1 [ERROR] [MY-010334] [Server] Failed to = initialize DD Storage Engine > 2024-10-10T19:55:16.150187Z 0 [ERROR] [MY-010020] [Server] Data = Dictionary initialization failed. > 2024-10-10T19:55:16.150233Z 0 [ERROR] [MY-010119] [Server] Aborting >=20 >=20 > Something seems to wrong with my my.cnf file. The only line which = affects the innodb file size is: >=20 > innodb_data_file_path =3D ibdata1:128M:autoextend >=20 > I never changed this line an In have no idea how to fix the error. >=20 > Any help is appreciated. >=20 >=20 > Thanks in advance, >=20 > Udo >=20 >=20 >=20 >=20 >=20 >=20 >=20 >=20 >=20 --Apple-Mail=_12ACA1C8-469D-4E69-B98F-E03D366F738E Content-Type: multipart/related; type="text/html"; boundary="Apple-Mail=_7CECCF8A-07AD-4F4B-AF09-BF06CCE0E7D3" --Apple-Mail=_7CECCF8A-07AD-4F4B-AF09-BF06CCE0E7D3 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=utf-8 <html><head><meta http-equiv=3D"content-type" content=3D"text/html; = charset=3Dutf-8"></head><body style=3D"overflow-wrap: break-word; = -webkit-nbsp-mode: space; line-break: after-white-space;">Hi = Udo,<div><br></div><div>What I=E2=80=99d do in this case would be to, = first and foremost, back up your data directory (zfs snapshot of the = host would suffice, if you=E2=80=99re on that filesystem, with the = service stopped of course =E2=80=94but is a given in this case=E2=80=94), = and then start the service with InnoDB in recovery = mode:</div><div><br></div><div><div style=3D"display: block;"><div = style=3D"-webkit-user-select: all; -webkit-user-drag: element; display: = inline-block;" class=3D"apple-rich-link" draggable=3D"true" role=3D"link" = data-url=3D"https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recover= y.html"><a style=3D"border-radius:10px;font-family:-apple-system, = Helvetica, Arial, = sans-serif;display:block;-webkit-user-select:none;width:300px;user-select:= none;-webkit-user-modify:read-only;user-modify:read-only;overflow:hidden;t= ext-decoration:none;" class=3D"lp-rich-link" rel=3D"nofollow" = href=3D"https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.ht= ml" dir=3D"ltr" role=3D"button" draggable=3D"false" width=3D"300"><table = style=3D"table-layout:fixed;border-collapse:collapse;width:300px;backgroun= d-color:#E5E6E9;font-family:-apple-system, Helvetica, Arial, = sans-serif;" class=3D"lp-rich-link-emailBaseTable" cellpadding=3D"0" = cellspacing=3D"0" border=3D"0" width=3D"300"><tbody><tr><td = vertical-align=3D"center"><table bgcolor=3D"#E5E6E9" cellpadding=3D"0" = cellspacing=3D"0" width=3D"300" style=3D"font-family:-apple-system, = Helvetica, Arial, = sans-serif;table-layout:fixed;background-color:rgba(229, 230, 233, 1);" = class=3D"lp-rich-link-captionBar"><tbody><tr><td style=3D"padding:8px = 0px 8px 0px;" class=3D"lp-rich-link-captionBar-textStackItem"><div = style=3D"max-width:100%;margin:0px 16px 0px 16px;overflow:hidden;" = class=3D"lp-rich-link-captionBar-textStack"><div = style=3D"word-wrap:break-word;font-weight:500;font-size:12px;overflow:hidd= en;text-overflow:ellipsis;text-align:left;" = class=3D"lp-rich-link-captionBar-textStack-topCaption-leading"><a = rel=3D"nofollow" = href=3D"https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.ht= ml" style=3D"text-decoration: none" draggable=3D"false"><font = color=3D"#272727" style=3D"color: rgba(0, 0, 0, 0.847059);">MySQL :: = MySQL 8.4 Reference Manual :: 17.20.3 Forcing InnoDB = Recovery</font></a></div><div = style=3D"word-wrap:break-word;font-weight:400;font-size:11px;overflow:hidd= en;text-overflow:ellipsis;text-align:left;" = class=3D"lp-rich-link-captionBar-textStack-bottomCaption-leading"><a = rel=3D"nofollow" = href=3D"https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.ht= ml" style=3D"text-decoration: none" draggable=3D"false"><font = color=3D"#808080" style=3D"color: rgba(0, 0, 0, = 0.498039);">dev.mysql.com</font></a></div></div></td><td = style=3D"padding:6px 12px 6px 0px;" = class=3D"lp-rich-link-captionBar-rightIconItem" width=3D"36"><a = rel=3D"nofollow" = href=3D"https://dev.mysql.com/doc/refman/8.4/en/forcing-innodb-recovery.ht= ml" draggable=3D"false"><img style=3D"pointer-events:none = !important;display:inline-block;width:36px;height:36px;border-radius:3px;"= width=3D"36" height=3D"36" draggable=3D"false" = class=3D"lp-rich-link-captionBar-rightIcon" alt=3D"favicon.ico" = src=3D"cid:A8E0B575-2D2B-4A7D-A570-3DA0B0BD8A13"></a></td></tr></tbody></t= able></td></tr></tbody></table></a></div></div><br = id=3D"lineBreakAtBeginningOfMessage"><div>I've seen similar errors to = yours, but involving the InnoDB log files, e.g. ib_logfile0, which could = be safely moved to the side to have the MySQL recreate it/them upon = restart. But in your case it appears that it=E2=80=99s the ibdata files = what are corrupt, which are the "system=E2=80=99s tablespace=E2=80=9D = files, https://dba.stackexchange.com/a/27106, so I=E2=80=99d definitely = be more careful with = those.</div><div><br></div><div>HTH!</div><div><br><blockquote = type=3D"cite"><div>On Oct 10, 2024, at 4:08=E2=80=AFPM, Udo Pokojski = <freebsd@upokojski.de> wrote:</div><br = class=3D"Apple-interchange-newline"><div><div>Hallo,<br><br><br>after = doing an pkg update and pkg upgrade on FreeBSD 13.3, I cannot start the = mysql-server.<br><br>The command service mysql-server start returns no = error.<br><br><br>In the mysql error log, I can find the following = messages:<br><br>2024-10-10T19:55:15.913147Z 1 [System] [MY-013576] = [InnoDB] InnoDB initialization has = started.<br>2024-10-10T19:55:16.148244Z 1 [ERROR] [MY-012263] [InnoDB] = The Auto-extending innodb_system data file '/var/db/mysql/ibdata1' is of = a different size 768 pages (rounded down to MB) than specified in the = .cnf file: initial 8192 pages, max 0 (relevant if non-zero) = pages!<br>2024-10-10T19:55:16.148370Z 1 [ERROR] [MY-012930] [InnoDB] = Plugin initialization aborted with error Generic = error.<br>2024-10-10T19:55:16.149901Z 1 [ERROR] [MY-010334] [Server] = Failed to initialize DD Storage Engine<br>2024-10-10T19:55:16.150187Z 0 = [ERROR] [MY-010020] [Server] Data Dictionary initialization = failed.<br>2024-10-10T19:55:16.150233Z 0 [ERROR] [MY-010119] [Server] = Aborting<br><br><br>Something seems to wrong with my my.cnf file. The = only line which affects the innodb file size = is:<br><br>innodb_data_file_path = =3D ibdata1:128M:autoextend<br><br>I never changed = this line an In have no idea how to fix the error.<br><br>Any help is = appreciated.<br><br><br>Thanks in = advance,<br><br>Udo<br><br><br><br><br><br><br><br><br><br></div></div></b= lockquote></div><br></div></body></html>= --Apple-Mail=_7CECCF8A-07AD-4F4B-AF09-BF06CCE0E7D3 Content-Transfer-Encoding: base64 Content-Disposition: inline; filename=favicon.ico Content-Type: image/vnd.microsoft.icon; x-unix-mode=0666; name="favicon.ico" Content-Id: <A8E0B575-2D2B-4A7D-A570-3DA0B0BD8A13> AAABAAEAEBAAAAEACABoBQAAFgAAACgAAAAQAAAAIAAAAAEACAAAAAAAAAEAABILAAASCwAAAAEA AAABAAB0RQAAeEkAAHlLAAB6TAAAek0AAHtNAAB7TgAAfE4AAHxPAAB9UAAAflEAAH5SAAB/UgAA f1MAAIBUAACAVQAAgVUAAIJXAACEUwAAhFQAAIRVAACDWAAAg1kAAIRZAACEWgAAhVoAAIVbAACF WwEAhVwBAIddBACHXQUAhl0GAIddBgCHXgkAilsAAIheBwCIXwkAiWALAIpiDQCNZhIAjmcSAI5n EwCNZRQAjmYUAI9oFwCPaBgAj2kaAJZrHACTbScAlXEmAJdzKgCXcywAl3QsAJpyKQCYdCoAmHUu AKF7NwCgfzYAoH48AJp8QQCjhEcApIRAAKaHSgCoiUcAqIpPAKyPTwClilIAqYxRAKqNUwCpklUA qZBaAK+TXwCymF8ArpFgALCUaACxnGwAtpxsALifcgC7o3cAuqJ5AL+pgwDCrYoAxLCMAMWxjgDF sY8Ax7SSAMi1kwDLuZsAzLmcAMy6oADOvKEAz76jANC/pgDRwagA1cevANXHsADYyrQA2s28AN3Q vgDd0b4A3NDAAN7SxADf1McA4dbHAOTa0QDl3NAA5t3TAOri2QDr5N0A7+rnAPDr6QDx7OkA8e3q APLt6gD///8AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAcygbGxsVET4lATQ7HRsocygXFxsbDVBvTT1RIhcbGygbGxsbEjpTR2hdHRcXGxsXGxcbGwNT N0FyLg0bGxsbGxsXGxcNWiUmQg0bGxsXGxsbGxsbEVolFBEVGxcbGw00GxsbFwNZNhcbGRsbGxcV axsXGxQlZjEXGxsbGxcDVmAbFxcNXD4NFxkbGRkDOG8lGxsNRlUBFxsZGRkJL29AAxsXEWIsETAb GRkCMm9KAxcXDVhMATxPDQMNS21DAxsbDVNOAAMRBx1JaV8sBxcbGzVhFz9kZ2VsXjkNEhsbGxsr WGliRCsvIwMNFxcbFxcoRR0VBwMXFxcbGxsbGxsoSIABAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA= --Apple-Mail=_7CECCF8A-07AD-4F4B-AF09-BF06CCE0E7D3-- --Apple-Mail=_12ACA1C8-469D-4E69-B98F-E03D366F738E--
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?CBD261A5-6D51-47D0-9A89-CDA8205B62C1>