Wind River Support Network

HomeDefectsLIN1024-3527
Fixed

LIN1024-3527 : mariadb: start mysqld.service failed with qemuriscv64

Created: Aug 27, 2024    Updated: Oct 8, 2024
Resolved Date: Sep 12, 2024
Found In Version: 10.24.33.1
Severity: Standard
Applicable for: Wind River Linux LTS 24
Component/s: Userspace

Description

Steps:

1) build
setup.sh --machine qemuriscv64 --dl-layers --distros wrlinux --templates feature/LAMP feature/grpc feature/ipv6 feature/mariadb feature/ntp feature/package-management feature/sftp-server feature/syslog-ng feature/system-stats feature/target-toolchain feature/tcpslice

2) 
source environment-setup-x86_64-wrlinuxsdk-linux
source oe-init-build-env build

3) modify conf/local.conf
DISTRO_FEATURES:append = " pam"
CUSTOMER_RECIPES:meta-python += "python3-grpcio"
DISTRO_FEATURES:append = " ldap"
DISTRO_FEATURES:append = " libcap-ng"
DISTRO_FEATURES:append = " polkit x11"
PACKAGECONFIG:append:pn-systemd = " coredump"
WRLINUX_SUPPORTED_RECIPE:pn-python3-grpcio-tools = "1"

4) bitbake wrlinux-image-std

 

Failure:

root@qemuriscv64:~# sed -i 's/skip-networking/#skip-networking/g' /etc/my.cnf
root@qemuriscv64:~# sed -i 's/bind-address/#bind-address/g' /etc/my.cnf
root@qemuriscv64:~# systemctl start mysqld.service
[ 1456.918172] mariadbd[12115]: unhandled signal 4 code 0x1 at 0x000055558689d134 in mariadbd[555585bfa000+14a7000]
[ 1456.921772] CPU: 1 PID: 12115 Comm: mariadbd Not tainted 6.6.43-yocto-standard #1
[ 1456.922327] Hardware name: riscv-virtio,qemu (DT)
[ 1456.923045] epc : 000055558689d134 ra : 000055558620ea48 sp : 00007fffdc487770
[ 1456.923525]  gp : 00005555872ec400 tp : 00007fff89560780 t0 : 0000555587be32e8
[ 1456.923951]  t1 : 0000555586886042 t2 : 000000002d6a89f0 s0 : 00007fffdc4877b0
[ 1456.924371]  s1 : 00005555872ebc08 a0 : 00005555872f1d38 a1 : 0000000000000000
[ 1456.924855]  a2 : 00007fffdc487778 a3 : 0000000000000000 a4 : 0000555587248468
[ 1456.925275]  a5 : 000000003b9aca00 a6 : 0000000000000002 a7 : 0000000000000001
[ 1456.925690]  s2 : 00005555872f1d38 s3 : 00007fff89e8bd08 s4 : 0000000000000001
[ 1456.926111]  s5 : 0000555587b68680 s6 : 0000555587bb1670 s7 : 00005555872eedb0
[ 1456.926634]  s8 : 00007fff89e8c008 s9 : 0000000000000040 s10: 000055557f2bcfac
[ 1456.927327]  s11: 000055557f2bcf20 t3 : 00007fff89e762f4 t4 : 000000000060000a
[ 1456.927762]  t5 : 0000000000000001 t6 : ffffffffffffffff
[ 1456.928085] status: 0000000200004020 badaddr: 00000000c00027f3 cause: 0000000000000002

^C
root@qemuriscv64:~#
root@qemuriscv64:~# journalctl -xeu mysqld.service
-- The unit mysqld.service completed and consumed the indicated resources.
Aug 27 09:13:20 qemuriscv64 systemd[1]: Starting MariaDB database server...
-- Subject: A start job for unit mysqld.service has begun execution
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- A start job for unit mysqld.service has begun execution.
-- 
-- The job identifier is 1604.
Aug 27 09:13:23 qemuriscv64 mysqld_safe[11984]: 240827 09:13:23 mysqld_safe Logging to '/var/log/mysqld.log'.
Aug 27 09:13:25 qemuriscv64 mysqld_safe[11984]: 240827 09:13:25 mysqld_safe Starting mariadbd daemon with databases from /var/lib/mysql
Aug 27 09:18:20 qemuriscv64 systemd[1]: mysqld.service: start-post operation timed out. Terminating.
Aug 27 09:18:20 qemuriscv64 systemd[1]: mysqld.service: Control process exited, code=killed, status=15/TERM
-- Subject: Unit process exited
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- An ExecStartPost= process belonging to unit mysqld.service has exited.
-- 
-- The process' exit code is 'killed' and its exit status is 15.
Aug 27 09:18:20 qemuriscv64 systemd[1]: mysqld.service: Failed with result 'timeout'.
-- Subject: Unit failed
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- The unit mysqld.service has entered the 'failed' state with result 'timeout'.
Aug 27 09:18:20 qemuriscv64 systemd[1]: Failed to start MariaDB database server.
-- Subject: A start job for unit mysqld.service has failed
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- A start job for unit mysqld.service has finished with a failure.
-- 
-- The job identifier is 1604 and the job result is failed.
Aug 27 09:18:20 qemuriscv64 systemd[1]: mysqld.service: Consumed 1min 22.664s CPU time, 5.5M memory peak, 0B memory swap peak.
-- Subject: Resources consumed by unit runtime
-- Defined-By: systemd
-- Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
-- 
-- The unit mysqld.service completed and consumed the indicated resources.
root@qemuriscv64:~# 

Steps to Reproduce

1) build
--machine qemuriscv64 --dl-layers  --distros wrlinux --templates feature/LAMP feature/grpc feature/ipv6 feature/mariadb feature/ntp feature/package-management feature/sftp-server feature/syslog-ng feature/system-stats feature/target-toolchain feature/tcpslice

2) 
source environment-setup-x86_64-wrlinuxsdk-linux
source oe-init-build-env build

3) modify conf/local.conf
DISTRO_FEATURES:append = " pam"
CUSTOMER_RECIPES:meta-python += "python3-grpcio"
DISTRO_FEATURES:append = " ldap"
DISTRO_FEATURES:append = " libcap-ng"
DISTRO_FEATURES:append = " polkit x11"
PACKAGECONFIG:append:pn-systemd = " coredump"
WRLINUX_SUPPORTED_RECIPE:pn-python3-grpcio-tools = "1"

4) bitbake wrlinux-image-std
Live chat
Online