[Bug 280165] mysqld SIGILL with mysql80-server-8.0.35_1 and mysql81-server-8.1.0 with FreeBSD 14.1

From: <bugzilla-noreply_at_freebsd.org>
Date: Sat, 06 Jul 2024 22:44:39 UTC
https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=280165

            Bug ID: 280165
           Summary: mysqld SIGILL with mysql80-server-8.0.35_1 and
                    mysql81-server-8.1.0 with FreeBSD 14.1
           Product: Ports & Packages
           Version: Latest
          Hardware: arm64
                OS: Any
            Status: New
          Severity: Affects Some People
          Priority: ---
         Component: Individual Port(s)
          Assignee: ports-bugs@FreeBSD.org
          Reporter: steinhelten@gmail.com

For both mysql80-server and mysql81-server I get


024-07-06T22:32:23.099644Z 1 [System] [MY-013576] [InnoDB] InnoDB
initialization has started.
2024-07-06T22:32:32Z UTC - mysqld got signal 4 ;
Most likely, you have hit a bug, but this error can also be caused by
malfunctioning hardware.
Thread pointer: 0x7e44949d7000
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...
[0x22eb778] +0x0
[0x22eb8dc] +0x0
[0x85650e48] +0x0
[0x85650594] +0x0
[0x841081a4] +0x0
[0x3092db8] +0x0
[0x2f95e2c] +0x0
[0x2f960c0] +0x0
[0x2f90ac8] +0x0
[0x2f92680] +0x0
[0x2f9e010] +0x0
[0x3045ee8] +0x0
[0x2d9bd20] +0x0
[0x2ba010c] +0x0
[0x2ba68f4] +0x0
[0x1fb8550] +0x0
[0x30f3b04] +0x0
[0x856463a0] +0x0
stack_bottom = 940f0e90 thread_stack 0x100000
0x2d508d8 <_Z19my_print_stacktracePKhm+0x13c> at /usr/local/libexec/mysqld
0x22eb778 <_Z18print_fatal_signali+0x25c> at /usr/local/libexec/mysqld
0x22eb8dc <handle_fatal_signal+0x40> at /usr/local/libexec/mysqld
0x85650e48 <pthread_sigmask+0x534> at /lib/libthr.so.3

Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): 
Connection ID (thread ID): 1
Status: NOT_KILLED
...
/usr/local/etc/rc.d/mysql-server: WARNING: failed precmd routine for mysql

(well, obviously, the addresses very slightly between 8.1 and 8.0 - this is
8.0)

The ONLY change I've made in the my.cnf file is
innodb_buffer_pool_size         = 64M
(I mean, come on, how can I afford 1G on a Raspberry Pi 3Plus?  It only HAS 1GB
of RAM)
which I have used successfully on FreeBSD 13.1 with mysql 5.7 which is not
available in pkgs for FreeBSD 14.1


# uname -a
FreeBSD remo 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8
GENERIC arm64

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