From nobody Thu Oct 10 20:08:08 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 4XPgmh3rxMz5YYY5 for ; Thu, 10 Oct 2024 20:08:20 +0000 (UTC) (envelope-from freebsd@upokojski.de) Received: from server1.upokojski.de (server1.upokojski.de [IPv6:2a03:4000:35:1e7::]) by mx1.freebsd.org (Postfix) with ESMTP id 4XPgmg3qqnz4QPk for ; Thu, 10 Oct 2024 20:08:19 +0000 (UTC) (envelope-from freebsd@upokojski.de) Authentication-Results: mx1.freebsd.org; dkim=none; spf=pass (mx1.freebsd.org: domain of freebsd@upokojski.de designates 2a03:4000:35:1e7:: as permitted sender) smtp.mailfrom=freebsd@upokojski.de; dmarc=none Received: from [IPV6:2003:f1:871b:cc00:c5dd:d0b6:a781:3bfa] (p200300f1871bcc00c5ddd0b6a7813bfa.dip0.t-ipconnect.de [IPv6:2003:f1:871b:cc00:c5dd:d0b6:a781:3bfa]) by server1.upokojski.de (Postfix) with ESMTPSA id A37F45829B for ; Thu, 10 Oct 2024 22:08:07 +0200 (CEST) Message-ID: <2b663bca-5579-41c8-9db3-02bf87424d0f@upokojski.de> Date: Thu, 10 Oct 2024 22:08:08 +0200 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 User-Agent: Mozilla Thunderbird Content-Language: en-US From: Udo Pokojski Subject: Mysql-Server not starting To: freebsd-questions@freebsd.org Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit X-Spamd-Result: default: False [-3.07 / 15.00]; NEURAL_HAM_MEDIUM(-1.00)[-1.000]; NEURAL_HAM_LONG(-1.00)[-1.000]; NEURAL_HAM_SHORT(-0.98)[-0.977]; R_SPF_ALLOW(-0.20)[+mx]; ONCE_RECEIVED(0.10)[]; MIME_GOOD(-0.10)[text/plain]; RCVD_NO_TLS_LAST(0.10)[]; XM_UA_NO_VERSION(0.01)[]; FROM_HAS_DN(0.00)[]; TO_MATCH_ENVRCPT_ALL(0.00)[]; RCPT_COUNT_ONE(0.00)[1]; DMARC_NA(0.00)[upokojski.de]; RCVD_COUNT_ONE(0.00)[1]; RCVD_VIA_SMTP_AUTH(0.00)[]; ARC_NA(0.00)[]; TO_DN_NONE(0.00)[]; FROM_EQ_ENVFROM(0.00)[]; ASN(0.00)[asn:197540, ipnet:2a03:4000::/32, country:DE]; PREVIOUSLY_DELIVERED(0.00)[freebsd-questions@freebsd.org]; R_DKIM_NA(0.00)[]; MLMMJ_DEST(0.00)[freebsd-questions@freebsd.org]; MID_RHS_MATCH_FROM(0.00)[]; MIME_TRACE(0.00)[0:+] X-Rspamd-Queue-Id: 4XPgmg3qqnz4QPk X-Spamd-Bar: --- 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           = 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