[Bug 270807] databases/mysql80-server: mysqld got signal 4
Date: Wed, 10 May 2023 16:24:20 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=270807
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 libprotobuf.
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 IBM)
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 => /usr/local/lib/libicuuc.so.73 (0x5f7ec7c8d000)
libicuio.so.73 => /usr/local/lib/libicuio.so.73 (0x5f7ec8913000)
libicudata.so.73 => /usr/local/lib/libicudata.so.73 (0x5f7ec961b000)
libicui18n.so.73 => /usr/local/lib/libicui18n.so.73 (0x5f7eca8f0000)
libprotobuf-lite.so.3.19.4 =>
/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 = /var/db/mysql_tmpdir
secure-file-priv = /var/db/mysql_secure
log-bin = mysql-bin
-log-output = TABLE
+log-output = FILE
+log-error = /var/log/mysqld.log
relay-log-recovery = 1
slow-query-log = 1
server-id = 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 progress as
process 7534
mysqld: Error on delete of '/var/db/mysql/auto.cnf' (OS errno 2 - No such file
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 from
/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_main
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 |
+---------------+---------------------+
--
You are receiving this mail because:
You are the assignee for the bug.