Repository navigation
NC 16+ uses SQL that is only supported in Postgresql >= 9.5 #15613
Description
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"}
Activity
kesselb commentedon May 18, 2019
Thank you for reporting this issue 🎉
Duplicate of #15441 (but your issue title is much better and easier to find through the search)
skjnldsv commentedon Jun 5, 2019
@rullzer we should maybe add a warning :)
[-]NC 16+ uses SQL that is only supported in Postgresql > 9.5[/-][+]NC 16+ uses SQL that is only supported in Postgresql >= 9.5[/+]tobybryans commentedon Jun 6, 2019
Since this is now a milestone, I edited the title so it's correct :)
esantoro commentedon Jun 7, 2019
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 commentedon Jun 9, 2019
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 commentedon Jul 18, 2019
With nextcloud/documentation#1516 this is the requirement for Nc 16.
removes the specific upsert query which is available on PSQL 9.5 only