Server: NC 16+ uses SQL that is only supported in Postgresql >= 9.5

[tobybryans]

Steps to reproduce

1. Use Postgres 9.4 or lower (9.4 is still a supported version)
2. Upgrade from NC 15 to 16
3. Upgrade works well, until you try to synchronise files, which then fails and the error log fills with SQL errors.

Expected behaviour

The upgrade script should check the version of postgres and prevent upgrades when the version is 9.4 or lower with a full explanation.

Actual behaviour

Upgrade proceeds, looks successful but instance then fails in unclear ways.

The SQL that causes the problem is INSERT [...] ON CONFLICT [...].

Server configuration

Operating system:
CentOS 6.10

Web server:
Apache 2.4

Database:
Postgres 9.3

PHP version:
7.1

Nextcloud version: (see Nextcloud admin page)
16+

Updated from an older Nextcloud/ownCloud or fresh install:
15.0.5

Where did you install Nextcloud from:
Source

List of activated apps:

App list

Enabled:
  - accessibility: 1.2.0
  - activity: 2.9.1
  - calendar: 1.7.0
  - cloud_federation_api: 0.2.0
  - comments: 1.6.0
  - contacts: 3.1.1
  - dav: 1.9.2
  - deck: 0.6.2
  - federatedfilesharing: 1.6.0
  - federation: 1.6.0
  - files: 1.11.0
  - files_external: 1.7.0
  - files_pdfviewer: 1.5.0
  - files_rightclick: 0.13.0
  - files_sharing: 1.8.0
  - files_texteditor: 2.8.0
  - files_trashbin: 1.6.0
  - files_versions: 1.9.0
  - files_videoplayer: 1.5.0
  - firstrunwizard: 2.5.0
  - gallery: 18.3.0
  - logreader: 2.1.0
  - lookup_server_connector: 1.4.0
  - mail: 0.15.1
  - nextcloud_announcements: 1.5.0
  - notes: 2.6.0
  - notifications: 2.4.1
  - oauth2: 1.4.2
  - ojsxc: 3.4.4
  - privacy: 1.0.0
  - provisioning_api: 1.6.0
  - recommendations: 0.4.0
  - serverinfo: 1.6.0
  - sharebymail: 1.6.0
  - social: 0.1.4
  - spreed: 6.0.1
  - support: 1.0.0
  - survey_client: 1.4.0
  - systemtags: 1.6.0
  - theming: 1.7.0
  - twofactor_backupcodes: 1.5.0
  - twofactor_nextcloud_notification: 1.1.1
  - twofactor_totp: 2.1.2
  - updatenotification: 1.6.0
  - user_sql: 4.3.0
  - viewer: 1.0.0
  - workflowengine: 1.6.0
Disabled:
  - admin_audit
  - documents
  - encryption
  - password_policy
  - tasks
  - user_ldap

Nextcloud log (data/nextcloud.log)

Nextcloud log

{"reqId":"TRG3UbxBsrSHgYZGflbk","level":4,"time":"2019-05-18T18:24:10+00:00","remoteAddr":"212.9.102.182","user":"[email protected]","app":"webdav","method":"GET","url":"\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","message":{"Exception":"Sabre\\DAV\\Exception","Message":"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/006398cf092d97f5a4a219f2cb01e0d9\", 1, 1558207450]:\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                                                             ^","Code":0,"Trace":[{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/lib\/Connector\/Sabre\/File.php","line":380,"function":"convertToSabreException","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[{"__class__":"Doctrine\\DBAL\\Exception\\SyntaxErrorException"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php","line":85,"function":"get","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"function":"httpGet","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpGet"],[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:GET",[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/remote.php","line":163,"args":["\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php"],"function":"require_once"}],"File":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/lib\/Connector\/Sabre\/File.php","Line":622,"Previous":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/006398cf092d97f5a4a219f2cb01e0d9\", 1, 1558207450]:\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                                                             ^","Code":0,"Trace":[{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":184,"function":"convertException","class":"Doctrine\\DBAL\\Driver\\AbstractPostgreSQLDriver","type":"->","args":["An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/006398cf092d97f5a4a219f2cb01e0d9\", 1, 1558207450]:\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
                                              ^",{"errorInfo":["42601",7,"ERROR:  syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n                                                             ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/DBALException.php","line":158,"function":"wrapException","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"},{"errorInfo":["42601",7,"ERROR:  syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n                                                             ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"An exception occurred while executing 'INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING' with params [\"files\\\/006398cf092d97f5a4a219f2cb01e0d9\", 1, 1558207450]:\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
                                ^"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1088,"function":"driverExceptionDuringQuery","class":"Doctrine\\DBAL\\DBALException","type":"::","args":[{"__class__":"Doctrine\\DBAL\\Driver\\PDOPgSql\\Driver"},{"errorInfo":["42601",7,"ERROR:  syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n                                                             ^"],"__class__":"Doctrine\\DBAL\\Driver\\PDOException"},"INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",{"1":"files\/006398cf092d97f5a4a219f2cb01e0d9","2":1,"3":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",["files\/006398cf092d97f5a4a219f2cb01e0d9",1,1558207450],[2,2,2]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/AdapterPgSql.php","line":49,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3) ON CONFLICT DO NOTHING",{"dcValue1":"files\/006398cf092d97f5a4a219f2cb01e0d9","dcValue2":1,"dcValue3":1558207450},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/Connection.php","line":261,"function":"insertIgnoreConflict","class":"OC\\DB\\AdapterPgSql","type":"->","args":["file_locks",{"key":"files\/006398cf092d97f5a4a219f2cb01e0d9","lock":1,"ttl":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":139,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files\/006398cf092d97f5a4a219f2cb01e0d9","lock":1,"ttl":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":185,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/006398cf092d97f5a4a219f2cb01e0d9",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/Storage\/Common.php","line":715,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/006398cf092d97f5a4a219f2cb01e0d9",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":1927,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":2037,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,false]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":1134,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":988,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["fopen","\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",["read"],"r"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/lib\/Connector\/Sabre\/File.php","line":378,"function":"fopen","class":"OC\\Files\\View","type":"->","args":["documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","r"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php","line":85,"function":"get","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"function":"httpGet","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpGet"],[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:GET",[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/remote.php","line":163,"args":["\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php"],"function":"require_once"}],"File":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/AbstractPostgreSQLDriver.php","Line":74,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDOException","Message":"SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n                                                             ^","Code":"42601","Trace":[{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1079,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",["files\/006398cf092d97f5a4a219f2cb01e0d9",1,1558207450],[2,2,2]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/AdapterPgSql.php","line":49,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3) ON CONFLICT DO NOTHING",{"dcValue1":"files\/006398cf092d97f5a4a219f2cb01e0d9","dcValue2":1,"dcValue3":1558207450},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/Connection.php","line":261,"function":"insertIgnoreConflict","class":"OC\\DB\\AdapterPgSql","type":"->","args":["file_locks",{"key":"files\/006398cf092d97f5a4a219f2cb01e0d9","lock":1,"ttl":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":139,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files\/006398cf092d97f5a4a219f2cb01e0d9","lock":1,"ttl":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":185,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/006398cf092d97f5a4a219f2cb01e0d9",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/Storage\/Common.php","line":715,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/006398cf092d97f5a4a219f2cb01e0d9",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":1927,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":2037,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,false]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":1134,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":988,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["fopen","\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",["read"],"r"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/lib\/Connector\/Sabre\/File.php","line":378,"function":"fopen","class":"OC\\Files\\View","type":"->","args":["documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","r"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php","line":85,"function":"get","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"function":"httpGet","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpGet"],[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:GET",[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/remote.php","line":163,"args":["\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php"],"function":"require_once"}],"File":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":143,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \"ON\"\nLINE 1: ..._locks\" (\"key\", \"lock\", \"ttl\") VALUES($1, $2, $3) ON CONFLIC...\n                                                             ^","Code":"42601","Trace":[{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","line":141,"function":"execute","class":"PDOStatement","type":"->","args":[null]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Connection.php","line":1079,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDOStatement","type":"->","args":[]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/Connection.php","line":216,"function":"executeUpdate","class":"Doctrine\\DBAL\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(?, ?, ?) ON CONFLICT DO NOTHING",["files\/006398cf092d97f5a4a219f2cb01e0d9",1,1558207450],[2,2,2]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/AdapterPgSql.php","line":49,"function":"executeUpdate","class":"OC\\DB\\Connection","type":"->","args":["INSERT INTO \"oc_file_locks\" (\"key\", \"lock\", \"ttl\") VALUES(:dcValue1, :dcValue2, :dcValue3) ON CONFLICT DO NOTHING",{"dcValue1":"files\/006398cf092d97f5a4a219f2cb01e0d9","dcValue2":1,"dcValue3":1558207450},{"dcValue1":2,"dcValue2":2,"dcValue3":2}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/DB\/Connection.php","line":261,"function":"insertIgnoreConflict","class":"OC\\DB\\AdapterPgSql","type":"->","args":["file_locks",{"key":"files\/006398cf092d97f5a4a219f2cb01e0d9","lock":1,"ttl":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":139,"function":"insertIgnoreConflict","class":"OC\\DB\\Connection","type":"->","args":["file_locks",{"key":"files\/006398cf092d97f5a4a219f2cb01e0d9","lock":1,"ttl":1558207450}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Lock\/DBLockingProvider.php","line":185,"function":"initLockField","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/006398cf092d97f5a4a219f2cb01e0d9",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/Storage\/Common.php","line":715,"function":"acquireLock","class":"OC\\Lock\\DBLockingProvider","type":"->","args":["files\/006398cf092d97f5a4a219f2cb01e0d9",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/Storage\/Wrapper\/Wrapper.php","line":593,"function":"acquireLock","class":"OC\\Files\\Storage\\Common","type":"->","args":["files\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":1927,"function":"acquireLock","class":"OC\\Files\\Storage\\Wrapper\\Wrapper","type":"->","args":["files\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,{"__class__":"OC\\Lock\\DBLockingProvider"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":2037,"function":"lockPath","class":"OC\\Files\\View","type":"->","args":["\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1,false]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":1134,"function":"lockFile","class":"OC\\Files\\View","type":"->","args":["\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",1]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/lib\/private\/Files\/View.php","line":988,"function":"basicOperation","class":"OC\\Files\\View","type":"->","args":["fopen","\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md",["read"],"r"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/lib\/Connector\/Sabre\/File.php","line":378,"function":"fopen","class":"OC\\Files\\View","type":"->","args":["documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","r"]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/CorePlugin.php","line":85,"function":"get","class":"OCA\\DAV\\Connector\\Sabre\\File","type":"->","args":[]},{"function":"httpGet","class":"Sabre\\DAV\\CorePlugin","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/event\/lib\/EventEmitterTrait.php","line":105,"function":"call_user_func_array","args":[[{"__class__":"Sabre\\DAV\\CorePlugin"},"httpGet"],[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":479,"function":"emit","class":"Sabre\\Event\\EventEmitter","type":"->","args":["method:GET",[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/sabre\/dav\/lib\/DAV\/Server.php","line":254,"function":"invokeMethod","class":"Sabre\\DAV\\Server","type":"->","args":[{"absoluteUrl":"https:\/\/rook.deburen.uk\/remote.php\/webdav\/documents\/Joplin\/4b8612d30e6341fe931f95753f162215.md","__class__":"Sabre\\HTTP\\Request"},{"__class__":"Sabre\\HTTP\\Response"}]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php","line":80,"function":"exec","class":"Sabre\\DAV\\Server","type":"->","args":[]},{"file":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/remote.php","line":163,"args":["\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/apps\/dav\/appinfo\/v1\/webdav.php"],"function":"require_once"}],"File":"\/u01\/webapps\/owncloud\/hostname.obfuscated\/nextcloud\/3rdparty\/doctrine\/dbal\/lib\/Doctrine\/DBAL\/Driver\/PDOStatement.php","Line":141}}},"CustomMessage":"--"},"userAgent":"node-fetch\/1.0 (+https:\/\/github.com\/bitinn\/node-fetch)","version":"16.0.1.1"}

[kesselb]

Thank you for reporting this issue :tada:

Duplicate of https://github.com/nextcloud/server/issues/15441 (but your issue title is much better and easier to find through the search)

[skjnldsv]

@rullzer we should maybe add a warning :)

[tobybryans]

Since this is now a milestone, I edited the title so it's correct :)

[esantoro]

If I may add a tiny bit, it would be nice if during a new install the installed would check if Postgresql version is 9.4 or below and if so, refuse to go ahead.

In my experience the install process goes through fine, but the installed Nextcloud is not usable.

[BJPGameVideosITA]

If I may add a tiny bit, it would be nice if during a new install the installed would check if Postgresql version is 9.4 or below and if so, refuse to go ahead.

In my experience the install process goes through fine, but the installed Nextcloud is not usable.

Just finished opening a new issue for the installation for the same issue (#15906),
I've just finished installing NC 16.0.1 on PostgreSQL 9.2 and now it spits out a good old 500 internal server error of the death (worse than BSOD of Win)...

Behaviour reported here:
PostgreSQL 9.2.24 is the default on CentOS 7 and now I'm trying to upgrade to >=9.5, hopefully without having to recreate databases and nextcloud installation...

[blizzz]

With https://github.com/nextcloud/documentation/pull/1516 this is the requirement for Nc 16.