Retrieving messages for the following external account has failed

[dragoslav]

Since the last update I have this error message:

******** (failing since 22/10/19 14:54)
Error: system failure: Folder sync failed, system failure: Synchronization of folder '/*******/INBOX' failed, system failure: UID FETCH failed: com.zimbra.cs.mailclient.CommandFailedException: UID FETCH failed: Error in response, UID FETCH failed: Error in response, Exception in response handler, system failure: Unable to get size of dataSource *******, Out of range value for column 'sum(mi.size)' : value 2149014610 is not in class java.lang.Integer range
The failed accounts will not update until the problem(s) have been resolved. Click OK to go to account preferences.

I have this error on all accounts with external IMAP

What can I do? I have no hope

[dragoslav]

From /opt/zimbra/log/mailbox.log

...
com.zimbra.common.service.ServiceException: system failure: Unable to get size of dataSource Old UCB
ExceptionId:ScheduledTask-10:1571785205964:7981563a5e16741b
Code:service.FAILURE
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:288)
at com.zimbra.cs.db.DbDataSource.getDataSourceUsage(DbDataSource.java:811)
at com.zimbra.cs.mailbox.Mailbox.getDataSourceUsage(Mailbox.java:10439)
at com.zimbra.cs.account.DataSource.getUsage(DataSource.java:553)
at com.zimbra.cs.datasource.MailItemImport$CurrentUsage.calculate(MailItemImport.java:257)
at com.zimbra.cs.datasource.MailItemImport$CurrentUsage.<init>(MailItemImport.java:251)
at com.zimbra.cs.datasource.MailItemImport.addMessage(MailItemImport.java:89)
at com.zimbra.cs.datasource.imap.ImapFolderSync.handleFetch(ImapFolderSync.java:1023)
at com.zimbra.cs.datasource.imap.ImapFolderSync.handleFetch(ImapFolderSync.java:991)
at com.zimbra.cs.datasource.imap.ImapFolderSync.access$200(ImapFolderSync.java:70)
at com.zimbra.cs.datasource.imap.ImapFolderSync$1.handleFetchResponse(ImapFolderSync.java:857)
at com.zimbra.cs.mailclient.imap.FetchResponseHandler.handleResponse(FetchResponseHandler.java:34)
at com.zimbra.cs.mailclient.imap.ImapConnection.processUntagged(ImapConnection.java:726)
at com.zimbra.cs.mailclient.imap.ImapConnection.processResponse(ImapConnection.java:700)
at com.zimbra.cs.mailclient.imap.ImapConnection.waitForResponse(ImapConnection.java:670)
at com.zimbra.cs.mailclient.imap.ImapConnection.sendRequest(ImapConnection.java:537)
at com.zimbra.cs.mailclient.imap.ImapRequest.send(ImapRequest.java:97)
at com.zimbra.cs.mailclient.imap.ImapRequest.sendCheckStatus(ImapRequest.java:113)
at com.zimbra.cs.mailclient.imap.ImapConnection.uidFetch(ImapConnection.java:352)
at com.zimbra.cs.datasource.imap.ImapFolderSync.fetchMessages(ImapFolderSync.java:873)
at com.zimbra.cs.datasource.imap.ImapFolderSync.fetchMessages(ImapFolderSync.java:776)
at com.zimbra.cs.datasource.imap.ImapFolderSync.syncMessages(ImapFolderSync.java:359)
at com.zimbra.cs.datasource.imap.ImapSync.syncMessages(ImapSync.java:339)
at com.zimbra.cs.datasource.imap.ImapSync.syncFolders(ImapSync.java:250)
at com.zimbra.cs.datasource.imap.ImapSync.importData(ImapSync.java:175)
at com.zimbra.cs.datasource.imap.ImapSync.importData(ImapSync.java:147)
at com.zimbra.cs.datasource.DataSourceManager.importData(DataSourceManager.java:406)
at com.zimbra.cs.datasource.DataSourceManager.importData(DataSourceManager.java:362)
at com.zimbra.cs.datasource.DataSourceTask.call(DataSourceTask.java:83)
at com.zimbra.cs.datasource.DataSourceTask.call(DataSourceTask.java:31)
at com.zimbra.common.util.TaskScheduler$TaskRunner.call(TaskScheduler.java:79)
at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304)
at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
at java.base/java.lang.Thread.run(Thread.java:834)
Caused by: java.sql.SQLException: Out of range value for column 'sum(mi.size)' : value 3333587169 is not in class java.lang.Integer range
at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.RowProtocol.rangeCheck(RowProtocol.java:275)
at org.mariadb.jdbc.internal.com.read.resultset.rowprotocol.TextRowProtocol.getInternalInt(TextRowProtocol.java:258)
at org.mariadb.jdbc.internal.com.read.resultset.SelectResultSet.getInt(SelectResultSet.java:1022)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
at org.apache.commons.dbcp.DelegatingResultSet.getInt(DelegatingResultSet.java:225)
... 34 more
2019-10-23 00:00:05,966 ERROR [ScheduledTask-10] [name=*******************.com;mid=77;ds=Old UCB;] datasource - UID FETCH failed: com.zimb$
com.zimbra.cs.mailclient.CommandFailedException: UID FETCH failed: Error in response
at com.zimbra.cs.mailclient.imap.ImapRequest.failed(ImapRequest.java:212)
at com.zimbra.cs.mailclient.imap.ImapRequest.send(ImapRequest.java:105)
at com.zimbra.cs.mailclient.imap.ImapRequest.sendCheckStatus(ImapRequest.java:113)
at com.zimbra.cs.mailclient.imap.ImapConnection.uidFetch(ImapConnection.java:352)
at com.zimbra.cs.datasource.imap.ImapFolderSync.fetchMessages(ImapFolderSync.java:873)
at com.zimbra.cs.datasource.imap.ImapFolderSync.fetchMessages(ImapFolderSync.java:776)
at com.zimbra.cs.datasource.imap.ImapFolderSync.syncMessages(ImapFolderSync.java:359)
at com.zimbra.cs.datasource.imap.ImapSync.syncMessages(ImapSync.java:339)
at com.zimbra.cs.datasource.imap.ImapSync.syncFolders(ImapSync.java:250)
at com.zimbra.cs.datasource.imap.ImapSync.importData(ImapSync.java:175)
at com.zimbra.cs.datasource.imap.ImapSync.importData(ImapSync.java:147)
at com.zimbra.cs.datasource.DataSourceManager.importData(DataSourceManager.java:406)
at com.zimbra.cs.datasource.DataSourceManager.importData(DataSourceManager.java:362)
...



Any suggestions?

[dragoslav]

News:

I just upgraded Zimbra on another test server. It happens exactly the same as on the first server. Definitely a bug in the last update.

How to post a bug? And how to restore to the previous version?

Code: Select all

Get:1 http://security.ubuntu.com/ubuntu xenial-security InRelease [109 kB]
Hit:2 http://cm.archive.ubuntu.com/ubuntu xenial InRelease
Get:3 http://cm.archive.ubuntu.com/ubuntu xenial-updates InRelease [109 kB]
Hit:4 https://repo.zimbra.com/apt/87 xenial InRelease
Hit:5 https://repo.zimbra.com/apt/8815 xenial InRelease
Get:6 http://cm.archive.ubuntu.com/ubuntu xenial-backports InRelease [107 kB]
Fetched 325 kB in 1s (170 kB/s)
Reading package lists... Done
This is 473 up on the previous count with 473 new packages.
There are 22 new upgrades
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following NEW packages will be installed:
  linux-headers-4.4.0-166 linux-headers-4.4.0-166-generic linux-image-4.4.0-166-generic linux-modules-4.4.0-166-generic
  linux-modules-extra-4.4.0-166-generic
The following packages will be upgraded:
  base-files bsdutils grub-legacy-ec2 initramfs-tools initramfs-tools-bin initramfs-tools-core libblkid1 libfdisk1 libmount1
  libsmartcols1 libuuid1 libxslt1.1 linux-generic linux-headers-generic linux-image-generic mount python3-distupgrade
  python3-update-manager ubuntu-release-upgrader-core update-manager-core util-linux uuid-runtime zimbra-clamav zimbra-clamav-lib
  zimbra-common-core-jar zimbra-common-core-libs zimbra-mbox-admin-console-war zimbra-mbox-store-libs zimbra-mbox-war
  zimbra-mbox-webclient-war zimbra-mta-components zimbra-patch
32 upgraded, 5 newly installed, 0 to remove and 0 not upgraded.
Need to get 178 MB/244 MB of archives.
After this operation, 295 MB of additional disk space will be used.
Do you want to continue? [Y/n] y

[yo_mono]

Hey, did you found a solution for this?
Im facing the same issue, and neither getting responses on this forum

[dragoslav]

There is no solution for now.

https://bugzilla.zimbra.com/show_bug.cgi?id=109249

[dragoslav]

This is the last Patch 3 informations:

https://wiki.zimbra.com/wiki/Zimbra_Releases/8.8.15/P3

Fixed issue with backup when mailbox had large amount of data

The default value for the Free Space Threshold value on NG Backup is now 2048Mb to improve usability.

[yo_mono]

Thats interesting.. but how this affects to the external accounts? I mean, what it has to do with the backup ng modue?
Besides.. I'm using the open source edition! I dont even have that module!
is there a way to change that limit?

[Ace Suares]

I have the same problem, it has a lot of effect on our users. Is there a solution? It got introduced after the last update via the ubuntu package system (apt/dpkg)
Release 8.8.15.GA.3829.UBUNTU16.64 UBUNTU16_64 FOSS edition.

[Ace Suares]

This is the error. It has a lot of impact on a lot of clients.

https://imgur.com/uEb2fiY

[andrey.ivanov]

From the look of the error message it seems like Zimbra code uses java int type to obtain the size of the external mailbox. The int size in java (java.lang.Integer) has the range from -2 147 483 648 to 2 147 483 647 corresponding to 2Gb. They should use java.lang.Long for that. If that is the case it is definitely a bug. You should create a ticket at support.zimbra.com.