Hello!
I am trying to figure out why my mariaDB isnt starting. I get this resource error.
What I tryed.
- Seems to not be previous files in var since I deleted them
- 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 [email protected]
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