Ticket #984 (closed defect: fixed)

Opened 3 years ago

Last modified 3 years ago

Fix migration, where upgrade diverges from actual model.

Reported by: kindly Owned by: kindly
Priority: critical Milestone: ckan-v1.4-sprint-2
Component: ckan Keywords:
Cc: Repository:
Theme:

Description

The migration scripts have not been inline with the upgrade scripts. There are lots of discrepancies.

Attachments

ckan_migration_fixes.sql​ (8.2 KB) - added by kindly 3 years ago.
Migration fixes.
ckan_upgrade.diff​ (8.7 KB) - added by kindly 3 years ago.
This is the sql that needs to run on ckan.net *after* db upgrade has run on version 1.3.1
ckan_upgrade_v2.sql​ (8.0 KB) - added by kindly 3 years ago.
This upgrade works from ckan 1.3.2.
dgu-upgrade.diff​ (3.0 KB) - added by kindly 3 years ago.
dgu update

Change History

comment:1 Changed 3 years ago by kindly

  • Priority changed from awaiting triage to critical

Changed 3 years ago by kindly

Migration fixes.

comment:3 Changed 3 years ago by kindly

These are the errors listed in severity order.

  • group revision tables joins wrong in many ways.
  • changemask table not added.
  • licence_id wrong type.
  • package_revision.download_url and changset.status not dropped.
  • package.name and tag.name unique constraint not added.
  • update cascaded defined wrongly.

Attached are the fixes that will need to be run in ckan_migration_fixes.sql

comment:4 Changed 3 years ago by kindly

  • Milestone set to ckan-v1.4-sprint-2

comment:6 Changed 3 years ago by kindly

  • Status changed from new to closed
  • Resolution set to fixed

Changed 3 years ago by kindly

This is the sql that needs to run on ckan.net *after* db upgrade has run on version 1.3.1

Changed 3 years ago by kindly

This upgrade works from ckan 1.3.2.

Changed 3 years ago by kindly

dgu update

Note: See TracTickets for help on using tickets.