Date: Sun, 21 May 2023 17:43:10 +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-cJ9uL6tDft@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 --- 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 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.=
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?bug-270807-7788-cJ9uL6tDft>