Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Page Properties
label


Status
Status
colourYellow
titleIn progress
Stakeholders
Outcome
Due date
Owner


Truncation problem

PostgreSQL silently truncates identifiers after 63 bytes.

...

To reduce the downtime in multi-tenant installations it must be possible to migrate one tenant at a time.

Okapi and the modules should provide these APIs :

PATCH /_/proxy/tenants - rename all non-compliant tenant ids
PATCH /_/proxy/tenants/{old_tenant_id} - rename the old tenant id, the new tenant id is in the PATCH body

Both APIs fail if the new tenant id already exists. They have a dryRun option that replies with the SQL commands to rename the schema. They have a skipSchemaRename option to disable running the schema rename SQL so that the sysop can run this separately; this might be needed if Okapi doesn't have permissions for schema renameand/or scripts to do the migration.

mod-data-import-converter-storage rename

...

References

Jira Legacy
serverSystem JiraFOLIO Issue Tracker
columnIdsissuekey,summary,issuetype,created,updated,duedate,assignee,reporter,priority,status,resolution
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
maximumIssues20
jqlQuerykey in (FOLIO-3450, OKAPI-1081, OKAPI-1082)
serverId01505d016ccf3fe4-b8533301-3c2e368a-90f1983e-ee9b165564fc20c466b11a49