[Bug 270807] databases/mysql80-server: mysqld got signal 4

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=270807

--- Comment #3 from Federico GDB <federicogalvezdurand@yahoo.com> ---
(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 progress 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 data
directory /var/db/mysql/ is unusable. You can remove all files that the server
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 progress as
process 53284
mysqld: Error on delete of '/var/db/mysql/auto.cnf' (OS errno 2 - No such file
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 
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                            = 3306
socket                          = /tmp/mysql.sock

[mysql]
prompt                          = \u@\h [\d]>\_
no_auto_rehash

[mysqld]
performance_schema              = off
user                            = mysql
port                            = 3306
socket                          = /tmp/mysql.sock
bind-address                    = 127.0.0.1
basedir                         = /usr/local
datadir                         = /var/db/mysql
tmpdir                          = /var/db/mysql_tmpdir
replica_load_tmpdir             = /var/db/mysql_tmpdir
secure-file-priv                = /var/db/mysql_secure
log-error                       = /var/log/mysqld.log
log-bin                         = mysql-bin
log-output                      = TABLE
relay-log-recovery              = 1
slow-query-log                  = 1
server-id                       = 1
sync_binlog                     = 1
sync_relay_log                  = 1
myisam-recover-options          = BACKUP,FORCE
binlog_expire_logs_seconds      = 2592000
default_password_lifetime       = 0
enforce-gtid-consistency        = 1
gtid-mode                       = ON
safe-user-create                = 1
lower_case_table_names          = 1
explicit-defaults-for-timestamp = 1

innodb_buffer_pool_size         = 8M
innodb_log_buffer_size          = 256K
max_connections                 = 10
key_buffer_size                 = 8
thread_cache_size               = 0
host_cache_size                 = 0
innodb_ft_cache_size            = 2097152
innodb_ft_total_cache_size      = 33554432

thread_stack                    = 135168
sort_buffer_size                = 32K
read_buffer_size                = 8192
read_rnd_buffer_size            = 8192
max_heap_table_size             = 16K
tmp_table_size                  = 1K
bulk_insert_buffer_size         = 0
join_buffer_size                = 128
net_buffer_length               = 1K
innodb_sort_buffer_size         = 64K

binlog_cache_size               = 4K
binlog_stmt_cache_size          = 4K

[mysqldump]
max_allowed_packet              = 256M
quote_names
quick

-- 
You are receiving this mail because:
You are the assignee for the bug.