[bug,3.2.1] Google calendar items duplicated after upgrade (workaround explained)

Wow, that's a really old one... I will give it a try and post updates.

Anyway, I will also keep this bug report open as it should be closed once the root cause is understood and it is fixed for public release.

Simply re-installing the app doesn't help to fix it (I've just wanted to try that option first, even though I've expected the result :)

I've renamed the Calendar folder (like it's removed) and synced the calendars again and I confirm the bug does not re-appear.

same issue here, and removing the "db" and "db.changed" files from /home/nemo/.local/share/system/privileged/Calendar/mkcal fixed the problem initially (I actually moved them to another folder, just in case)

but synchronising again makes duplicate entries being added every time

@cartron I have renamed the whole folder in my test and the fix is permanent (no duplicates so far). I haven't recovered from backup created before upgrade, I've only installed the Calendar app again and enabled Google calendar again and tried to sync few times.

@jovirkku - still same bug occurs after update :(

Under what conditions is it supposed to be solved : I have the 3.3.0.16 and it has dupplicated all my repeated events. I can delete my account as mentionned higher but I prefer to read what is the right path than trying in the dark. At least, I can say : "Doing nothing from a corrected without dupplicated events (because I had the bug in 3.2) doesn't solve it when upgrading to 3.3.0.16. Because rigth after the events are duplicated again. :-(

On XA2 and 3.2.1.20 this workaround does not help. While it gets rid of the duplicates initially, every sync will create a new copy of each calendar entry. I checked the contents of the database file (db) and it actually does have multiple entries for each calendar events. Here's an example:

$ sqlite3 db
sqlite> SELECT Summary, DateStart, DateEndDue, DateCreated,UID,URL FROM Componen
ts WHERE DateStart='1566367200';
MyEvent|1566367200|1566370800|1578074171|a2cce444-58f6-4bd4-9c42-9f4e105bcd8c|urn:x-ical:a2cce444-58f6-4bd4-9c42-9f4e105bcd8c
MyEvent|1566367200|1566370800|1578074187|12ffa64f-8039-40aa-ba33-2b50c12e89b5|urn:x-ical:12ffa64f-8039-40aa-ba33-2b50c12e89b5
MyEvent|1566367200|1566370800|1578075304|6de4c755-5212-4a3b-8066-2a1e912a05e1|urn:x-ical:6de4c755-5212-4a3b-8066-2a1e912a05e1

Afaics the only difference between these events are their UID and URL. The DateCreated does change, but it seems to be the time when the event was created in the Sailfish calendar.

Hi @mattock are you able to do the following to get some information about how and why duplicates are occurring, as I am unable to reproduce on my device (Sony Xperia original, not XA2):

systemctl --user stop msyncd
killall msyncd
MSYNCD_LOGGING_LEVEL=8 devel-su -p msyncd

then trigger sync.

Collect the (verbose) logs, and redact any personal information (usernames, passwords, event information which is private such as names/addresses, etc) and email to chris dot adams at jolla dot com? That would be very helpful - thanks.

@chris.adams I sent you the info you requested.

Thanks very much. Prospective fix can be found at https://git.sailfishos.org/mer-core/buteo-sync-plugins-social/merge_requests/54 - can you either build that one yourself, or use the prebuilt package I sent you, to test? Would be greatly appreciated.

Agh, testing showed that my fix introduced a different issue (which can result in a much worse problem: server-side duplication of events in some cases) so please don't attempt to test with that package until I have a chance to investigate and fix that issue.

Doesn't work on my Xperia X. Username and password suppossed to be the same as the Gmail one, aren't they? On Telegram you have events included in the path. Which is correct? But anyway both ways don't work for me.

Sorry, it was a format issue. "events" belongs to the path.

Yes, you have to use your Gmail username and password for the CalDAV account and replace the part pf the expression with brackets with your email. I unchecked CardDAV.

/calendar/dav/hello@gmail.com/events

thanks @jsommer, it seems to work! the only thing I had to do to make it work is create an "App password" on my GSuite account, since my company security does not allow to use my Google password for 3rd party apps.

Also, I see two times each appointment created before I added the CalDAV Google account - I think it's still somewhere in a database, since when i create a new appointment in my Google calendar, it only appears once on my Xperia.

Did you remove the Google calendar account completely at first? Did you try the following?

devel-su -c rm -f /home/nemo/.local/share/system/privileged/Sync/gcal.ini
devel-su -c rm -f /home/nemo/.local/share/system/privileged/Sync/gcontacts.ini

@jsommer - yes, i removed the Google account completely, then removed the gcal.ini and gcontacts.ini files probably there's still something in the mkcal folder, i'll look at that later

I have two Google calendars. Both affected by the bug.

I've deleted one of them and added back as you suggest. I confirm that duplicates are gone but I am still alerted 3 times, therefore the bug is fixed only partially and fixing it still requires developer tools and messing in terminal.

That's why I cannot accept your answer.

I recreated the account twice, both times I could get duplicates on each manual sync from the calendar app.