View Issue Details

IDProjectCategoryView StatusLast Update
0005424SOGoBackend Address Bookpublic2022-01-24 18:32
Reporterdragoangel Assigned Tofrancis  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Platform[Server] LinuxOSDebianOS Version8 (Jessie)
Product Version5.2.0 
Fixed in Version5.5.1 
Summary0005424: CalDav missing contacts in GAL that available on SOGo Web and server
Description

I have 195 contacts on contacts while sync over CalDAV via TbSync provide only 145 contacts

Steps To Reproduce

Unknown, need help to understand how to debug this issue

TagsNo tags attached.

Relationships

related to 0004896 resolvedfrancis SOGoDomainsVisibility and GAL Address Book broken 

Activities

blackips

blackips

2021-11-08 13:02

reporter   ~0015601

Please have a look at my ticket 0005420 (https://www.sogo.nu/bugs/view.php?id=5420), especially the failed log. I use TbSync too and did a debug session with it for about 2 weeks.

To debug your issue open the TbSync settings screen, open the "Help" tab and change the Debug Mode to the most verbose option. When you find some entries like the following line, you have the same issue:
Skipped Card [USERNAME, true, false, true, true, true]
Skipped Card [USERNAME, false, true, true, true, true]

The first value after the username is a check if the HTTP return code is 200 (= request has been completed successfully), the second is for a valid ETag. Both values have to be true so TbSync can import/modify the entry into it's addresses database. Ehen you do further inverstigations, have a look for the occurence of entries like in my attached files in my ticket. If there are similar entries you ran into the same problem.

The sync issue occured after the 5.2.0 upgrade and cloud be fixed only be downgrading to 5.1.0...

dragoangel

dragoangel

2021-11-08 15:27

reporter   ~0015602

Last edited: 2022-01-11 15:38

Hi @blackips, yep, looks like I have same issue as you "Skipped Card", and also I started facing:

[EventLog] : 501
URL:
https://mail.example.com/SOGo/dav/user@example.com/ (PROPFIND)
dragoangel

dragoangel

2021-11-08 15:47

reporter   ~0015603

And you know... usual (not a GAL) books always works fine. I already have another bug, that maybe like also could be possible related: https://www.sogo.nu/bugs/view.php?id=4896

dragoangel

dragoangel

2022-01-11 14:13

reporter   ~0015738

Hi guys, any update? It still the issue on latest nightly build...

dragoangel

dragoangel

2022-01-12 08:52

reporter   ~0015755

If I will block access to GAL links over nginx (will return 503 instantly on nginx) SOGo will stop hanging up. So this proves that mysql connection exhaustions issue related to directly to not working GAL over CardDAV

dragoangel

dragoangel

2022-01-24 18:19

reporter   ~0015812

issue resolved by 0004896

Issue History

Date Modified Username Field Change
2021-11-05 11:52 dragoangel New Issue
2021-11-08 13:02 blackips Note Added: 0015601
2021-11-08 15:27 dragoangel Note Added: 0015602
2021-11-08 15:47 dragoangel Note Added: 0015603
2022-01-11 14:13 dragoangel Note Added: 0015738
2022-01-11 15:38 francis Note Edited: 0015602
2022-01-11 22:09 francis Relationship added related to 0004896
2022-01-12 08:52 dragoangel Note Added: 0015755
2022-01-24 18:19 dragoangel Note Added: 0015812
2022-01-24 18:32 francis Assigned To => francis
2022-01-24 18:32 francis Status new => resolved
2022-01-24 18:32 francis Resolution open => fixed
2022-01-24 18:32 francis Fixed in Version => 5.5.1