[ckan-dev] CKAN2.2 Upgrade Error

Wed Dec 18 14:54:00 UTC 2013

So,

if I understood correctly I have to run the upgrade database command  
every time I update CKAN?? Even if I am updating a minor revision??

I tried both ways but unfortunately none of them worked!

Any other ideas??

Best,

G.

> 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
>
> _______________________________________________
> 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.