Bug 320757 - CalDAV Calender not shown anymore. Tasks only partly.
Summary: CalDAV Calender not shown anymore. Tasks only partly.
Status: RESOLVED FIXED
Alias: None
Product: Akonadi
Classification: Frameworks and Libraries
Component: DAV Resource (show other bugs)
Version: 4.10
Platform: Ubuntu Linux
: NOR normal
Target Milestone: ---
Assignee: kdepim bugs
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-06-05 09:59 UTC by Arthur Schiwon
Modified: 2014-09-08 08:03 UTC (History)
3 users (show)

See Also:
Latest Commit:
Version Fixed In: 4.10.4


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Arthur Schiwon 2013-06-05 09:59:22 UTC
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"
Comment 1 Grégory Oestreicher 2013-06-05 11:17:32 UTC
Hi Arthur,

Thanks for the report. This has been fixed in 4.10.4, released yesterday.

Cheers,
Grégory
Comment 2 Arthur Schiwon 2013-06-05 12:06:42 UTC
Cool, Thanks Grégory!
Comment 3 Arthur Schiwon 2013-06-07 11:12:40 UTC
After upgrade and using nepomukcleaner:  still no calendar. No tasks at all. Same error messages. What to do?
Comment 4 Arthur Schiwon 2013-06-07 11:14:52 UTC
Sorry, I was too fast. Now everything is there. Sorry and thanks again!
Comment 5 Arthur Schiwon 2013-07-10 09:25:37 UTC
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).
Comment 6 Ricardo J. Barberis 2013-07-21 19:17:22 UTC
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.
Comment 7 Ricardo J. Barberis 2013-07-21 19:19:48 UTC
Ah, I didn't realize you rebooted and your problem persisted.
My work around probably won't work for you :(
Comment 8 Ricardo J. Barberis 2013-07-21 19:21:15 UTC
And I meant KDE SC 4.4.x in my first comment, sorry for spamming your bug report!
Comment 9 Grégory Oestreicher 2013-09-03 20:01:23 UTC
(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.
Comment 10 Roger Larsson 2014-01-08 08:00:48 UTC
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...
Comment 11 Arthur Schiwon 2014-01-15 08:24:59 UTC
>> 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.
Comment 12 Unknown 2014-03-20 17:56:27 UTC
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
Comment 13 Unknown 2014-03-20 17:58:02 UTC
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
Comment 14 Grégory Oestreicher 2014-09-05 21:01:35 UTC
(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?
Comment 15 Arthur Schiwon 2014-09-07 21:29:55 UTC
Back using Kontact (4.14) i did not see this happening again.
Comment 16 Grégory Oestreicher 2014-09-08 08:03:34 UTC
Thanks for the update, closing.