OJS installation not working anymore

Hello everybody, I hope you can help.

We installed OJS 3.3.0-15 and it worked well until yesterday.

Today when we try to access it with a browser it does not show anything. The browser remains waiting. It does not show the home page neither gives an error.

We investigated a little, and our impression is that when OJS connects to the DB at some point it remains stucked waiting for an answer from the DB that does not arrive.

The DBMS is PostgreSQL 13.

After turning on the databse debug mode in OJS configuration file, we can see from the log that apparently it can execute some queries to the DB (so the connection seems to be established).

The last query that is reported in the log (so the last one that presumably is correctly executed) is the following:

SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ā€˜defaultthemepluginā€™ AND context_id=0

Can you give some advice on how to understand what is going on?

Thank you in advance

Dear @edg,

Are you able to access the OJS backend or everything just displays a blank page? Also, what do you have in the error log?

Best regards,
Josh

In the browser I only see a blank page, like if the page was loading.

On the error log, there was no error message. In order to understand what was happening with the DB I turned on the debug mode in OJS and what I see now is some SQL queries (I guess is a log of the queries done by the OJS application):

[Thu Oct 19 01:33:13.110230 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nSELECT * FROM sessions WHERE session_id = ?\n["siq7vrthcodgi8289vcsi6k136"]
[Thu Oct 19 01:33:13.111633 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nDELETE FROM sessions WHERE session_id = ?\n["siq7vrthcodgi8289vcsi6k136"]
[Thu Oct 19 01:33:13.112498 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nINSERT INTO sessions\n\t\t\t\t(session_id, ip_address, user_agent, created, last_used, remember, data, domain)\n\t\t\t\tVALUES\n\t\t\t\t(?, ?, ?, ?, ?, ?, ?, ?)\n["siq7vrthcodgi8289vcsi6k136","62.211.27.74","Mozilla\\/5.0 (Windows NT 10.0; Win64; x64; rv:109.0) Gecko\\/20100101 Firefox\\/118.0",1697693593,1697693593,0,"","jgaa-v4.cs.brown.edu"]
[Thu Oct 19 01:33:13.120964 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nSELECT * FROM site\n[]
[Thu Oct 19 01:33:13.140404 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nSELECT * FROM site_settings\n[]
[Thu Oct 19 01:33:13.168976 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nSET TIME ZONE INTERVAL '+0:00' HOUR TO MINUTE\n[]
[Thu Oct 19 01:33:13.176496 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nSELECT v.*\n\t\t\tFROM versions v LEFT JOIN plugin_settings ps ON\n\t\t\t\tlower(v.product_class_name) = ps.plugin_name\n\t\t\t\tAND ps.setting_name = 'enabled' AND (context_id = ? OR v.sitewide = 1)\n\t\t\tWHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1)\n[0]
[Thu Oct 19 01:33:13.409316 2023] [php:notice] [pid 641102] [client 62.211.27.74:49903] Database query\nSELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ? AND context_id = ?\n["defaultthemeplugin",0]

The only ā€œsuspiciousā€ thing is, at the beginning of the log file, the following WARNING:

PHP Warning:  PHP Startup: Unable to load dynamic library 'pdo_pgsql' (tried: /usr/lib/php/20220829/pdo_pgsql (/usr/lib/php/20220829/pdo_pgsql: cannot open shared object file: No such file or directory), /usr/lib/php/20220829/pdo_pgsql.so (/usr/lib/php/20220829/pdo_pgsql.so: undefined symbol: pdo_parse_params)) in Unknown on line 0
PHP Warning:  Module "intl" is already loaded in Unknown on line 0
PHP Warning:  Module "pgsql" is already loaded in Unknown on line 0

Thank you for any advice.

[UPDATE][SOLVED]

I solved the problem.
Just in case it can be useful to someone else:
I removed the cache folder and create a new one empty.

1 Like