z-push 2.4.5 sync issue - 0xFFFFFFFF8004010F

Constin

Btw. problem not exist in Ubuntu 20.04 with mariadb. By me problem fixed by dist-upgrade to 20.04.
P.S. i don’t use community or subscribe packages. distr packages only, due to problem with php-mapi.

peterm888

Hello,

I’ve been struggling with this problem for ages (years!) and eventually found this post.

Several key pointers: max_packet_size and not restricting client sync duration (download all). As has been suggested, a possible performance problem.

Can I suggest turning on “slow query logging” in MariaDB (https://www.liquidweb.com/kb/mysql-performance-identifying-long-queries/). Also ref: https://forum.kopano.io/topic/713/properties-ibd-table-more-than-25gb/11

I would hesitate a guess that properties/tproperties tables are organised by folder, but not indexed by date (at least on my DB, and I cannot find the DB schema definitions online), so a common client query of “get emails for last month” will scan all emails in the folder, presumably triggering a timeout?

nib

Hi all,

Back with another bit of evidence towards a database issue. Up until 10 minutes ago, I was running MariaDB10 as a backend for kopano/z-push/fetchmail on UCS, attachments on a network share, not in the db.
Previously I had encountered issues with syncing a calendar with a new device. Some entries got lost, others wouldn’t disapear, in short: a sync problem.
I had absolutely inexplicable issues when I recently did a full reset on the device and then tried to add a new z-push client (android outlook) on that device for this account. It proved impossible to sync calendar entries for this account, but mail was syncing ok. Another account (older and actually more entries) synced seemingly ok at first, but had issues with new entries.

I finally found time to stop the server for an hour, migrate the kopano database to a “docker-based” mysqld 5.7.31 and restart.
Instantly, the calendar entries started to appear on the new device. No account refreshing, no z-push.admin magic, just look at the mobile, open outlook and calendar was properly synced.

To me, it seems to be a very well hidden performance issue with MariaDB 10 when devices try to z-push sync many entries. Could well be --as someone mentioned earlier-- a timeout in one of the involved subsystems on the chain between device and database, which is about all of them. And Mysql doesn’t have this issue, so I guess it is close to the DB server, if not the server itself.

Hope, finally someone finds the resources to fix this… once and for all.

Nib.

Hello everybody!

Has anyone had a chance to reproduce subject issue using nightly 10.0.x Kopano builds and MariaDB 10.3 ?

fbartels

Hi @Finji,

@Finji said in z-push 2.4.5 sync issue - 0xFFFFFFFF8004010F:

Has anyone had a chance to reproduce subject issue

so far the steps given here did not lead to a successful reproduction of the issue on our end.

Edit: I think I made that statement here before. But if you have a Kopano subscription and are experiencing this with our supported packages please reach out to our support so that we could have a direct look on your system. As far as I know there is not a single customer who has reported these kind of issues to our support.