[Tickets #12770] Re: Sync "loop" of Kolab categories <-> Horde tags sync

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12770
------------------------------------------------------------------------------
  Ticket             | 12770
  Updated By         | Git Commit <commits at lists.horde.org>
  Summary            | Sync "loop" of Kolab categories <-> Horde tags sync
  Queue              | Kronolith
  Version            | Git master
  Type               | Bug
  State              | Unconfirmed
  Priority           | 1. Low
  Milestone          |
  Patch              | 1
  Owners             |
------------------------------------------------------------------------------


Git Commit <commits at lists.horde.org> (2013-11-21 21:26) wrote:

Changes have been made in Git (master):

commit 24181adf76bef93aaefba40ebf66d25ec1c7a05d
Author: Thomas Jarosch <thomas.jarosch at intra2net.com>
Date:   Wed Oct 16 16:22:31 2013 +0200

     Fix sync "loop" of Kolab categories <-> Horde tags sync. Fixes #12770.

     Consider this scenario with a new, empty calendar:

     1. User inserts the first event. The event is tagged with "foobar".
        This tag is inserted into the tagging backend.
     2. User creates another event with a foreign Kolab client.
        This event is tagged "Foobar" (noticed the capital 'F')
     3. kronolith syncs in the foreign event. The Kolab sync tells
        the tag backend to store the tag(s) for the new event object,
        it does a case insensitive search for an existing tag label.
        -> it picks the existing row id of "foobar".

     The next time Event::synchronizeTags() runs, it notices
     the tags given by the Kolab driver for the second event
     differ from the tag backend ("Foobar" != "foobar")
         -> A sync is triggered.

     I have a productive calendar with about 2.000 events.
     The sync "loop" produces 3.6000+ INSERT / UPDATE statements
     on every click.

     Fix it by making the tag label comparison case insensitive.

     Signed-off-by: Michael J Rubinsky <mrubinsk at horde.org>

  kronolith/lib/Event.php |    6 ++++--
  1 files changed, 4 insertions(+), 2 deletions(-)

http://git.horde.org/horde-git/-/commit/24181adf76bef93aaefba40ebf66d25ec1c7a05d