Ticket modified by Jérémy Carnus at 2010/03/16 18:52
Tracking System: Bugs
Category: SyncML
Version: Version 1.6.003
Status: Open
Resolution: None
Completed: 0%
Priority: 5 - medium
Created By: Jérémy Carnus
Assigned to: Jörg Lehrke
Summary: #2522 - Duplicates events and taks
I’m using syncml to sync with one phone and computer (for the same account)!
Sometimes, i have duplicated events on calendar! I don’t know why but I think there is a bug because if i checked the “last modified time” of events, the first and the duplicated have their date updated to the date of the sync?
Comment by Jérémy Carnus at 2010/03/16 18:52:
Hi,
to sum up:
3 accounts A,B,C
account A with one computer A
Account B with one computer B
Account C with one computer C and one phone D
Clients : funambol outlook and funambol windows mobile
Synchronisation every 15 minutes for all client!
All events and tasks ans notes are created on outlook or on the phone. I’m using egroupware like a Syncml Server. (so no events are created on EGW)
The problem seems to occur for events which multi-days (repeated every friday for example, the case of the morning)!
Sorry, but i can’t really disable the sync of contacts etc! but if you want i can just try new code.
Comment by Jörg Lehrke at 2010/03/16 15:04:
Hi, I checked your logs. The event
Anniversaire de FRIZAT
exists twice in the database – with (cal_id =1210) and without(cal_id=1268) exception on 2009/10/21.
I don’t know how you put event 1210 in your db because the exception date is not part of the recurrence.
Theses two events are exported from EGw over and over again and seemed never be confirmed by the client (no mapping).
I’m not sure whether you are running in some sort of race condition while syncing all for datastores simultaneously. Could you please try to disable all but e.g. the calendar synchronization to see whether this changes something?
Comment by Jérémy Carnus at 2010/03/16 12:29:
Hi,
Some duplicates (events with special scheduling and tasks and notes were created) this morning (march 16) at 08:45
Here you can download the log
http://jcarnus.fr/egroupware_syncml-1.6.log
Thanks
Comment by Jérémy Carnus at 2010/03/15 12:07:
It’s enabled!
This morning just one event on calendar was duplicate 4 times during this night (maybe the problem is because this event is scheduled every wednesday)
Also tasks were all duplicated 4 times!
next issue i will send you the log file!
Thanks
Comment by Jörg Lehrke at 2010/03/15 08:47:
I would need more detailed information to sort out the possible problem. Could you please enable the SyncML logging in
phpgwapi/inc/horde/config/conf.php ($conf[‘log’][‘enabled’] = true;)
You can change
$conf[‘log’][‘type’] = ‘file’;
to use a file instead of the error_log of your webserver.
Comment by Jérémy Carnus at 2010/03/14 13:22:
Hi,
There is a similar issue with tasks (in infolog)
Please can you tell me what exactly log you need?
I can’t reproduce this bug, there are sync every 15m and it fails occasionnaly! first i thought it was a problem with internet connection of the phone (3G) but last time it bugs with the funambol outlook client over ADSL line.
I noticed that this problem only occurs with the account which is synced with the phone and the computer! I have 2 more accounts just connected to outlook sync client and this bug don’t happen!
Here are the sql table of the infolog entries:
INSERT INTO egw_infolog (info_id, info_type, info_from, info_addr, info_subject, info_des, info_owner, info_responsible, info_access, info_cat, info_datemodified, info_startdate, info_enddate, info_id_parent, info_planned_time, info_replanned_time, info_used_time, info_status, info_confirm, info_modifier, info_link_id, info_priority, pl_id, info_price, info_percent, info_datecompleted, info_location, info_custom_from, info_uid) VALUES
(203, ‘note’, NULL, NULL, ‘NE PAS OUBLIER BAT SUR MER’, ‘NE PAS OUBLIER BAT SUR MER’, 7, ‘0’, ‘public’, 73, 1268337174, 0, 0, 0, 0, 0, 0, ‘done’, ‘not’, 7, 0, 1, NULL, NULL, 0, NULL, NULL, NULL, ‘infolog-203-d702f95eaa709d698419be7ec0ee85ad’),
(214, ‘note’, NULL, NULL, ‘NE PAS OUBLIER BAT S’, ‘NE PAS OUBLIER BAT SUR MER’, 7, ‘0’, ‘public’, 0, 1268427740, 1268427748, 0, 0, 0, 0, 0, ‘done’, ‘not’, 7, 0, 1, NULL, NULL, 0, NULL, NULL, NULL, ‘infolog-214-d702f95eaa709d698419be7ec0ee85ad’),
(28, ‘task’, NULL, NULL, ‘T° pour les extincteurs et plan de sortie’, NULL, 7, ‘0’, ‘public’, 0, 1267969717, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 2, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-28-d702f95eaa709d698419be7ec0ee85ad’),
(29, ‘task’, NULL, NULL, ‘Affichage obligatoire’, NULL, 7, ‘0’, ‘public’, 0, 1267969717, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 3, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-29-d702f95eaa709d698419be7ec0ee85ad’),
(30, ‘task’, NULL, NULL, ‘Date de fermeture’, NULL, 7, ‘0’, ‘public’, 0, 1267969717, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 3, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-30-d702f95eaa709d698419be7ec0ee85ad’),
(210, ‘task’, NULL, NULL, ‘Affichage obligatoire’, NULL, 7, ‘0’, ‘public’, 0, 1268427728, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 3, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-210-d702f95eaa709d698419be7ec0ee85ad’),
(211, ‘task’, NULL, NULL, ‘Affichage obligatoire’, NULL, 7, ‘0’, ‘public’, 0, 1268427728, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 3, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-211-d702f95eaa709d698419be7ec0ee85ad’),
(212, ‘task’, NULL, NULL, ‘Date de fermeture’, NULL, 7, ‘0’, ‘public’, 0, 1268427728, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 3, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-212-d702f95eaa709d698419be7ec0ee85ad’),
(213, ‘task’, NULL, NULL, ‘T° pour les extincteurs et plan de sortie’, NULL, 7, ‘0’, ‘public’, 0, 1268427728, 0, 0, 0, 0, 0, 0, ‘not-started’, ‘not’, 7, 0, 3, NULL, NULL, 0, 0, NULL, NULL, ‘infolog-213-d702f95eaa709d698419be7ec0ee85ad’);
here are the access log of apache of a good sync:
[12/Mar/2010:22:11:50 +0100] "POST /rpc.php HTTP/1.0" 200 7321 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:12:16 +0100] "POST /rpc.php?syncml_sessionid=syncml-c3485a616f5b3c3d28619761d1174968 HTTP/1.0" 200 897 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:12:27 +0100] "POST /rpc.php?syncml_sessionid=syncml-c3485a616f5b3c3d28619761d1174968 HTTP/1.0" 200 898 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:12:38 +0100] "POST /rpc.php?syncml_sessionid=syncml-c3485a616f5b3c3d28619761d1174968 HTTP/1.0" 200 891 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:12:51 +0100] "POST /rpc.php?syncml_sessionid=syncml-c3485a616f5b3c3d28619761d1174968 HTTP/1.0" 200 3131 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:13:10 +0100] "POST /rpc.php?syncml_sessionid=syncml-c3485a616f5b3c3d28619761d1174968 HTTP/1.0" 200 912 "-" "Funambol Pocket PC Sync Client 8.0.4"
When duplicates are created, the access logs are longer:
"POST /rpc.php HTTP/1.0" 200 7321 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:21:57:06 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4422 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.65 - - [12/Mar/2010:21:57:34 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4132 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:21:58:00 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4828 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.65 - - [12/Mar/2010:21:58:43 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4190 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.65 - - [12/Mar/2010:21:59:08 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4132 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:21:59:35 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4364 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:00:02 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 4364 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:00:45 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 3842 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:01:13 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 8700 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:01:52 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 1119 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.65 - - [12/Mar/2010:22:02:02 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 1230 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.64 - - [12/Mar/2010:22:02:14 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 6601 "-" "Funambol Pocket PC Sync Client 8.0.4"
193.253.141.65 - - [12/Mar/2010:22:02:40 +0100] "POST /rpc.php?syncml_sessionid=syncml-c6d95187a2fdc8d3f42285852b1dd148 HTTP/1.0" 200 1232 "-" "Funambol Pocket PC Sync Client 8.0.4"
I hope it will help you!
Thanks you
Comment by Jörg Lehrke at 1970/01/01 01:33:
Could you please find a way to reproduce the problem. I need more specific information to look into this issue. We did many tests before the release and found no open issues.
Linked entries:
http://www.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=2522&no_popup=1