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

Steps to reproduce

Use Postgres 9.4 or lower (9.4 is still a supported version)
Upgrade from NC 15 to 16
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"}

Thank you for reporting this issue 🎉

Duplicate of #15441 (but your issue title is much better and easier to find through the search)

@rullzer

@rullzer we should maybe add a warning :)

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

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.

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...

With nextcloud/documentation#1516 this is the requirement for Nc 16.

removes the specific upsert query which is available on PSQL 9.5 only

Navigation Menu

Repository navigation

NC 16+ uses SQL that is only supported in Postgresql >= 9.5 #15613

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Nextcloud log (data/nextcloud.log)

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

NC 16+ uses SQL that is only supported in Postgresql >= 9.5 #15613

Description

Steps to reproduce

Expected behaviour

Actual behaviour

Server configuration

Nextcloud log (data/nextcloud.log)

Activity

kesselb commented on May 18, 2019

skjnldsv commented on Jun 5, 2019

tobybryans commented on Jun 6, 2019

esantoro commented on Jun 7, 2019

BJPGameVideosITA commented on Jun 9, 2019

blizzz commented on Jul 18, 2019

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions