View Issue Details

IDProjectCategoryView StatusLast Update
0004939SOGoWeb Calendarpublic2021-10-06 18:34
Reporterdragoangel Assigned Tofrancis  
PriorityhighSeverityminorReproducibilitysometimes
Status resolvedResolutionfixed 
Product Versionnightly master 
Fixed in Version5.3.0 
Summary0004939: ICS WebCalendar with "Reload on login" block login
Description

In SOGo logs:
[74]: [ERROR] <0x55846b2d26a0[SOGoAppointmentObject]:20180621T221346Z--1004799908@some.ics> write failed: <MySQL4Exception: 0x55846ba10e70> NAME:ExecutionFailed REASON:Duplicate entry '224-20180621T221346Z--1004799908@some.ics' for key 'PRIMARY'

Steps To Reproduce
  1. import external webcalendar
  2. enable reload on login
  3. sync
  4. logout
  5. login
TagsNo tags attached.

Activities

francis

francis

2020-04-03 16:49

administrator   ~0014255

Check if your external calendar has duplicated UIDs.

dragoangel

dragoangel

2020-04-03 17:02

reporter   ~0014256

Hi, this external calendar is Confluence TeamCalendars. Do you know easy way to check this?

dragoangel

dragoangel

2020-04-03 17:03

reporter   ~0014257

Manually searching can take a lot. And at time of import this calendar working at SOGo

dragoangel

dragoangel

2020-04-03 17:04

reporter   ~0014258

Ho, I now realize that error has duid. Will check.

francis

francis

2020-04-03 17:38

administrator   ~0014259

You can start by looking at the UID reported in the log.

dragoangel

dragoangel

2020-04-03 18:30

reporter   ~0014260

I find exact calendar that was cause of issue, this even is repeat per year, but there no duplicates in UID. And in all other calendars there no such UID as well

dragoangel

dragoangel

2020-04-04 21:51

reporter   ~0014263

I send to you email with link to anonymized calendar, you can remove your email from thread if you can/want. Paste here some part that send to PM to not lose point:
looks like now I can't reproduce issue, maybe some update fixed it. Calendar reload on login not broke login fully now - SOGo is waiting really long on login screen, but had success to open mail client page. Previously when I initially create this bug SOGo instantly login to mail client page, but all page was white and no matter how many I wait it was still without any content. In any way SOGo will throw more then 1000 errors in log about one such load and consume many resources.

francis

francis

2020-04-06 18:02

administrator   ~0014266

I've subscribe to your calendar. With the latest code, I've seen no error during the import. It took about 30 seconds on my machine to import the calendar.

dragoangel

dragoangel

2020-04-06 22:07

reporter   ~0014269

After my last test I too not get blocked on login screen, but get 1000 errors in SOGo log about duplicates, did you get them as well? Or this only reproduce in my case? Thank you.

Related Changesets

sogo: master f017c426

2021-10-06 14:16

francis


Details Diff
perf(calendar(web)): initiate Web calendars reload from the frontend

The Web calendars subsciptions marked to be reloaded on login are no
longer reloaded from the backend; the sync operation is now activated
from the frontend in XHR calls to avoid blocking the Web interface.

Fixes 0004939
Affected Issues
0004939
mod - UI/MainUI/SOGoRootPage.m Diff File
mod - UI/PreferencesUI/UIxPreferences.m Diff File
mod - UI/WebServerResources/js/Preferences/Preferences.service.js Diff File

Issue History

Date Modified Username Field Change
2020-01-15 19:20 dragoangel New Issue
2020-04-03 16:49 francis Note Added: 0014255
2020-04-03 17:02 dragoangel Note Added: 0014256
2020-04-03 17:03 dragoangel Note Added: 0014257
2020-04-03 17:04 dragoangel Note Added: 0014258
2020-04-03 17:38 francis Note Added: 0014259
2020-04-03 18:30 dragoangel Note Added: 0014260
2020-04-04 21:51 dragoangel Note Added: 0014263
2020-04-06 18:02 francis Note Added: 0014266
2020-04-06 19:24 francis Severity block => minor
2020-04-06 22:07 dragoangel Note Added: 0014269
2021-10-06 18:34 francis Changeset attached => sogo master f017c426
2021-10-06 18:34 francis Assigned To => francis
2021-10-06 18:34 francis Resolution open => fixed
2021-10-06 18:34 francis Status new => resolved
2021-10-06 18:34 francis Fixed in Version => 5.3.0