Bug 30545 - akonadi fails to start mysqld
Summary: akonadi fails to start mysqld
Status: RESOLVED WORKSFORME
Alias: None
Product: Mageia
Classification: Unclassified
Component: RPM Packages (show other bugs)
Version: Cauldron
Hardware: All Linux
Priority: Normal normal
Target Milestone: ---
Assignee: KDE maintainers
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-06-14 07:12 CEST by Pierre Fortin
Modified: 2023-07-07 16:59 CEST (History)
1 user (show)

See Also:
Source RPM: korganizer-22.04.0-1.mga9
CVE:
Status comment:


Attachments
screenshot of Knut (94.43 KB, image/png)
2022-06-14 17:50 CEST, Pierre Fortin
Details
akonadictl restart (8.24 KB, text/plain)
2022-06-14 23:01 CEST, Pierre Fortin
Details
mysql.err (6.82 KB, application/zip)
2022-06-15 05:11 CEST, Pierre Fortin
Details

Description Pierre Fortin 2022-06-14 07:12:54 CEST
Description of problem:  Haven't used KOrganizer in the many years I've been retired. Am now working on a large project with many TB of data, and could use a calendar/scheduler.  KOrganizer appears to be the only complete option.

Installed korganizer-22.04.0-1.mga9 and the first thing I want to do is setup at least one calendar DB. 


Version-Release number of selected component (if applicable):


How reproducible: always


Steps to Reproduce:
1. Settings->Configure KOrganizer
2. Calendars tab: Click Add...
3. Get:  Knut  An agent for debugging purpose.
4. Click on Knut; click on OK
5. get: akonadi_knut_resource_3   No data file selected.
    (the "3" is because I've been through these steps before)
6. and a 'Select Data File' selector

This is a first run; there was never a data file...  OK, let's try something crazy:

7. in the file selector, navigate to .local/share/korganizer and add NCDT in Name field; Save
8. Click Restart on Calendars tab -- no response
9. Click item in step 5 above; click Remove
10. [?] Do you want to remove account 'akonadi_knut_resource_3'?
   What?  That's not an account.  Click Remove. (removed)
11. Hmm...  trying again. This time, select akonadi_knut_resource_4 and click OK
12. No DB named akonadi_knut_resource_4 created; so much for thinking I could find a workaround...

Of course, trying to add events fails due to lack of DB.

Before filing this, I sent the following and got a response:

Reply-To: discuss@ml.mageia.org
Subject: Re: [discuss] KOrganizer: bug? where to report?

On 6/13/22 7:50 PM, Pierre Fortin (via discuss Mailing List) wrote:
> Went to bugs.kde.org to report what appears to be a really basic bug in
> KOrganizer; but it only has version choices up to 5.20.2 which is quite
> old compared to korganizer-22.04.0-1.mga9
>
> Is KOrganizer deprecated?
>
> I try to add a calendar; but when I click Add... it gives me a Knut sad
> face.
>
> Trying to add an event fails with "Error while trying to create calendar
> item. Error was: Failed to insert new part into database."  According to
> the manual, adding a calendar should be straight-forward.  Exporting
> creates an icalout.ics; but I doubt this is the "database"...
>
> Does this sound like a bug? Or user error?
>
> Thanks,
> Pierre  

Korganizer is active

The latest tag is v22.04.2 
<https://invent.kde.org/pim/korganizer/-/tags/v22.04.2> See 
https://invent.kde.org/pim/korganizer/-/tags

If it is not a build problem with korganizer in mageia then I assume it 
is an upstream KDE problem.

Did you search the kde bugzilla to see if the problem has been reported 
there? 
https://bugs.kde.org/buglist.cgi?order=bug_id%20DESC&product=korganizer

I suspect you may need to contact the KDE bugzilla administrator and 
prod them to add the newer release values.

Robert H.

Yup, I went to bugs.kde.org; but what chance does my bug have when the korganizer bugs page ends with:

  This result was limited to 500 bugs. See all search results for this query.
Comment 1 sturmvogel 2022-06-14 08:43:15 CEST
Korganizer uses a default local file as ressource. You try to add an (non existing) external ressource which will lead to an error.

The Korganizer handbook is big (but good).
https://docs.kde.org/stable5/en/korganizer/korganizer/index.html

What you try to do is to import an external calendar ressource:
https://docs.kde.org/stable5/en/korganizer/korganizer/managing-data.html
Comment 2 Pierre Fortin 2022-06-14 17:50:17 CEST
Created attachment 13295 [details]
screenshot of Knut

Starting over...

https://docs.kde.org/stable5/en/korganizer/korganizer/managing-data.html
Following: Procedure 3.1. Adding a New KOrganizer Resource

Step 3: this is a fresh install.  I never had a calendar app on this system, so the Calendar Accounts box (below the Filter... box) is empty.
Click Add...
Instead of presenting the options as illustrated in the image directly above "Procedure 3.1", I get the attached...

Without a calendar (database), I can't add anything... 

KOrganizer seems to require a DB file; but it doesn't name the default file so I can find or create it externally -- at least, I haven't found it yet...
Chicken or egg situation...
Comment 3 Dave Hodgins 2022-06-14 18:00:35 CEST
What's the output of "akonadictl status"?

CC: (none) => davidwhodgins

Comment 4 Pierre Fortin 2022-06-14 21:26:04 CEST
$ akonadictl status
Akonadi Control: running
Akonadi Server: running
Akonadi Server Search Support: available (Remote Search, Akonadi Search Plugin)
Available Agent Types: akonadi_akonotes_resource, akonadi_birthdays_resource, akonadi_contacts_resource, akonadi_davgroupware_resource, akonadi_ews_resource, akonadi_ewsmta_resource, akonadi_google_resource, akonadi_ical_resource, akonadi_icaldir_resource, akonadi_imap_resource, akonadi_indexing_agent, akonadi_knut_resource, akonadi_kolab_resource, akonadi_maildir_resource, akonadi_maildispatcher_agent, akonadi_mbox_resource, akonadi_migration_agent, akonadi_mixedmaildir_resource, akonadi_newmailnotifier_agent, akonadi_notes_agent, akonadi_notes_resource, akonadi_openxchange_resource, akonadi_pop3_resource, akonadi_tomboynotes_resource, akonadi_vcard_resource, akonadi_vcarddir_resource
Comment 5 Pierre Fortin 2022-06-14 23:01:29 CEST
Created attachment 13296 [details]
akonadictl restart

Got curious about the akonadictl command; saw "restart", so...  results attached as there are some errors.
For the record, I've seen references to akonadi; but never took the time to look into what it provided, or messed with it in any way.  HTH
Comment 6 Dave Hodgins 2022-06-14 23:11:30 CEST
akonadi is the database used by kde plasma for storing things like search
indexes, contacts, calendar entries, etc.

Try "akonadictl fsck"
Dave Hodgins 2022-06-14 23:12:27 CEST

Assignee: bugsquad => kde

Comment 7 Pierre Fortin 2022-06-15 00:55:54 CEST
Ah....  a bit of progress...

$ akonadictl fsck
Looking for resources in the DB not matching a configured resource...
Found 4 orphan resources: akonadi_contacts_resource_0,akonadi_ical_resource_0,akonadi_akonotes_resource_0,akonadi_birthdays_resource
Removing resource akonadi_contacts_resource_0
Removing resource akonadi_ical_resource_0
Removing resource akonadi_akonotes_resource_0
Removing resource akonadi_birthdays_resource
[...]
Looking for dirty objects...
Collection "Search" (id: 1) has no RID.
Collection "OpenInvitations" (id: 15) has no RID.
Collection "DeclinedInvitations" (id: 16) has no RID.
Found 3 collections without RID.
Found 0 items without RID.
Found 0 dirty items.
Looking for rid-duplicates not matching the content mime-type of the parent collection
[...]

This is the only output that look abnormal to me.

Restarted KOrganizer and now, I get further... 
Settings->Config->Calendars now shows:
 - Birthdays & Anniversaries
 - Personal Calendar
Click Add...
Expected list is there; choose: iCal Calendar File
File Name:  NCDT
Display Name:  NC DT
   [ ] Read only
   [X] Enable file monitoring
Apply, OK
Now, I see a new account:  akonadi_knut_resource_2
Selected and removed it.
Added again, now: akonadi_knut_resource_3
OK... try to add an event; Calendar choices are now:
 - Personal Calendar
 - akonadi_knut_resource_3
:p  So I select akonadi_knut_resource_3 and create an event.
Apply returns: "Error while trying to create calendar item. Error was: Failed to insert new part into database."

Cancel out of event creation.

$ akonadictl fsck
[...]
Looking for dirty objects...
Collection "Search" (id: 1) has no RID.
Collection "OpenInvitations" (id: 15) has no RID.
Collection "DeclinedInvitations" (id: 16) has no RID.
Collection "akonadi_ical_resource_3" (id: 36) has no RID.
Found 4 collections without RID.
Found 0 items without RID.
Found 0 dirty items.
Looking for rid-duplicates not matching the content mime-type of the parent collection
[...]

Exit KOrganizer.

$ ps aux | grep organ
pfortin  1649654  0.0  0.0 2464784 128784 ?      Sl   Jun13   0:26 /usr/bin/khelpcenter help:korganizer

$ kill 1649654

Started over. Still get akonadi_knut_resource_3 instead of iCal Calendar File.

And this on konsole:
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c0050a0) )
org.kde.pim.akonadiserver: Subscriber "" disconnected
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c1b0000) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c0792f0) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c1b0000) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c17c790) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c0270e0) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c0050a0) identified as "TagCacheMonitor - 15394800"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c0792f0) identified as "ETMCalendarMonitor - 15356160"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c1b0000) identified as "TagCacheMonitor - 17845504"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c17c790) identified as "ItemMonitorMonitor - 17201232"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c0270e0) identified as "TagCacheMonitor - 16651456"
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c003e60) )
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c1a9410) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c003e60) identified as "TagSelectionComboBoxMonitor - 25119872"
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c1a9410) identified as "CollectionComboBoxMonitor - 25159872"
"No file specified."
org.kde.pim.akonadiagentbase: Impossible to remove  "/home/pfortin/.config/akonadi/agent_config_akonadi_ical_resource_3"
org.kde.pim.akonadiserver: Subscriber "AgentBaseChangeRecorder - 34854400" disconnected
org.kde.pim.akonadicontrol: Application '/usr/bin/akonadi_ical_resource' exited normally...
org.kde.pim.akonadiserver: New notification connection (registered as Akonadi::Server::NotificationSubscriber(0x7f333c173350) )
org.kde.pim.akonadiserver: Subscriber Akonadi::Server::NotificationSubscriber(0x7f333c173350) identified as "AgentBaseChangeRecorder - 6359744"
"No file selected."
"No file selected."


File (/home/pfortin/.config/akonadi/agent_config_akonadi_ical_resource_3) mentioned in konsole output does not exist; but that folder now contains:

$ ll .config/akonadi
total 84
-rw-r--r-- 1 pfortin pfortin   43 Jun 14 18:20  agent_config_akonadi_akonotes_resource_0
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 18:20  agent_config_akonadi_akonotes_resource_0_changes.dat
-rw-r--r-- 1 pfortin pfortin   39 Jun 14 18:20  agent_config_akonadi_birthdays_resource
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 18:20  agent_config_akonadi_birthdays_resource_changes.dat
-rw-r--r-- 1 pfortin pfortin   31 Jun 14 18:20  agent_config_akonadi_contacts_resource_0
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 18:20  agent_config_akonadi_contacts_resource_0_changes.dat
-rw-r--r-- 1 pfortin pfortin   31 Jun 14 18:20  agent_config_akonadi_ical_resource_0
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 18:20  agent_config_akonadi_ical_resource_0_changes.dat
-rw-r--r-- 1 pfortin pfortin    1 Jun 14 18:46 '#agent_config_akonadi_ical_resource_3#'
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 18:42  agent_config_akonadi_ical_resource_4_changes.dat
-rw-r--r-- 1 pfortin pfortin   32 Jun 14 16:55  agent_config_akonadi_indexing_agent
-rw-r--r-- 1 pfortin pfortin   16 Apr  7 10:50  agent_config_akonadi_indexing_agent_changes.dat
-rw-r--r-- 1 pfortin pfortin   51 Jun 14 16:55  agent_config_akonadi_maildir_resource_0
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 16:55  agent_config_akonadi_maildir_resource_0_changes.dat
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 16:55  agent_config_akonadi_maildispatcher_agent_changes.dat
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 16:55  agent_config_akonadi_migration_agent_changes.dat
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 16:55  agent_config_akonadi_newmailnotifier_agent_changes.dat
-rw-r--r-- 1 pfortin pfortin   16 Jun 14 16:55  agent_config_akonadi_notes_agent_changes.dat
-rw-r--r-- 1 pfortin pfortin 1554 Jun 14 18:42  agentsrc
-rw-r--r-- 1 pfortin pfortin  217 Jun 14 16:55  akonadiconnectionrc
-rw------- 1 pfortin pfortin  178 Jun 14 16:55  akonadiserverrc

Apr 7 is the date I received/installed this machine.
Comment 8 Dave Hodgins 2022-06-15 01:54:34 CEST
Try creating a new user and see if it works for that user.
Comment 9 Pierre Fortin 2022-06-15 02:27:46 CEST
No change.  Same as after "akonadictl fsck" on main userid.
Comment 10 Dave Hodgins 2022-06-15 03:09:14 CEST
Given that Knut is described as "An agent for debugging purpose" with no
mention in the korganizer handbook, I'm guessing it's meant for use by
people familiar with the internals of how korganizer works and how to
debug it. Why are you trying to use it? I would expect everyone other
then experts would only be using the other calendar types.
Comment 11 Pierre Fortin 2022-06-15 03:23:03 CEST
LOL...  I'm not trying to use Knut.  It's obviously popping up because something is going wrong...  I just want to use KOrganizer.  It looks like no-one has set it up from square-zero for some time.  If I had a sample of the file it's expecting for storing events, etc; maybe I could use that as a workaround.
Comment 12 Dave Hodgins 2022-06-15 04:28:21 CEST
By default korganizer components use akonadi which uses mysql (mariadb) as
the backend. I'm not even sure if there is an alternative.

I didn't previously have it installed in my cauldron install. I installed it
and had no problems adding events to the calendar it creates when it's first
started.

It has export/import for other formats, but the calender itself is stored
using sql tables.
Comment 13 Dave Hodgins 2022-06-15 05:00:11 CEST
I went back over the above and created an iCal Calendar File, which I
was then able to select when adding a new event.
Comment 14 Pierre Fortin 2022-06-15 05:01:48 CEST
Tried starting KOrg again and got this in journal.  Looks like bad userid somewhere...

Jun 14 22:56:38 pf.pfortin.com systemd[10106]: Started KOrganizer - Personal Organizer.
Jun 14 22:56:46 pf.pfortin.com akonadi_control[3476012]: Connecting to deprecated signal QDBusConnectionInterface::serviceOwnerChanged(QString,QString,QString)
Jun 14 22:56:46 pf.pfortin.com akonadiserver[3476015]: org.kde.pim.akonadiserver: Starting up the Akonadi Server...
Jun 14 22:56:46 pf.pfortin.com akonadiserver[3476015]: org.kde.pim.akonadiserver: mysqld for Akonadi is already running, trying to connect to it.
Jun 14 22:56:47 pf.pfortin.com plasmashell[3476020]: /usr/bin/mysqlcheck: Got error: 1044: Access denied for user ''@'localhost' to database 'akonadi' when selecting the database
Jun 14 22:56:47 pf.pfortin.com akonadiserver[3476015]: org.kde.pim.akonadiserver: Failed to create database
Jun 14 22:56:47 pf.pfortin.com akonadiserver[3476015]: org.kde.pim.akonadiserver: Query error: "Access denied for user ''@'localhost' to database 'akonadi' QMYSQL: Unable to execute query"
Jun 14 22:56:47 pf.pfortin.com akonadiserver[3476015]: org.kde.pim.akonadiserver: Database error: ""
Jun 14 22:56:47 pf.pfortin.com akonadiserver[3476015]: org.kde.pim.akonadiserver: Shutting down AkonadiServer...
Jun 14 22:56:47 pf.pfortin.com akonadi_control[3476012]: org.kde.pim.akonadicontrol: Application '/usr/bin/akonadiserver' exited normally...
Comment 15 Pierre Fortin 2022-06-15 05:11:29 CEST
Created attachment 13297 [details]
mysql.err

Found lots of errors in .local/share/akonadi/db_data/mysql.err

Tiny zip file; but it inflates to over 1MB -- LOTS of identical errors. Besides these errors, top & bottom of file may have clues...
Comment 16 Pierre Fortin 2022-06-15 05:19:32 CEST
(In reply to Dave Hodgins from comment #13)
> I went back over the above and created an iCal Calendar File, which I
> was then able to select when adding a new event.

Story of my life...  If there's the slightest flaw, I somehow manage to hit it...   LOL
Comment 17 Dave Hodgins 2022-06-15 05:21:05 CEST
Please try it again in the new user a account. Also, are all cauldron updates
installed?
Comment 18 Pierre Fortin 2022-06-15 05:50:33 CEST
Created a brand new userid. KOrg failed with "The Akonadi personal information management service is not operational".
I update at least once a day, sometimes 2.   Sigh...  yet another glibc and kernel...  Guess I need to reboot. It'll take at least a half hour to get back to my working environment, so enjoy some ZZZZs Dave.  Thanks!
Comment 19 Dave Hodgins 2022-06-15 06:13:28 CEST
I've managed to recreate the problem by deleting my account in my test
cauldron install, including the home directory. After re-adding the
user, akonadiserver is now failing with process error: "Unknown error".
I'll look into it more tomorrow.

Very strange as it was working after first installing korganizer as per
comment 12.
Comment 20 Pierre Fortin 2022-06-15 16:34:16 CEST
Rebooted. Started KOrg. Started creating new event...  Interesting; now the calendar account I tried creating in comment 7 (NCDT) now appears in the event window; but the Calendar list is:
  NC DT
  Personal Calendar
  akonadi_ical_resource_4
while the Settings>Calendars is now:
  Birthdays & Anniversaries
  NC DT
  Personal Calendar

Tried creating a new Calendar: seemed to work; but in the event window, it appears as akonadi_ical_resource_5, instead of the name (NC EIT) I used, below the others (see above).

Quit and restart KOrg; now akonadi_ical_resource_5 is at the top of the list in Settings>Calendars.  Trying to create a new event; akonadi_ical_resource_5 is the default calendar -- nope, although it's looking a tiny tad better, trying to save the event still errors out; even if I select the pre-defined Personal Calendar.
I agree with "strange"... :)
Comment 21 Dave Hodgins 2022-06-15 20:20:19 CEST
Narrowed it down a bit. From ~/.local/share/akonadi/db_data/mysql.err
2022-06-15 14:08:33 0 [Warning] option 'innodb-log-buffer-size': unsigned value 1048576 adjusted to 2097152
2022-06-15 14:08:33 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-06-15 14:08:33 0 [Note] InnoDB: Number of transaction pools: 1
2022-06-15 14:08:33 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
2022-06-15 14:08:33 0 [Note] InnoDB: Using Linux native AIO
2022-06-15 14:08:33 0 [Note] InnoDB: Initializing buffer pool, total size = 128.000MiB, chunk size = 2.000MiB
2022-06-15 14:08:33 0 [Note] InnoDB: Completed initialization of buffer pool
2022-06-15 14:08:33 0 [ERROR] InnoDB: File ./ib_logfile0 was not found
2022-06-15 14:08:33 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2022-06-15 14:08:33 0 [Note] InnoDB: Starting shutdown...
2022-06-15 14:08:34 0 [ERROR] Plugin 'InnoDB' init function returned error.
2022-06-15 14:08:34 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2022-06-15 14:08:34 0 [ERROR] Unknown/unsupported storage engine: innodb
2022-06-15 14:08:34 0 [ERROR] Aborting

So it looks like a problem between akonadi and mysqld that's been introduce
sometime in the last few months.

User accounts created months ago do not see the problem. New user accounts do.

I'll leave this in the hands of the kde team to figure out further.
Dave Hodgins 2022-06-15 20:28:56 CEST

Summary: add calendar fails; returns Knut sad face => akonadi fails to start mysqld

Comment 22 Pierre Fortin 2022-06-15 21:12:13 CEST
Dave, were you able to find a workaround for now? 

After system reboot and starting KOrg, I see this:
pfortin    11107  0.0  0.0 2828140 80400 ?       Sl   00:07   0:10 /usr/sbin/mysqld --defaults-file=/home/pfortin/.local/share/akonadi/mysql.conf --datadir=/home/pfortin/.local/share/akonadi/db_data/ --socket=/run/user/1000/

After hitting Start in mcc's System...Services, this is added:
mysql    1931617  1.6  0.0 2278436 80132 ?       Ssl  15:02   0:00 /usr/sbin/mysqld

but KOrg still fails.
Comment 23 Dave Hodgins 2022-06-16 01:24:25 CEST
No workaround obvious. akonadi requires, among other things mysql (aka mariadb).

For mysqld, when running as a system service, a regular user can not create
tables in it or update them if they exist, unless root has given the user
permission to.

With akonadi, it starts a copy of mysqld owned by the user, so it's limited
to using files and directories the user has access to. It's that copy that's
failing to start, likely due to errors in ~/.local/share/akonadi/mysql.conf

Either mariadb has been updated and akonadi not altered to work with the
changes, or akonadi has been updated introducing an error in the creation
of the ib_logfile0 file.
Comment 24 Pierre Fortin 2023-07-07 16:59:09 CEST
appears to be resolved; been using korganizer for a couple months now.

Status: NEW => RESOLVED
Resolution: (none) => WORKSFORME


Note You need to log in before you can comment on or make changes to this bug.