View Issue Details

IDProjectCategoryView StatusLast Update
0004598SOGoWeb Generalpublic2019-08-01 09:33
ReporterASolana Assigned To 
PrioritynormalSeverityminorReproducibilitysometimes
Status newResolutionopen 
Platform[Server] LinuxOSUbuntuOS Version16.04 LTS
Product Version4.0.2 
Summary0004598: Slow login when users have big web calendars subscribed.
Description

I noticed issues about slowly logins when users had web calendar subscriptions (Gmail calendars), a read only calendars.

Login action ends when all web calendars are fully loaded on database. You could see it in sogo.log (you must enable mysql/postgres verbose log).

Every web calendar event.ics has to be loaded in SOGo database, so if web calendars are big, it slows down login action a lot.

If user unsubscribe these web calendars and then he subscribe again then login action is fast.

The gmail calendars I saw had a lot of new events per day, it seems after some days a some kind of degradation appears that provokes the slowly login action.

Steps To Reproduce
  1. Subscribe a web calendar in SOGO webmail server.

  2. Create some new events every day in the remote web calendar. Do it for several days or weeks.

  3. After some days, weeks, you'll notice slowly login action in SOGo webmail server.

  4. Unsuscribe web calendar in SOGo webmail.
    Subscribe again.

You'll notice a fast login after.

TagsNo tags attached.

Activities

ASolana

ASolana

2019-01-25 14:46

reporter   ~0013281

This issue is still appearing with SOGo 4.0.4, our users are complaining about it.

ASolana

ASolana

2019-08-01 09:33

reporter   ~0013689

This issue is still appearing with SOGo 4.0.8, our users are complaining about it.

Issue History

Date Modified Username Field Change
2018-11-20 13:37 ASolana New Issue
2019-01-25 14:46 ASolana Note Added: 0013281
2019-08-01 09:33 ASolana Note Added: 0013689