Mail: Inbox is not loading -- Duplicate entry '7050-8' for key 'mail_msg_mb_uid_idx'

Created on 12 Oct 2020  ·  12Comments  ·  Source: nextcloud/mail

My Inbox isn't loading anymore.
It seems there is a problem with the database. I had database problems regarding the mail app during upgrade from NC 19 --> 20.

What can I do, do you need more Info?

[mail] Error: OCA\Mail\Exception\ServiceException: Sync failed for 3:INBOX: An exception occurred while executing 'INSERT INTO `oc_mail_messages` (`uid`, `message_id`, `references`, `in_reply_to`, `thread_root_id`, `mailbox_id`, `subject`, `sent_at`, `flag_answered`, `flag_deleted`, `flag_draft`, `flag_flagged`, `flag_seen`, `flag_forwarded`, `flag_junk`, `flag_notjunk`, `flag_important`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [7050, "<20200916180658866.C2F5B45E327D9BAB@PC-Saskia>", "[]", null, "<20200916180658866.C2F5B45E327D9BAB@PC-Saskia>", 8, "Abaana Afrika Term News - September 2020", 1600279626, false, false, false, false, true, false, false, false, false]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7050-8' for key 'mail_msg_mb_uid_idx' at <<closure>>

0. /var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php line 127
   OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox {id: 8}, OC\AppFramework\ScopedPsrLogger {}, 42, null, false, true)
1. /var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php line 92
   OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramework\ScopedPsrLogger {})
2. /var/www/html/lib/public/BackgroundJob/Job.php line 80
   OCA\Mail\BackgroundJob\SyncJob->run({accountId: 3})
3. /var/www/html/lib/public/BackgroundJob/TimedJob.php line 61
   OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})
4. /var/www/html/cron.php line 126
   OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

at 2020-10-11T23:45:02+00:00


Complete Error Log

``php OCA\Mail\Exception\ServiceException: Sync failed for 3:INBOX: An exception occurred while executing 'INSERT INTOoc_mail_messages(uid,message_id,references,in_reply_to,thread_root_id,mailbox_id,subject,sent_at,flag_answered,flag_deleted,flag_draft,flag_flagged,flag_seen,flag_forwarded,flag_junk,flag_notjunk,flag_important`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [7050, "<20200916180658866.C2F5B45E327D9BAB@PC-Saskia>", "[]", null, "<20200916180658866.C2F5B45E327D9BAB@PC-Saskia>", 8, "Abaana Afrika Term News - September 2020", 1600279626, false, false, false, false, true, false, false, false, false]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7050-8' for key 'mail_msg_mb_uid_idx'

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 127:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null, false, true)

/var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php - line 92:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramew ... {})

/var/www/html/lib/public/BackgroundJob/Job.php - line 80:

OCA\Mail\BackgroundJob\SyncJob->run({ accountId: 3})

/var/www/html/lib/public/BackgroundJob/TimedJob.php - line 61:

OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})

/var/www/html/cron.php - line 126:

OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

Verursacht durchDoctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO oc_mail_messages (uid, message_id, references, in_reply_to, thread_root_id, mailbox_id, subject, sent_at, flag_answered, flag_deleted, flag_draft, flag_flagged, flag_seen, flag_forwarded, flag_junk, flag_notjunk, flag_important) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [7050, "<20200916180658866.C2F5B45E327D9BAB@PC-Saskia>", "[]", null, "<20200916180658866.C2F5B45E327D9BAB@PC-Saskia>", 8, "Abaana Afrika Term News - September 2020", 1600279626, false, false, false, false, true, false, false, false, false]: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7050-8' for key 'mail_msg_mb_uid_idx'

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 169:

Doctrine\DBAL\Driver\AbstractMySQLDriver->convertException("An exceptio ... '", Doctrine\DBA ... ]})

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php - line 149:

Doctrine\DBAL\DBALException::wrapException(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "An exceptio ... '")

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1071:

Doctrine\DBAL\DBALException::driverExceptionDuringQuery(Doctrine\DBA ... {}, Doctrine\DBA ... ]}, "INSERT INTO ... )", { 1: 7050,2: ... e})

/var/www/html/lib/private/DB/Connection.php - line 214:

Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ 7050,"<202 ... e], [ 1,2,2,0,2, ... 5])

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 209:

OC\DB\Connection->executeUpdate("INSERT INTO ... )", { uid: 7050, ... e}, { uid: 1,mes ... 5})

/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php - line 217:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/html/custom_apps/mail/lib/Db/MessageMapper.php - line 279:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 345:

OCA\Mail\Db\MessageMapper->insertBulk(OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null})

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 217:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->runPartialSync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null)

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 127:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null, false, true)

/var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php - line 92:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramew ... {})

/var/www/html/lib/public/BackgroundJob/Job.php - line 80:

OCA\Mail\BackgroundJob\SyncJob->run({ accountId: 3})

/var/www/html/lib/public/BackgroundJob/TimedJob.php - line 61:

OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})

/var/www/html/cron.php - line 126:

OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

Verursacht durchDoctrine\DBAL\Driver\PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7050-8' for key 'mail_msg_mb_uid_idx'

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1062:

Doctrine\DBAL\Driver\PDOStatement->execute()

/var/www/html/lib/private/DB/Connection.php - line 214:

Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ 7050,"<202 ... e], [ 1,2,2,0,2, ... 5])

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 209:

OC\DB\Connection->executeUpdate("INSERT INTO ... )", { uid: 7050, ... e}, { uid: 1,mes ... 5})

/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php - line 217:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/html/custom_apps/mail/lib/Db/MessageMapper.php - line 279:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 345:

OCA\Mail\Db\MessageMapper->insertBulk(OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null})

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 217:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->runPartialSync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null)

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 127:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null, false, true)

/var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php - line 92:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramew ... {})

/var/www/html/lib/public/BackgroundJob/Job.php - line 80:

OCA\Mail\BackgroundJob\SyncJob->run({ accountId: 3})

/var/www/html/lib/public/BackgroundJob/TimedJob.php - line 61:

OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})

/var/www/html/cron.php - line 126:

OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

Verursacht durchPDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7050-8' for key 'mail_msg_mb_uid_idx'

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php - line 127:

PDOStatement->execute(null)

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Connection.php - line 1062:

Doctrine\DBAL\Driver\PDOStatement->execute()

/var/www/html/lib/private/DB/Connection.php - line 214:

Doctrine\DBAL\Connection->executeUpdate("INSERT INTO ... )", [ 7050,"<202 ... e], [ 1,2,2,0,2, ... 5])

/var/www/html/3rdparty/doctrine/dbal/lib/Doctrine/DBAL/Query/QueryBuilder.php - line 209:

OC\DB\Connection->executeUpdate("INSERT INTO ... )", { uid: 7050, ... e}, { uid: 1,mes ... 5})

/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php - line 217:

Doctrine\DBAL\Query\QueryBuilder->execute()

/var/www/html/custom_apps/mail/lib/Db/MessageMapper.php - line 279:

OC\DB\QueryBuilder\QueryBuilder->execute()

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 345:

OCA\Mail\Db\MessageMapper->insertBulk(OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null}, OCA\Mail\Db\Message { id: null})

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 217:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->runPartialSync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null)

/var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php - line 127:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox { id: 8}, OC\AppFramew ... {}, 42, null, false, true)

/var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php - line 92:

OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramew ... {})

/var/www/html/lib/public/BackgroundJob/Job.php - line 80:

OCA\Mail\BackgroundJob\SyncJob->run({ accountId: 3})

/var/www/html/lib/public/BackgroundJob/TimedJob.php - line 61:

OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})

/var/www/html/cron.php - line 126:

OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

```

Expected behavior

Inbox should show my Mails.

Actual behavior

Inbox is loading forever.

Mail app

Mail app version: 1.5.0

Mailserver or service: mailbox.org

Server configuration

Operating system: Ubuntu 18 LTS, official Apache Docker Image

Web server: Apache

Database: MariaDB

PHP version: 7.4.11

Nextcloud Version: 20.0.0

Client configuration

Browser: Firefox 81

Operating system: Windows

0. to triage bug
Source
picture menaceone

All 12 comments

There is logic to prevent this scenario. Is this a persistent error or was it only seen a single time?

ChristophWurst picture ChristophWurst on 12 Oct 2020

I have only two Log Errors. both with same Exception but for different Mails.
However Inbox isn't loading at all.

menaceone picture menaceone on 12 Oct 2020

In my Firefox Debug Console I get these errors which show not up in _nextcloud.log_
[ERROR] mail: Background sync failed: undefined Object { app: "mail", uid: "user_x", error: MailboxLockedError }
[INFO] mail: Mailbox is locked Object { app: "mail", uid: "user_x", error: MailboxLockedError }

menaceone picture menaceone on 12 Oct 2020

got new error, mails not loading.


Error Log

[mail] Error: OCA\Mail\Exception\ServiceException: Sync failed for 3:INBOX: An exception occurred while executing 'INSERT INTO `oc_mail_messages` (`uid`, `message_id`, `references`, `in_reply_to`, `thread_root_id`, `mailbox_id`, `subject`, `sent_at`, `flag_answered`, `flag_deleted`, `flag_draft`, `flag_flagged`, `flag_seen`, `flag_forwarded`, `flag_junk`, `flag_notjunk`, `flag_important`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [7051, "<[email protected]>", "[]", null, "<[email protected]>", 8, "Cron <root@homerserver> \/home\/user\/skript.sh", 1600324248, false, false, false, false, true, false, false, false, false]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7051-8' for key 'mail_msg_mb_uid_idx' at <<closure>>

0. /var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php line 127
   OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox {id: 8}, OC\AppFramework\ScopedPsrLogger {}, 42, null, false, true)
1. /var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php line 92
   OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramework\ScopedPsrLogger {})
2. /var/www/html/lib/public/BackgroundJob/Job.php line 80
   OCA\Mail\BackgroundJob\SyncJob->run({accountId: 3})
3. /var/www/html/lib/public/BackgroundJob/TimedJob.php line 61
   OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})
4. /var/www/html/cron.php line 126
   OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

at 2020-10-13T23:55:01+00:00

Regarding Server Issue 5539 I can't delete all Mail app data for a clean reset.
Am I right?

menaceone picture menaceone on 14 Oct 2020

Am I right?

yes

ChristophWurst picture ChristophWurst on 27 Oct 2020
😕1

Updates to NC 20.0.1 and Mail 1.7.0 don't change behaviour.
Anything I can do?

menaceone picture menaceone on 13 Nov 2020

Is it always Duplicate entry 'abc-xyz' for key 'mail_msg_mb_uid_idx'? I still don't understand how this is happening.

ChristophWurst picture ChristophWurst on 17 Nov 2020

Yes it is always this pattern.
Every 12 hours I get a log error entry with this error.
e.g. from today 01:35 PM:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7051-8' for key 'mail_msg_mb_uid_idx'


Complete Error Log

``php [mail] Error: OCA\Mail\Exception\ServiceException: Sync failed for 3:INBOX: An exception occurred while executing 'INSERT INTOoc_mail_messages(uid,message_id,references,in_reply_to,thread_root_id,mailbox_id,subject,sent_at,flag_answered,flag_deleted,flag_draft,flag_flagged,flag_seen,flag_forwarded,flag_junk,flag_notjunk,flag_important`) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [7051, "1M6Db0-1kPQD63XB2-006iyW@mail.gmx.com", "[]", null, "1M6Db0-1kPQD63XB2-006iyW@mail.gmx.com", 8, "Cron \/home\/xxx\/scripts\/backupskript.sh", 1600324248, false, false, false, false, true, false, false, false, false]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '7051-8' for key 'mail_msg_mb_uid_idx' at <>

  1. /var/www/html/custom_apps/mail/lib/Service/Sync/ImapToDbSynchronizer.php line 128
    OCA\Mail\Service\Sync\ImapToDbSynchronizer->sync(OCA\Mail\Account {}, OCA\Mail\Db\Mailbox {id: 8}, OC\AppFramework\ScopedPsrLogger {}, 42, null, false, true)
  2. /var/www/html/custom_apps/mail/lib/BackgroundJob/SyncJob.php line 92
    OCA\Mail\Service\Sync\ImapToDbSynchronizer->syncAccount(OCA\Mail\Account {}, OC\AppFramework\ScopedPsrLogger {})
  3. /var/www/html/lib/public/BackgroundJob/Job.php line 80
    OCA\Mail\BackgroundJob\SyncJob->run({accountId: 3})
  4. /var/www/html/lib/public/BackgroundJob/TimedJob.php line 61
    OCP\BackgroundJob\Job->execute(OC\BackgroundJob\JobList {}, OC\Log {})
  5. /var/www/html/cron.php line 127
    OCP\BackgroundJob\TimedJob->execute(OC\BackgroundJob\JobList {}, OC\Log {})

at 2020-11-17T12:35:01+00:00
```

menaceone picture menaceone on 17 Nov 2020

Every 12h? This makes it even more weird. I'm assuming your cron runs every 5 to 15 minutes?

ChristophWurst picture ChristophWurst on 17 Nov 2020

yupp, cron is running every 15min

menaceone picture menaceone on 17 Nov 2020

As I stated in Issue description, it started after upgrading NC19 to NC20.
First upgrade attempt quit with an error regarding Mail app. I just restarted upgrade process and it worked.
Unfortunately I don't have a record from the error during 1st upgrade attempt.

menaceone picture menaceone on 17 Nov 2020

Okay I should have had this idea earlier.
I deleted all my mail provider accounts within the app and readded them.
Now it shows my mails again and works as intended.

Strange anyway. Maybe someone in the feature has the same problem.

Solution: delete and re-add mail accounts.

menaceone picture menaceone on 17 Nov 2020
👍1
Was this page helpful?
0 / 5 - 0 ratings

Related issues

CHazz picture CHazz  ·  3Comments
g6094199 picture g6094199  ·  3Comments
StCyr picture StCyr  ·  4Comments
jancborchardt picture jancborchardt  ·  5Comments
MariusBluem picture MariusBluem  ·  3Comments