Bug#939751:

2019-10-10 Thread Roel van Meer

Hi,

This patch fixes the problem (at least for me, on the one server where it  
manifested itself). It might not be the best solution though. I've sent it  
to Kopano to ask for feedback.


Cheers, Roel
Decrease ICS processing batch size

This fixes the following Z-push error:

   StatusException: ExportChangesICS->InitializeExporter():
   Error, mapi_exportchanges_config() failed: 0x8004010F
   - code: 12
   - file: /usr/share/z-push/backend/kopano/exporter.php:230

when running kopanocore with Mariadb 10.3.

Index: kopanocore-8.7.0/provider/libserver/ECICS.cpp
===
--- kopanocore-8.7.0.orig/provider/libserver/ECICS.cpp
+++ kopanocore-8.7.0/provider/libserver/ECICS.cpp
@@ -490,7 +490,7 @@ static ECRESULT getchanges_contents(stru
 	std::vector db_rows;
 	std::vector db_lengths;
 	static constexpr unsigned int ncols = 7;
-	unsigned long col_lengths[1000*ncols];
+	unsigned long col_lengths[500*ncols];
 	unsigned int length_counter = 0;
 
 	while (lpDBResult && (lpDBRow = lpDBResult.fetch_row()) != nullptr) {
@@ -506,7 +506,7 @@ static ECRESULT getchanges_contents(stru
 		}
 		db_rows.emplace_back(lpDBRow);
 		db_lengths.emplace_back(lpDBLen);
-		if (db_rows.size() == 1000) {
+		if (db_rows.size() == 500) {
 			er = lpHelper->ProcessRows(db_rows, db_lengths);
 			if (er != erSuccess)
 return er;


Bug#939751: (no subject)

2019-09-08 Thread Martin Wolf
I forgot to mention, that this incompatibility renders the entire
active-sync part unusable, because the mobile clients can't send or
receive emails and also delays e.g. outlook and thunderbird because of
the high server load.



Bug#939751: Kopano-Server in Stable not compatible with MariaDB 10.3

2019-09-08 Thread Martin Wolf
Package: kopano-server
Version: 8.7.0-3

severity: grave

After I completed my migration of my mails and the attachments to my Debian 10 
system with Kopano 8.7.0-3 my last step was
to get z-push working. 
After a few hours kopano-server produced 1.xx load and filled my z-push 
errorlog faster than I could read.

11/08/2019 02:57:42 [ 1764] [WARN] [myem...@mydomain.com] StatusException: 
ExportChangesICS->InitializeExporter(): Error, mapi_exportchanges_config() 
failed: 0x8004010F - code: 12 - file: 
/usr/share/z-push/backend/kopano/exporter.php:230

I searched for this warning and I found a post at the kopano forums:
https://forum.kopano.io/topic/2269/z-push-2-4-5-sync-issue-0x8004010f

It happens faster on bigger stores than on smaller ones or on clients who use 
the calendar excessively.

They only got it reliably working when they switched from mariadb to mysql, 
because kopano has some issues with the mariadb version shipped by debian.
After I uninstalled mariadb and migrated my database to mysql 5.7 kopano 
started to behave normally again.

I had no issues of the sort in the last three weeks with kopano + mysql.


Linux admailserver 4.19.0-6-amd64 #1 SMP Debian 4.19.67-2 (2019-08-28) x86_64 
GNU/Linux