[Akonadi] [Bug 315934] New: Akonadi can't load resource it created after closing the app (kaddressbook or korganizer)

Fri Mar 1 00:13:21 GMT 2013

https://bugs.kde.org/show_bug.cgi?id=315934

            Bug ID: 315934
           Summary: Akonadi can't load resource it created after closing
                    the app (kaddressbook or korganizer)
    Classification: Unclassified
           Product: Akonadi
           Version: 4.10
          Platform: Ubuntu Packages
                OS: Linux
            Status: UNCONFIRMED
          Severity: critical
          Priority: NOR
         Component: ICal file resource
          Assignee: kdepim-bugs at kde.org
          Reporter: alexandre.bonneau at linuxfr.eu

Akonadi chokes on data with multiple resource type (I tested kcal, ical,
icaldir, and vcarddir).

Reproducible: Always

Steps to Reproduce:
1. Create a new ical|icaldir|vcarddir resource within korganizer|kaddressbook
2. Point that resource to the ics or vcf files, click "OK"
3. Akonadi, mysqld and the korganizer|kaddressbook app are working (as well as
Nepomuk)
4. All your contacts|events and tasks are shown in the application, that's
great !
5. Close korganizer|kaddressbook (perhaps you need to restart Akonadi too)
6. Open korganizer|kaddressbook again
7. You get only one error per resource, like this one :
"AkonadiAgentServer(20469): akonadi_ical_resource: Can't find incidence with
uid  "f36a0552-a73e-4c0d-9945-e772057bfafe" ; item.id() =  521696 
ItemRetrieverException :  Unable to retrieve item from resource: <html>Invalid
item retrieved</html>"
Actual Results:  
As a result, you can no longer browser your precious data in
korganizer|kaddressbook nor in akonadiconsole.

Expected Results:  
If Akonadi can import data and show them once, don't choke on your own data.

### ICAL and ICALDIR resource ###
In the log I get this error :
"AkonadiAgentServer(20469): akonadi_ical_resource: Can't find incidence with
uid  "f36a0552-a73e-4c0d-9945-e772057bfafe" ; item.id() =  521696 
ItemRetrieverException :  Unable to retrieve item from resource: <html>Invalid
item retrieved</html>".
I found that this uid "f36a0552-a73e-4c0d-9945-e772057bfafe" is the uid of
___the very first row where data is null___, using this query :
"SELECT remoteId, data
FROM pimitemtable pit, parttable pt
WHERE collectionid = 2617 -- this is my agenda collection id 
AND pit.id = pt.pimItemId
AND data is not null;"
...and this uid exists in the std.ics file (`grep
"f36a0552-a73e-4c0d-9945-e772057bfafe" std.ics` return a line where it find
that uid, while querying the 'data' column in the akonadi database returns no
such characters string.

### VCARDDIR resource ###
With the vcarddir resource I get this same kind of error message (translated) :
"Can't find contact information with uid "0bWSNqn4C6"".
I found that this uid "0bWSNqn4C6" is the uid of ___the very first result where
'data' is not a vcard___ but a link to the file "0bWSNqn4C6_rX" into the folder
~/.local/share/akonadi/file_db_data/, and that file doesn't exists.
That error message states that the uid 0bWSNqn4C6 can't be found, but I can
with that query :
"SELECT *
FROM pimitemtable pit, parttable pt
WHERE collectionid = 2683
AND pit.id = pt.pimItemId
AND remoteId LIKE "%0bWSNqn4C6%";"
...and the file is physically present in the folder ~/.local/share/contacts
(and is not empty).

it seems like somehow Akonadi deletes files from
~/.local/share/akonadi/file_db_data/, but doesn't update the database..

Right now I'm trying to figure out if data that are entered via korganizer or
kadressbook is lost before the bug arise, but I think I lost one or two tasks
in that process..

Last but not least, I imported my data (ics and vcf) into another computer
still on 4.9.5 for a new user, and everything went fine (and still is, which is
the point of this bug report).

-- 
You are receiving this mail because:
You are the assignee for the bug.