User can not access Ajax or HTML interface

[razametal]

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

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.

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.

# 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

[soxfan]

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

[razametal]

Thank you for the response.

I'm trying to reindex the account:

zmprov ma jlucas@mail.mydomain.com zimbraAccountStatus maintenance
zmprov rim jlucas@mail.mydomain.com start

This is the portion of the log:

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?

[soxfan]

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.

[razametal]

In the command line tail is helping me:

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