Repository navigation
Description
Describe the bug
I can no longer open any notes after upgrading to Nextcloud 16.0.3 (then later upgraded to 16.0.4)
Looking at the JSON response it looks like this
{"JSON":{"etag":"45c5269c51a890deaf1d02139403a959","modified":null,"title":"Fusion project","category":"statkraft","content":"Error: (Fusion project.txt) An exception occurred while executing 'INSERT INTO "oc_file_locks" ("key", "lock", "ttl") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params ["files\/3f12ddc0287423160f601fa2e1029d01", 1, 1569178240]:\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "ON"\nLINE 1: ..._locks" ("key", "lock", "ttl") VALUES($1, $2, $3) ON CONFLIC...\n ^","favorite":false,"error":true,"errorMessage":"Error: (Fusion project.txt) An exception occurred while executing 'INSERT INTO "oc_file_locks" ("key", "lock", "ttl") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params ["files\/3f12ddc0287423160f601fa2e1029d01", 1, 1569178240]:\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near "ON"\nLINE 1: ..._locks" ("key", "lock", "ttl") VALUES($1, $2, $3) ON CONFLIC...\n ^","id":6234}}
To Reproduce
Steps to reproduce the behavior:
- Go to Notes app in the webpage
- Click any note
- Note does not open, but at the top of the page an error message is seen
Expected behavior
That I can open a note
Server (please complete the following information):
- Notes app version: 3.0.3
- Nextcloud version: 16.0.4
- OS: entos-release-7-6.1810.2.el7.centos.x86_64
- Web server: Not known. Managed by hosting provider. Probably Apache
- PHP version: 7.1
- Database: PostgreSQL 9.4.24 on x86_64-unknown-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-36), 64-bit
Client (please complete the following information):
- Browser (incl. version): Firefox 69.0. Also newer Chrome
- OS: Linux and Windows.
This mostly looks like server side issue.
Log files
Activity
oyse commentedon Sep 22, 2019
Attached log file.
nextcloud-notes-error.log
korelstar commentedon Sep 22, 2019
It looks like this is a known issue in Nextcloud server, see nextcloud/server#15441 and nextcloud/server#15613 . Currently, Nextcloud 16 requires PostgreSQL 9.5 or above; you're using PostgreSQL 9.4.
Nevertheless, it looks like they wrote a fix for this (nextcloud/server#16572) which will be included in Nextcloud 16.0.5 (see nextcloud/server#16814).
To sum up, there is nothing we can do here. Please upgrade to PostgreSQL 9.5+ or wait for Nextcloud 16.0.5.
oyse commentedon Sep 23, 2019
Ok. Thank you for looking into it. I will wait for the 16.0.5 release.