Cloud Computing Insider Awards 2022: Vote for ONLYOFFICE
Vote for ONLYOFFICE

500 error after apt update

I did an update on ubuntu to the latest onlyoffice packages:

ii  onlyoffice-communityserver 11.1.0.1506  all          Community Server is a free open-source collaborative system developed to manage documents, projects, customer relationship and emails, all in one place.
ii  onlyoffice-controlpanel    3.1.0.460    all          Control Panel is an open-source component that provides tools to quickly configure and administrate self-hosted ONLYOFFICE, including backups, updates, and data encryption.
ii  onlyoffice-documentserver  7.1.1-23     amd64        Online editors for text documents, spreadsheets, and presentations

systemctl onlyoffice* showed one failed status:

onlyofficeMailAggregator.service - ONLYOFFICE MailAggregator Service
   Loaded: loaded (/lib/systemd/system/onlyofficeMailAggregator.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Thu 2022-06-09 12:49:33 CEST; 1s ago
  Process: 22599 ExecStartPre=/bin/bash -c rm -f /tmp/onlyofficeMailAggregator (code=exited, status=0/SUCCESS)
  Process: 22600 ExecStart=/usr/bin/mono-service -d:/var/www/onlyoffice/Services/MailAggregator -l:/tmp/onlyofficeMailAggregator /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe (code=exited, status=0/SUCCESS)
 Main PID: 22601 (code=exited, status=1/FAILURE)

Jun 09 12:49:31 oocs systemd[1]: Starting ONLYOFFICE MailAggregator Service...
Jun 09 12:49:31 oocs systemd[1]: Started ONLYOFFICE MailAggregator Service.
Jun 09 12:49:33 oocs mono[22601]: /var/www/onlyoffice/Services/MailAggregator/ASC.Mail.Aggregator.CollectionService.exe: The given key '0' was not present in the dictionary.
Jun 09 12:49:33 oocs systemd[1]: onlyofficeMailAggregator.service: Main process exited, code=exited, status=1/FAILURE
Jun 09 12:49:33 oocs systemd[1]: onlyofficeMailAggregator.service: Failed with result 'exit-code'

in web.log:

2022-06-09 11:37:10,033 ERROR [5] ASC.Resources - Can not get resource from TalkResource.resx for en: GetString(ProductName), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:10,145 ERROR [5] ASC.Resources - Can not get resource from TalkResource.resx for Neutral: GetString(ProductName), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:10,502 ERROR [5] ASC.Resources - ReplaceLogo System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:10,796 ERROR [5] ASC.Web - Warmup error System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:10,801 ERROR [5] ASC - Start Warmup System.NullReferenceException: Object reference not set to an instance of an object
2022-06-09 11:37:45,851 ERROR [5] ASC.Resources - Can not get resource from CRMCommonResource.resx for en-US: GetString(ProductName), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:45,970 ERROR [5] ASC.Resources - Can not get resource from CRMCommonResource.resx for en: GetString(ProductName), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:46,224 ERROR [5] ASC.Resources - Can not get resource from CRMCommonResource.resx for Neutral: GetString(ProductName), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:46,601 ERROR [5] ASC.Resources - ReplaceLogo System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:46,788 ERROR [5] ASC.Resources - Can not get resource from CRMVoipResource.resx for en-US: GetString(VoipModuleTitle), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:46,873 ERROR [5] ASC.Resources - Can not get resource from CRMVoipResource.resx for en: GetString(VoipModuleTitle), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:46,965 ERROR [5] ASC.Resources - Can not get resource from CRMVoipResource.resx for Neutral: GetString(VoipModuleTitle), System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
2022-06-09 11:37:47,216 ERROR [5] ASC.Resources - ReplaceLogo System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.

mail.cln.log:

2022-06-09 12:59:45,310 ERROR [193] ASC.Mail.Cleaner - Timer->workTimer_Elapsed. Exception:
System.Collections.Generic.KeyNotFoundException: The given key '0' was not present in the dictionary.
  at System.Collections.Generic.Dictionary`2[TKey,TValue].get_Item (TKey key) [0x0001e] in <f2b3ab7dfff746f594d2ef5b16ec3c90>:0
  at MySql.Data.MySqlClient.MySqlField.SetFieldEncoding () [0x00034] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlField.set_CharacterSetIndex (System.Int32 value) [0x00007] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.NativeDriver.GetColumnData (MySql.Data.MySqlClient.MySqlField field) [0x000ad] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.NativeDriver.GetColumnsData (MySql.Data.MySqlClient.MySqlField[] columns) [0x00004] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.Driver.GetColumns (System.Int32 count) [0x0001c] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.ResultSet.LoadColumns (System.Int32 numCols) [0x00000] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.ResultSet..ctor (MySql.Data.MySqlClient.Driver d, System.Int32 statementId, System.Int32 numCols) [0x0002a] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00039] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x000d5] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x00039] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlDataReader.Dispose (System.Boolean disposing) [0x00003] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlDataReader.Dispose () [0x00000] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x0004b] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.Driver.Configure (MySql.Data.MySqlClient.MySqlConnection connection) [0x0017e] in <da785fc808b442f0b54e3e25a667809f>:0
  at MySql.Data.MySqlClient.MySqlConnection.Open () [0x002c8] in <da785fc808b442f0b54e3e25a667809f>:0
  at ASC.Common.Data.DbManager.OpenConnection () [0x00006] in <83cbfc6ece0d432397ee6810dc678fae>:0
  at ASC.Common.Data.DbManager.get_Command () [0x0000e] in <83cbfc6ece0d432397ee6810dc678fae>:0
  at ASC.Common.Data.DbManager.ExecuteList (ASC.Common.Data.Sql.ISqlInstruction sql) [0x00000] in <83cbfc6ece0d432397ee6810dc678fae>:0
  at ASC.Mail.Core.Dao.MailboxDao.GetRangeMailboxes (ASC.Mail.Core.Dao.Expressions.Mailbox.IMailboxExp exp) [0x00030] in <589ed54f222841b698d18aed147147ed>:0
  at ASC.Mail.Core.Engine.MailboxEngine.GetRangeMailboxes (ASC.Mail.Core.Dao.Expressions.Mailbox.IMailboxExp exp) [0x0000c] in <589ed54f222841b698d18aed147147ed>:0
  at ASC.Mail.Iterators.MailboxIterator..ctor (System.Int32 tenant, System.String userId, System.Nullable`1[T] isRemoved, ASC.Common.Logging.ILog log) [0x00076] in <589ed54f222841b698d18aed147147ed>:0
  at ASC.Mail.Core.Engine.MailGarbageEngine.ClearMailGarbage (System.Threading.CancellationToken cancelToken) [0x00027] in <589ed54f222841b698d18aed147147ed>:0
  at ASC.Mail.StorageCleaner.StorageCleanerService.IntervalTimer_Elapsed (System.Object state) [0x00024] in <114553cd5c63491981ade4c0db7193f4>:0

Related ticket: https://github.com/ONLYOFFICE/CommunityServer/issues/394

Issue has been resolved, see github link above for details.