upgrade of current development PPA packages fails

Bug #917107 reported by Guy K. Kloss
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
sloecode
Fix Released
High
Unassigned

Bug Description

Upgrade from 0.1dev-0~140-82~maverick1 to 0.1dev-0~143-82~maverick1 errors out on DB upgrade script. Below the console output for the upgrade attempt:

applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 1.
Error: near line 24: table project has 4 columns but 5 values were supplied
error encountered processing /usr/share/dbconfig-common/data/sloecode/upgrade/sqlite3/1:

dbconfig-common: sloecode configure: retrying.
dbconfig-common: writing config to /etc/dbconfig-common/sloecode.conf
creating database backup in /var/cache/dbconfig-common/backups/sloecode_0.1dev-0~140-82~maverick1.sqlite3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 1.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 2.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 2.
Error: near line 22: table project has 4 columns but 5 values were supplied
error encountered processing /usr/share/dbconfig-common/data/sloecode/upgrade/sqlite3/2:

dbconfig-common: sloecode configure: retrying.
dbconfig-common: writing config to /etc/dbconfig-common/sloecode.conf
creating database backup in /var/cache/dbconfig-common/backups/sloecode_0.1dev-0~140-82~maverick1.sqlite3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 1.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 2.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 3.
Error: near line 1: duplicate column name: public
error encountered processing /usr/share/dbconfig-common/data/sloecode/upgrade/sqlite3/3:

dbconfig-common: sloecode configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/sloecode.conf
creating database backup in /var/cache/dbconfig-common/backups/sloecode_0.1dev-0~140-82~maverick1.sqlite3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 1.
Error: near line 24: table project has 4 columns but 5 values were supplied
error encountered processing /usr/share/dbconfig-common/data/sloecode/upgrade/sqlite3/1:

dbconfig-common: sloecode configure: trying again.
dbconfig-common: writing config to /etc/dbconfig-common/sloecode.conf
creating database backup in /var/cache/dbconfig-common/backups/sloecode_0.1dev-0~140-82~maverick1.sqlite3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 1.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 2.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 3.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 2.
Error: near line 22: table project has 4 columns but 5 values were supplied
error encountered processing /usr/share/dbconfig-common/data/sloecode/upgrade/sqlite3/2:

dbconfig-common: sloecode configure: aborted.
applying upgrade sql for 0.1dev-0~140-82~maverick1 -> 3.
Starting Sloecode

Related branches

Changed in sloecode:
milestone: none → 1.1
Changed in sloecode:
status: New → In Progress
importance: Undecided → High
assignee: nobody → Thomi Richards (thomir)
Changed in sloecode:
status: In Progress → Fix Committed
Changed in sloecode:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.