mariaDB systemctl start error

Hello!

I am trying to figure out why my mariaDB isnt starting. I get this resource error.

What I tryed.

  1. Seems to not be previous files in var since I deleted them
  2. Can this error be related to AppArmor created by mysql?
Job for mariadb.service failed because of unavailable resources or another system error.
See "systemctl status mariadb.service" and "journalctl -xeu mariadb.service" for details

____
journalctl -xeu mariadb.service:


mai   08 23:05:35 GLXDRGNZD systemd[1]: Failed to start MariaDB 10.11.2 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 12030 and the job result is failed.
mai   08 23:29:48 GLXDRGNZD systemd[1]: mariadb.service: Found left-over process 78146 >
mai   08 23:29:48 GLXDRGNZD systemd[1]: This usually indicates unclean termination of a>
mai   08 23:29:48 GLXDRGNZD systemd[1]: mariadb.service: Will not start SendSIGKILL=no >
mai   08 23:29:48 GLXDRGNZD systemd[1]: mariadb.service: Failed to run 'start-pre' task>
mai   08 23:29:48 GLXDRGNZD systemd[1]: mariadb.service: Failed with result 'resources'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'resources'.
mai   08 23:29:48 GLXDRGNZD systemd[1]: mariadb.service: Unit process 78146 (mariadbd) >
mai   08 23:29:48 GLXDRGNZD systemd[1]: Failed to start MariaDB 10.11.2 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: https://lists.freedesktop.org/mailman/listinfo/systemd-devel
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 12156 and the job result is failed.

System:
  Kernel: 6.2.12-zen1-1-zen arch: x86_64 bits: 64 compiler: gcc v: 12.2.1
    parameters: BOOT_IMAGE=/@/boot/vmlinuz-linux-zen
    root=UUID=0f309958-7881-489f-869b-afc74fd9b0e0 rw rootflags=subvol=@
    quiet quiet splash rd.udev.log_priority=3 vt.global_cursor_default=0
    resume=UUID=f551f9c4-353d-45f8-b453-fd3936591bd1 loglevel=3 ibt=off
  Desktop: KDE Plasma v: 5.27.4 tk: Qt v: 5.15.9 wm: kwin_x11 vt: 1 dm: SDDM
    Distro: Garuda Linux base: Arch Linux
Machine:
  Type: Desktop Mobo: ASUSTeK model: PRIME B450M-A v: Rev X.0x
    serial: <superuser required> UEFI: American Megatrends v: 3604
    date: 02/25/2022
CPU:
  Info: model: AMD Ryzen 7 2700X bits: 64 type: MT MCP arch: Zen+ gen: 2
    level: v3 note: check built: 2018-21 process: GF 12nm family: 0x17 (23)
    model-id: 8 stepping: 2 microcode: 0x800820D
  Topology: cpus: 1x cores: 8 tpc: 2 threads: 16 smt: enabled cache:
    L1: 768 KiB desc: d-8x32 KiB; i-8x64 KiB L2: 4 MiB desc: 8x512 KiB
    L3: 16 MiB desc: 2x8 MiB
  Speed (MHz): avg: 3494 high: 3703 min/max: 2200/3700 boost: disabled
    scaling: driver: acpi-cpufreq governor: performance cores: 1: 3700 2: 3685
    3: 3700 4: 3703 5: 2916 6: 3492 7: 3700 8: 3139 9: 3692 10: 3700 11: 2967
    12: 3700 13: 3700 14: 2991 15: 3609 16: 3516 bogomips: 118401
  Flags: avx avx2 ht lm nx pae sse sse2 sse3 sse4_1 sse4_2 sse4a ssse3 svm
  Vulnerabilities: <filter>
Graphics:
  Device-1: NVIDIA GP104 [GeForce GTX 1080] vendor: Gigabyte driver: nvidia
    v: 530.41.03 alternate: nouveau,nvidia_drm non-free: 530.xx+
    status: current (as of 2023-03) arch: Pascal code: GP10x
    process: TSMC 16nm built: 2016-21 pcie: gen: 3 speed: 8 GT/s lanes: 16
    bus-ID: 09:00.0 chip-ID: 10de:1b80 class-ID: 0300
  Device-2: Logitech Webcam C270 type: USB driver: snd-usb-audio,uvcvideo
    bus-ID: 3-2:3 chip-ID: 046d:0825 class-ID: 0102 serial: <filter>
  Display: x11 server: X.Org v: 21.1.8 with: Xwayland v: 23.1.1
    compositor: kwin_x11 driver: X: loaded: nvidia unloaded: modesetting,nouveau
    alternate: fbdev,nv,vesa gpu: nvidia display-ID: :0 screens: 1
  Screen-1: 0 s-res: 3840x1200 s-dpi: 93 s-size: 1049x321mm (41.30x12.64")
    s-diag: 1097mm (43.19")
  Monitor-1: DVI-D-0 pos: primary,right res: 1920x1200 hz: 60 dpi: 94
    size: 518x324mm (20.39x12.76") diag: 611mm (24.05") modes: N/A
  Monitor-2: HDMI-0 pos: left res: 1920x1200 hz: 60 dpi: 94
    size: 518x324mm (20.39x12.76") diag: 611mm (24.05") modes: N/A
  API: OpenGL v: 4.6.0 NVIDIA 530.41.03 renderer: NVIDIA GeForce GTX
    1080/PCIe/SSE2 direct-render: Yes
Audio:
  Device-1: NVIDIA GP104 High Definition Audio vendor: Gigabyte
    driver: snd_hda_intel bus-ID: 3-2:3 v: kernel pcie: chip-ID: 046d:0825
    gen: 3 class-ID: 0102 serial: <filter> speed: 8 GT/s lanes: 16
    bus-ID: 09:00.1 chip-ID: 10de:10f0 class-ID: 0403
  Device-2: AMD Family 17h HD Audio vendor: ASUSTeK driver: snd_hda_intel
    v: kernel pcie: gen: 3 speed: 8 GT/s lanes: 16 bus-ID: 0b:00.3
    chip-ID: 1022:1457 class-ID: 0403
  Device-3: Logitech Webcam C270 type: USB driver: snd-usb-audio,uvcvideo
  Device-4: C-Media CM6631A Audio Processor type: USB
    driver: hid-generic,snd-usb-audio,usbhid bus-ID: 3-3:4 chip-ID: 0d8c:0004
    class-ID: 0300
  API: ALSA v: k6.2.12-zen1-1-zen status: kernel-api tools: N/A
  Server-1: PipeWire v: 0.3.70 status: active with: 1: pipewire-pulse
    status: active 2: wireplumber status: active 3: pipewire-alsa type: plugin
    4: pw-jack type: plugin tools: pactl,pw-cat,pw-cli,wpctl
Network:
  Device-1: Qualcomm Atheros AR9285 Wireless Network Adapter driver: ath9k
    v: kernel pcie: gen: 1 speed: 2.5 GT/s lanes: 1 bus-ID: 07:00.0
    chip-ID: 168c:002b class-ID: 0280
  IF: wlp7s0 state: down mac: <filter>
  Device-2: Realtek RTL8111/8168/8411 PCI Express Gigabit Ethernet
    vendor: ASUSTeK PRIME B450M-A driver: r8169 v: kernel pcie: gen: 1
    speed: 2.5 GT/s lanes: 1 port: f000 bus-ID: 08:00.0 chip-ID: 10ec:8168
    class-ID: 0200
  IF: enp8s0 state: up speed: 1000 Mbps duplex: full mac: <filter>
Drives:
  Local Storage: total: 2.62 TiB used: 119.8 GiB (4.5%)
  SMART Message: Unable to run smartctl. Root privileges required.
  ID-1: /dev/nvme0n1 maj-min: 259:0 vendor: Silicon Power
    model: SPCC M.2 PCIe SSD size: 476.94 GiB block-size: physical: 512 B
    logical: 512 B speed: 31.6 Gb/s lanes: 4 type: SSD serial: <filter>
    rev: H211011a temp: 43.9 C scheme: GPT
  ID-2: /dev/sda maj-min: 8:0 vendor: Crucial model: M4-CT128M4SSD2
    size: 119.24 GiB block-size: physical: 512 B logical: 512 B speed: 6.0 Gb/s
    type: SSD serial: <filter> rev: 000F scheme: GPT
  ID-3: /dev/sdb maj-min: 8:16 vendor: Western Digital
    model: WD20EARX-00PASB0 size: 1.82 TiB block-size: physical: 4096 B
    logical: 512 B speed: 6.0 Gb/s type: N/A serial: <filter> rev: AB51
    scheme: MBR
  ID-4: /dev/sdc maj-min: 8:32 vendor: Kingston model: SUV400S37240G
    size: 223.57 GiB block-size: physical: 4096 B logical: 512 B speed: 6.0 Gb/s
    type: SSD serial: <filter> rev: 96R9 scheme: GPT
Partition:
  ID-1: / raw-size: 234.38 GiB size: 234.38 GiB (100.00%)
    used: 119.8 GiB (51.1%) fs: btrfs dev: /dev/nvme0n1p1 maj-min: 259:1
  ID-2: /boot/efi raw-size: 497 MiB size: 496 MiB (99.80%)
    used: 580 KiB (0.1%) fs: vfat dev: /dev/nvme0n1p5 maj-min: 259:5
  ID-3: /home raw-size: 234.38 GiB size: 234.38 GiB (100.00%)
    used: 119.8 GiB (51.1%) fs: btrfs dev: /dev/nvme0n1p1 maj-min: 259:1
  ID-4: /var/log raw-size: 234.38 GiB size: 234.38 GiB (100.00%)
    used: 119.8 GiB (51.1%) fs: btrfs dev: /dev/nvme0n1p1 maj-min: 259:1
  ID-5: /var/tmp raw-size: 234.38 GiB size: 234.38 GiB (100.00%)
    used: 119.8 GiB (51.1%) fs: btrfs dev: /dev/nvme0n1p1 maj-min: 259:1
Swap:
  Kernel: swappiness: 133 (default 60) cache-pressure: 100 (default)
  ID-1: swap-1 type: zram size: 15.53 GiB used: 2.01 GiB (12.9%)
    priority: 100 dev: /dev/zram0
  ID-2: swap-2 type: partition size: 15.62 GiB used: 0 KiB (0.0%)
    priority: -2 dev: /dev/nvme0n1p2 maj-min: 259:2
Sensors:
  System Temperatures: cpu: 48.6 C mobo: N/A gpu: nvidia temp: 46 C
  Fan Speeds (RPM): N/A gpu: nvidia fan: 0%
Info:
  Processes: 446 Uptime: 10h 58m wakeups: 5 Memory: 15.53 GiB
  used: 7.49 GiB (48.3%) Init: systemd v: 253 default: graphical
  tool: systemctl Compilers: gcc: 13.1.1 clang: 15.0.7 Packages: pm: pacman
  pkgs: 1947 libs: 438 tools: octopi,pamac,paru,yay pm: rpm pkgs: 0
  Shell: fish v: 3.6.1 default: Bash v: 5.1.16 running-in: alacritty
  inxi: 3.3.26
Garuda (2.6.16-1):
  System install date:     2023-01-18
  Last full system update: 2023-05-08 ↻
  Is partially upgraded:   No
  Relevant software:       snapper NetworkManager dracut nvidia-dkms
  Windows dual boot:       Probably (Run as root to verify)
  Failed units:            mariadb.service

first i would reboot the see if the service starts

7 Likes

Seems to be running now. Thanks.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.