Results 1 to 5 of 5

Thread: User can not access Ajax or HTML interface

  1. #1
    Join Date
    Feb 2008
    Location
    Manta - Ecuador - South America
    Posts
    36
    Rep Power
    7

    Question User can not access Ajax or HTML interface

    Hi,

    I'm running zimbra 6.0.6 on a ubuntu 8.04.

    I've 22 email accounts on the server working fine, but one of the accounts can not access de web interface.

    On the logs I'm having this message regarding slow execution "sqltrace - Slow execution":

    Code:
    2010-05-05 10:21:10,356 INFO  [btpool0-335://localhost/service/soap/BatchRequest] [name=jlucas@mail.mydomain.com;mid=6;oip=200.93.220.21;ua=zclient/6.0.6_GA_2324.UBUNTU8;] sqltrace - Slow execution (6454ms): SELECT parent_id, unread, flags, tags FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND parent_id = 468
    2010-05-05 10:21:28,096 INFO  [LmtpServer-938] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] sqltrace - Slow execution (17697ms): SELECT parent_id, unread, flags, tags FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND parent_id = 863
    2010-05-05 10:21:28,159 INFO  [LmtpServer-938] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] mailop - Adding Message: id=589125, Message-ID=<201005051517.o45FHdjo030175@mail.mydomain.com>, parentId=863, folderId=2, folderName=Inbox.
    2010-05-05 10:22:09,411 INFO  [LmtpServer-948] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] sqltrace - Slow execution (40754ms): SELECT parent_id, unread, flags, tags FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND parent_id = 863
    2010-05-05 10:22:09,475 INFO  [LmtpServer-948] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] mailop - Adding Message: id=589126, Message-ID=<201005051519.o45FJTDT030272@mail.mydomain.com>, parentId=863, folderId=2, folderName=Inbox.
    2010-05-05 10:22:18,938 INFO  [LmtpServer-946] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] sqltrace - Slow execution (8782ms): SELECT parent_id, unread, flags, tags FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND parent_id = 309
    2010-05-05 10:22:18,941 INFO  [LmtpServer-946] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] mailop - Adding Message: id=589127, Message-ID=<201005051517.o45FHXqU030162@mail.mydomain.com>, parentId=309, folderId=2, folderName=Inbox.
    2010-05-05 10:22:41,393 INFO  [LmtpServer-947] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] sqltrace - Slow execution (22118ms): SELECT parent_id, unread, flags, tags FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND parent_id = 863
    2010-05-05 10:22:41,454 INFO  [LmtpServer-947] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] mailop - Adding Message: id=589128, Message-ID=<201005051519.o45FJMsa030261@mail.mydomain.com>, parentId=863, folderId=2, folderName=Inbox.
    2010-05-05 10:23:04,618 INFO  [LmtpServer-937] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] sqltrace - Slow execution (22439ms): SELECT parent_id, unread, flags, tags FROM mboxgroup6.mail_item WHERE mailbox_id = 6 AND parent_id = 863
    2010-05-05 10:23:04,679 INFO  [LmtpServer-937] [name=jlucas@mail.mydomain.com;mid=6;ip=200.93.220.8;] mailop - Adding Message: id=589129, Message-ID=<201005051517.o45FHVdA030158@mail.mydomain.com>, parentId=863, folderId=2, folderName=Inbox.
    All the other accounts are having access to the web interface (ajax and html), one of the accounts is using 7.5GB of quota and works fine too. The user with problem is using 3GB of quota.

    Code:
    zmprov gmi jlucas@mail.mydomain.com
    mailboxId: 6
    quotaUsed: 3865292997
    The user PC and the server are located under the same LAN and there is not QoS or bandwithd shaping between the zimbra server and the client pc's.

    Code:
    # cat /etc/lsb-release 
    DISTRIB_ID=Ubuntu
    DISTRIB_RELEASE=8.04
    DISTRIB_CODENAME=hardy
    DISTRIB_DESCRIPTION="Ubuntu 8.04"
    
    
    # cat /proc/cpuinfo 
    processor	: 0
    vendor_id	: GenuineIntel
    cpu family	: 15
    model		: 4
    model name	: Intel(R) Pentium(R) 4 CPU 2.80GHz
    stepping	: 1
    cpu MHz		: 2800.131
    cache size	: 1024 KB
    physical id	: 0
    siblings	: 2
    core id		: 0
    cpu cores	: 1
    fdiv_bug	: no
    hlt_bug		: no
    f00f_bug	: no
    coma_bug	: no
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 5
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pebs bts sync_rdtsc pni monitor ds_cpl cid cx16 xtpr
    bogomips	: 5604.26
    clflush size	: 64
    
    processor	: 1
    vendor_id	: GenuineIntel
    cpu family	: 15
    model		: 4
    model name	: Intel(R) Pentium(R) 4 CPU 2.80GHz
    stepping	: 1
    cpu MHz		: 2800.131
    cache size	: 1024 KB
    physical id	: 0
    siblings	: 2
    core id		: 0
    cpu cores	: 1
    fdiv_bug	: no
    hlt_bug		: no
    f00f_bug	: no
    coma_bug	: no
    fpu		: yes
    fpu_exception	: yes
    cpuid level	: 5
    wp		: yes
    flags		: fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm pbe nx lm constant_tsc pebs bts sync_rdtsc pni monitor ds_cpl cid cx16 xtpr
    bogomips	: 5600.15
    clflush size	: 64
    
    # free -m
                 total       used       free     shared    buffers     cached
    Mem:          1255       1175         79          0         32         86
    -/+ buffers/cache:       1056        199
    Swap:         1443        380       1063
    
    # df -h
    Filesystem            Size  Used Avail Use% Mounted on
    /dev/sda1              73G   27G   43G  39% /
    varrun                628M  184K  628M   1% /var/run
    varlock               628M     0  628M   0% /var/lock
    udev                  628M   40K  628M   1% /dev
    devshm                628M     0  628M   0% /dev/shm

  2. #2
    Join Date
    Mar 2006
    Location
    Massachusetts
    Posts
    965
    Rep Power
    10

    Default

    Have you tried re-indexing the mailbox for this account?

  3. #3
    Join Date
    Feb 2008
    Location
    Manta - Ecuador - South America
    Posts
    36
    Rep Power
    7

    Default

    Thank you for the response.

    I'm trying to reindex the account:
    Code:
    zmprov ma jlucas@mail.mydomain.com zimbraAccountStatus maintenance
    zmprov rim jlucas@mail.mydomain.com start
    This is the portion of the log:
    Code:
    2010-05-05 12:28:48,240 INFO  [ReIndex-1] [name=jlucas@mail.mydomain.com;mid=6;] sqltrace - Slow execution (36735ms): SELECT mi.id, mi.index_id, mi.type, mi.mod_content FROM mboxgroup6.mail_item AS mi WHERE mi.mailbox_id = 6 AND (type NOT IN (1,2,13,3,4) AND mi.index_id is NOT NULL )
    2010-05-05 12:28:50,095 INFO  [ReIndex-1] [name=jlucas@mail.mydomain.com;mid=6;] mailbox - IndexDeferredItems(0, 0): Deferred count out of sync - found=397147 in progress=0 (deferred count=100000)
    2010-05-05 12:28:54,271 INFO  [LmtpServer-6] [ip=200.93.220.8;] lmtp - try again for address jlucas@mail.mydomain.com: account status maintenance
    2010-05-05 12:28:54,271 INFO  [LmtpServer-6] [ip=200.93.220.8;] lmtp - 450 4.2.1 Mailbox disabled, not accepting messages (RCPT TO:)
    How can check the progress of the reindex task?

  4. #4
    Join Date
    Mar 2006
    Location
    Massachusetts
    Posts
    965
    Rep Power
    10

    Default

    I usually do re-indexing through the Admin console, and I'm pretty sure it shows some type of progress indicator there. Not sure about the command line.

  5. #5
    Join Date
    Feb 2008
    Location
    Manta - Ecuador - South America
    Posts
    36
    Rep Power
    7

    Default

    In the command line tail is helping me:

    Code:
    tail -f /opt/zimbra/log/mailbox.log | grep ReInde
    2010-05-05 12:53:20,681 INFO  [ReIndex-1] [name=jlucas@mail.mydomain.com;mid=6;] mailbox - Batch Indexing: Mailbox 6 on item 106000 out of 397147
    2010-05-05 12:53:56,481 INFO  [ReIndex-1] [name=jlucas@mail.mydomain.com;mid=6;] sqltrace - Slow execution (2458ms): SELECT mi.id, mi.type, mi.parent_id, mi.folder_id, mi.index_id, mi.imap_id, mi.date, mi.size, mi.volume_id, mi.blob_digest, mi.unread, mi.flags, mi.tags, mi.subject, mi.name, mi.metadata, mi.mod_metadata, mi.change_date, mi.mod_content FROM mboxgroup6.mail_item AS mi WHERE mailbox_id = 6 AND id = 251281
    2010-05-05 12:54:15,315 INFO  [ReIndex-1] [name=jlucas@mail.mydomain.com;mid=6;] mailbox - Batch Indexing: Mailbox 6 on item 108000 out of 397147
    2010-05-05 12:54:50,689 INFO  [ReIndex-1] [name=jlucas@mail.mydomain.com;mid=6;] mailbox - Batch Indexing: Mailbox 6 on item 110000 out of 397147

Similar Threads

  1. Replies: 2
    Last Post: 03-05-2008, 08:24 AM
  2. Replies: 13
    Last Post: 10-18-2007, 09:39 PM
  3. Fedora Core 3, Clean Install - Not working!
    By pcjackson in forum Installation
    Replies: 17
    Last Post: 03-05-2006, 06:38 PM
  4. Network edition - strange behavior
    By goetzi in forum Installation
    Replies: 6
    Last Post: 11-16-2005, 02:08 PM
  5. Replies: 1
    Last Post: 10-31-2005, 09:14 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
  •