Fresh and clean setup of KDEPIM 4.10.2. I added a CalDAV calender resource (serverd by my ownCloud 4.5). In the wizard, I chose genered CalDAV and configured everything myself. Meanwhile I upgraded to 4.10.3. It's already some weeks ago. What happens now is that my calenders (5 calenders in my CalDAV resource) are not shown. To be more precise: they are shown in the resource list, but no appointment is displayed (and there should be lots). In the Tasks/Todo View, also all ToDos vanished. Yesterday I added additional ones (via ownCloud), they do appear in Kontact. Old ones do not, however. There are odd Error messages in the log files (see additional information). Reproducible: Always Steps to Reproduce: 1. configure CalDAV resource 2. use it 3. after some days or so see described issues Actual Results: - CalDAV Calendars not shown - CalDAV Todos only shown partly Expected Results: - CalDAV Calendars shown - CalDAV Todos shown fully Log mysql.err (Akonadi internal DB. Never touched it.) 130605 11:02:56 [Note] Plugin 'FEDERATED' is disabled. 130605 11:02:56 InnoDB: The InnoDB memory heap is disabled 130605 11:02:56 InnoDB: Mutexes and rw_locks use GCC atomic builtins 130605 11:02:56 InnoDB: Compressed tables use zlib 1.2.7 130605 11:02:56 InnoDB: Using Linux native AIO 130605 11:02:56 InnoDB: Initializing buffer pool, size = 80.0M 130605 11:02:56 InnoDB: Completed initialization of buffer pool 130605 11:02:56 InnoDB: highest supported file format is Barracuda. 130605 11:03:00 InnoDB: Waiting for the background threads to start 130605 11:03:01 InnoDB: 5.5.31 started; log sequence number 388069446 130605 11:03:01 [Warning] Can't open and lock time zone table: Table 'mysql.time_zone_leap_second' doesn't exist trying to live without them 130605 11:03:01 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist 130605 11:03:01 [ERROR] Native table 'performance_schema'.'events_waits_current' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'events_waits_history' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'events_waits_history_long' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'setup_consumers' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'setup_instruments' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'setup_timers' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'performance_timers' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'threads' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'mutex_instances' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'rwlock_instances' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'cond_instances' has the wrong structure 130605 11:03:01 [ERROR] Native table 'performance_schema'.'file_instances' has the wrong structure 130605 11:03:01 [Note] /usr/sbin/mysqld: ready for connections. Version: '5.5.31-0ubuntu0.13.04.1' socket: '/home/blizzz/.local/share/akonadi/socket-zara/mysql.socket' port: 0 (Ubuntu) Log akonadiserver.error (looks like Nepomuk or what forgets parts of resource configurations??): Nepomuk Query Server not available "Cannot connect to agent instance with identifier 'akonadi_davgroupware_resource_2', error message: 'Could not get owner of name 'org.freedesktop.Akonadi.Resource.akonadi_davgroupware_resource_2': no such name'" ItemRetrieverException : Unable to contact resource Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id = :1 ) )" : "Deadlock found when trying to get lock; try restarting transaction QMYSQL3: Unable to execute statement" Error during executing query "UPDATE PimItemTable SET atime = :0 WHERE ( ( PimItemTable.id = :1 ) )" : "Deadlock found when trying to get lock; try restarting transaction QMYSQL3: Unable to execute statement"
Hi Arthur, Thanks for the report. This has been fixed in 4.10.4, released yesterday. Cheers, Grégory
Cool, Thanks Grégory!
After upgrade and using nepomukcleaner: still no calendar. No tasks at all. Same error messages. What to do?
Sorry, I was too fast. Now everything is there. Sorry and thanks again!
After some more time of "using": the problems in 4.10.5 remain. Sometimes calendar and tasks are shown, often not. Running nepomuk cleaner more or less regularly does not help. Which more information can I provide? Also, after a reboot Kontact states that Akonadi is not running, although it does. I need to restart Kontact (minor annoyance for me because I suspend my laptop usually).
Hi, I have seen a similar issue with kmail on KDE SC 4.8.x (the version we're currently stuck with at work). My workaround is to open a konsole and run 'akonadictl stop' and 'akonadictl status' till everything is stopped (especially the mysql), then I do 'ps fxu | grep mysql' and kill any instance of akonadi's mysql still running. After that is a simple matter of running 'akonadictl start' and everything is working properly again.
Ah, I didn't realize you rebooted and your problem persisted. My work around probably won't work for you :(
And I meant KDE SC 4.4.x in my first comment, sorry for spamming your bug report!
(In reply to comment #5) > After some more time of "using": the problems in 4.10.5 remain. Sometimes > calendar and tasks are shown, often not. Running nepomuk cleaner more or > less regularly does not help. > > Which more information can I provide? When the events and tasks disappear, can you have a look in akonadiconsole to see if they're still listed? If not, does restarting the resource help? I can have a similar behavior by forcefully clearing Akonadi's cache, but I don't think this is something that happens in normal circumstances.
This error report mentions ERROR performance schema. I had some problems fixing this... Searching on web reveals that you should run > mysql_upgrade [-u root -p] But that did not work... got a very unhelpful response Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck FATAL ERROR: Upgrade failed So how to do it... > ps aux | grep mysql Add the options given to your mysqld server, should look something like > mysql_upgrade --defaults-file=/home/USER/.local/share/akonadi/mysql.conf --datadir=/home/USER/.local/share/akonadi/db_data/ --socket=/tmp/akonadi-USER.wanykr/mysql.socket I did not need the '-u root -p' options...
>> Which more information can I provide? > When the events and tasks disappear, can you have a look in akonadiconsole to see if they're still listed? If not, does restarting the resource help? I can have a similar behavior by forcefully clearing Akonadi's cache, but I don't think this is something that happens in normal circumstances. Sorry, I don't have the setup anymore (i.e. no Akonadi at all). IIRC restarting resources did not help.
the error is still present even when I reboot and causes partial syncro ( I have only some of my appointment). I'll post here the "mysql.err" : http://pastebin.com/qrkhq0Zg Hope that will help you
sorry forgot : uname -a Linux NONE 3.12.6-1-CHAKRA #1 SMP PREEMPT Sat Feb 1 00:04:58 UTC 2014 x86_64 GNU/Linux
(In reply to mcmaur from comment #12) > the error is still present even when I reboot and causes partial syncro ( I > have only some of my appointment). Is this bug still present in the latest release?
Back using Kontact (4.14) i did not see this happening again.
Thanks for the update, closing.