fetching broke last friday

[sstecker]

we have been up and running for awhile. after a power outage friday the fetching process broke. i did not notice until today.

errors i am getting ;

2017-11-21 18:10:08] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:10:09] Espo.ERROR: EmailAccount 589f34d7479872b1f (Import Message w/ php-mime-mail-parser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:16:41] Espo.ERROR: Uncaught Exception PDOException: "SQLSTATE[HY000] [2002] No such file or directory" at /var/www/html/espo/application/Espo/ORM/EntityManager.php line 155 {"exception":"[object] (PDOException(code: 2002): SQLSTATE[HY000] [2002] No such file or directory at /var/www/html/espo/application/Espo/ORM/EntityManager.php:155)"} []
[2017-11-21 18:20:09] Espo.ERROR: EmailAccount 58a7298ca135b8273 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:20:10] Espo.ERROR: EmailAccount 58a47a238e767b135 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:20:12] Espo.ERROR: EmailAccount 58a47802407e31001 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '53459' for key 'PRIMARY' [] []
[2017-11-21 18:20:13] Espo.ERROR: EmailAccount 58a3418f34dfc9c27 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:20:13] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:20:13] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:20:15] Espo.ERROR: EmailAccount 589f34d7479872b1f (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:25:11] Espo.ERROR: EmailAccount 58a47a238e767b135 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:25:13] Espo.ERROR: EmailAccount 58a3418f34dfc9c27 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:25:14] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:25:14] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:25:15] Espo.ERROR: EmailAccount 589f34d7479872b1f (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:30:06] Espo.ERROR: EmailAccount 58a3418f34dfc9c27 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:30:06] Espo.ERROR: EmailAccount 58a3418f34dfc9c27 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:30:06] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:30:07] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:35:08] Espo.ERROR: EmailAccount 58a7298ca135b8273 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:35:09] Espo.ERROR: EmailAccount 58a47a238e767b135 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:35:10] Espo.ERROR: EmailAccount 58a47a238e767b135 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:35:11] Espo.ERROR: EmailAccount 58a47802407e31001 (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '53459' for key 'PRIMARY' [] []
[2017-11-21 18:35:12] Espo.ERROR: EmailAccount 58a3418f34dfc9c27 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:35:13] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:35:13] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:35:14] Espo.ERROR: EmailAccount 589f34d7479872b1f (Import Message w/ PhpMimeMailParser): [23000] SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '59278' for key 'PRIMARY' [] []
[2017-11-21 18:40:10] Espo.ERROR: EmailAccount 58a3418f34dfc9c27 (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:40:10] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []
[2017-11-21 18:40:10] Espo.ERROR: EmailAccount 58a1bf8a6b93f8f9e (Select Folder) [0] cannot change folder, maybe it does not exist [] []



any pointers to which table has a problem?

thank you
shawn

[yuri]

Hi Shawn,

Did you try to repair your database? It can be done in phpmyadmin.

[sstecker]

Hi Shawn,

Did you try to repair your database? It can be done in phpmyadmin.

i had repaired a couple tables. missed 2.
mysqlcheck -r DATABASE that worked back up and running