From nobody Fri Oct 11 04:06:31 2024 X-Original-To: freebsd-questions@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4XPtNm2c1Vz5Z9Ml for ; Fri, 11 Oct 2024 04:06:48 +0000 (UTC) (envelope-from jmpalacios@gmail.com) Received: from mail-qt1-x829.google.com (mail-qt1-x829.google.com [IPv6:2607:f8b0:4864:20::829]) (using TLSv1.3 with cipher TLS_AES_128_GCM_SHA256 (128/128 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (2048 bits) client-digest SHA256) (Client CN "smtp.gmail.com", Issuer "WR4" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4XPtNl1MdQz4Pbh for ; Fri, 11 Oct 2024 04:06:47 +0000 (UTC) (envelope-from jmpalacios@gmail.com) Authentication-Results: mx1.freebsd.org; none Received: by mail-qt1-x829.google.com with SMTP id d75a77b69052e-460391553ecso14709911cf.1 for ; Thu, 10 Oct 2024 21:06:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1728619605; x=1729224405; darn=freebsd.org; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:from:to:cc:subject:date:message-id:reply-to; bh=KRmIuT2VVhz68BL91/HPUVC03ZEAbiiuz14aS24LkhY=; b=S1JWaR/c4I8vkE4K449ekXo7SZ++Hh6ivk49b1Lg086SikT26ukq32Gke/B44TuVAS RV3PcEU7RpAojHbNznnZs7hR5EYCj0uAnlYooHL2yBmFXkI2HgCs4q6yJAlI9IlMoUfl KfTX4Dv6sw3I7tORJ6RLsevk8Rn5dYj3FDUCFDh8Kdyny9zPO3eRGLciRUO+PbTgCFbt TQ81819XC23yF8aW+98n8yx6CRstqw5C/DRiDolz7IvTdwG9NMXQFUQVMHpEOLW1Oofn CfPKkjyEE2fUnGCaEJ5x/KeWGrM0VUWO9cMouvltzlqemuR5W2I2QN613nKEJnNrVOMD rw7A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1728619605; x=1729224405; h=references:to:cc:in-reply-to:date:subject:mime-version:message-id :from:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=KRmIuT2VVhz68BL91/HPUVC03ZEAbiiuz14aS24LkhY=; b=V/V+86dq7+qjfXxMUDXsnp7xCniQsOnJMk3ZNXwN9/4yIeKnXZyFqe4cCUuB1AV6qy 7JblK2erXSIiL1owf6bFvBP+Jz7a6pJ3KsrEOd831xdhkTp+bph1/bQnwCabSzh8j0O/ yuYgn313UOJ7X/cFmOqy+DIOn5G1L+Y60+8GXU001QjCgShM9mzz+mBi/2Ex1LmaDmgI +vme4H+bZWEEpZZ38XVfRtKIizW+ZaotqCMF+9hVPx+Uj32RT+6XAN/qpY7GXUTlIPrY cL1V2wgveBzZYKHKgkzinvknPhSsntINU0iqsp4DzkcuTq2a4pqdgFDtHw5apgdxteuv il4w== X-Gm-Message-State: AOJu0YwvkzDclT6UY73hBXvMBZ0ItIVJKv3drHLxVG7FuCPu7xc3PlF+ yxhlV7HebGOsLLvK64em+nEP2tJiIZFaXUyk3GuhDljir1nnjvxusoa0RQ== X-Google-Smtp-Source: AGHT+IEBYgy72keYtGuNmTMq2WDoo8CmrhbZ2a9idJyK0SehUaZx65dvbYgwE3brxGXshytciSElCw== X-Received: by 2002:a05:622a:110f:b0:45b:5e8d:981e with SMTP id d75a77b69052e-4604bc49c8bmr23461021cf.54.1728619605035; Thu, 10 Oct 2024 21:06:45 -0700 (PDT) Received: from smtpclient.apple ([2600:4041:7970:8b10:99e6:1e16:6ac0:6b7e]) by smtp.gmail.com with ESMTPSA id d75a77b69052e-46042802624sm11774971cf.53.2024.10.10.21.06.42 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Thu, 10 Oct 2024 21:06:43 -0700 (PDT) From: Juan Manuel Palacios Message-Id: Content-Type: multipart/alternative; boundary="Apple-Mail=_12ACA1C8-469D-4E69-B98F-E03D366F738E" List-Id: User questions List-Archive: https://lists.freebsd.org/archives/freebsd-questions List-Help: List-Post: List-Subscribe: List-Unsubscribe: X-BeenThere: freebsd-questions@freebsd.org Sender: owner-freebsd-questions@FreeBSD.org Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51.11.1\)) Subject: Re: Mysql-Server not starting Date: Fri, 11 Oct 2024 00:06:31 -0400 In-Reply-To: <2b663bca-5579-41c8-9db3-02bf87424d0f@upokojski.de> Cc: freebsd-questions@freebsd.org To: Udo Pokojski References: <2b663bca-5579-41c8-9db3-02bf87424d0f@upokojski.de> X-Mailer: Apple Mail (2.3776.700.51.11.1) X-Rspamd-Pre-Result: action=no action; module=replies; Message is reply to one we originated X-Spamd-Result: default: False [-4.00 / 15.00]; REPLY(-4.00)[]; ASN(0.00)[asn:15169, ipnet:2607:f8b0::/32, country:US] X-Rspamd-Queue-Id: 4XPtNl1MdQz4Pbh X-Spamd-Bar: ---- --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 = 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 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:

3D"favicon.ico"

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:

Hallo,


after = doing an pkg update and pkg upgrade on FreeBSD 13.3, I cannot start the = mysql-server.

The command service mysql-server start returns no = error.


In the mysql error log, I can find the following = messages:

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


Something seems to wrong with my my.cnf file. The = only line which affects the innodb file size = is:

innodb_data_file_path       =     =3D ibdata1:128M:autoextend

I never changed = this line an In have no idea how to fix the error.

Any help is = appreciated.


Thanks in = advance,

Udo










= --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: 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--