OJS 2.4.8 PHP queries were not closing correctly

Software Support
1

Hi @asmecher

We have been experiencing problems on our OJS 2.4.8-2 installations whereby the system - website entirely - goes down (offline). Upon investigation, it seemed that the behavior was due to PHP queries that aren’t/can’t close correctly. We had to manually terminate them, in order for the site to load again.

However, these query behavior is causing the PHP slots to become full and none being available for the user to browse. Apart from being down, the sites are extremely slow to respond/load.

Are anyone else experiencing this on their server, and have possibly a solution to fix this? Increasing the PHP slots did not make any difference.

Regards, Trudie

2

Hi @tretief,

Just to be clear, do you mean PHP threads, or SQL queries?

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi @asmecher

Here the following error messages:

  • WARNING: server reached max_children setting (20), consider raising it

  • The website is reaching its maximum concurrent PHP connections

Regards, Trudie

4

Hi @tretief,

This tells me that your web server is busy responding to 20 requests and is not accepting more until it can free some slots. That might indicate a higher number of visitors than your server can handle, or that some of its slots are stalled somehow, or that it’s taking longer than normal to respond to requests. I’m afraid you’ll have to investigate further with your sysadmin to find out what those 20 slots are up to before you’ll know how to resolve it. This may be an OJS issue, or a MySQL problem, or Apache, or…

Thanks,
Alec Smecher
Public Knowledge Project Team