"Un Expected Error", Http 500 and slow page openings!

[Umit_Hacioglu]

Hi,

I am currently having some technical problems with slow page openings and HTTP 500 or request time-out errors after upgrading to the latest version of OJS 3.3.0.14.

I have no problem with the external server as it is using 8 CPUs and 8129 RAM. My journal database is 250MB.

When I wanted to access any article from our journal via google scholar to test the speed of the page of the article, I almost wait at least 60-90 seconds. When I work to save a modified page (like the editorial board), the cursor is always running and I am waiting. Editing Author information or unscheduling an article is not easy. I am sharing some screenshots.

I believe something is wrong between Database, PHP, or frontend. An optimization may solve the issue but I do not know any useful plugins but a script provided by OJT Team.

Would you please guide me on this issue? Should I downgrade my OJS?
I would really appreciate it if you provide me with some ideas!

Please tell us what happens and what you expected to happen.

Best Regards
Umit

[rcgillis]

Hi @Umit_Hacioglu,

when encountering the 500 error it is good to have a look at your PHP error logs? Could you report on any errors found there?

-Roger
PKP Team

[ssbfnet]

Hi Roger,

Thank you for your kind response.

My server provided increased the server CPU and RAM to solve the problem for 500 Error. But there is still something wrong between 250 MB size of Database and PHP requests. There are serious delays when the request is made from PHP.

I am just posting some of the selected warnings from error_log
Some errors:

[04-Mar-2023 18:45:01 Europe/Istanbul] PHP Fatal error: Uncaught Error: Call to a member function getConnection() on null in /ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php:74
Stack trace:

thrown in

/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Capsule/Manager.php on line 74
[04-Mar-2023 18:46:05 Europe/Istanbul] PHP Warning: ini_set(): Session ini settings cannot be changed when a session is active in
sbfnet.com/ojs/lib/pkp/classes/session/SessionManager.inc.php on line 71

[04-Mar-2023 18:48:05 Europe/Istanbul] PHP Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in ojs/lib/pkp/lib/vendor/smarty/smarty/libs/plugins/modifier.escape.php on line 36

[04-Mar-2023 21:26:59 Europe/Istanbul] PHP Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in ojs/lib/pkp/lib/vendor/smarty/smarty/libs/plugins/modifier.escape.php on line 36

ext Doctrine\DBAL\Driver\PDO\Exception: SQLSTATE[42000] [1203] User xxxx0_xxxx already has more than ‘max_user_connections’ active connections in xxx/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18
Stack trace:

thrown in xxojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[24-Mar-2023 11:03:32 Europe/Istanbul] PHP Fatal error: Uncaught PDOException: SQLSTATE[42000] [1203] User xxxx already has more than ‘max_user_connections’ active connections in /xxx/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:38
Stack trace:

thrown in xx/ojs/lib/pkp/lib/vendor/laravel/framework/src/Illuminate/Database/Connection.php on line 671
[16-Mar-2023 04:21:26 Europe/Istanbul] PHP Fatal error: Uncaught PDOException: SQLSTATE[HY000] [2002] Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2) in /home/xxx/ojs/lib/pkp/lib/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:38
Stack trace:

[19-Mar-2023 22:39:31 Europe/Istanbul] PHP Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in xxx/ojs/lib/pkp/lib/vendor/smarty/smarty/libs/plugins/modifier.escape.php on line 36

[01-Apr-2023 11:28:09 Europe/Istanbul] PHP Warning: ini_set(): Session ini settings cannot be changed when a session is active in /xxx/ojs/lib/pkp/classes/session/SessionManager.inc.php on line 71