# During update from 13.0.5 to 13.06 database error: SQLSTATE\[23000\]: Integrity constraint violation: 19 UNIQUE constraint failed: oc\_filecache.fileid **URL:** \ **Category:** ℹ️ Support\ **Tags:** update\_problems, nc13\ **Created:** [September 8, 2018, 2:27pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455 "2018-09-08T14:27:46Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![radoeka](https://help.nextcloud.com/user_avatar/help.nextcloud.com/radoeka/32/5239_2.png) [@radoeka](https://help.nextcloud.com/u/radoeka)\ **Post date:** [September 8, 2018, 2:27pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/1 "2018-09-08T14:27:46Z")
> **Support intro** > > Sorry to hear you’re facing problems 🙁 > > _**[help.nextcloud.com](http://help.nextcloud.com) is for home/non-enterprise users. If you’re running a business, paid support can be accessed via [portal.nextcloud.com](http://portal.nextcloud.com) where we can ensure your business keeps running smoothly.**_ > > The following error is reported during the update from 13.0.5 to 13.0.6 > Using the same update procedure with previous releases, that normally works fine. > > ```auto > # occ upgrade > Nextcloud or one of the apps require upgrade - only a limited number of commands are available > You may use your browser or the occ upgrade command to do the upgrade > Set log level to debug > Doctrine\DBAL\Exception\UniqueConstraintViolationException: An exception occurred while executing 'INSERT INTO oc_filecache (fileid, storage, parent, name, mimetype, mimepart, mtime, encrypted, path, path_hash, etag, storage_mtime, permissions, size, unencrypted_size, checksum) SELECT fileid, storage, parent, name, mimetype, mimepart, mtime, encrypted, path, path_hash, etag, storage_mtime, permissions, size, unencrypted_size, checksum FROM __temp__ oc_filecache': > > SQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_filecache.fileid > Update failed > Maintenance mode is kept active > Reset log level > > ``` > > Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can ❤ Nextcloud version _(eg, 12.0.2)_: 13.0.5 -\> 13.0.6 Operating system and version _(eg, Ubuntu 17.04)_: openSUSE\_42.2 Apache or nginx version _(eg, Apache 2.4.25)_: apache2 2.4.23 PHP version _(eg, 7.1)_: 7.0.7 The issue you are facing: Upgrade fails Is this the first time you’ve seen this error? _(Y/N)_: Y Steps to replicate it: 1. install nextcloud 13.0.6 2. occ upgrade 3. The update procedure is the same as all preceding updates. Those were succesfull. The output of your Nextcloud log in **Admin \> Logging** : ```auto {"reqId":"84o4cpC4DpTk9erpjvc8","level":0,"time":"2018-09-08T15:32:35+02:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"starting upgrade from 13.0.5.2 to 13.0.6.1","userAgent":"--","version":"13.0.5.2"} {"reqId":"84o4cpC4DpTk9erpjvc8","level":3,"time":"2018-09-08T15:32:39+02:00","remoteAddr":"","user":"--","app":"core","method":"--","url":"--","message":"Exception: {\"Exception\":\"Doctrine\\\\DBAL\\\\Exception\\\\UniqueConstraintViolationException\",\"Message\":\"An exception occurred while executing 'INSERT INTO oc_filecache (fileid, storage, parent, name, mimetype, mimepart, mtime, encrypted, path, path_hash, etag, storage_mtime, permissions, size, unencrypted_size, checksum) SELECT fileid, storage, parent, name, mimetype, mimepart, mtime, encrypted, path, path_hash, etag, storage_mtime, permissions, size, unencrypted_size, checksum FROM __temp__ oc_filecache':\\n\\nSQLSTATE[23000]: Integrity constraint violation: 19 UNIQUE constraint failed: oc_filecache.fileid\",\"Code\":0,\"Trace\":\"#0 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/DBALException.php(128): Doctrine\\\\DBAL\\\\Driver\\\\AbstractSQLiteDriver->convertException('An exception oc...', Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException))\\n#1 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Connection.php(964): Doctrine\\\\DBAL\\\\DBALException::driverExceptionDuringQuery(Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOSqlite\\\\Driver), Object(Doctrine\\\\DBAL\\\\Driver\\\\PDOException), 'INSERT INTO oc_...')\\n#2 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/lib\\\/private\\\/Repair\\\/SqliteAutoincrement.php(96): Doctrine\\\\DBAL\\\\Connection->query('INSERT INTO oc_...')\\n#3 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/lib\\\/private\\\/Repair.php(93): OC\\\\Repair\\\\SqliteAutoincrement->run(Object(OC\\\\Repair))\\n#4 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/lib\\\/private\\\/Updater.php(258): OC\\\\Repair->run()\\n#5 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/lib\\\/private\\\/Updater.php(139): OC\\\\Updater->doUpgrade('13.0.6.1', '13.0.5.2')\\n#6 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/core\\\/Command\\\/Upgrade.php(270): OC\\\\Updater->upgrade()\\n#7 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/symfony\\\/console\\\/Command\\\/Command.php(264): OC\\\\Core\\\\Command\\\\Upgrade->execute(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#8 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(874): Symfony\\\\Component\\\\Console\\\\Command\\\\Command->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#9 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(228): Symfony\\\\Component\\\\Console\\\\Application->doRunCommand(Object(OC\\\\Core\\\\Command\\\\Upgrade), Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#10 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/symfony\\\/console\\\/Application.php(130): Symfony\\\\Component\\\\Console\\\\Application->doRun(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#11 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/lib\\\/private\\\/Console\\\/Application.php(173): Symfony\\\\Component\\\\Console\\\\Application->run(Object(Symfony\\\\Component\\\\Console\\\\Input\\\\ArgvInput), Object(Symfony\\\\Component\\\\Console\\\\Output\\\\ConsoleOutput))\\n#12 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/console.php(90): OC\\\\Console\\\\Application->run()\\n#13 \\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/occ(11): require_once('\\\/srv\\\/www\\\/vhosts...')\\n#14 {main}\",\"File\":\"\\\/srv\\\/www\\\/vhosts\\\/owncloud.server-fqdn\\\/nextcloud-13.0.6\\\/3rdparty\\\/doctrine\\\/dbal\\\/lib\\\/Doctrine\\\/DBAL\\\/Driver\\\/AbstractSQLiteDriver.php\",\"Line\":48}","userAgent":"--","version":"13.0.5.2"} ``` The output of your config.php file in `/path/to/nextcloud` (make sure you remove any identifiable information!): ```auto '/srv/owncloud', 'dbtype' => 'sqlite3', 'defaultapp' => 'bookmarks', 'version' => '13.0.5.2', 'installed' => true, 'logfile' => '/var/log/nextcloud/nextcloud.log', 'log_rotate_size' => 1048576, 'loglevel' => 0, 'theme' => '', 'trusted_domains' => array ( ), 'maintenance' => false, 'memcache.local' => '\\OC\\Memcache\\APCu', 'forcessl' => true, 'forceSSLforSubdomains' => true, 'htaccess.RewriteBase' => '/', 'trashbin_retention_obligation' => 'auto, 30', ); ``` The output of your Apache/nginx/system log in `/var/log/ ____ `: ```auto webserve is down during the upgrade ``` ---
**Author:** ![radoeka](https://help.nextcloud.com/user_avatar/help.nextcloud.com/radoeka/32/5239_2.png) [@radoeka](https://help.nextcloud.com/u/radoeka)\ **Post date:** [September 8, 2018, 2:50pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/2 "2018-09-08T14:50:14Z")
note: removed not applicable screenshot ---
**Author:** ![tflidd](https://help.nextcloud.com/letter_avatar/tflidd/32/5_5575768a8748004e209b776fc1b2916d.png) [@tflidd](https://help.nextcloud.com/u/tflidd)\ **Post date:** [September 9, 2018, 11:16am UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/3 "2018-09-09T11:16:07Z")
Related to this bug report? > however the configuration looks different… ---
**Author:** ![radoeka](https://help.nextcloud.com/user_avatar/help.nextcloud.com/radoeka/32/5239_2.png) [@radoeka](https://help.nextcloud.com/u/radoeka)\ **Post date:** [September 9, 2018, 12:05pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/4 "2018-09-09T12:05:13Z")
@tflidd: looks similar, but I don’t whether it is the same. I’ve an sqlite3 database. It’s not a heavy nextcloud instance. I’ve none of the four locking options enabled in config.php filelocking.enabled’ =\> true, Default is true, so filelocking is enabled ‘filelocking.ttl’ =\> 60\*60, 1 hour, the whole thing completes in a few seconds. ‘memcache.locking’ =\> Not set -\> defaults to none. ‘filelocking.debug’ =\> false, This might be useful. Shall I enabled this one? What is the SQL to execute. As this uses temporarely data it is hard to replicate… ---
**Author:** ![tflidd](https://help.nextcloud.com/letter_avatar/tflidd/32/5_5575768a8748004e209b776fc1b2916d.png) [@tflidd](https://help.nextcloud.com/u/tflidd)\ **Post date:** [September 9, 2018, 5:24pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/5 "2018-09-09T17:24:46Z")
You could try to check the filecache first, there is an option for the occ command: files:cleanup In case you have duplicates in your database, it should remove this. If that does not help, please open a new topic on the bug tracker. You can refer to the above topic but with the very different setup, it is better to create a new one. ---
**Author:** ![radoeka](https://help.nextcloud.com/user_avatar/help.nextcloud.com/radoeka/32/5239_2.png) [@radoeka](https://help.nextcloud.com/u/radoeka)\ **Post date:** [September 9, 2018, 6:49pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/6 "2018-09-09T18:49:21Z")
Thanks. For reference: Before cleanup: > $ echo “.headers on > .mode csv > select name, path\_hash from oc\_filecache;” | sqlite3 owncloud.db | wc -l > 8633 > $ occ files:cleanup > 15 orphaned file cache entries deleted Files is no reduced to 8621 > $ echo “.headers on       > .mode csv > select name, path\_hash from oc\_filecache;” | sqlite3 owncloud.db | sort | uniq -c | sort -nr | grep -v "      1" | head -10 >     20 “”,d41d8cd98f00b204e9800998ecf8427e >     17 files,45b963397aa40d4a0063e0d85e4fe7a1 >     17 cache,0fea6a13c52b4d4725368f24b045ca84 >     10 v0.6.0,f72c70196746fc6912257146fcd84fcf >     10 lucene\_index,a0c55384eae17768d8f9fe6696efed6e Not much changed in this respect. Will do the upgrade later this week. Would it be possible to completely empty the file\_cache table? It’s a cache after all, as such the entries will be created once accessed again, or is this not the case? ---
**Author:** ![radoeka](https://help.nextcloud.com/user_avatar/help.nextcloud.com/radoeka/32/5239_2.png) [@radoeka](https://help.nextcloud.com/u/radoeka)\ **Post date:** [September 14, 2018, 2:34pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/7 "2018-09-14T14:34:45Z")
> occ files:cleanup didn’t help, still the same error ☹ ---
**Author:** ![radoeka](https://help.nextcloud.com/user_avatar/help.nextcloud.com/radoeka/32/5239_2.png) [@radoeka](https://help.nextcloud.com/u/radoeka)\ **Post date:** [September 14, 2018, 3:16pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/8 "2018-09-14T15:16:03Z")
Opened bug report [https://github.com/nextcloud/server/issues/11221](https://github.com/nextcloud/server/issues/11221) When I emptied the oc\_filecache table the update succeeded succesfully, however after loging in, the was very much noticable that the cache had to be build again. So initially the response from the server is slow. ---
**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\ **Post date:** [December 4, 2024, 7:40am UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/9 "2024-12-04T07:40:06Z")
---
**Author:** ![wwe](https://help.nextcloud.com/user_avatar/help.nextcloud.com/wwe/32/72963_2.png) [@wwe](https://help.nextcloud.com/u/wwe)\ **Post date:** [December 9, 2024, 3:15pm UTC](https://help.nextcloud.com/t/during-update-from-13-0-5-to-13-06-database-error-sqlstate-23000-integrity-constraint-violation-19-unique-constraint-failed-oc-filecache-fileid/36455/10 "2024-12-09T15:15:41Z")