[eGroupWare-tracker] Bugs #3039: With ActiveSync high Apache load (100% CPU)

[<tr...@eg...>]

Ticket modified by Ingo Ratsdorf at 2011/10/17 11:17
Tracking SystemBugs
CategoryActiveSync
VersionTrunk
StatusOpen
ResolutionNone
Completed0%
Priority5 - medium
Created byfrancesco_r francesco_r
Created on2011/09/15 14:40
Assigned toPhilip Herbert
Summary#3039 - With ActiveSync high Apache load (100% CPU)
I have installed the latest EGroupware trunk version with ActiveSync support.
I have successfully configured it with LDAP accounts (address book is in SQL) but i have a huge problem: when the activesync clients connect to EGW, Apache within some minutes is consuming 100% of my CPU and i must restart the service to restore the functionality.
I have configured three iPhone4 and one Samsung Galaxy Tab Android 2.2 .

This is the output of top after 5 minutes:

top - 14:39:36 up 2 days, 23 min,  1 user,  load average: 3.44, 3.06, 2.52
Tasks: 245 total,   4 running, 241 sleeping,   0 stopped,   0 zombie
Cpu(s): 40.1%us, 36.0%sy,  0.0%ni, 23.7%id,  0.0%wa,  0.0%hi,  0.2%si,  0.0%st
Mem:   2044500k total,  1985332k used,    59168k free,   159324k buffers
Swap:  2022392k total,    13924k used,  2008468k free,  1136032k cached

  PID USER      PR  NI  VIRT  RES  SHR S %CPU %MEM    TIME+  COMMAND
 1383 www-data  20   0 82544  35m  10m R  100  1.8  11:07.40 apache2
 1386 www-data  20   0 80608  35m 9700 R   99  1.8  15:13.22 apache2
 1802 www-data  20   0 78772  29m 8960 R   98  1.5   6:56.51 apache2
 1384 www-data  20   0 76692  31m  10m S    4  1.6   0:10.18 apache2

I have tried to change some settings in Apache (like KeepAlive or KeepAliveTimeout) but nothing change. And in the apache log i have no errors.
I found some post in the forum of z-push that have similar problem, perhaps something is wrong in the egw backend. See:

z-push.sourceforge.net/phpbb/viewtopic.php?f=2&t=891&p=4743&hilit=apache#p4743
z-push.sourceforge.net/phpbb/viewtopic.php?f=2&t=891&p=4751#p4751
z-push.sourceforge.net/phpbb/viewtopic.php?f=4&t=1274&p=4845&hilit=apache#p4845

Please help me to track down this issue.
Thank you
Francesco

Comment by Ingo Ratsdorf at 2011/10/17 11:17:
Was that CPU load appearing right from the start or only after several syncs? And how much data are you syncing?
Comment by francesco_r francesco_r at 2011/09/21 13:02:
Egroupware is installed on Ubuntu Lucid 10.04 LTS Server edition. The standard apache files are untouched and this is the apache egroupware configuration:

Alias /egroupware /usr/share/egroupware

# Enable ActiveSync protocol support via eSync app
Alias /Microsoft-Server-ActiveSync /usr/share/egroupware/activesync/index.php

# iOS 4.3+ calendar requires that to autodetect accounts
RedirectMatch ^(/principals/users/.*)$ /egroupware/groupdav.php$1



  Options FollowSymLinks ExecCGI
  AllowOverride None
  Order allow,deny
  Allow from all
  DirectoryIndex index.html index.php
  AddHandler cgi-script .cgi
  AddDefaultCharset Off
  php_flag display_errors off
  php_admin_flag file_uploads on
  php_flag log_errors on
  php_flag magic_quotes_gpc off
  php_flag magic_quotes_runtime off
  php_flag register_globals off
  php_flag short_open_tag on
  php_flag track_vars on
  php_flag display_errors off
  # E_ALL & ~E_NOTICE & ~E_STRICT = 8191 - 8 - 2048 = 6135
  php_value error_reporting 6135
  # php_value error_reporting 'E_ALL & ~E_NOTICE'
  php_value max_execution_time 90
  php_admin_value mbstring.func_overload 7
  php_value memory_limit 64M
  php_value session.gc_divisor 10
  # php_value session.gc_maxlifetime 1440
  # php_value session.gc_probability 1
  php_value session.save_path /var/lib/egroupware/sessions
  # php_flag session.use_trans_sid off
  php_value include_path .:/usr/share/php
  php_admin_value open_basedir /usr/share/egroupware:/var/lib/egroupware:/tmp:/usr/share/php:/usr/bin/zip:/usr/share/jpgraph:/usr/bin/tnef:/usr/bin/crontab:/usr/bin/php5
  php_value upload_max_filesize 64M
  php_admin_value upload_tmp_dir /tmp
  php_value post_max_size 65M
  
    Order allow,deny
    Deny from all
  
  php_admin_value open_basedir /



  php_admin_value mbstring.func_overload 0
  Order allow,deny
  Allow from all



However i have disabled the push from the iPhones (they sync every 15 minutes) and now the load is normal. So is something strange with the push from Apple.
With Android push i don't have this problem.
Comment by Andre Larbiere at 2011/09/16 17:59:
I am using the z-push interface of egroupware, too, with up to 6 mobile devices at the same time (Nokia E75, Samsung Galaxy TAB, Galaxy i9000 S, Galaxy ACE, Galaxy i9003S, Galaxy i9000 S2, Palm Pre 2), and while there are some minor issues (which may well be due to the buggy Android ActiveSync client), I do not have any CPU load issues on my server.
My server is not particularly powerful (Proliant ML110 G3 with 2 Gb of RAM), so I think I should see this problem if there was a fundamental issue in the eGroupware z-push interface.

You might want to post your apache configuration files - maybe we can point out a problem there.

BTW, do your clients sync correctly, despite the CPU load problem?

Andre


Linked entries:
https://community.egroupware.org/egroupware/index.php?menuaction=tracker.tracker_ui.edit&tr_id=3039&no_popup=1