# Database error upgrading from 27 to 28

**URL:** <https://help.nextcloud.com/t/database-error-upgrading-from-27-to-28/176633>\
**Category:** 📦 Appliances (Docker, Snappy, VM, NCP, AIO)\
**Tags:** update\_problems, docker\
**Created:** [December 14, 2023, 11:41am UTC](https://help.nextcloud.com/t/database-error-upgrading-from-27-to-28/176633 "2023-12-14T11:41:01Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Commerzpunk](https://help.nextcloud.com/letter_avatar/commerzpunk/32/5_5575768a8748004e209b776fc1b2916d.png) [@Commerzpunk](https://help.nextcloud.com/u/Commerzpunk)\
**Post date:** [December 14, 2023, 11:41am UTC](https://help.nextcloud.com/t/database-error-upgrading-from-27-to-28/176633/1 "2023-12-14T11:41:01Z")

</div>

Hello,  
my docker environment just made an update and should have pdated NC from V 27 to V 28.

It did not, but showing up this error:

using keys found in /config/keys  
Initializing nextcloud 28.0.0.11 (this can take a while) …  
Upgrading nextcloud from 27.1.4.1 …  
Setting permissions  
Setting log level to debug  
Turned on maintenance mode  
Updating database schema  
Exception: Database error when running migration 28000Date20230906104802 for app core  
Index name “lock\_ttl\_index” for table “oc\_file\_locks\_org” collides with the constraint on table “oc\_file\_locks”.  
Update failed  
Maintenance mode is kept active  
Resetting log level  
Initializing finished

Strange enough, I cant find any results from google, github or the forum for this.

Who can advice help?

---

<div class="post-metadata">

**Author:** ![Commerzpunk](https://help.nextcloud.com/letter_avatar/commerzpunk/32/5_5575768a8748004e209b776fc1b2916d.png) [@Commerzpunk](https://help.nextcloud.com/u/Commerzpunk)\
**Post date:** [December 14, 2023, 12:12pm UTC](https://help.nextcloud.com/t/database-error-upgrading-from-27-to-28/176633/2 "2023-12-14T12:12:08Z")

</div>

Oh wait, after some investigation, I figured out, that \_org table was a copy that i once made for myself. No more need to keep it. After dropping it, the update went fine.

---

<div class="post-metadata">

**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 14, 2024, 1:23pm UTC](https://help.nextcloud.com/t/database-error-upgrading-from-27-to-28/176633/3 "2024-12-14T13:23:46Z")

</div>


