OJS 3.4.0-3 very slow

Software Support
1

Hi,
I have upgraded our OJS from OJS S 3.3.0-14 to OJS 3.4.0-3. It works ok but it is very slow. All other applications and OJS 3.3.0-14 in our server running with Mysql and PHP run fast. Do anyone have an idea about this problem?

  • Obi
2

Hi @obi,

Do you know whether it’s the MySQL processes or the PHP processes (or something else) that represent the additional load? (Related: this thread)

Regards,
Alec Smecher
Public Knowledge Project Team

3

Hi Alec,
Thanks for helping. I think Mysql (mariadbd) is the culprit. I have looked at the logs and I cannot figure out why all the ojs3.4.x’s(3.4.0.1, 3.4.0.2, 3.4.0.3) are too slow and not ojs 3.3.0.14. I have copied the installation to three different servers and got the same result. All the servers are running php v8.2.10 and mysql (mysql Ver 15.1 Distrib 10.11.3-MariaDB) on Linux Debian 12.

Obi

4

Hi @obi,

One major difference between 3.3.0-x and 3.4.0-x is that we introduced foreign key constraints. I haven’t experienced this to perform a lot slower, but it might be worth investigating (and may be something that needs separate tuning in the MySQL configuration).

Regards,
Alec Smecher
Public Knowledge Project Team

5

Hi @alec

We have the same exacte problem. We’ve just upgrade our OJS 3.3 to 3.4 and the result is a bizarre slowness.

The error generated is : [Fri Jan 23 11:11:17.581541 2026] [proxy_fcgi:error] [pid 146156:tid 146177] [remote 192.168.103.186:58858] AH01071: Got error 'PHP message: PHP Fatal error: Uncaught PDOException: SQLSTATE[23000]: Integrity constraint violation: 1451 Cannot delete or update a parent row: a foreign key constraint fails (ojs34revuesdb.authors, CONSTRAINT authors_user_group_id_foreign FOREIGN KEY (user_group_id) REFERENCES user_groups (user_group_id)

Any suggestion to solve this issue?

Thank you.