[Tickets #6056] Re: Contacts get tripled using Synthesis Client

[bugs at horde.org]

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

Ticket URL: http://bugs.horde.org/ticket/6056
-----------------------------------------------------------------------
 Ticket             | 6056
 Updated By         | Klaus.Steinberger at Physik.Uni-Muenchen.DE
 Summary            | Contacts get tripled using Synthesis Client
 Queue              | SyncML
 Type               | Bug
 State              | Feedback
 Priority           | 2. Medium
 Milestone          |
 Patch              |
 Owners             | Jan Schneider
-----------------------------------------------------------------------


Klaus.Steinberger at Physik.Uni-Muenchen.DE (2008-05-20 11:58) wrote:

Looks like the indizes for horde_syncml_map are severly broken in the old
database. Probably something gone bad somewhere in one of the upgrade steps
from 3.1 to 3.2-rcX.

mysql> show index from horde_syncml_map;
+------------------+------------+------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| Table            | Non_unique | Key_name               | Seq_in_index |
Column_name        | Collation | Cardinality | Sub_part | Packed | Null |
Index_type | Comment |
+------------------+------------+------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
| horde_syncml_map |          1 | syncml_cuid_idx        |            1 |
syncml_syncpartner | A         |           5 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_cuid_idx        |            2 |
syncml_db          | A         |          12 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_cuid_idx        |            3 |
syncml_uid         | A         |          12 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_cuid_idx        |            4 |
syncml_cuid        | A         |        3860 |     NULL | NULL   | YES  |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_suid_idx        |            1 |
syncml_syncpartner | A         |           5 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_suid_idx        |            2 |
syncml_db          | A         |          12 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_suid_idx        |            3 |
syncml_uid         | A         |          12 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_suid_idx        |            4 |
syncml_suid        | A         |        1930 |     NULL | NULL   | YES  |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_syncpartner_idx |            1 |
syncml_syncpartner | A         |           5 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_db_idx          |            1 |
syncml_db          | A         |           4 |     NULL | NULL   |      |
BTREE      | NULL    |
| horde_syncml_map |          1 | syncml_uid_idx         |            1 |
syncml_uid         | A         |           2 |     NULL | NULL   |      |
BTREE      | NULL    |
+------------------+------------+------------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+
11 rows in set (0.00 sec)

I did remove the horde_synml_map and horde_syncml_anchor tables, cleaned
up addressbook and calender, and now the sync seem to work, at least with
test account and VPA.

With the production VPA and my normal account, it doesn't like to add
contacts now, but I will investigate that tomorrow.