[ckan-dev] CKAN2.2 Upgrade Error

[Ross Jones]

That’s not good. 

I’ve never had this specific problem, so not sure of the best way to proceed (apart from _doing a backup_). 

If it were me I’d try one of the following after backing up (and testing the backup elsewhere) and not in production. I’d be less than confident of either approach though. 

# Hacky solution 1.

1. Take a backup
2. Set the value to 67 and re-run the upgrade command.
3. You might then want to compare it to the schema on a fresh database.

# Hacky (and even less likely to work) solution 2

1. Take a backup
2. Run the upgrade command.
3. If it fails with an already existing column, increment the number, go to 2.

In future, it’ll probably be safer to always run the migrations with the upgrade command.

Ross.

On 18 Dec 2013, at 12:25, Dimitrakakis Georgios <giorgis at ucnet.uoc.gr> wrote:

> Mine seems to be in 1
> 
> Here is the output:
> 
> ckan_default=# select version from migrate_version;
> version
> ---------
>       1
> (1 row)
> 
> 
> G.
> 
> 
>> When you run the upgrade, it runs the migrations to update your database but  I think that is from a really early migration and should have already been run in the past.
>> 
>> What do you get from the following query on your database?
>> 
>> select version from migrate_version;
>> 
>> On my older 2.something version this is 67.
>> 
>> Ross.
>> 
>> On 18 Dec 2013, at 12:06, Dimitrakakis Georgios <giorgis at ucnet.uoc.gr> wrote:
>> 
>>> No  because I was upgrading from v2.1 and since this is a minor release I thought it was not necessary.
>>> 
>>> Therefore I did that now and here is the error:
>>> 
>>> http://pastebin.com/b8EV99AF
>>> 
>>> 
>>> Any ideas about this?
>>> 
>>> G.
>>> 
>>>> Hi,
>>>> 
>>>> Did you run the ‘paster db upgrade’ at step 3 of http://docs.ckan.org/en/latest/upgrade-package-to-minor-release.html ?
>>>> 
>>>> Ross
>>>> 
>>>> On 18 Dec 2013, at 11:38, Dimitrakakis Georgios <giorgis at ucnet.uoc.gr> wrote:
>>>> 
>>>>> I am trying to upgade to release-v2.2 from GIT but I am getting the error shown here: http://pastebin.com/3QgqFJHv
>>>>> when  I try to reindex the database!!!
>>>>> 
>>>>> Any ideas much appreciated!!!
>>>>> 
>>>>> Best,
>>>>> 
>>>>> G.
>>>>> 
>>>>> ----------------------------------------------------------------
>>>>> This message was sent using IMP, the Internet Messaging Program.
>>>>> 
>>>>> _______________________________________________
>>>>> ckan-dev mailing list
>>>>> ckan-dev at lists.okfn.org
>>>>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>>>>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>>>> 
>>>> 
>>> 
>>> ----------------------------------------------------------------
>>> This message was sent using IMP, the Internet Messaging Program.
>>> _______________________________________________
>>> ckan-dev mailing list
>>> ckan-dev at lists.okfn.org
>>> https://lists.okfn.org/mailman/listinfo/ckan-dev
>>> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev
>> 
>> 
> 
> ----------------------------------------------------------------
> This message was sent using IMP, the Internet Messaging Program.
> _______________________________________________
> ckan-dev mailing list
> ckan-dev at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/ckan-dev
> Unsubscribe: https://lists.okfn.org/mailman/options/ckan-dev