From nobody Sun May 21 17:43:10 2023 X-Original-To: ports-bugs@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 4QPSbf1JSbz4CG3C for ; Sun, 21 May 2023 17:43:10 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4QPSbd62qZz3nr1 for ; Sun, 21 May 2023 17:43:09 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1684690989; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references; bh=m/H2wmVefiWHxPP93AcrGM6B6WLVftCE/SG+ekBpn4A=; b=rDcgdtQ22TzbJKsj14zm1QoHcZFrI5ZS2mBp7yv8zx3Uh+UiocN7XSEP1Oq7NjHAAJLpyM e6UhkbsjdjzS6TGD77s9w93f5f6uVSRKtLmdIX3cPYnGTaU2tIIwXXppmfhyYzyEfYQVb1 XKLD8lvPR+FksAzINnIJF5FoPqLBQ94lcTAblK/uAqJ0Rz8mnGciBXumsggBdhVs6+o42Z QWGxLhNCLrpJkDWMbHBcgXWvFh2c+VDe92CRpLCOLCiscFuuBOc5ZdKqsyfVjeTYcmFdZ9 WOYG6j5TzI08udquUljl717x6TlJZu52sIirYDCShybzb3nKPouWYtUsBmURQA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1684690989; a=rsa-sha256; cv=none; b=f2jTds81FvT30Zf1naVCv2EtoOuWv31I6Gdfmc756pSY6avB3C29iC+UGv8FBg3RlzxCVj aBcxdoJ8LciiTY0IlwSVngJEBIwVDDeZtfEr/XlgLdXsGNadko+Q/H45oYfuyJIXxoeLKG h4ihrUm2Z7yAOjR4o5tS44y5jNE22APkBdNsBjbFQ7kLTNyagpKLINVvBO8Um3kJUrZTXU DMtqJN6B9rKAPVCgPjWErMm6Jcxd5d5EyyP5tlLjWbiBwRnv6FSWLeSB1sajJXrkWCwA+y VEpgPWK7IaGoYXSeQQhEa4GxjnJ27lJoXAXIaSerLdaRQP4sBpf3Xb4yj40HVg== Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4QPSbd58Fsz11Kt for ; Sun, 21 May 2023 17:43:09 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 34LHh90I046479 for ; Sun, 21 May 2023 17:43:09 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 34LHh912046478 for ports-bugs@FreeBSD.org; Sun, 21 May 2023 17:43:09 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: www set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 270807] databases/mysql80-server: mysqld got signal 4 Date: Sun, 21 May 2023 17:43:10 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Many People X-Bugzilla-Who: federicogalvezdurand@yahoo.com X-Bugzilla-Status: Open X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: maintainer-feedback? X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D270807 --- Comment #3 from Federico GDB --- (In reply to Toshimichi Masubuchi from comment #1) Thank you for your input. Unfortunaltely, it does not seem related to devel/libprotobuf. *** It fails the same way. *** # rm -r /var/db/mysql # sudo service mysql-server start /usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql # cat /var/log/mysqld.log 2023-05-21T12:29:01.919788Z 0 [System] [MY-013169] [Server] /usr/local/libexec/mysqld (mysqld 8.0.32) initializing of server in progres= s as process 53267 2023-05-21T12:29:01.925560Z 0 [ERROR] [MY-010457] [Server] --initialize specified but the data directory has files in it. Aborting. 2023-05-21T12:29:01.925648Z 0 [ERROR] [MY-013236] [Server] The designated d= ata directory /var/db/mysql/ is unusable. You can remove all files that the ser= ver added to it. 2023-05-21T12:29:01.925770Z 0 [ERROR] [MY-010119] [Server] Aborting 2023-05-21T12:29:01.926043Z 0 [System] [MY-010910] [Server] /usr/local/libexec/mysqld: Shutdown complete (mysqld 8.0.32) Source distribution. 2023-05-21T12:29:29.121399Z 0 [System] [MY-013169] [Server] /usr/local/libexec/mysqld (mysqld 8.0.32) initializing of server in progres= s as process 53284 mysqld: Error on delete of '/var/db/mysql/auto.cnf' (OS errno 2 - No such f= ile or directory) 2023-05-21T12:29:29.138963Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/db/mysql/auto.cnf' has been removed. 2023-05-21T12:29:29.158451Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-05-21T12:29:30Z UTC - mysqld got signal 4 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x98d58000 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Fatal signal 11 while backtracing *** Background *** # uname -a FreeBSD rpi4.local 13.2-RELEASE FreeBSD 13.2-RELEASE releng/13.2-n254617-525ecfdad597 GENERIC arm64 # sudo pkg info | grep mysql80=20 mysql80-client-8.0.32_2 Multithreaded SQL database (client) mysql80-server-8.0.32_3 Multithreaded SQL database (server) #sudo pkg check -dna Checking all packages: 100% This my.cnf works with mysql80-server-8.0.26 # cat /usr/local/etc/mysql/my.cnf [client] port =3D 3306 socket =3D /tmp/mysql.sock [mysql] prompt =3D \u@\h [\d]>\_ no_auto_rehash [mysqld] performance_schema =3D off user =3D mysql port =3D 3306 socket =3D /tmp/mysql.sock bind-address =3D 127.0.0.1 basedir =3D /usr/local datadir =3D /var/db/mysql tmpdir =3D /var/db/mysql_tmpdir replica_load_tmpdir =3D /var/db/mysql_tmpdir secure-file-priv =3D /var/db/mysql_secure log-error =3D /var/log/mysqld.log log-bin =3D mysql-bin log-output =3D TABLE relay-log-recovery =3D 1 slow-query-log =3D 1 server-id =3D 1 sync_binlog =3D 1 sync_relay_log =3D 1 myisam-recover-options =3D BACKUP,FORCE binlog_expire_logs_seconds =3D 2592000 default_password_lifetime =3D 0 enforce-gtid-consistency =3D 1 gtid-mode =3D ON safe-user-create =3D 1 lower_case_table_names =3D 1 explicit-defaults-for-timestamp =3D 1 innodb_buffer_pool_size =3D 8M innodb_log_buffer_size =3D 256K max_connections =3D 10 key_buffer_size =3D 8 thread_cache_size =3D 0 host_cache_size =3D 0 innodb_ft_cache_size =3D 2097152 innodb_ft_total_cache_size =3D 33554432 thread_stack =3D 135168 sort_buffer_size =3D 32K read_buffer_size =3D 8192 read_rnd_buffer_size =3D 8192 max_heap_table_size =3D 16K tmp_table_size =3D 1K bulk_insert_buffer_size =3D 0 join_buffer_size =3D 128 net_buffer_length =3D 1K innodb_sort_buffer_size =3D 64K binlog_cache_size =3D 4K binlog_stmt_cache_size =3D 4K [mysqldump] max_allowed_packet =3D 256M quote_names quick --=20 You are receiving this mail because: You are the assignee for the bug.=