OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



OCS is working slowly

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
What to do if you have a technical problem with OCS:

1. Search the forum. You can do this from the Advanced Search Page or from our Google Custom Search, which will search the entire PKP site. If you are encountering an error, we especially recommend searching the forum for said error.

2. Check the FAQ to see if your question or error has already been resolved. Please note that this FAQ is OJS-centric, but most issues are applicable to both platforms.

3. Post a question, but please, only after trying the above two solutions. If it's a workflow or usability question you should probably post to the OCS Conference Support and Discussion subforum; if you have a development question, try the OCS Development subforum.

OCS is working slowly

Postby Sinbademik » Tue Oct 18, 2011 6:09 am

Hi all...

We have prepared a conference site with OCS. (http://web.deu.edu.tr/ilahiyat/ocs)
Everything is good but the site is responding too late.
We also installed OJS in the same server and it is working properly.

We locally patched and upgraded ocs from 2.3.3-1 to 2.3.4 to fix the problem. At the end of the process both ocs current version did not change in "system information" page and the slowness of the site is still in progress.

How can we solve these problems? Can you help us?

Best regards,

Hadi SOFU



system information:
OCS Current version 2.3.3.1
OS platform SunOS
PHP version 5.2.9
Apache version Apache/2.0.63
Database driver mysql
Database server version 5.0.51-log
Sinbademik
 
Posts: 2
Joined: Thu Sep 29, 2011 4:39 am

Re: OCS is working slowly

Postby michael » Tue Oct 18, 2011 10:39 am

Hi Hadi SOFU,

One likely reason why your version number was not updated to 2.3.4 is that the upgrade process timed out and didn't actually complete until the end.

The OCS 2.3.4 upgrade will try and re-index all of your conference content as part of a bug fix included in the release. If you have a lot of content, this may take some time to finish and PHP may be timing out before it has a chance to complete this task.

The version number is updated at the end of the entire upgrade process, so if the index rebuild times out, your version number will not be updated correctly.

You can modify your server settings and ensure that PHP's execution and memory limits are sufficiently high:

Code: Select all
    max_execution_time = 450     ; Maximum execution time of each script, in seconds (30)
    max_input_time = 90 ; Maximum amount of time each script may spend parsing request data (60)
    memory_limit = 256M      ; Maximum amount of memory a script may consume (128MB)


You can find these in your php.ini (don't forget to restart the webserver after making changes).

Alternatively, you can remove the index rebuild step from the upgrade process, complete the upgrade without it, and then try to manually rebuild the index after the upgrade is complete:

1) After unzipping the OCS 2.3.4 source or patching your old install with the OCS 2.3.4 upgrade patch, go to the bottom of dbscripts/xml/upgrade.xml.

You will find the following:
Code: Select all
   <upgrade minversion="2.0.0.0" maxversion="2.3.3.9">
      <data file="dbscripts/xml/upgrade/2.3.4_update.xml" />
      <code function="rebuildSearchIndex" />
      <note file="docs/release-notes/README-2.3.4" />
   </upgrade>


2) Remove the line: <code function="rebuildSearchIndex" />

3) Run the upgrade.

4) Once the upgrade is complete and you can verify the correct version number, manually rebuild the search index from the command line: php tools/rebuildSearchIndex.php

Re: OCS being slow, can you please be more specific? Which pages are being slow? Is the whole site affected?

Cheers,
Michael
michael
 
Posts: 405
Joined: Thu Mar 29, 2007 2:09 pm

Re: OCS is working slowly

Postby Sinbademik » Tue Oct 18, 2011 7:59 pm

Dear Michael;
Many thanks for your reply.
Our Data Processing Center, as soon as possible, will apply your recommendations about upgrade problem.

Regarding slowness..:
we were getting the following error each time in the past both in the front-end and back-end processes:
"Fatal error: Maximum execution time of 30 seconds exceeded in ..................inc.php on line ...."

To get rid of this error, I wrote the following code in the first line of all the .php files that gives such error:
"set_time_limit(600);"

Now, we don't get this error but the whole site is working slowly.

Best regards,

Hadi SOFU
Sinbademik
 
Posts: 2
Joined: Thu Sep 29, 2011 4:39 am

Re: OCS is working slowly

Postby michael » Wed Oct 19, 2011 10:14 am

Hi Hadi SOFU,

Which pages were timing out previously, before you increased the execution time limit?

Thanks,
Michael
michael
 
Posts: 405
Joined: Thu Mar 29, 2007 2:09 pm

Slowness

Postby mendesrocha » Wed May 28, 2014 12:31 pm

Hello,

we are also dealing with slowness on our OCS installation. Pages loading time are on an average of 40-60sec. We currently host 17 conferences which 5 will happen this year. Conferences managers are all complaining about the slowness. They say it is hard to work on.

We have OCS 2.3.5 running on Apache, PHP 5.2.7 and Mysql 5.1.54-rel12.6-log

The slowness increased when we changed the main address from cbce.tempsite.ws/congressos to the new subdomain congressos.cbce.org.br. I don't think this could be considered as a cause.

The weird thing is that we have an OJS in the same server that is running smoothly. I have contact our hosting service and they say that database service is ok.

Can anyone help me?

regards,
Renato
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: OCS is working slowly

Postby asmecher » Thu May 29, 2014 8:14 am

Hi Renato,

First you'll need to narrow down what is working slowly. Using a web developer tool like Firebug for Firefox, you can look at the requests your browser is making to the server and see whether one is working slowly or not responding altogether. (If you've changed your URL and forgotten to clear your cache files, for example, it's possible that something is still referring to the old URL, and the browser is waiting for that request to time-out before displaying the page.) If it's a request to OCS that's taking a long time to respond, then the next thing to examine will be whether it's e.g. a PHP or a MySQL problem. Temporarily turning on the "debug" option in config.inc.php (warning -- this will present a lot of debug information to any user viewing the site) will present MySQL queries via the browser; you can check these queries to see if they require a long time to execute on the server. If you can identify one of these, we can help check to see if there are performance improvements possible.

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8905
Joined: Wed Aug 10, 2005 12:56 pm

Re: OCS is working slowly

Postby mendesrocha » Thu May 29, 2014 1:30 pm

Hi Alec,

The clear cache function is that available at '../admin/clearDataCache' and '../admin/clearTemplateCache' ?

I set the database debug on and it printed about six thousand queries. Glancing over them It seems that most of them regards to a paper_comments related request like this:

Code: Select all
(mysql): SELECT a.* FROM paper_comments a WHERE paper_id = '1377' AND comment_type = 1 AND assoc_id = '1364' ORDER BY date_posted DESC LIMIT 1 
(mysql): SELECT a.* FROM paper_files a WHERE file_id = '3935' AND revision = '1' 


I attached the full debug stats output with speed information.

I also tried the Firebug but couldn't find any error displayed. Maybe I am using it wrong.

When I set 'display_errors' on it shows this message

Code: Select all
ocs2 has produced an error Message: WARNING: filesize() [function.filesize]: stat failed for /home/storage/4/c4/e6/cbce/public_html/congressos/cache/fc-pluginSettings-0-0-AcronPlugin.php In file: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/pqp/classes/PhpQuickProfiler.php At line: 64 Stacktrace: File: (unknown) line (unknown) Function: PKPApplication->errorHandler(2, "filesize() [<a href='function.filesize'>function.filesize</a>]: ...", "/home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/pq...", 64, Array(6)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/pqp/classes/PhpQuickProfiler.php line 64 Function: filesize("/home/storage/4/c4/e6/cbce/public_html/congressos/cache/fc-plugi...") File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/PKPProfiler.inc.php line 40 Function: PhpQuickProfiler->gatherFileData() File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/template/PKPTemplateManager.inc.php line 533 Function: PKPProfiler->getData() File: /home/storage/4/c4/e6/cbce/public_html/congressos/cache/t_compile/%%CF^CF5^CF5BA9DF%%footer.tpl.php line 20 Function: PKPTemplateManager->smartyGetDebugInfo(Array(0), Object(TemplateManager)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/smarty/Smarty.class.php line 1869 Function: include("/home/storage/4/c4/e6/cbce/public_html/congressos/cache/t_compil...") File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/template/PKPTemplateManager.inc.php line 177 Function: Smarty->_smarty_include(Array(2)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/cache/t_compile/%%CB^CB6^CB620954%%footer.tpl.php line 4 Function: PKPTemplateManager->_smarty_include(Array(2)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/smarty/Smarty.class.php line 1869 Function: include("/home/storage/4/c4/e6/cbce/public_html/congressos/cache/t_compil...") File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/template/PKPTemplateManager.inc.php line 177 Function: Smarty->_smarty_include(Array(2)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/cache/t_compile/%%30^309^309A5EF8%%site.tpl.php line 33 Function: PKPTemplateManager->_smarty_include(Array(2)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/smarty/Smarty.class.php line 1256 Function: include("/home/storage/4/c4/e6/cbce/public_html/congressos/cache/t_compil...") File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/lib/smarty/Smarty.class.php line 1106 Function: Smarty->fetch("index/site.tpl", Null, Null, True) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/template/PKPTemplateManager.inc.php line 234 Function: Smarty->display("index/site.tpl") File: /home/storage/4/c4/e6/cbce/public_html/congressos/pages/index/IndexHandler.inc.php line 82 Function: PKPTemplateManager->display("index/site.tpl") File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/PKPPageRouter.inc.php line 177 Function: IndexHandler->index(Array(0), Object(Request)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/Dispatcher.inc.php line 130 Function: PKPPageRouter->route(Object(Request)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/lib/pkp/classes/core/PKPApplication.inc.php line 170 Function: Dispatcher->dispatch(Object(Request)) File: /home/storage/4/c4/e6/cbce/public_html/congressos/index.php line 64 Function: PKPApplication->execute() Server info: OS: Linux PHP Version: 5.2.17 Apache Version: N/A DB Driver: mysql DB server version: 5.1.54-rel12.6-log
Attachments
deprecation.txt
(60.24 KiB) Downloaded 22 times
debut_speed.txt
(864.6 KiB) Downloaded 27 times
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: OCS is working slowly

Postby asmecher » Thu May 29, 2014 2:45 pm

Hi Renato,

Have you checked the paper_comments table's contents to see if you might have a spam problem? Are you using paper commenting features?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8905
Joined: Wed Aug 10, 2005 12:56 pm

Re: OCS is working slowly

Postby mendesrocha » Thu May 29, 2014 6:51 pm

Hi, Alec,

i've checked the entries in 'paper_comments' table and I haven't found any evidence of spam attack. Most entries are record of editorial decisions of past conferences.

-Renato
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: OCS is working slowly

Postby asmecher » Fri May 30, 2014 7:55 am

Hi Renato,

Can you PM or email me a dump of the "debug" output? That still sounds like far too many queries.

Thanks,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8905
Joined: Wed Aug 10, 2005 12:56 pm

Re: OCS is working slowly

Postby mendesrocha » Fri May 30, 2014 8:30 am

Alec,

isn't it he files I attached to the previous message? Or something different?

Anyway, I mailed them.

-Renato
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: OCS is working slowly

Postby mendesrocha » Sat May 31, 2014 3:30 pm

Alec,

good news. An editor has noticied that the website speed has improved. It is loading on average of 15s, rather of the previous 60s.
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: OCS is working slowly

Postby asmecher » Tue Jun 03, 2014 11:43 am

Hi Renato,

That still sounds pretty frustrating to use. Is this poor performance on all pages, or just e.g. certain editorial pages?

Regards,
Alec Smecher
Public Knowledge Project Team
asmecher
 
Posts: 8905
Joined: Wed Aug 10, 2005 12:56 pm

Re: OCS is working slowly

Postby mendesrocha » Tue Jun 03, 2014 12:10 pm

All pages, editorial and public ones.
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil

Re: OCS is working slowly

Postby mendesrocha » Thu Jun 05, 2014 6:51 am

Hi All,

We got great performance improvement after disabling the Acron system plugin. Pages are now loading in ms. instead of the previous 60s!

Thanks Alec for the attention and accurate suggestion.

-
Renato
mendesrocha
 
Posts: 174
Joined: Mon Nov 05, 2007 11:10 am
Location: Brazil


Return to OCS Technical Support

Who is online

Users browsing this forum: Yahoo [Bot] and 2 guests