Mailbox unreachable after DB corruption

[Aleksej]

Hello.

Can someone suggest something?

I moved zimbra server to a new hardware and ssd too (with rsync).
In all all works fine, but some accounts not working.
in some accounts simple `zmprov rim account` fixed issues, but in some not.

i tried https://wiki.zimbra.com/wiki/Mysql_Crash_Recovery. nothing...

when i could reach mbox i made dump (from web interface). Thought i will remove mbox, create it and restore. but now i cant delete mailbox.
with

Code: Select all

zmprov da myacc

there is error:
ERROR: service.FAILURE (system failure: fetching all tags for mailbox 47)

in mailbox.log i have

Code: Select all

com.zimbra.common.service.ServiceException: system failure: fetching all tags for mailbox 47
	at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:292) ~[zimbracommon.jar:8.8.15_GA_4508]
	at com.zimbra.cs.db.DbTag.getAllTags(DbTag.java:227) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.db.DbMailItem.getFoldersAndTags(DbMailItem.java:2167) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.mailbox.Mailbox.loadFoldersAndTags(Mailbox.java:2333) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.mailbox.Mailbox.beginTransaction(Mailbox.java:1868) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.mailbox.Mailbox.beginReadTransaction(Mailbox.java:1783) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox.java:2917) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.mailbox.Mailbox.getItemById(Mailbox.java:2909) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.mailbox.Mailbox.getFolderById(Mailbox.java:4200) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.filter.IncomingMessageHandler.getDefaultFolderPath(IncomingMessageHandler.java:91) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.filter.RuleManager.applyRulesToIncomingMessage(RuleManager.java:447) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliverMessageToLocalMailboxes(ZimbraLmtpBackend.java:702) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.ZimbraLmtpBackend.deliver(ZimbraLmtpBackend.java:433) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.LmtpHandler.processMessageData(LmtpHandler.java:445) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.TcpLmtpHandler.continueDATA(TcpLmtpHandler.java:79) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.LmtpHandler.doDATA(LmtpHandler.java:434) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.LmtpHandler.processCommand(LmtpHandler.java:216) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.lmtpserver.TcpLmtpHandler.processCommand(TcpLmtpHandler.java:72) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.server.ProtocolHandler.processConnection(ProtocolHandler.java:189) [zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.server.ProtocolHandler.run(ProtocolHandler.java:128) [zimbrastore.jar:8.8.15_GA_4508]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]
	at java.lang.Thread.run(Thread.java:833) [?:?]
Caused by: java.sql.SQLSyntaxErrorException: (conn=17) Table 'mboxgroup47.tag' doesn't exist
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:242) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:171) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:248) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:230) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:157) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:172) ~[mariadb-java-client-2.4.3.jar:?]
	at com.zimbra.cs.db.DebugPreparedStatement.executeQuery(DebugPreparedStatement.java:165) ~[zimbrastore.jar:8.8.15_GA_4508]
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
	at com.zimbra.cs.db.StatTrackingPreparedStatement.executeQuery(StatTrackingPreparedStatement.java:352) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.db.DbTag.getAllTags(DbTag.java:221) ~[zimbrastore.jar:8.8.15_GA_4508]
	... 21 more
Caused by: java.sql.SQLException: Table 'mboxgroup47.tag' doesn't exist
Query is: SELECT id, name, color, item_count, unread, listed, sequence, policy FROM mboxgroup47.tag WHERE mailbox_id = ? AND id > 0, parameters [47]
java thread: LmtpServer-3
	at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:292) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:221) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:157) ~[mariadb-java-client-2.4.3.jar:?]
	at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:172) ~[mariadb-java-client-2.4.3.jar:?]
	at com.zimbra.cs.db.DebugPreparedStatement.executeQuery(DebugPreparedStatement.java:165) ~[zimbrastore.jar:8.8.15_GA_4508]
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
	at org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96) ~[commons-dbcp-1.4.jar:1.4]
	at com.zimbra.cs.db.StatTrackingPreparedStatement.executeQuery(StatTrackingPreparedStatement.java:352) ~[zimbrastore.jar:8.8.15_GA_4508]
	at com.zimbra.cs.db.DbTag.getAllTags(DbTag.java:221) ~[zimbrastore.jar:8.8.15_GA_4508]
	... 21 more

i can't find any info how to recreate this ".tag" table or maybe recreate all tables for this account.

thanks
p.s. zimbra 8.8.15 ga 4508
all packages are up to date

[phoenix]

Do an internet search for the following:

Code: Select all

there is error:ERROR: service.FAILURE (system failure: fetching all tags for mailbox 47)

Check the results for an answer.