[24.03 SP3 RVA23] mariadb.service / mysqld.service 无法启动

【缺陷描述】
`mariadb.service`（或 `mysqld.service`，本质上是一个东西）无法启动
**一、缺陷信息**

**【缺陷所属的os版本】**
openEuler 24.03 LTS SP3 RVA23，QEMU EDK2 UEFI 和 U-Boot 版本镜像均可复现

https://repo.tarsier-infra.isrc.ac.cn/openEuler-RISC-V/testing/20251126/v0.2/QEMU/

**【内核版本】**
`Linux openeuler-riscv64 6.6.0-116.0.0.95.oe2403sp3.riscv64 #1 SMP Wed Nov 19 07:39:35 UTC 2025 riscv64 riscv64 riscv64 GNU/Linux`
**【缺陷所属软件及版本号】**
`mariadb-10.5.29-2.oe2403sp3.riscv64`
**【环境信息】**
硬件信息
qemu-system-riscv64 10.1.2

**【问题复现步骤】：请描述具体的操作步骤**
安装并启动 `mariadb.service` 或 `mysqld.service`
**【实际结果】**
正常初始化并启动
**【期望结果】**
未能启动，出现 `SIGILL` 非法指令
**【其他相关附件信息】**
这个问题是在 mugen 测试中发现的，RVA20 的测试用例是通过状态，而 RVA23 所有 mariadb 相关的用例都失败了，人工排查发现是无法启动。

```shell
dnf debuginfo-install -y mariadb-server-10.5.29-2.oe2403sp3.riscv64 glibc-2.38-77.oe2403sp3.riscv64; dnf install -y gdb
gdb --args mariadbd --user=root --verbose
```

```log
[root@openeuler-riscv64 ~]# gdb --args mysqld --user=root --verbose
GNU gdb (GDB) openEuler 14.1-11.oe2403sp3
Copyright (C) 2023 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
Type "show copying" and "show warranty" for details.
This GDB was configured as "riscv64-openEuler-linux-gnu".
Type "show configuration" for configuration details.
For bug reporting instructions, please see:
<https://www.gnu.org/software/gdb/bugs/>.
Find the GDB manual and other documentation resources online at:
    <http://www.gnu.org/software/gdb/documentation/>.

For help, type "help".
Type "apropos word" to search for commands related to "word"...
Reading symbols from mysqld...
Reading symbols from /usr/lib/debug//usr/libexec/mariadbd-10.5.29-2.oe2403sp3.riscv64.debug...
(gdb) r
Starting program: /usr/sbin/mysqld --user=root --verbose
[Thread debugging using libthread_db enabled]
Using host libthread_db library "/usr/lib64/libthread_db.so.1".
[New Thread 0x3ff7665060 (LWP 1603)]
2025-12-09 22:34:42 0 [Note] Starting MariaDB 10.5.29-MariaDB source revision c461188ca6ad6ec3a54201eb87ebd75797d296df server_uid w/xn1WGJE9viJGUAdPN7RDfmp0A= as process 1601
[New Thread 0x3ff5303060 (LWP 1604)]
2025-12-09 22:34:42 0 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
2025-12-09 22:34:42 0 [Note] InnoDB: Uses event mutexes
2025-12-09 22:34:42 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
2025-12-09 22:34:42 0 [Note] InnoDB: Number of pools: 1
2025-12-09 22:34:42 0 [Note] InnoDB: Using generic crc32 instructions
[New Thread 0x3fe1d1a060 (LWP 1605)]
2025-12-09 22:34:42 0 [Note] InnoDB: Using Linux native AIO
2025-12-09 22:34:42 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728
2025-12-09 22:34:42 0 [Note] InnoDB: Completed initialization of buffer pool
[New Thread 0x3fdafff060 (LWP 1606)]
2025-12-09 22:34:42 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 100663296 bytes

Thread 1 "mysqld" received signal SIGILL, Illegal instruction.
memset_aligned<512ul> (s=0x2aacf81800, c=0, n=512) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/include/assume_aligned.h:68
68        return std::memset(my_assume_aligned<Alignment>(s), c, n);
(gdb) bt
#0  memset_aligned<512ul> (s=0x2aacf81800, c=0, n=512) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/include/assume_aligned.h:68
#1  log_t::file::write_header_durable (this=this@entry=0x2aaca53140 <log_sys+256>, lsn=lsn@entry=8704)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/log/log0log.cc:499
#2  0x0000002aab0f6f5a in create_log_file (create_new_db=create_new_db@entry=true, lsn=8704, logfile0="./ib_logfile101")
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/srv/srv0start.cc:325
#3  0x0000002aab7131a6 in srv_start (create_new_db=true) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/srv/srv0start.cc:1331
#4  0x0000002aab650278 in innodb_init (p=<optimized out>) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/handler/ha_innodb.cc:4070
#5  0x0000002aab3b9f96 in ha_initialize_handlerton (plugin_=0x2aacaeaaa0) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/handler.cc:648
#6  0x0000002aab1ec9e4 in plugin_do_initialize (plugin=0x2aacaeaaa0, state=@0x3fffffca34: 4)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/sql_plugin.cc:1452
#7  0x0000002aab1f1842 in plugin_initialize (tmp_root=tmp_root@entry=0x3fffffd068, plugin=plugin@entry=0x2aacaeaaa0, 
    argc=argc@entry=0x2aac1add30 <remaining_argc>, argv=argv@entry=0x2aacaace58, options_only=<optimized out>)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/sql_plugin.cc:1506
#8  0x0000002aab1f2b02 in plugin_init (argc=argc@entry=0x2aac1add30 <remaining_argc>, argv=<optimized out>, flags=0)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/sql_plugin.cc:1761
#9  0x0000002aab12bf00 in init_server_components () at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/mysqld.cc:4954
#10 0x0000002aab131936 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/mysqld.cc:5562
#11 0x0000003ff76cb93c in __libc_start_call_main (main=main@entry=0x2aab0ff256 <main(int, char**)>, argc=argc@entry=3, argv=argv@entry=0x3ffffff458)
    at ../sysdeps/nptl/libc_start_call_main.h:58
#12 0x0000003ff76cb9e4 in __libc_start_main_impl (main=0x2aab0ff256 <main(int, char**)>, argc=3, argv=0x3ffffff458, init=<optimized out>, 
    fini=<optimized out>, rtld_fini=<optimized out>, stack_end=<optimized out>) at libc-start.c:360
#13 0x0000002aab127604 in _start ()
(gdb) x/i $pc
=> 0x2aab68f414 <_ZN5log_t4file20write_header_durableEm+52>:    .insn   4, 0x0044a00f
(gdb) disassemble $pc
Dump of assembler code for function _ZN5log_t4file20write_header_durableEm:
   0x0000002aab68f3e0 <+0>:     addi    sp,sp,-80
   0x0000002aab68f3e2 <+2>:     sd      s0,64(sp)
   0x0000002aab68f3e4 <+4>:     sd      s2,48(sp)
   0x0000002aab68f3e6 <+6>:     sd      s3,40(sp)
   0x0000002aab68f3e8 <+8>:     sd      ra,72(sp)
   0x0000002aab68f3ea <+10>:    sd      s1,56(sp)
   0x0000002aab68f3ec <+12>:    addi    s0,sp,80
   0x0000002aab68f3ee <+14>:    auipc   s3,0x13c4
   0x0000002aab68f3f2 <+18>:    addi    s3,s3,-942 # 0x2aaca53040 <log_sys>
   0x0000002aab68f3f6 <+22>:    ld      s1,456(s3)
   0x0000002aab68f3fa <+26>:    auipc   s2,0xa68
   0x0000002aab68f3fe <+30>:    ld      s2,46(s2) # 0x2aac0f7428
   0x0000002aab68f402 <+34>:    ld      a4,0(s2)
   0x0000002aab68f406 <+38>:    sd      a4,-56(s0)
   0x0000002aab68f40a <+42>:    li      a4,0
   0x0000002aab68f40c <+44>:    andi    a5,s1,511
   0x0000002aab68f410 <+48>:    bnez    a5,0x2aab68f552 <_ZN5log_t4file20write_header_durableEm+370>
=> 0x0000002aab68f414 <+52>:    .insn   4, 0x0044a00f
   0x0000002aab68f418 <+56>:    addi    a5,s1,64
   0x0000002aab68f41c <+60>:    .insn   4, 0x0047a00f
   0x0000002aab68f420 <+64>:    addi    a5,s1,128
   0x0000002aab68f424 <+68>:    .insn   4, 0x0047a00f
   0x0000002aab68f428 <+72>:    addi    a5,s1,192
   0x0000002aab68f42c <+76>:    .insn   4, 0x0047a00f
   0x0000002aab68f430 <+80>:    addi    a5,s1,256
   0x0000002aab68f434 <+84>:    .insn   4, 0x0047a00f
   0x0000002aab68f438 <+88>:    addi    a5,s1,320
   0x0000002aab68f43c <+92>:    .insn   4, 0x0047a00f
   0x0000002aab68f440 <+96>:    addi    a5,s1,384
   0x0000002aab68f444 <+100>:   .insn   4, 0x0047a00f
   0x0000002aab68f448 <+104>:   addi    a5,s1,448
   0x0000002aab68f44c <+108>:   .insn   4, 0x0047a00f
   0x0000002aab68f450 <+112>:   auipc   a5,0x13c4
   0x0000002aab68f454 <+116>:   lw      a5,-784(a5) # 0x2aaca53140 <log_sys+256>
   0x0000002aab68f458 <+120>:   .insn   4, 0xcc087057
   0x0000002aab68f45c <+124>:   auipc   a4,0x30c
   0x0000002aab68f460 <+128>:   addi    a4,a4,1716 # 0x2aab99bb10
   0x0000002aab68f464 <+132>:   .insn   4, 0x02070087
   0x0000002aab68f468 <+136>:   srliw   a2,a5,0x18
   0x0000002aab68f46c <+140>:   srliw   a3,a5,0x10
   0x0000002aab68f470 <+144>:   srliw   a4,a5,0x8
   0x0000002aab68f474 <+148>:   .insn   2, 0x8890
   0x0000002aab68f476 <+150>:   .insn   2, 0x88d4
   0x0000002aab68f478 <+152>:   .insn   2, 0x88b8
   0x0000002aab68f47a <+154>:   .insn   2, 0x88fc
   0x0000002aab68f47c <+156>:   auipc   a5,0x13c4
   0x0000002aab68f480 <+160>:   lw      a5,-824(a5) # 0x2aaca53144 <log_sys+260>
   0x0000002aab68f484 <+164>:   srli    t1,a1,0x38
   0x0000002aab68f488 <+168>:   srli    a7,a1,0x30
   0x0000002aab68f48c <+172>:   srliw   t5,a5,0x18
   0x0000002aab68f490 <+176>:   srliw   t4,a5,0x10
   0x0000002aab68f494 <+180>:   srliw   t3,a5,0x8
   0x0000002aab68f498 <+184>:   srli    a6,a1,0x28
   0x0000002aab68f49c <+188>:   srli    a0,a1,0x20
   0x0000002aab68f4a0 <+192>:   srli    a2,a1,0x18
   0x0000002aab68f4a4 <+196>:   srli    a3,a1,0x10
   0x0000002aab68f4a8 <+200>:   srli    a4,a1,0x8
   0x0000002aab68f4ac <+204>:   sb      a5,7(s1)
--Type <RET> for more, q to quit, c to continue without paging--q
Quit
(gdb) c
Continuing.
251209 22:35:09 [ERROR] /usr/sbin/mysqld got signal 4 ;
Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.
To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report
a bug on https://jira.mariadb.org/.

Please include the information from the server start above, to the end of the
information below.

Server version: 10.5.29-MariaDB source revision: c461188ca6ad6ec3a54201eb87ebd75797d296df

The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/
contains instructions to obtain a better version of the backtrace below.
Following these instructions will help MariaDB developers provide a fix quicker.

Attempting backtrace. Include this in the bug report.
(note: Retrieving this information may fail)

Thread pointer: 0x0
stack_bottom = 0x0 thread_stack 0x49000
[Detaching after fork from child process 1607]
/usr/sbin/mysqld(my_print_stacktrace+0x4c)[0x2aab850e74]
/usr/sbin/mysqld(handle_fatal_signal+0x268)[0x2aab3b7378]
[Detaching after fork from child process 1608]
addr2line: 'linux-vdso.so.1': No such file
linux-vdso.so.1(__vdso_rt_sigreturn+0x0)[0x3ff7fdd800]
[Detaching after fork from child process 1609]
/usr/sbin/mysqld(+0xbe5414)[0x2aab68f414]
/usr/sbin/mysqld(+0x64cf5a)[0x2aab0f6f5a]
/usr/sbin/mysqld(+0xc691a6)[0x2aab7131a6]
/usr/sbin/mysqld(+0xba6278)[0x2aab650278]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonPv+0x66)[0x2aab3b9f96]
/usr/sbin/mysqld(+0x7429e4)[0x2aab1ec9e4]
/usr/sbin/mysqld(+0x747842)[0x2aab1f1842]
bits/string_fortified.h:59(log_t::file::write_header_durable(unsigned long))[0x2aab1f2b02]
srv/srv0start.cc:328(create_log_file(bool, unsigned long, std::__cxx11::basic_string<char, std::char_traits<char>, std::allocator<char> >&))[0x2aab12bf00]
handler/ha_innodb.cc:4072(innodb_init(void*))[0x2aab131936]
[Detaching after fork from child process 1616]
csu/libc-start.c:74(__libc_start_call_main)[0x3ff76cb93c]
csu/libc-start.c:128(call_init)[0x3ff76cb9e4]
[Detaching after fork from child process 1617]
/usr/sbin/mysqld(_start+0x20)[0x2aab127604]
Writing a core file...
Working directory at /var/lib/mysql
Resource Limits (excludes unlimited resources):
Limit                     Soft Limit           Hard Limit           Units     
Max stack size            8388608              unlimited            bytes     
Max processes             31170                31170                processes 
Max open files            32190                32190                files     
Max locked memory         67108864             67108864             bytes     
Max pending signals       31170                31170                signals   
Max msgqueue size         819200               819200               bytes     
Max nice priority         0                    0                    
Max realtime priority     0                    0                    
Core pattern: |/usr/lib/systemd/systemd-coredump %P %u %g %s %t %c %h %d

Kernel version: Linux version 6.6.0-116.0.0.95.oe2403sp3.riscv64 (abuild@openeuler-riscv64) (gcc_old (GCC) 14.3.1 20250523 (openEuler 14.3.1-9.oe2403sp3), GNU ld (GNU Binutils) 2.42) #1 SMP Wed Nov 19 07:39:35 UTC 2025

Thread 1 "mysqld" received signal SIGILL, Illegal instruction.
0x0000003ff76da508 in __GI_kill () at ../sysdeps/unix/syscall-template.S:120
120     T_PSEUDO (SYSCALL_SYMBOL, SYSCALL_NAME, SYSCALL_NARGS)
(gdb) bt
#0  0x0000003ff76da508 in __GI_kill () at ../sysdeps/unix/syscall-template.S:120
#1  0x0000002aab3b732e in handle_fatal_signal (sig=4) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/signal_handler.cc:309
#2  <signal handler called>
#3  memset (__dest=0x2aacf81800, __ch=0, __len=512) at /usr/include/bits/string_fortified.h:59
#4  memset_aligned<512ul> (s=0x2aacf81800, c=0, n=512) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/include/assume_aligned.h:68
#5  log_t::file::write_header_durable (this=this@entry=0x2aaca53140 <log_sys+256>, lsn=lsn@entry=8704)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/log/log0log.cc:499
#6  0x0000002aab0f6f5a in create_log_file (create_new_db=create_new_db@entry=true, lsn=8704, logfile0="./ib_logfile101")
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/srv/srv0start.cc:325
#7  0x0000002aab7131a6 in srv_start (create_new_db=true) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/srv/srv0start.cc:1331
#8  0x0000002aab650278 in innodb_init (p=<optimized out>) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/storage/innobase/handler/ha_innodb.cc:4070
#9  0x0000002aab3b9f96 in ha_initialize_handlerton (plugin_=0x2aacaeaaa0) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/handler.cc:648
#10 0x0000002aab1ec9e4 in plugin_do_initialize (plugin=0x2aacaeaaa0, state=@0x3fffffca34: 4)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/sql_plugin.cc:1452
#11 0x0000002aab1f1842 in plugin_initialize (tmp_root=tmp_root@entry=0x3fffffd068, plugin=plugin@entry=0x2aacaeaaa0, 
    argc=argc@entry=0x2aac1add30 <remaining_argc>, argv=argv@entry=0x2aacaace58, options_only=<optimized out>)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/sql_plugin.cc:1506
#12 0x0000002aab1f2b02 in plugin_init (argc=argc@entry=0x2aac1add30 <remaining_argc>, argv=<optimized out>, flags=0)
    at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/sql_plugin.cc:1761
#13 0x0000002aab12bf00 in init_server_components () at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/mysqld.cc:4954
#14 0x0000002aab131936 in mysqld_main (argc=<optimized out>, argv=<optimized out>) at /usr/src/debug/mariadb-10.5.29-2.oe2403sp3.riscv64/sql/mysqld.cc:5562
#15 0x0000003ff76cb93c in __libc_start_call_main (main=main@entry=0x2aab0ff256 <main(int, char**)>, argc=argc@entry=3, argv=argv@entry=0x3ffffff458)
    at ../sysdeps/nptl/libc_start_call_main.h:58
#16 0x0000003ff76cb9e4 in __libc_start_main_impl (main=0x2aab0ff256 <main(int, char**)>, argc=3, argv=0x3ffffff458, init=<optimized out>, 
    fini=<optimized out>, rtld_fini=<optimized out>, stack_end=<optimized out>) at libc-start.c:360
#17 0x0000002aab127604 in _start ()
(gdb) x/i $pc
=> 0x3ff76da508 <__GI_kill+8>:  lui     a7,0xfffff
(gdb) disassemble $pc
Dump of assembler code for function __GI_kill:
   0x0000003ff76da500 <+0>:     li      a7,129
   0x0000003ff76da504 <+4>:     ecall
=> 0x0000003ff76da508 <+8>:     lui     a7,0xfffff
   0x0000003ff76da50a <+10>:    bltu    a7,a0,0x3ff76da510 <__GI_kill+16>
   0x0000003ff76da50e <+14>:    ret
   0x0000003ff76da510 <+16>:    j       0x3ff76cba58 <__syscall_error>
   0x0000003ff76da514 <+20>:    ret
   0x0000003ff76da516 <+22>:    unimp
   0x0000003ff76da518 <+0>:     li      a7,136
End of assembler dump.
```

openEuler/RISC-V

内容风险标识

评论 (7)

openEuler/RISC-V .gitee-modal { width: 500px !important; }

内容风险标识