Hi all,
Currently we have two webmail servers that service all of our hosting customers. Both webmail servers sit behind a load balancer (using IP Virtual Server) and connect to our mySQL cluster which appears to work great. Both webmails are connected to the same database so that contacts and other personal settings are kept in sync, so that should one of the webmail servers go down for some reason it is transparent to the end user and they are automatically transitioned onto the other server.
I have noticed in the error logs the following:
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_1295ecaf4e7382d9da798cb9c07248ea4bdd7132b7 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8583' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_13bfd2038e73c9378296c230c82a3b3ee2c013d849 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8584' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_14714b668778e41311f9a164b5247eb8bd120ca817 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8585' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_19bf21c785b8f33177d52a0439b5a8d62d88306b4b USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8587' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_2030ac4327a69bf7b2be3a38feec2e4c3696a87a3a USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8588' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_2155eddbc3aabedc8c1d78ea7a1e5cdcbef75026f3 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8592' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_247791dc41fff9c0c28756d1d2e9abc38459cce70e USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8589' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_31ad88427b6bdee83f7fc01138bcc321f7f109a8f4 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8596' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_323e3fe763630d348315dc70c0d73f325925a919a0 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8597' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_33d216ebaf9ad3eacefe5dd6b7ac0688330a6d67ec USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8598' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_34488695b8b485e05c9fb638833b4c1e59d0c8eaa8 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8599' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_35a38171b1bf154fed5017308933733db43d1fc1e3 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8600' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_360b7bcf8f62368bdd7b52eba33cf1300241d55ab1 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8601' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_3799ed725f38b6902b30fed55e864ee661170a451c USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8602' for key 2]
Sep 17 11:51:20 webmail2 roundcube: MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_385e3d7e6ba08ff68c6da021d345c4a45845c4db87 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '7208-INBOX.msg-8603' for key 2]
The above errors seem to happen very frequently on both servers.
Are the above errors normal, and if not is there any way to resolve them?
Thanks
