Unable to create new users

Ask questions about your setup or get help installing ZCS server (ZD section below).
User avatar
fizi
Advanced member
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

Post by fizi »

So should I be looking at backing up my data and doing a fresh install?
bburtin
Advanced member
Advanced member
Posts: 78
Joined: Fri Sep 12, 2014 9:55 pm

Unable to create new users

Post by bburtin »

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.
User avatar
fizi
Advanced member
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

Post by fizi »

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.
bburtin
Advanced member
Advanced member
Posts: 78
Joined: Fri Sep 12, 2014 9:55 pm

Unable to create new users

Post by bburtin »

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
User avatar
fizi
Advanced member
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

Post by fizi »

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.
User avatar
fizi
Advanced member
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

Post by fizi »

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.
bburtin
Advanced member
Advanced member
Posts: 78
Joined: Fri Sep 12, 2014 9:55 pm

Unable to create new users

Post by bburtin »

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.
User avatar
fizi
Advanced member
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

Post by fizi »

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.
User avatar
fizi
Advanced member
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

Post by fizi »

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.
Max Ma
Advanced member
Advanced member
Posts: 101
Joined: Fri Sep 12, 2014 10:30 pm

Unable to create new users

Post by Max Ma »

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
:)
Post Reply