Calendars duplicated when creating an event

Question

20

Calendars duplicated when creating an event

asked 2014-11-16 01:45:46 +0300

WhyNotHugo

2537 ●41 ●68 ●66

https://hugo.barrera.io/

updated 2015-02-02 12:29:45 +0300

AzP
1087 ●8 ●19 ●22

I created an event on a CalDAV calendar (on my phone), and not only did it not appear, but all events from that calendar disapeared, and I now have that calendar duplicated on my "Manage Calendars" screen:

image description

Deleting the calendar from Settings>Accounts makes both disapear, but there seems to be no workaround for creating new events from my phone.

[edit]
After adding the calendar again, the duplicates reappear and multiply, making matters worse.

edit retag flag offensive close delete

Comments

I can confirm this bug appeared after upgrading two of the Jolla phones in my family to Sailfish from version 1.0.8.21 (Tahkalampi) to 1.1.0.39 (Uitukka): I'm using generic CalDAV calendar only (CardDAV disabled) sync with Owncloud server v7.0.3. If I create a new calendar event with Jolla Calendar application then synchronization stops working and random old events may even disappear from Jolla Calendar even though they still may exists on the Owncloud server (and on Mozilla Thunderbird calendar which is also configured as a CalDAV client to the Owncloud server).

Not sure if this is relevant wrt CalDAV between Jolla and Owncloud server, but on the Owncloud server I'm using there are two other users who have shared all their calendars to me and I'm synchronizing all of them to my Jolla.

I've also noticed that sometimes entering the 'Manage calendars' view from the Calendar application pull down menu stalls for a very long time (well above 10 seconds) and finally shows the list of calendars with all entries multiplied several times, just as described in the original question by hobarrera. However, coming back to the 'Manage calendars' view later the calendars entries are listed normally again, once each. I'm using once per hour sync scheduling and there are quite a lot of both recurring and regular events in my Owncloud calendars changing quite often, so perhaps synchronization has been running in the background when I've seen the calendar list temporary multiplication issue?

Ville ( 2014-11-18 09:04:21 +0300 )edit

1

This is fixed for a while, but unfortunately not released, if you are brave enough you just need to compile and install this package: https://github.com/nemomobile/buteo-sync-plugin-caldav

VDVsx ( 2014-11-20 08:43:53 +0300 )edit

@Ville: Not related to owncloud, since I'm using radicale. @VDVsx: I'll look into it. My main concern right now is how to delete the duplicates.

WhyNotHugo ( 2014-11-20 10:21:58 +0300 )edit

@hobarrera - If removing acct does not help you can remove calendar db(you will loose all other calendar from device) or use this tool to remove single instances: https://github.com/pgerdt/mkcal/tree/eventtool/tools

VDVsx ( 2014-11-20 10:24:54 +0300 )edit

@VDVsx: Deleting all calendars wouldn't be an issue, since I don't use offline (eg: non-caldav) calendars. But I've failed to find the calendar db, regrettably.

WhyNotHugo ( 2014-11-20 12:28:38 +0300 )edit

I can confirm this bug appeared after upgrading two of the Jolla phones in my family to Sailfish from version 1.0.8.21 (Tahkalampi) to 1.1.0.39 (Uitukka): I'm using generic CalDAV calendar only (CardDAV disabled) sync with Owncloud server v7.0.3. If I create a new calendar event with Jolla Calendar application then synchronization stops working and random old events may even disappear from Jolla Calendar even though they still may exists on the Owncloud server (and on Mozilla Thunderbird calendar which is also configured as a CalDAV client to the Owncloud server).
Not sure if this is relevant wrt CalDAV between Jolla and Owncloud server, but on the Owncloud server I'm using there are two other users who have shared all their calendars to me and I'm synchronizing all of them to my Jolla.
I've also noticed that sometimes entering the 'Manage calendars' view from the Calendar application pull down menu stalls for a very long time (well above 10 seconds) and finally shows the list of calendars with all entries multiplied several times, just as described in the original question by hobarrera. However, coming back to the 'Manage calendars' view later the calendars entries are listed normally again, once each. I'm using once per hour sync scheduling and there are quite a lot of both recurring and regular events in my Owncloud calendars changing quite often, so perhaps synchronization has been running in the background when I've seen the calendar list temporary multiplication issue?
Ville ( 2014-11-18 09:04:21 +0300 )edit
This is fixed for a while, but unfortunately not released, if you are brave enough you just need to compile and install this package: https://github.com/nemomobile/buteo-sync-plugin-caldav
VDVsx ( 2014-11-20 08:43:53 +0300 )edit
@Ville: Not related to owncloud, since I'm using radicale. @VDVsx: I'll look into it. My main concern right now is how to delete the duplicates.
WhyNotHugo ( 2014-11-20 10:21:58 +0300 )edit
@hobarrera - If removing acct does not help you can remove calendar db(you will loose all other calendar from device) or use this tool to remove single instances: https://github.com/pgerdt/mkcal/tree/eventtool/tools
VDVsx ( 2014-11-20 10:24:54 +0300 )edit
@VDVsx: Deleting all calendars wouldn't be an issue, since I don't use offline (eg: non-caldav) calendars. But I've failed to find the calendar db, regrettably.
WhyNotHugo ( 2014-11-20 12:28:38 +0300 )edit

Answer 1

3

answered 2015-09-09 17:20:04 +0300

AzP
1087 ●8 ●19 ●22

This still isn't fixed and it drives me crazy... I'm trying to use my Jolla as my professional work phone and it's impossible when I never know if events actually get published/synced properly or not. Perhaps I also need to clean away all the old calendars to get it working properly again.

edit flag offensive delete publish link

Answer 2

1

answered 2015-10-22 00:03:28 +0300

mattikbk

1625 ●27 ●36 ●49

http://apulanta.fi/matti/

I managed to remove the extra calendars by using the answer from https://together.jolla.com/question/59173/delete-all-entries-from-a-calendar/ :

devel-su
sqlite3 /home/nemo/.local/share/system/privileged/Calendar/mkcal/db
SELECT * FROM Calendars;
DELETE FROM Components WHERE Notebook='<insert calendar id from the previous listing>';
DELETE FROM Calendars WHERE CalendarID='<insert calendar id from the previous listing>';

edit flag offensive delete publish link

Answer 3

3

answered 2017-03-13 16:35:54 +0300

Runningtrilo
163 ●9 ●15 ●19

updated 2017-03-13 16:37:36 +0300

Hello Jolla-users, i miss the "another question to the same problem" funktion.

Not an answer, but another question to the same problem.

I am using any calendars via caldav from my own server. After many startig-problems all calendars works well (greatest one over 1000 entries with outlook-invitations and many endless-appointments, smallest one with 20 birthday-dates).

When i create a new appointment or change one in the database (only tested from an other client not from jolla), my jolla duplicates the relevant calendar. During using the automatic-sync-funktion my jolla create allways an new calendar-copy, when a change ore a new entry is available.

To delete the new calendars is by the guidance on top possible, but not an intelligent way.

I need help.

(Sailfish OS 2.0.5.6)

edit flag offensive delete publish link

Comments

Hi, are you able to get sync logs as per https://sailfishos.org/wiki/CalDAV_and_CardDAV_Community_Contributions#Sync_Logs as that would provide some information which could be helpful in figuring out what is causing this issue in your case.

Thanks!

chris.adams ( 2017-03-15 03:07:18 +0300 )edit

Hi Chris, i send you my logs by e-mail on 15th March. sadly without any reaction.

Today, i installed the new update, but my problem is not solved.

Hubertus

Runningtrilo ( 2017-04-19 11:47:57 +0300 )edit

Hi Chris, is send you an actual log on your e-mail-address Hubertus

Runningtrilo ( 2017-04-19 13:03:09 +0300 )edit

Thanks, I received those logs now. As mentioned, unfortunately the log file suggests that the sync succeeds (and without any remote or local changes being detected, with A/M/R=0/0/0 in both stages).

I wonder whether there is a database corruption (check with "pragma integrity_check;" from sqlite3 prompt for the mkcal db file should help there), or other options is perhaps to try deleting the gcal sync anchors file from /home/nemo/.local/share/system/privileged/Sync/gcal.ini

Best regards, Chris.

chris.adams ( 2017-04-26 07:12:25 +0300 )edit

I lose confidence in a practicaly solution and i reset the phone to factory-settings. After an evening with several sailfish-updates / installing my apps and opening my accounts the phone operate proper for two days. Now my Jolla have 4 copys from each of my five calendars and the function of the caldav-sync is like before the reset.

p.s. i cant delete anything in the folder "privileged".

Runningtrilo ( 2017-05-13 12:32:27 +0300 )edit

Calendars duplicated when creating an event

Comments

3 Answers

Comments

Question tools

Stats

Related questions

Calendars duplicated when creating an event

Comments

3 Answers

Comments

Question tools

Public thread

Stats

Related questions