Strange shift of recurring events
-
A quick check on the database:
MariaDB [kopano]> select * from properties where val_string='MyRecurringEvent'; +-------------+-----+------+-----------+------------------+------------+------------+-------------+--------+--------+------+ | hierarchyid | tag | type | val_ulong | val_string | val_binary | val_double | val_longint | val_hi | val_lo | comp | +-------------+-----+------+-----------+------------------+------------+------------+-------------+--------+--------+------+ | 1031398 | 55 | 30 | NULL | MyRecurringEvent | NULL | NULL | NULL | NULL | NULL | 0 | +-------------+-----+------+-----------+------------------+------------+------------+-------------+--------+--------+------+ 1 row in set (9.99 sec) MariaDB [kopano]> select * from properties where hierarchyid=1031398; +-------------+-------+------+-----------+----------------------------------------------------------+-------------------------------------------------------------------------------------------+------------+-------------+----------+------------+------+ | hierarchyid | tag | type | val_ulong | val_string | val_binary | val_double | val_longint | val_hi | val_lo | comp | +-------------+-------+------+-----------+----------------------------------------------------------+-------------------------------------------------------------------------------------------+------------+-------------+----------+------------+------+ | 1031398 | 26 | 30 | NULL | IPM.Appointment | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 54 | 3 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 55 | 30 | NULL | MyRecurringEvent | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 59 | 258 | NULL | NULL | ZARAFA:darian | NULL | NULL | NULL | NULL | 0 | | 1031398 | 61 | 30 | NULL | | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 65 | 258 | NULL | NULL | �!�P@��H��S0D% MjAwMQ== | NULL | NULL | NULL | NULL | 0 | | 1031398 | 66 | 30 | NULL | Darian | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 100 | 30 | NULL | ZARAFA | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 101 | 30 | NULL | darian | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 3591 | 3 | 9 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 3592 | 3 | 1597 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 3611 | 11 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 4224 | 3 | 1025 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 12295 | 64 | NULL | NULL | NULL | NULL | NULL | 30640068 | 752783872 | 0 | | 1031398 | 12296 | 64 | NULL | NULL | NULL | NULL | NULL | 30640304 | 1040502016 | 0 | | 1031398 | 12299 | 258 | NULL | NULL | ���O�W��A�� | NULL | NULL | NULL | NULL | 0 | | 1031398 | 16378 | 30 | NULL | darian | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 16379 | 258 | NULL | NULL | �!�P@��H��S0D% MjAwMQ== | NULL | NULL | NULL | NULL | 0 | ��jL�HNU�-5! | NULL | NULL | NULL | NULL | 0 | ��jL�HNU�-5! | NULL | NULL | NULL | NULL | 0 | | 1031398 | 26498 | 3 | 415873 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32773 | 3 | 2 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32781 | 64 | NULL | NULL | NULL | NULL | NULL | 30675133 | 2964549632 | 0 | | 1031398 | 32782 | 64 | NULL | NULL | NULL | NULL | NULL | 30675334 | 3676123136 | 0 | | 1031398 | 32787 | 3 | 1440 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32789 | 11 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | � ! | 258 | NULL | NULL | 00 0 0 � | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32791 | 3 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32792 | 3 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32803 | 11 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32817 | 3 | 4 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32818 | 30 | NULL | Occurs every year effective 01-07-2018 until 02-08-2023. | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32819 | 258 | NULL | NULL | ���� ���� | NULL | NULL | NULL | NULL | 0 | | 1031398 | 32820 | 30 | NULL | (GMT +01:00) | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33185 | 3 | 15 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33186 | 64 | NULL | NULL | NULL | NULL | NULL | 30675133 | 2964549632 | 0 | | 1031398 | 33187 | 11 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33190 | 11 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33200 | 3 | 369 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33204 | 11 | 1 | NULL | NULL | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33206 | 64 | NULL | NULL | NULL | NULL | NULL | 30675133 | 2964549632 | 0 | | 1031398 | 33207 | 64 | NULL | NULL | NULL | NULL | NULL | 30675334 | 3676123136 | 0 | | 1031398 | 33280 | 64 | NULL | NULL | NULL | NULL | NULL | 30675131 | 2554484224 | 0 | | 1031398 | 33603 | 258 | NULL | NULL | � � tŷ� 1 vCal-Uid 5f6006ab-0da5-4933-af01-6b29e7fad29b | NULL | NULL | NULL | NULL | 0 | | 1031398 | 33635 | 258 | NULL | NULL | � � tŷ� 1 vCal-Uid 5f6006ab-0da5-4933-af01-6b29e7fad29b | NULL | NULL | NULL | NULL | 0 | +-------------+-------+------+-----------+----------------------------------------------------------+-------------------------------------------------------------------------------------------+------------+-------------+----------+------------+------+ MariaDB [kopano]> select FROM_UNIXTIME((((val_hi << 32) + val_lo)-116444736000000000)/10000000) from properties where hierarchyid=1031398 and type=64; +------------------------------------------------------------------------+ | FROM_UNIXTIME((((val_hi << 32) + val_lo)-116444736000000000)/10000000) | +------------------------------------------------------------------------+ | 2018-01-07 15:31:16.0000 | | 2018-01-08 19:41:06.0000 | | 2018-07-01 00:00:00.0000 | | 2018-07-02 00:00:00.0000 | | 2018-07-01 00:00:00.0000 | | 2018-07-01 00:00:00.0000 | | 2018-07-02 00:00:00.0000 | | 2018-06-30 23:45:00.0000 | +------------------------------------------------------------------------+ 8 rows in set (0.00 sec) -
Hi Darian,
does it also happen the other way around, when you create a recurring appointment in webapp/deskapp?
Manfred
-
Unfortunately I cannot test this on my system. In Webapp I can setup the recurrence with all options but none of the buttons (OK, Cancel…) in the window do seem to respond to make the settings effective. The window remains open and closing is the only thing that works.
I installed Deskapp on Fedora but same issue :-( -
Hi @Darian which version of php are you using? And what distribution are you using?
-
@lherrmann I am using Centos 7. I wasn’t sure if I mixed up packages on my previous installation so I redeployed the latest nightly kopano php56-packages on a new instance. Webapp is running fine besides the recurrence window issue.
[root@kopano4 ~]# rpm -qa '*php*' rh-php56-php-mbstring-5.6.25-1.el7.x86_64 rh-php56-php-common-5.6.25-1.el7.x86_64 rh-php56-php-pear-1.9.5-4.el7.noarch rh-php56-php-5.6.25-1.el7.x86_64 php-mapi-webapp-0-4.1.noarch rh-php56-php-mysqlnd-5.6.25-1.el7.x86_64 rh-php56-php-soap-5.6.25-1.el7.x86_64 rh-php56-php-opcache-5.6.25-1.el7.x86_64 rh-php56-php-pecl-jsonc-1.3.6-3.el7.x86_64 rh-php56-php-cli-5.6.25-1.el7.x86_64 rh-php56-php-xml-5.6.25-1.el7.x86_64 rh-php56-2.3-1.el7.x86_64 php-mapi-8.5.80.77-188.1.x86_64 rh-php56-php-enchant-5.6.25-1.el7.x86_64 rh-php56-php-pdo-5.6.25-1.el7.x86_64 rh-php56-runtime-2.3-1.el7.x86_64 rh-php56-php-process-5.6.25-1.el7.x86_64 -
For some reason I could create a recurrent event via Webapp after I restarted the kopano services. I will first install z-push on that instance and retest the shift issue before I come back to you.
Thanks! -
Ok, so the new instance lets me create recurrent events via Webapp. They don’t get shifted. Events created on a mobile device for the 1. August still get shifted to 1. July. To exclude side effects coming from the existing data, I started with a clean database.
For anyone who would like to reproduce:
- Create an event on 1st August on your mobile device
- Make it an all day event
- Set the repetition to yearly
- Check Webapp/Deskapp if the event was stored on 1st August or 1st July
-
Hi Darian,
could you also test the latest nightly of Z-Push (the ones from the develop repo)?
Manfred
-
Hi Manfred,
just updated to the following packages from the development repo:
[root@kopano4 ~]# rpm -qa 'z-pus*' z-push-config-apache-2.4.0.beta1+15.44515e3-2286.1.noarch z-push-backend-kopano-2.4.0.beta1+15.44515e3-2286.1.noarch z-push-state-sql-2.4.0.beta1+15.44515e3-2286.1.noarch z-push-common-2.4.0.beta1+15.44515e3-2286.1.noarch z-push-ipc-sharedmemory-2.4.0.beta1+15.44515e3-2286.1.noarchAppointments end up where expected, no shifts observed so far!
-
There is another observation I made with the current 2.3.9 build but I am not sure if it is related with the observations above:
Many of my recurring all day appointments got vanished on my mobile devices. Especially halfway through the year I am missing 80% of the appointments. The missing items are consistent over all clients. I tried a resync or reinstalled accounts on my Android an iPhone devices with no luck. Upgrading z-push to 2.4.0 beta from the pre-final repo fixed those issues.
