server
server copied to clipboard
[wip] Support sharding migration
- [ ] 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.