| Summary: | akonadi fails to start mysqld | ||
|---|---|---|---|
| Product: | Mageia | Reporter: | Pierre Fortin <pfortin> |
| Component: | RPM Packages | Assignee: | KDE maintainers <kde> |
| Status: | RESOLVED WORKSFORME | QA Contact: | |
| Severity: | normal | ||
| Priority: | Normal | CC: | davidwhodgins |
| Version: | Cauldron | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | Linux | ||
| Whiteboard: | |||
| Source RPM: | korganizer-22.04.0-1.mga9 | CVE: | |
| Status comment: | |||
| Attachments: |
screenshot of Knut
akonadictl restart mysql.err |
||
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 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... What's the output of "akonadictl status"? CC:
(none) =>
davidwhodgins $ 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 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
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 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. Try creating a new user and see if it works for that user. No change. Same as after "akonadictl fsck" on main userid. 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. 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. 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. I went back over the above and created an iCal Calendar File, which I was then able to select when adding a new event. 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... 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...
(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 Please try it again in the new user a account. Also, are all cauldron updates installed? 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! 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. 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"... :) 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 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. 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. appears to be resolved; been using korganizer for a couple months now. Status:
NEW =>
RESOLVED |
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.