Date: Wed, 10 May 2023 16:24:20 +0000 From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 270807] databases/mysql80-server: mysqld got signal 4 Message-ID: <bug-270807-7788-336aoUmZrx@https.bugs.freebsd.org/bugzilla/> In-Reply-To: <bug-270807-7788@https.bugs.freebsd.org/bugzilla/> References: <bug-270807-7788@https.bugs.freebsd.org/bugzilla/>
next in thread | previous in thread | raw e-mail | index | archive | help
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D270807 Toshimichi Masubuchi <t.masub@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |t.masub@gmail.com --- Comment #1 from Toshimichi Masubuchi <t.masub@gmail.com> --- (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.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-270807-7788-336aoUmZrx>