Currently I’m facing problem with Kmail and kOrganizer.
org.kde.pim.akonadiserver: database server stopped unexpectedly
Please read this:
Especially these bits:
Also,
- Please read this:
[HowTo] Provide System Information
and press the three dots … below your post and press the
to give us more information so we can see what’s really going on.
Now we know the symptom of the disease, but we need some more probing to know where the origin lies…
- An
inxi --admin --verbosity=7 --filter --no-host --widthwould be the minimum required information for us to be able to help you. (Personally Identifiable Information like serial numbers and MAC addresses will be filtered out by the above command)
Also, please copy-paste that output in-between 3 backticks ``` at the beginning and end of the code/text.
seems that you have to reinstall / reconfigure mariadb-server. That should be the solution I think…
is there an output for sudo systemctl status mysqld ?
1 Like
sudo systemctl status mysqld
○ mariadb.service - MariaDB 10.6.4 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset>
Active: inactive (dead)
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/what gives you:
`sudo systemctl start mysqld` ?
1 Like
● mariadb.service - MariaDB 10.6.4 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset>
Active: active (running) since Tue 2021-09-07 17:12:46 IST; 16s ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Process: 167381 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_>
Process: 167382 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR=>
Process: 167405 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START>
Main PID: 167390 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 14 (limit: 9413)
Memory: 60.1M
CPU: 215ms
CGroup: /system.slice/mariadb.service
└─167390 /usr/bin/mariadbd
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [Note] InnoDB>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [Note] InnoDB>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [Note] InnoDB>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [Note] Server>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [Note] Server>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [ERROR] Incor>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [ERROR] maria>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: 2021-09-07 17:12:46 0 [Note] /usr/b>
Sep 07 17:12:46 mozammel-tm1703 mariadbd[167390]: Version: '10.6.4-MariaDB' socket: >
Sep 07 17:12:46 mozammel-tm1703 systemd[1]: Started MariaDB 10.6.4 database server.akonadictl start ✔ 41s
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
~ org.kde.pim.akonadiserver: mysqld for Akonadi is already running, trying to connect to it.
/usr/bin/mysqlcheck: Error: Couldn't get table list for database akonadi: Unknown database 'akonadi'
org.kde.pim.akonadiserver: Running DB initializer
org.kde.pim.akonadiserver: "\nSql error: Table 'schemaversiontable' already exists QMYSQL: Unable to execute query\nQuery: CREATE TABLE SchemaVersionTable (version INTEGER NOT NULL DEFAULT 0, generation INTEGER NOT NULL DEFAULT 0) COLLATE=utf8_general_ci DEFAULT CHARSET=utf8"
org.kde.pim.akonadiserver: Unable to initialize database.
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kd
inxi --admin --verbosity=7 --filter --no-host --width ✔
System:
Kernel: 5.10.61-1-MANJARO x86_64 bits: 64 compiler: gcc v: 11.1.0
parameters: BOOT_IMAGE=/boot/vmlinuz-5.10-x86_64
root=UUID=42f2d665-4fe3-47ac-9fb4-d0db0d09b485 ro quiet apparmor=1
security=apparmor resume=UUID=a2d2d02d-f2b3-4b08-896e-d59b388058e7
udev.log_priority=3
Desktop: KDE Plasma 5.22.5 tk: Qt 5.15.2 wm: kwin_x11 vt: 1 dm: SDDM
Distro: Manjaro Linux base: Arch Linux
Machine:
Type: Laptop System: Timi product: TM1703 v: XMAKB3M0P120C serial: <filter>
Mobo: Timi model: TM1703 v: XMAKB3M0P120C serial: <filter> UEFI: Insyde
v: XMAKB3M0P120C date: 07/10/2018
Battery:
ID-1: BAT0 charge: 22.9 Wh (100.0%) condition: 22.9/40.1 Wh (57.0%)
volts: 8.4 min: 7.6 model: SUNWODA R13B02W type: Li-ion serial: <filter>
status: Not charging
Memory:
RAM: total: 7.68 GiB used: 5.11 GiB (66.6%)
RAM Report: permissions: Unable to run dmidecode. Root privileges required.
CPU:
Info: Quad Core model: Intel Core i5-8250U bits: 64 type: MT MCP
arch: Kaby Lake note: check family: 6 model-id: 8E (142) stepping: A (10)
microcode: EA cache: L2: 6 MiB bogomips: 28808
Speed: 1600 MHz min/max: 400/1600 MHz Core speeds (MHz): 1: 1600 2: 1600
3: 1600 4: 1600 5: 1600 6: 1600 7: 1600 8: 1600
Flags: 3dnowprefetch abm acpi adx aes aperfmperf apic arat arch_perfmon art
avx avx2 bmi1 bmi2 bts clflush clflushopt cmov constant_tsc cpuid
cpuid_fault cx16 cx8 de ds_cpl dtes64 dtherm dts epb ept ept_ad erms est
f16c flexpriority flush_l1d fma fpu fsgsbase fxsr ht hwp hwp_act_window
hwp_epp hwp_notify ibpb ibrs ida intel_pt invpcid invpcid_single lahf_lm lm
mca mce md_clear mmx monitor movbe mpx msr mtrr nonstop_tsc nopl nx pae pat
pbe pcid pclmulqdq pdcm pdpe1gb pebs pge pln pni popcnt pse pse36 pti pts
rdrand rdseed rdtscp rep_good sdbg sep smap smep ss ssbd sse sse2 sse4_1
sse4_2 ssse3 stibp syscall tm tm2 tpr_shadow tsc tsc_adjust
tsc_deadline_timer vme vmx vnmi vpid x2apic xgetbv1 xsave xsavec xsaveopt
xsaves xtopology xtpr
Vulnerabilities: Type: itlb_multihit status: KVM: VMX disabled
Type: l1tf
mitigation: PTE Inversion; VMX: conditional cache flushes, SMT vulnerable
Type: mds mitigation: Clear CPU buffers; SMT vulnerable
Type: meltdown mitigation: PTI
Type: spec_store_bypass
mitigation: Speculative Store Bypass disabled via prctl and seccomp
Type: spectre_v1
mitigation: usercopy/swapgs barriers and __user pointer sanitization
Type: spectre_v2 mitigation: Full generic retpoline, IBPB: conditional,
IBRS_FW, STIBP: conditional, RSB filling
Type: srbds mitigation: Microcode
Type: tsx_async_abort status: Not affected
Graphics:
Device-1: Intel UHD Graphics 620 vendor: Xiaomi driver: i915 v: kernel
bus-ID: 00:02.0 chip-ID: 8086:5917 class-ID: 0300
Device-2: NVIDIA GP108M [GeForce MX150] vendor: Xiaomi driver: nvidia
v: 470.63.01 alternate: nouveau,nvidia_drm bus-ID: 01:00.0
chip-ID: 10de:1d12 class-ID: 0302
Device-3: Chicony XiaoMi USB 2.0 Webcam type: USB driver: uvcvideo
bus-ID: 1-5:3 chip-ID: 04f2:b5a3 class-ID: 0e02
Display: x11 server: X.Org 1.20.13 compositor: kwin_x11 driver:
loaded: modesetting,nvidia alternate: fbdev,nouveau,nv,vesa display-ID: :0
screens: 1
Screen-1: 0 s-res: 1920x1080 s-dpi: 115 s-size: 424x238mm (16.7x9.4")
s-diag: 486mm (19.1")
Monitor-1: eDP-1 res: 1920x1080 hz: 60 dpi: 166 size: 294x165mm (11.6x6.5")
diag: 337mm (13.3")
OpenGL: renderer: Mesa Intel UHD Graphics 620 (KBL GT2) v: 4.6 Mesa 21.2.1
direct render: Yes
Audio:
Device-1: Intel Sunrise Point-LP HD Audio vendor: Xiaomi
driver: snd_hda_intel v: kernel alternate: snd_soc_skl bus-ID: 00:1f.3
chip-ID: 8086:9d71 class-ID: 0403
Sound Server-1: ALSA v: k5.10.61-1-MANJARO running: yes
Sound Server-2: sndio v: N/A running: no
Sound Server-3: JACK v: 1.9.19 running: no
Sound Server-4: PulseAudio v: 15.0 running: yes
Sound Server-5: PipeWire v: 0.3.34 running: yes
Network:
Device-1: Intel Wireless 8265 / 8275 driver: iwlwifi v: kernel port: 3000
bus-ID: 02:00.0 chip-ID: 8086:24fd class-ID: 0280
IF: wlp2s0 state: up mac: <filter>
IP v4: <filter> type: dynamic noprefixroute scope: global
broadcast: <filter>
IP v6: <filter> type: dynamic noprefixroute scope: global
IP v6: <filter> type: noprefixroute scope: link
WAN IP: <filter>
Bluetooth:
Device-1: Intel Bluetooth wireless interface type: USB driver: btusb v: 0.8
bus-ID: 1-7:5 chip-ID: 8087:0a2b class-ID: e001
Report: rfkill ID: hci0 rfk-id: 5 state: up address: see --recommends
Logical:
Message: No logical block device data found.
RAID:
Message: No RAID data found.
Drives:
Local Storage: total: 704.24 GiB used: 420.94 GiB (59.8%)
SMART Message: Unable to run smartctl. Root privileges required.
ID-1: /dev/nvme0n1 maj-min: 259:0 vendor: Samsung model: MZVLW256HEHP-00000
size: 238.47 GiB block-size: physical: 512 B logical: 512 B speed: 31.6 Gb/s
lanes: 4 type: SSD serial: <filter> rev: CXB7401Q temp: 35.9 C scheme: GPT
ID-2: /dev/sda maj-min: 8:0 vendor: Western Digital
model: WDS500G2B0B-00YS70 size: 465.76 GiB block-size: physical: 512 B
logical: 512 B speed: 6.0 Gb/s type: SSD serial: <filter> rev: 90WD
scheme: GPT
Message: No optical or floppy data found.
Partition:
ID-1: / raw-size: 229.37 GiB size: 224.77 GiB (97.99%)
used: 194.42 GiB (86.5%) fs: ext4 dev: /dev/nvme0n1p2 maj-min: 259:2
label: N/A uuid: 42f2d665-4fe3-47ac-9fb4-d0db0d09b485
ID-2: /StringD raw-size: 465.76 GiB size: 457.45 GiB (98.22%)
used: 226.32 GiB (49.5%) fs: ext4 dev: /dev/sda1 maj-min: 8:1 label: StringD
uuid: 45e0d749-9089-42ab-84c2-d8f95fb475e0
ID-3: /boot/efi raw-size: 300 MiB size: 299.4 MiB (99.80%)
used: 312 KiB (0.1%) fs: vfat dev: /dev/nvme0n1p1 maj-min: 259:1 label: N/A
uuid: 753C-7A0A
Swap:
Kernel: swappiness: 60 (default) cache-pressure: 100 (default)
ID-1: swap-1 type: partition size: 8.8 GiB used: 207.1 MiB (2.3%)
priority: -2 dev: /dev/nvme0n1p3 maj-min: 259:3 label: N/A
uuid: a2d2d02d-f2b3-4b08-896e-d59b388058e7
Unmounted:
Message: No unmounted partitions found.
USB:
Hub-1: 1-0:1 info: Full speed (or root) Hub ports: 12 rev: 2.0
speed: 480 Mb/s chip-ID: 1d6b:0002 class-ID: 0900
Device-1: 1-1:2 info: MOSART Semi. 2.4G RF Keyboard & Mouse
type: Keyboard,Mouse driver: hid-generic,usbhid interfaces: 2 rev: 1.1
speed: 12 Mb/s power: 100mA chip-ID: 3938:1032 class-ID: 0301
Device-2: 1-5:3 info: Chicony XiaoMi USB 2.0 Webcam type: Video
driver: uvcvideo interfaces: 2 rev: 2.0 speed: 480 Mb/s power: 500mA
chip-ID: 04f2:b5a3 class-ID: 0e02
Device-3: 1-6:4 info: Elan Micro ELAN:Fingerprint type: <vendor specific>
driver: N/A interfaces: 1 rev: 2.0 speed: 12 Mb/s power: 100mA
chip-ID: 04f3:0c1a class-ID: 0000
Device-4: 1-7:5 info: Intel Bluetooth wireless interface type: Bluetooth
driver: btusb interfaces: 2 rev: 2.0 speed: 12 Mb/s power: 100mA
chip-ID: 8087:0a2b class-ID: e001
Hub-2: 2-0:1 info: Full speed (or root) Hub ports: 6 rev: 3.0 speed: 5 Gb/s
chip-ID: 1d6b:0003 class-ID: 0900
Sensors:
System Temperatures: cpu: 45.0 C mobo: 37.0 C
Fan Speeds (RPM): N/A
Info:
Processes: 281 Uptime: 1d 21h 51m wakeups: 20 Init: systemd v: 248
tool: systemctl Compilers: gcc: 11.1.0 clang: 12.0.1 Packages: 1627 apt: 1
pacman: 1626 lib: 416 Shell: Zsh v: 5.8 running-in: konsole inxi: 3.3.06
1 Like
try to reinstall those packages
extra/akonadi 21.08.1-1 [installed]
PIM layer, which provides an asynchronous API to access all kind of PIM data
extra/akonadi-calendar 21.08.1-1 [installed]
Akonadi calendar integration
extra/akonadi-calendar-tools 21.08.1-1 (kde-applications kdepim) [installed]
CLI tools to manage akonadi calendars
extra/akonadi-contacts 21.08.1-1 [installed]
Libraries and daemons to implement Contact Management in Akonadi
extra/akonadi-import-wizard 21.08.1-1 (kde-applications kdepim) [installed]
Import data from other mail clients to KMail
extra/akonadi-mime 21.08.1-1 [installed]
Libraries and daemons to implement basic email handling
extra/akonadi-notes 21.08.1-1 [installed]
Libraries and daemons to implement management of notes in Akonadi
extra/akonadi-search 21.08.1-1 [installed]
Libraries and daemons to implement searching in Akonadi
extra/akonadiconsole 21.08.1-1 (kde-applications kdepim) [installed]
Akonadi management and debugging console
extra/libakonadi 21.08.1-1 [installed]
Libraries used by applications based on Akonadi
that means:
akonadi, akonadi-calendar, akonadi-calendar-tools, akonadi-contacts, akonadi-mime, akonadi-notes, akonadi-search, akonadikonsole, libakonadi
and also then:
systemctl enable mysqld
Very same output after reinstall all the package you said.
~ akonadictl start ✔
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
~ org.kde.pim.akonadiserver: database server stopped unexpectedly ✔
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/mozammel/.local/share/akonadi/mysql.conf", "--datadir=/home/mozammel/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-09-07 20:37:25 0 [Note] /usr/bin/mysqld (server 10.6.4-MariaDB) starting as process 3134 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
sudo aa-complain /usr/bin/akonadiserver
if I remember correctly, some months back when I had similar issue, I found this commend and it worked
sudo aa-complain /usr/bin/akonadiserver
but now it didn’t work. same result as before
~ akonadictl start ✔
org.kde.pim.akonadictl: Starting Akonadi Server...
org.kde.pim.akonadictl: done.
Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
org.kde.pim.akonadiserver: Starting up the Akonadi Server...
~ org.kde.pim.akonadiserver: database server stopped unexpectedly ✔
org.kde.pim.akonadiserver: Database process exited unexpectedly during initial connection!
org.kde.pim.akonadiserver: executable: "/usr/bin/mysqld"
org.kde.pim.akonadiserver: arguments: ("--defaults-file=/home/mozammel/.local/share/akonadi/mysql.conf", "--datadir=/home/mozammel/.local/share/akonadi/db_data/", "--socket=/run/user/1000/akonadi/mysql.socket", "--pid-file=/run/user/1000/akonadi/mysql.pid")
org.kde.pim.akonadiserver: stdout: ""
org.kde.pim.akonadiserver: stderr: "2021-09-07 21:17:08 0 [Note] /usr/bin/mysqld (server 10.6.4-MariaDB) starting as process 3312 ...\n"
org.kde.pim.akonadiserver: exit code: 1
org.kde.pim.akonadiserver: process error: "Unknown error"
org.kde.pim.akonadiserver: Shutting down AkonadiServer...
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
try:
sudo aa-enforce /usr/bin/akonadiserver
very same result. still not working.
sudo aa-status INT ✘
[sudo] password for mozammel:
apparmor module is loaded.
9 profiles are loaded.
9 profiles are in enforce mode.
/usr/bin/akonadiserver
dovecot-script-login
lsb_release
mariadbd_akonadi
mysqld_akonadi
nvidia_modprobe
nvidia_modprobe//kmod
php-fpm
postgresql_akonadi
0 profiles are in complain mode.
0 profiles are in kill mode.
0 profiles are in unconfined mode.
0 processes have profiles defined.
0 processes are in enforce mode.
0 processes are in complain mode.
0 processes are unconfined but have a profile defined.
0 processes are in mixed mode.
0 processes are in kill mode.
but mysqld is running well ?
yes, mysql is running fine, also mariadb running fine.
I think akonadi uses mariadb.
mariadb and mysqld are the same thing …
yes. right.
sudo systemctl status mariadb ✔
● mariadb.service - MariaDB 10.6.4 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Active: active (running) since Tue 2021-09-07 21:13:38 IST; 35min ago
Docs: man:mariadbd(8)
https://mariadb.com/kb/en/library/systemd/
Main PID: 508 (mariadbd)
Status: "Taking your SQL requests now..."
Tasks: 8 (limit: 9413)
Memory: 81.0M
CPU: 547ms
CGroup: /system.slice/mariadb.service
└─508 /usr/bin/mariadbd
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] InnoDB: 10.6.4 started; log sequence number 45166>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysq>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] InnoDB: Buffer pool(s) load completed at 210907 2>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] Server socket created on IP: '0.0.0.0'.
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] Server socket created on IP: '::'.
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [ERROR] Incorrect definition of table mysql.event: expec>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [ERROR] mariadbd: Event Scheduler: An error occurred whe>
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: 2021-09-07 21:13:38 0 [Note] /usr/bin/mariadbd: ready for connections.
Sep 07 21:13:38 mozammel-tm1703 mariadbd[508]: Version: '10.6.4-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 Arch>
Sep 07 21:13:38 mozammel-tm1703 systemd[1]: Started MariaDB 10.6.4 database server.
there is 2 error I don’t understand those error.
could you restart akonadi service once ?