From nobody Wed May 10 16:24:20 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 4QGgMn03RKz4B6Vt for ; Wed, 10 May 2023 16:24:21 +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 4QGgMm2Ykrz46mR for ; Wed, 10 May 2023 16:24:20 +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=1683735860; 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=4IHnmHlVvaH9AAXWnQmyGjXZc7onmiBTO/jMSZOPcXY=; b=lTAwjKt4gnb+Agm59VK4svYT3+gfGZsRT8MleqtHBGj2tbKASOK6yHDJJ0rxW/F9rBY439 sDlEZoc1M5XjWiETf0qR5xvthnJkjPGvI+wx5DvN7hRiiIUkOzCAYFRRd4cvYzjOxvc3o6 kFhItxwp/CVr4201cLisNL8XifNIjcSWN1tsSZWMAHms9wnePL4WNP2mEgP6yK8+NX7P7d Edv6Ly2Dyj/HS3J/GA4bqPThJV+F7B9KQXarTd22d7gDwMsnKW0fF7YwWl+MvLXWZm2HwQ /tba6lxEPkYGAJrvi9IMtCmn3rfFp65K2gwFe0UQghpN9iz51Meoww0hjc6Q1g== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1683735860; a=rsa-sha256; cv=none; b=xZ3tZ8pC1MXaIQW+3meAFdl3s92SmUiOPW3oem5idgbWOd0sWQIE9Xil1kDWSMv0YmaLCo xZeh93PLQoknfoX8Xa0pXP8hkc8tRZLbELZgkxc9Ara967RXw56/Jy5LbSX8rSVNLGybXU +YooguEuZZ7Wpwxiy8Apx3IzWdOer4geQU1a4lySnuKqAb4L6ojRCWwHuoec4uCwQUD/+C Vo2MLxIH2PhUtBay3fw24F5scjluv2/xTB5Tuonx/NZkcWy/LPVs3E5rKGXSxjAlVKQHbV yf6blY869C+fUFAOs+bi+55NbXW3/i5zsuyr+6olUD6JzeXGzYbx6zWl0vqkNA== 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 4QGgMm1cVfzHsq for ; Wed, 10 May 2023 16:24:20 +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 34AGOKE8022442 for ; Wed, 10 May 2023 16:24:20 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from www@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 34AGOK1U022441 for ports-bugs@FreeBSD.org; Wed, 10 May 2023 16:24:20 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: Wed, 10 May 2023 16:24:20 +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: t.masub@gmail.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: cc 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 Toshimichi Masubuchi changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |t.masub@gmail.com --- Comment #1 from Toshimichi Masubuchi --- (In reply to Federico GDB from comment #0) Can you try with mysql80-server-8.0.32_3? Get the latest package from pkg.FreeBSD.org or build with ports. 8.0.32_3 does not depend on devel/libprotobuf and uses the bundled libproto= buf. It worked without setting the library symlink. [System] FreeBSD 13.2-RELEASE releng/13.2-n254617-525ecfdad597 GENERIC arm64 * I'm using "FreeBSD-13.2-RELEASE-arm64-aarch64-RPI.img" with QEMU 8.0. [Log] # cat /usr/local/etc/pkg/repos/FreeBSD.conf FreeBSD: { url: "pkg+http://pkg.FreeBSD.org/${ABI}/latest", mirror_type: "srv", signature_type: "fingerprints", fingerprints: "/usr/share/keys/pkg", enabled: yes } # pkg update # pkg search -d mysql80-server mysql80-server-8.0.32_3 Comment : Multithreaded SQL database (server) Depends on : groff-1.22.4_4 libfido2-1.13.0 perl5-5.32.1_3 curl-8.0.1 libunwind-20211201_2 libevent-2.1.12 libedit-3.1.20221030,1 icu-73.1,1 mysql80-client-8.0.32_2 hidapi-0.13.1 zstd-1.5.4_2 liblz4-1.9.4,1 # pkg install -y mysql80-server : # pkg check -dna Checking all packages: 100% # pkg info | grep -E "mysql|icu|protobuf" icu-73.1,1 International Components for Unicode (from I= BM) mysql80-client-8.0.32_2 Multithreaded SQL database (client) mysql80-server-8.0.32_3 Multithreaded SQL database (server) # ldd /usr/local/libexec/mysqld | grep -E "mysql|icu|protobuf" /usr/local/libexec/mysqld: libicuuc.so.73 =3D> /usr/local/lib/libicuuc.so.73 (0x5f7ec7c8d000) libicuio.so.73 =3D> /usr/local/lib/libicuio.so.73 (0x5f7ec8913000) libicudata.so.73 =3D> /usr/local/lib/libicudata.so.73 (0x5f7ec961b0= 00) libicui18n.so.73 =3D> /usr/local/lib/libicui18n.so.73 (0x5f7eca8f00= 00) libprotobuf-lite.so.3.19.4 =3D> /usr/local/libexec/../lib/mysql/private/libprotobuf-lite.so.3.19.4 (0x5f7ed03d9000) # cd /usr/local/etc/mysql # vi my.cnf # diff -uaN my.cnf.sample my.cnf --- my.cnf.sample 2023-05-04 14:33:01.000000000 +0900 +++ my.cnf 2023-05-09 22:11:40.985426000 +0900 @@ -17,7 +17,8 @@ replica-load-tmpdir =3D /var/db/mysql_tmpdir secure-file-priv =3D /var/db/mysql_secure log-bin =3D mysql-bin -log-output =3D TABLE +log-output =3D FILE +log-error =3D /var/log/mysqld.log relay-log-recovery =3D 1 slow-query-log =3D 1 server-id =3D 1 # touch /var/log/mysqld.log # chown mysql:mysql /var/log/mysqld.log # service mysql-server onerestart Starting mysql. # tail -20 /var/log/mysqld.log 2023-05-09T13:26:48.246457Z 0 [System] [MY-013169] [Server] /usr/local/libexec/mysqld (mysqld 8.0.32) initializing of server in progres= s as process 7534 mysqld: Error on delete of '/var/db/mysql/auto.cnf' (OS errno 2 - No such f= ile or directory) 2023-05-09T13:26:49.164984Z 0 [Warning] [MY-010107] [Server] World-writable config file '/var/db/mysql/auto.cnf' has been removed. 2023-05-09T13:26:49.401917Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-05-09T13:27:00.986712Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-05-09T13:27:21.811567Z 6 [Warning] [MY-010453] [Server] root@localhost= is created with an empty password ! Please consider switching off the --initialize-insecure option. 2023-05-09T13:28:26.6NZ mysqld_safe Logging to '/var/log/mysqld.log'. 2023-05-09T13:28:26.6NZ mysqld_safe Starting mysqld daemon with databases f= rom /var/db/mysql 2023-05-09T13:28:30.813555Z 0 [System] [MY-010116] [Server] /usr/local/libexec/mysqld (mysqld 8.0.32) starting as process 8735 2023-05-09T13:28:31.754402Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-05-09T13:28:40.646425Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-05-09T13:28:48.754023Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed. 2023-05-09T13:28:48.756725Z 0 [System] [MY-013602] [Server] Channel mysql_m= ain configured to support TLS. Encrypted connections are now supported for this channel. 2023-05-09T13:28:49.481964Z 0 [System] [MY-011323] [Server] X Plugin ready = for connections. Bind-address: '::' port: 33060, socket: /tmp/mysqlx.sock 2023-05-09T13:28:49.483049Z 0 [System] [MY-010931] [Server] /usr/local/libexec/mysqld: ready for connections. Version: '8.0.32' socket: '/tmp/mysql.sock' port: 3306 Source distribution. # mysql_secure_installation : # mysql -u root -p -e "SHOW GLOBAL VARIABLES LIKE 'log_error';" Enter password: +---------------+---------------------+ | Variable_name | Value | +---------------+---------------------+ | log_error | /var/log/mysqld.log | +---------------+---------------------+ --=20 You are receiving this mail because: You are the assignee for the bug.=