Page 2 of 2 FirstFirst 12
Results 11 to 20 of 20

Thread: Unable to create new users

  1. #11
    fizi is offline Senior Member
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    So should I be looking at backing up my data and doing a fresh install?

  2. #12
    bburtin is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    9

    Default

    Is there anything else in the logs after
    Code:
    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.

  3. #13
    fizi is offline Senior Member
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    After that there is the following:

    Code:
    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)
            at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
            at javax.servlet.http.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)
            at com.zimbra.cs.servlet.ZimbraServlet.service(ZimbraServlet.java:162)
            at javax.servlet.http.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.

  4. #14
    bburtin is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    9

    Default

    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

  5. #15
    fizi is offline Senior Member
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    Well I have this:

    Code:
    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:

    Code:
    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.

  6. #16
    fizi is offline Senior Member
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    The plot thickens. I tried to delete those 3 accounts again after performing the below tweak and they all give this error:

    Code:
    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.

  7. #17
    bburtin is offline Zimbra Employee
    Join Date
    Sep 2005
    Posts
    78
    Rep Power
    9

    Default

    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.

  8. #18
    fizi is offline Senior Member
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    Not surprisingly the upgrade to 5.0 Beta 1 failed with the following:

    Code:
    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.

  9. #19
    fizi is offline Senior Member
    Join Date
    Nov 2006
    Location
    Canada
    Posts
    69
    Rep Power
    8

    Default

    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.

  10. #20
    Max Ma is offline Loyal Member
    Join Date
    Mar 2007
    Posts
    97
    Rep Power
    8

    Default about manually delete the mboxgroup database

    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


Page 2 of 2 FirstFirst 12

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Moving Zimbra, newly created users unable to log in.
    By mogmismo in forum Administrators
    Replies: 2
    Last Post: 07-24-2007, 08:12 PM
  2. unable to create inexistent folder
    By dhain in forum Developers
    Replies: 2
    Last Post: 07-16-2007, 11:27 AM
  3. need advice on configuring zimbra to work with fax server
    By pheonix1t in forum Administrators
    Replies: 0
    Last Post: 07-11-2007, 07:46 PM
  4. 3.0 to 4.5.3 Upgrade failed (mysql error)
    By dealt in forum Installation
    Replies: 35
    Last Post: 03-19-2007, 10:30 PM
  5. Unable to Move Users to a Domain or Delete Domain
    By Justin Rock in forum Administrators
    Replies: 2
    Last Post: 10-06-2005, 12:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •