CiviCRM Community Forums (archive)

Hi

Every now and then the website I'm developing virtually grinds to a halt. The support people had a look and this is what they send back to me


Hi Trevor,

I've been keeping an eye on your server this evening and the load suddenly went up and started causing resource issues.

I checked the processes and the web server was using nearly 100% CPU. So, I checked apache connections and interestingly there was only a few active connections so not a sudden rush or traffic.

I then attached a trace onto the process to find out exactly what was happening, and I found this:

getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Core/BAO/CustomField.php", 0x7fff6b5e41b0) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO/CustomField.php", {st_mode=S_IFREG|0644, st_size=88952, ...}) = 0
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/BAO", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Core/Permission.php", 0x7fff6b5e4090) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Permission.php", {st_mode=S_IFREG|0644, st_size=20988, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Core/Permission/Joomla.php", 0x7fff6b5e3d30) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Permission/Joomla.php", {st_mode=S_IFREG|0644, st_size=4636, ...}) = 0
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Core/Permission", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Utils/String.php", 0x7fff6b5e3ab0) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Utils/String.php", {st_mode=S_IFREG|0644, st_size=17892, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Utils/Array.php", 0x7fff6b5e4510) = -1 ENOENT (No such file or directory)
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Contact/BAO/Query.php", 0x7fff6b5e4630) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Query.php", {st_mode=S_IFREG|0644, st_size=171501, ...}) = 0
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Contact/BAO/Contact.php", 0x7fff6b5e43f0) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php", {st_mode=S_IFREG|0644, st_size=119076, ...}) = 0
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Contact/BAO/Contact.php", 0x7fff6b5e43f0) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO/Contact.php", {st_mode=S_IFREG|0644, st_size=119076, ...}) = 0
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Contact/BAO", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Core/Component.php", 0x7fff6b5e43f0) = -1 ENOENT (No such file or directory)
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Event/BAO/Query.php", 0x7fff6b5e4090) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Event/BAO/Query.php", {st_mode=S_IFREG|0644, st_size=31539, ...}) = 0
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Event/BAO", {st_mode=S_IFDIR|0755, st_size=4096, ...}) = 0
getcwd("/var/www/vhosts/the-businessclub.org.uk/httpdocs", 4096) = 49
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Event/DAO/Event.php", 0x7fff6b5e41b0) = -1 ENOENT (No such file or directory)
lstat("/var/www/vhosts/the-businessclub.org.uk/httpdocs/administrator/components/com_civicrm/civicrm/CRM/Event/DAO/Event.php", {st_mode=S_IFREG|0644,


Notice all of the messages "No such file or Directory", these literally filled hundreds of lines within a second. So, it looks like this is where the problems stems, there's an error causing this.

Tale a look at the following article I found with the same issue on a drupal website:
http://drupal.org/node/1050740

There's coding errors on this website causing issues, it could be with an extension. If you are unaware what could be cuaisn g this it may be worth contacting the developers or try disable any extensions you don't necessary need to run the website.


could someone investigate please - it's making the site unusable. Thanks

The file var/www/vhosts/the-businessclub.org.uk/httpdocs/./CRM/Core/BAO/CustomField.php should not exist actually. Can you check all of your settings and make sure all directories are correct? Something appears wrong.

Visit civicrm/admin/setting/updateConfigBackend&reset=1 and tell us what you see.

Well using that URL it should change the setting from your test server, and it must change b/c it's a different directory. It's not clear what's going on here--do another transfer I guess, run that URL and then post the settings from both sites.

If you run

UPDATE `civicrm_domain` SET `config_backend`=NULL ;
in MySQL after you transfer, CiviCRM should reset those itself.