Results 1 to 2 of 2

Thread: zmmaintaintables fails - SOAP fault - TABLE_SCHEMA does not exist

  1. #1
    Join Date
    Jan 2009
    Carterville, MO
    Rep Power

    Exclamation zmmaintaintables fails - SOAP fault - TABLE_SCHEMA does not exist

    I have three installations of Zimbra on three different servers for three different user communities/domains at 2 different locations. All are the latest version. All three give the following error when zmmaintaintables is run:

    [zimbra@mail ~]$ /opt/zimbra/libexec/zmmaintaintables
    Received SOAP fault: system failure: java.lang.IllegalArgumentException: Column 'TABLE_SCHEMA' does not exist
    Can't call method "to_string" on an undefined value at /opt/zimbra/libexec/zmmaintaintables line 64.

    Version information:

    [zimbra@mail ~]$ zmcontrol -v

    Release 6.0.6_GA_2324.RHEL5_20100406144520 CentOS5 FOSS edition.

    Has anyone else experienced this issue? FWIW, two of the three began life at a 6.x version prior to 6.0.6. The third was a fresh 6.0.6 install.

    Thanks in advance for any insight!

    Tim Pearson
    Pittsburg State University

  2. #2
    Join Date
    Mar 2010
    Rep Power

    Default Same issue here


    Yes, I have exactly the same issue here :

    $ zmcontrol -v
    Release 6.0.6_GA_2330.DEBIAN5_64 DEBIAN5_64 FOSS edition.
    $ /opt/zimbra/libexec/zmmaintaintables
    Received SOAP fault: system failure: java.lang.IllegalArgumentException: Column 'TABLE_SCHEMA' does not exist
    Can't call method "to_string" on an undefined value at /opt/zimbra/libexec/zmmaintaintables line 64.
    And in the mailboxd.log :

    2010-06-20 01:30:17,973 INFO [btpool0-7377://localhost:7071/service/admin/soap/] [name=zimbra;ip=;] sqltrace - Slow execution (3390ms): SELECT table_schema, table_name FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = 'zimbra' OR table_schema LIKE 'mboxgroup%'
    2010-06-20 01:30:17,989 WARN [btpool0-7377://localhost:7071/service/admin/soap/] [name=zimbra;ip=;] SoapEngine - handler exception
    java.lang.IllegalArgumentException: Column 'TABLE_SCHEMA' does not exist
    at com.zimbra.cs.db.DbResults.getIndex( :309)
    at com.zimbra.cs.db.DbResults.getString(DbResults.jav a:213)
    at com.zimbra.cs.db.DbResults.getString(DbResults.jav a:221)
    at com.zimbra.cs.db.DbTableMaintenance.runMaintenance (
    at com.zimbra.cs.service.admin.MaintainTables.handle(
    at com.zimbra.soap.SoapEngine.dispatchRequest(SoapEng
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:273)
    at com.zimbra.soap.SoapEngine.dispatch(SoapEngine.jav a:157)
    at com.zimbra.soap.SoapServlet.doWork(SoapServlet.jav a:291)
    at com.zimbra.soap.SoapServlet.doPost(SoapServlet.jav a:212)
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:727)
    at com.zimbra.cs.servlet.ZimbraServlet.service(Zimbra
    at javax.servlet.http.HttpServlet.service(HttpServlet .java:820)
    at org.mortbay.jetty.servlet.ServletHolder.handle(Ser
    at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(
    at com.zimbra.cs.servlet.SetHeaderFilter.doFilter(Set
    at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(
    at org.mortbay.servlet.UserAgentFilter.doFilter(UserA
    at org.mortbay.servlet.GzipFilter.doFilter(GzipFilter .java:155)
    at org.mortbay.jetty.servlet.ServletHandler$CachedCha in.doFilter(
    at org.mortbay.jetty.servlet.ServletHandler.handle(Se
    at org.mortbay.jetty.servlet.SessionHandler.handle(Se
    at org.mortbay.jetty.handler.ContextHandler.handle(Co
    at org.mortbay.jetty.webapp.WebAppContext.handle(WebA
    at org.mortbay.jetty.handler.ContextHandlerCollection .handle(
    at org.mortbay.jetty.handler.HandlerCollection.handle (
    at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha
    at org.mortbay.jetty.handler.rewrite.RewriteHandler.h andle(
    at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha
    at org.mortbay.jetty.handler.DebugHandler.handle(Debu
    at org.mortbay.jetty.handler.HandlerWrapper.handle(Ha
    at org.mortbay.jetty.Server.handle(
    at org.mortbay.jetty.HttpConnection.handleRequest(Htt
    at org.mortbay.jetty.HttpConnection$ ntent(
    at org.mortbay.jetty.HttpParser.parseNext(HttpParser. java:755)
    at org.mortbay.jetty.HttpParser.parseAvailable(HttpPa
    at org.mortbay.jetty.HttpConnection.handle(HttpConnec
    at org.mortbay.thread.BoundedThreadPool$ n(

    I looked in the database : the TABLE_SCHEMA column exists...


Similar Threads

  1. users logon with 2 passwords
    By vmcastro in forum Administrators
    Replies: 2
    Last Post: 01-11-2010, 09:08 AM
  2. Installation problems from 5.0.11 to 6.0.4
    By dcampbell in forum Installation
    Replies: 0
    Last Post: 12-30-2009, 01:37 PM
  3. Can recives but can't send mail outgoing
    By hoangkk in forum Installation
    Replies: 9
    Last Post: 09-21-2009, 07:35 PM
  4. Replies: 35
    Last Post: 07-17-2009, 03:52 PM
  5. zmzimletctl deploy - ERROR -
    By todd_dsm in forum Administrators
    Replies: 0
    Last Post: 04-02-2009, 01:41 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