We copied a postgresql commit-log in "pg_clog" and renamed it to "0007". It works now again.
cat error.log | grep -i warning [14/Feb/2018:13:41:58][16452.7f74ab050740][-main-] Warning: nsmain: rl_cur > FD_SETSIZE, select() calls should not be used cat error.log | grep -i error [14/Feb/2018:13:41:58][16452.7f74ab050740][-main-] Error: nsdbpg: result status: 7 message: FEHLER: konnte auf den Status von Transaktion 8252844 nicht zugreifen DETAIL: Konnte Datei »pg_clog/0007« nicht öffnen: Datei oder Verzeichnis nicht gefunden. [14/Feb/2018:13:41:59][16452.7f74ab050740][-main-] Error: Bootstrap:...
Hello Today I had to restart our Project Open-Server and since then, this error is appearing on the website: OpenACS Installation: Error We found the following problems with your PostgreSQL installation: PL/pgSQL has not been created in your database. Execute the following command while logged in as a PostgreSQL "superuser": createlang plpgsql your_database_name Postgres is running. When doing "createlang plpgsql projop", I get the output, that the language is already installed in the database. I...
This seems to be a serious bug. Whenever I try to sort the items in the Configuration-Database, I get this SQL-Error: Database operation "select" failed (exception ERROR, "ERROR: SELECT DISTINCT ON expressions must match initial ORDER BY expressions LINE 2: select DISTINCT on (i.tree_sortkey,conf_item_id) ^ This error also appears on http://demo.project-open.net/intranet-confdb/index when clicking on the title of a column ("Name", "Type" ... etc). When I change the "Order by clause" to ",im_conf_items",...