Unable to create new users
- fizi
- Advanced member
- Posts: 78
- Joined: Fri Sep 12, 2014 10:21 pm
- ZCS/ZD Version: 8.7.2_GA_1736.RHEL6_64
Unable to create new users
So should I be looking at backing up my data and doing a fresh install?
Unable to create new users
Is there anything else in the logs after
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'
? I believe we should be logging the nested exception and the SQL statement that caused the error.
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'
? I believe we should be logging the nested exception and the SQL statement that caused the error.
- fizi
- Advanced member
- Posts: 78
- Joined: Fri Sep 12, 2014 10:21 pm
- ZCS/ZD Version: 8.7.2_GA_1736.RHEL6_64
Unable to create new users
After that there is the following:
Query being executed when exception was thrown:
DROP DATABASE IF EXISTS mboxgroup13
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:790)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:256)
at com.zimbra.cs.db.DbUtil.executeScript(DbUtil.java:350)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:192)
... 27 more
2007-05-25 15:56:49,665 INFO [http-443-Processor99] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] zimlet - Zimlet not found: /opt/zimbra/tomcat/webapps/service/zimlet/com_zimbra_phone
2007-05-25 15:56:49,675 INFO [http-443-Processor99] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] zimlet - Zimlet not found: /opt/zimbra/tomcat/webapps/service/zimlet/com_zimbra_search
2007-05-25 15:56:53,328 INFO [http-443-Processor98] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] mailbox - Creating database mboxgroup13
2007-05-25 15:56:53,353 ERROR [http-443-Processor98] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] mailbox - Error during mailbox creation
com.zimbra.common.service.ServiceException: system failure: createMailboxDatabase(13)
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:197)
at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.java:538)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:216)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:175)
at com.zimbra.cs.session.Session.(Session.java:72)
at com.zimbra.cs.session.SoapSession.(SoapSession.java:76)
at com.zimbra.cs.session.SessionCache.getNewSession(SessionCache.java:86)
at com.zimbra.soap.ZimbraSoapContext.getSession(ZimbraSoapContext.java:449)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:195)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:178)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:264)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:168)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:90)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:223)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709">HttpServlet.service(HttpServlet.java:709)
at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802">HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'
Query being executed when exception was thrown:
DROP DATABASE IF EXISTS mboxgroup13
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:790)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:256)
at com.zimbra.cs.db.DbUtil.executeScript(DbUtil.java:350)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:192)
... 31 more
2007-05-25 15:56:53,355 WARN [http-443-Processor98] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] session - failed to create session
com.zimbra.common.service.ServiceException: system failure: createMailboxDatabase(13)
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:197)
at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.java:538)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:216)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:175)
at com.zimbra.cs.session.Session.(Session.java:72)
at com.zimbra.cs.session.SoapSession.(SoapSession.java:76)
at com.zimbra.cs.session.SessionCache.getNewSession(SessionCache.java:86)
at com.zimbra.soap.ZimbraSoapContext.getSession(ZimbraSoapContext.java:449)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:195)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:178)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:264)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:168)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:90)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:223)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709">HttpServlet.service(HttpServlet.java:709)
at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802">HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'
I believe that is me trying to delete the partially created account.
Query being executed when exception was thrown:
DROP DATABASE IF EXISTS mboxgroup13
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:790)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:256)
at com.zimbra.cs.db.DbUtil.executeScript(DbUtil.java:350)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:192)
... 27 more
2007-05-25 15:56:49,665 INFO [http-443-Processor99] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] zimlet - Zimlet not found: /opt/zimbra/tomcat/webapps/service/zimlet/com_zimbra_phone
2007-05-25 15:56:49,675 INFO [http-443-Processor99] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] zimlet - Zimlet not found: /opt/zimbra/tomcat/webapps/service/zimlet/com_zimbra_search
2007-05-25 15:56:53,328 INFO [http-443-Processor98] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] mailbox - Creating database mboxgroup13
2007-05-25 15:56:53,353 ERROR [http-443-Processor98] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] mailbox - Error during mailbox creation
com.zimbra.common.service.ServiceException: system failure: createMailboxDatabase(13)
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:197)
at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.java:538)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:216)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:175)
at com.zimbra.cs.session.Session.(Session.java:72)
at com.zimbra.cs.session.SoapSession.(SoapSession.java:76)
at com.zimbra.cs.session.SessionCache.getNewSession(SessionCache.java:86)
at com.zimbra.soap.ZimbraSoapContext.getSession(ZimbraSoapContext.java:449)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:195)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:178)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:264)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:168)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:90)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:223)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709">HttpServlet.service(HttpServlet.java:709)
at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802">HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'
Query being executed when exception was thrown:
DROP DATABASE IF EXISTS mboxgroup13
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1665)
at com.mysql.jdbc.Connection.execSQL(Connection.java:3124)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1149)
at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:790)
at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:256)
at com.zimbra.cs.db.DbUtil.executeScript(DbUtil.java:350)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:192)
... 31 more
2007-05-25 15:56:53,355 WARN [http-443-Processor98] [ua=ZimbraWebClient - IE7 (Win)/4.5.5_GA_838.RHEL4;ip=64.34.97.4;name=schewee@fizi.ca;] session - failed to create session
com.zimbra.common.service.ServiceException: system failure: createMailboxDatabase(13)
at com.zimbra.common.service.ServiceException.FAILURE(ServiceException.java:175)
at com.zimbra.cs.db.DbMailbox.createMailboxDatabase(DbMailbox.java:197)
at com.zimbra.cs.mailbox.MailboxManager.createMailbox(MailboxManager.java:538)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:216)
at com.zimbra.cs.mailbox.MailboxManager.getMailboxByAccountId(MailboxManager.java:175)
at com.zimbra.cs.session.Session.(Session.java:72)
at com.zimbra.cs.session.SoapSession.(SoapSession.java:76)
at com.zimbra.cs.session.SessionCache.getNewSession(SessionCache.java:86)
at com.zimbra.soap.ZimbraSoapContext.getSession(ZimbraSoapContext.java:449)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:195)
at com.zimbra.soap.DocumentHandler.getSession(DocumentHandler.java:178)
at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEngine.java:264)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:168)
at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.java:90)
at com.zimbra.soap.SoapServlet.doPost(SoapServlet.java:223)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709">HttpServlet.service(HttpServlet.java:709)
at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802">HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:541)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:667)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown table 'open_conversation,pop3_message,tombstone,appointment,mail_item'
I believe that is me trying to delete the partially created account.
Unable to create new users
Whoa. That doesn't make sense at all. It looks like MySQL's data dictionary tables are inconsistent. What's the state of the mboxgroup13 database? Does it exist? Are all the tables there? Does mboxgroup13.mail_item have data in it?
On a related note, we recently discovered problems with the DROP DATABASE statement. You should remove it from /opt/zimbra/db/create_database.sql. See this bug for more details:
Bug 16879 - Under certain error conditions databases are dropped
Boris
On a related note, we recently discovered problems with the DROP DATABASE statement. You should remove it from /opt/zimbra/db/create_database.sql. See this bug for more details:
Bug 16879 - Under certain error conditions databases are dropped
Boris
- fizi
- Advanced member
- Posts: 78
- Joined: Fri Sep 12, 2014 10:21 pm
- ZCS/ZD Version: 8.7.2_GA_1736.RHEL6_64
Unable to create new users
Well I have this:
mysql> show tables;
+-----------------------+
| Tables_in_mboxgroup13 |
+-----------------------+
| appointment |
| mail_item |
| open_conversation |
| pop3_message |
| tombstone |
+-----------------------+
5 rows in set (0.00 sec)
but I also got this:
mysql> SELECT * FROM appointment;
ERROR 1146 (42S02): Table 'mboxgroup13.appointment' doesn't exist
mysql> SELECT * FROM mail_item;
ERROR 1146 (42S02): Table 'mboxgroup13.mail_item' doesn't exist
mysql> SELECT * FROM open_conversation;
ERROR 1146 (42S02): Table 'mboxgroup13.open_conversation' doesn't exist
mysql> SELECT * FROM pop3_message;
ERROR 1146 (42S02): Table 'mboxgroup13.pop3_message' doesn't exist
mysql> SELECT * FROM tombstone;
ERROR 1146 (42S02): Table 'mboxgroup13.tombstone' doesn't exist
mysql>
I'm knocking out that bug right now.
mysql> show tables;
+-----------------------+
| Tables_in_mboxgroup13 |
+-----------------------+
| appointment |
| mail_item |
| open_conversation |
| pop3_message |
| tombstone |
+-----------------------+
5 rows in set (0.00 sec)
but I also got this:
mysql> SELECT * FROM appointment;
ERROR 1146 (42S02): Table 'mboxgroup13.appointment' doesn't exist
mysql> SELECT * FROM mail_item;
ERROR 1146 (42S02): Table 'mboxgroup13.mail_item' doesn't exist
mysql> SELECT * FROM open_conversation;
ERROR 1146 (42S02): Table 'mboxgroup13.open_conversation' doesn't exist
mysql> SELECT * FROM pop3_message;
ERROR 1146 (42S02): Table 'mboxgroup13.pop3_message' doesn't exist
mysql> SELECT * FROM tombstone;
ERROR 1146 (42S02): Table 'mboxgroup13.tombstone' doesn't exist
mysql>
I'm knocking out that bug right now.
- fizi
- Advanced member
- Posts: 78
- Joined: Fri Sep 12, 2014 10:21 pm
- ZCS/ZD Version: 8.7.2_GA_1736.RHEL6_64
Unable to create new users
The plot thickens. I tried to delete those 3 accounts again after performing the below tweak and they all give this error:
Message: system failure: createMailboxDatabase(13)
Error code: service.FAILURE
Method: ZmCsfeCommand.prototype.invoke
Details:soap:Receiver
Which means it thinks all 3 of them think they are mailbox13.
Message: system failure: createMailboxDatabase(13)
Error code: service.FAILURE
Method: ZmCsfeCommand.prototype.invoke
Details:soap:Receiver
Which means it thinks all 3 of them think they are mailbox13.
Unable to create new users
Yikes. This is starting to look like a MySQL bug, possibly this one:
MySQL Bugs: #28562: Table does not exist - Table already exists
At this point I think your best bet is to follow up with MySQL.
MySQL Bugs: #28562: Table does not exist - Table already exists
At this point I think your best bet is to follow up with MySQL.
- fizi
- Advanced member
- Posts: 78
- Joined: Fri Sep 12, 2014 10:21 pm
- ZCS/ZD Version: 8.7.2_GA_1736.RHEL6_64
Unable to create new users
Not surprisingly the upgrade to 5.0 Beta 1 failed with the following:
This appears to be 4.5.5_GA
Redolog Version: 1.12 New Redolog Version: 1.14
Mon Jun 11 14:33:57 2007: Verified redolog version 1.12.
Mon Jun 11 14:33:57 2007: Updating Redolog schema version from 1.12 to 1.14.
Schema upgrade required
Running /opt/zimbra/libexec/scripts/migrate20070306-Pop3MessageUid.pl
Mon Jun 11 14:34:00 2007: Verified schema version 36.
ERROR 1146 (42S02) at line 1: Table 'mboxgroup13.pop3_message' doesn't exist
Mon Jun 11 14:34:05 2007: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password= --database=zimbra --batch --skip-column-names'.
Script failed with code 256: - exiting
So chances are any upgrade will fail with the similar error. I am going to try and track down all reference to Mailbox/User 13 and see if that helps.
This appears to be 4.5.5_GA
Redolog Version: 1.12 New Redolog Version: 1.14
Mon Jun 11 14:33:57 2007: Verified redolog version 1.12.
Mon Jun 11 14:33:57 2007: Updating Redolog schema version from 1.12 to 1.14.
Schema upgrade required
Running /opt/zimbra/libexec/scripts/migrate20070306-Pop3MessageUid.pl
Mon Jun 11 14:34:00 2007: Verified schema version 36.
ERROR 1146 (42S02) at line 1: Table 'mboxgroup13.pop3_message' doesn't exist
Mon Jun 11 14:34:05 2007: Error while running '/opt/zimbra/bin/mysql --user=zimbra --password= --database=zimbra --batch --skip-column-names'.
Script failed with code 256: - exiting
So chances are any upgrade will fail with the similar error. I am going to try and track down all reference to Mailbox/User 13 and see if that helps.
- fizi
- Advanced member
- Posts: 78
- Joined: Fri Sep 12, 2014 10:21 pm
- ZCS/ZD Version: 8.7.2_GA_1736.RHEL6_64
Unable to create new users
Fixed it. I manually deleted the mboxgroup13.db file and then I was able to delete the dud accounts that I had created while trying to fix this. Now I can create/remove users from Zimbra 4.5.5.
Unable to create new users
Dear Fizi,
Just like to know if you can show me the command to manually remove the database as I use drop database mboxgroup17 and result in a error 1604
If you can show me how you remove it the mboxgroup 13 will be great
Just like to know if you can show me the command to manually remove the database as I use drop database mboxgroup17 and result in a error 1604
If you can show me how you remove it the mboxgroup 13 will be great