Hello everyone. sorry because my poor english congratulations to all the excellent project roundcube mail. I have one problem, I installed all versions for test, including svn / trunk (latest) and all creates overload on my server. High cpu load
I'm using the services:
Apache:
Server version: Apache/2.2.6 (Unix) Server built: Jul 1 2009 20:41:05
- -with-mpm=worker*
Php:
PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 26 2009 22:16:23) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
Mysql 5.0
SERVER load average info after 10 minutes then restart the apache server:
*top - 16:48:25 up 6:24, 3 users, load average: 6.92, 2.89, 3.88* Tasks: 84 total, 2 running, 82 sleeping, 0 stopped, 0 zombie *Cpu(s): 98.1%us, 1.7%sy, 0.0%ni, 46.9%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st* Mem: 2076288k total, 1079936k used, 996352k free, 297020k buffers Swap: 498004k total, 0k used, 498004k free, 486532k cached
PID USER PR NI VIRT RES SHR S *%CPU* %MEM TIME+ COMMAND
14103 www-data 20 0 564m 125m 3536 S *190* 6.2 6:28.57 httpd
14088 www-data 20 0 517m 89m 3464 S * 118* 4.4 10:45.10 httpd
the log error log from round roundcube mail:
Only:
*[03-Jul-2009 16:48:08 -0300] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_501fd0fc317c477d1c729158644dc2c5bd5f1d12d USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '2557-INBOX.msg-13334' for key 2] in /webhost/ webmail.atarde.com.br/program/include/rcube_mdb2.php on line 621 (GET /?_task=mail&_mbox=INBOX&_page=1)
[03-Jul-2009 16:48:08] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_674a5a0876c6968d9d29cb5837c47123866f39a43 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '2557-INBOX.msg-13401' for key 2]
Can you Help me, ? Thank's
On Fri, Jul 3, 2009 at 10:11 PM, Tiago Gomesalgodas@gmail.com wrote:
Hello everyone. sorry because my poor english congratulations to all the excellent project roundcube mail. I have one problem, I installed all versions for test, including svn / trunk (latest) and all creates overload on my server. High cpu load
I'm using the services:
Apache:
Server version: Apache/2.2.6 (Unix) Server built: Jul 1 2009 20:41:05 - -with-mpm=worker
Php:
PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 26 2009 22:16:23) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
Mysql 5.0
SERVER load average info after 10 minutes then restart the apache server:
top - 16:48:25 up 6:24, 3 users, load average: 6.92, 2.89, 3.88 Tasks: 84 total, 2 running, 82 sleeping, 0 stopped, 0 zombie Cpu(s): 98.1%us, 1.7%sy, 0.0%ni, 46.9%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st Mem: 2076288k total, 1079936k used, 996352k free, 297020k buffers Swap: 498004k total, 0k used, 498004k free, 486532k cached
PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
14103 www-data 20 0 564m 125m 3536 S 190 6.2 6:28.57 httpd 14088 www-data 20 0 517m 89m 3464 S 118 4.4 10:45.10 httpd
the log error log from round roundcube mail:
Only:
[03-Jul-2009 16:48:08 -0300] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_501fd0fc317c477d1c729158644dc2c5bd5f1d12d USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '2557-INBOX.msg-13334' for key 2] in /webhost/webmail.atarde.com.br/program/include/rcube_mdb2.php on line 621 (GET /?_task=mail&_mbox=INBOX&_page=1)
[03-Jul-2009 16:48:08] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_674a5a0876c6968d9d29cb5837c47123866f39a43 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '2557-INBOX.msg-13401' for key 2]
Can you Help me, ? Thank's
Can you clear the database and make sure the created tables match the definitions provided with the SQL scripts?
http://trac.roundcube.net/browser/trunk/roundcubemail/SQL _______________________________________________ List info: http://lists.roundcube.net/dev/
To view my php configuration, in attach.
when number of connection up to 150 connection the high overload begin . Thanks again 2009/7/3 Tiago Gomes algodas@gmail.com
Hello everyone. sorry because my poor english congratulations to all the excellent project roundcube mail. I have one problem, I installed all versions for test, including svn / trunk (latest) and all creates overload on my server. High cpu load
I'm using the services:
Apache:
Server version: Apache/2.2.6 (Unix) Server built: Jul 1 2009 20:41:05
- -with-mpm=worker*
Php:
PHP 5.2.6-1+lenny3 with Suhosin-Patch 0.9.6.2 (cli) (built: Apr 26 2009 22:16:23) Copyright (c) 1997-2008 The PHP Group Zend Engine v2.2.0, Copyright (c) 1998-2008 Zend Technologies
Mysql 5.0
SERVER load average info after 10 minutes then restart the apache server:
*top - 16:48:25 up 6:24, 3 users, load average: 6.92, 2.89, 3.88* Tasks: 84 total, 2 running, 82 sleeping, 0 stopped, 0 zombie *Cpu(s): 98.1%us, 1.7%sy, 0.0%ni, 46.9%id, 0.2%wa, 0.0%hi, 0.0%si, 0.0%st* Mem: 2076288k total, 1079936k used, 996352k free, 297020k buffers Swap: 498004k total, 0k used, 498004k free, 486532k cached
PID USER PR NI VIRT RES SHR S *%CPU* %MEM TIME+ COMMAND
14103 www-data 20 0 564m 125m 3536 S *190* 6.2 6:28.57 httpd
14088 www-data 20 0 517m 89m 3464 S * 118* 4.4 10:45.10 httpd
the log error log from round roundcube mail:
Only:
*[03-Jul-2009 16:48:08 -0300] DB Error: MDB2 Error: constraint violation Query: _doQuery: [Error message: Could not execute statement] [Last executed query: EXECUTE mdb2_statement_mysql_501fd0fc317c477d1c729158644dc2c5bd5f1d12d USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10] [Native code: 1062] [Native message: Duplicate entry '2557-INBOX.msg-13334' for key 2] in /webhost/ webmail.atarde.com.br/program/include/rcube_mdb2.php on line 621 (GET /?_task=mail&_mbox=INBOX&_page=1)
[03-Jul-2009 16:48:08] MDB2 Error: constraint violation (-3): _doQuery: [Error message: Could not execute statement]
[Last executed query: EXECUTE mdb2_statement_mysql_674a5a0876c6968d9d29cb5837c47123866f39a43 USING @0, @1, @2, @3, @4, @5, @6, @7, @8, @9, @10]
[Native code: 1062]
[Native message: Duplicate entry '2557-INBOX.msg-13401' for key 2]
Can you Help me, ? Thank's
--
Tiago Gomes Pereira http://www.tiagogomes.eti.br LPI Certified LPI ID - LPI000129445 IT Service Management - ITIL FOUNDATION V2 ID - SR341901 algodas@gmail.com
-
Tiago Gomes -
till