server icon indicating copy to clipboard operation
server copied to clipboard

[wip] Support sharding migration

Open icewind1991 opened this issue 4 months ago • 0 comments

  • [ ] requires https://github.com/nextcloud/server/pull/48563
  • [ ] Fix "File entry could not be inserted but could also not be selected with getId() in order to perform an update. Please try again." issue

Support migrating existing instances to sharding.

Enabled by setting the sharding configuration and setting the from_shard_key and from_primary to the sharding configuration with the next storage/file id (so the first storage/file that will be created after sharding is configured).

Any files on the existing storages will still go to the main db, only newly created storages will be sharded.

Things seem to work, but in some cases, the "File entry could not be inserted but could also not be selected with getId() in order to perform an update. Please try again." error gets thrown. (creating a new user is the most reliable way I found). While things seem to work otherwise, I suspect that this issue is a sign of a bigger connection handling issue.

icewind1991 avatar Oct 18 '24 16:10 icewind1991