Results 1 to 9 of 9

Thread: IMAP/mysql errors in /opt/zimbra/log/zimbra.log

  1. #1
    kirme3 is offline Trained Alumni
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    194
    Rep Power
    9

    Exclamation IMAP/mysql errors in /opt/zimbra/log/zimbra.log

    Hello all.

    I was digging through the zimbra log this morning as I am using imapsync and I am seeing the following:

    442 WARN [ImapServer-4519) [ ip=127.0.0.1;name=foo@domain.com;] sqltrace - Connection pool is 75% utilized. 27 connections out of a maximum of 34 in use. Turn on debug logging for zimbra.sqltrace to see stack tracess of connections not returned to the pool.

    Is this an IMAP limit, or mysql limit? Also, is there a way to increase the limit from 34, to a higher number. Or is this a warning I can ignore? I've also seen some that say 34 connections in use. Could anyone help me with this?

    Thanks!

  2. #2
    James Brinkerhoff is offline Intermediate Member
    Join Date
    May 2006
    Location
    New York, NY US
    Posts
    23
    Rep Power
    8

    Default Same Issue

    I've noticed the same message in my logs:

    2006-08-07 14:45:38,721 WARN [LmtpServer-17] [name=deb@anonymous.com;] sqltrace - Connection pool is 75% utilized. 10 connections out of a maximum of 10 in use. Turn on debug logging for zimbra.sqltrace to see stack traces of connections not returned to the pool.

    Any thoughts?

  3. #3
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    It's the limit of connections from tomcat -> mysql. This is determined at install time based on the total system memory. If you are running lots of concurrnet activity this is ok but once the system returns to idle these warnings should stop.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  4. #4
    kirme3 is offline Trained Alumni
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    194
    Rep Power
    9

    Default Ahh, I see

    So, doing a bunch of Imapsync's at once would be what was causing them. Is there any way to change the limit. For instance, we have doubled our system memory since we did the install. Will it automatically pick that up and change the limit?

  5. #5
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    zmprov gcf | grep -i mem

    This will give you the current % of mem. Changing that and restarting should reset it.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  6. #6
    kirme3 is offline Trained Alumni
    Join Date
    Apr 2006
    Location
    Illinois
    Posts
    194
    Rep Power
    9

    Default Wrong zmprov option?

    Are you sure that's the right command....I just get a grep of the zmprov help options for zmprov:

    ./zmprov gcf | grep -i mem
    AddDistributionListMember(adlm) {list@domain|id} {member@domain}
    RemoveDistributionListMember(rdlm) {list@domain|id} {member@domain}

    I tried ./zmprov gacf | grep -i mem and got:

    ./zmprov gacf | grep -i mem
    zimbraGalLdapFilterDef: ad&(|(cn=*%s*)(sn=*%s*)(gn=*%s*)(mail=*%s*))(!(msExc hHideFromAddressLists=TRUE))(mailnickname=*)(|(&(o bjectCategory=person)(objectClass=user)(!(homeMDB= *))(!(msExchHomeServerName=*)))(&(objectCategory=p erson)(objectClass=user)(|(homeMDB=*)(msExchHomeSe rverName=*)))(&(objectCategory=person)(objectClass =contact))(objectCategory=group)(objectCategory=pu blicFolder)(objectCategory=msExchDynamicDistributi onList)))

    Could it be zmlocalconfig | grep -i mem which gives me:
    mysql_memory_percent = 40
    tomcat_java_heap_memory_percent = 30
    Last edited by kirme3; 08-12-2006 at 07:58 AM.

  7. #7
    KevinH's Avatar
    KevinH is offline Expert Member
    Join Date
    Aug 2005
    Location
    San Mateo, CA
    Posts
    4,789
    Rep Power
    18

    Default

    Yeah zmlocalconfig will show it. I meant GetAllConfig which I think it gac

    You can allways run zmprov -? to get the full list of commands.
    Looking for new beta users -> Co-Founder of Acompli. Previously worked at Zimbra (and Yahoo! & VMware) since 2005.

  8. #8
    kechols is offline Senior Member
    Join Date
    Jun 2006
    Posts
    72
    Rep Power
    8

    Default

    I'm having a similar problem, except that mine shows up in /opt/zimbra/log/zimbra.log and says:
    2007-09-07 08:33:12,396 WARN [Pop3Server-16054] [ip=192.168.4.100;] sqltrace - Connection pool is 75% util ized. 8 connections out of a maximum of 10 in use. Turn on debug logging for zimbra.sqltrace to see stack traces of connections not returned to the pool.

    Is this the same thing? I went from 2 to 4 Gig of memory, so should I raise or lower the mysql memory settings to get this fixed, or does it matter so long as it changes??

  9. #9
    dkarp is offline Zimbra Employee
    Join Date
    Aug 2005
    Posts
    1,433
    Rep Power
    11

    Default

    The ZCS database connection pool size defaults to 100. It's overridden by the zimbra_mysql_connector_maxActive localconfig.xml setting.
    Bugzilla - Wiki - Downloads - Before posting... Search!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Errors Migrating from Exchange 5.5
    By Scotsman in forum Migration
    Replies: 2
    Last Post: 03-07-2007, 02:24 AM
  2. Errors bounced
    By cedbl in forum Administrators
    Replies: 6
    Last Post: 01-30-2007, 01:21 AM
  3. Mac OSX install: Java errors & LDAP CA error
    By jefbear in forum Installation
    Replies: 9
    Last Post: 12-16-2006, 03:39 PM
  4. Errors because of Deffered emails
    By mansuper in forum Administrators
    Replies: 0
    Last Post: 11-20-2006, 04:08 PM
  5. Upgrading to 3.1.3 errors sumary
    By kowell in forum Administrators
    Replies: 8
    Last Post: 06-25-2006, 12:11 AM

Posting Permissions

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