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